Crowdly

Add to Chrome

Universities
moodle.inthergroup.com
Course 6

Course 6

Looking for Course 6 test answers and solutions? Browse our comprehensive collection of verified answers for Course 6 at moodle.inthergroup.com.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

Which query returns rows where oid is missing (NULL)?

SELECT

* FROM cars WHERE oid IS NULL;

100%

SELECT

* FROM cars WHERE oid = NULL;

SELECT

* FROM cars WHERE oid = 0;

SELECT

* FROM cars WHERE oid IS 0;

View this question

What

happens when you run this query?

SELECT 1
UNION
SELECT 1;

Returns

two rows

Returns

error

Returns

one row

100%

Returns

NULL

View this question

Consider the following query:

SELECT COUNT(age) FROM users;

What does this return?

Always

returns 0

Total

number of rows

Number

of non-NULL age values

100%

Number

of NULL values

View this question

Which

statement about views is true?

Views

cannot be updated

Views

store data physically

Views

are virtual tables based on queries

100%

Views

cannot be queried

View this question

What does this query return?

SELECT p.name, pt.name
FROM products p
RIGHT JOIN product_types pt
ON p.product_type_id = pt.product_type_id;

All

products

Only

unmatched rows

All

product types, with matching products if they exist

100%

Only

matching rows

View this question

Consider the following query:

SELECT DISTINCT city FROM users;

What will this query return?

All

rows from the table

Only

non-null cities

All

cities including duplicates

Unique

cities only (duplicates removed)

100%

View this question

Which

of the following is NOT a type of join?

MULTIPLE

JOIN

100%

RIGHT

JOIN

LEFT

JOIN

INNER

JOIN

View this question

Which

statement about foreign keys is FALSE?

Foreign

keys enforce referential integrity

foreign key references another table

100%

foreign key can reference a primary key

Foreign

keys are not used to enforce referential integrity

View this question

Which clause is used to filter rows before grouping?

ORDER

GROUP

Which

query is correct?

SELECT

product_type_id, AVG(price) FROM products GROUP BY product_type_id HAVING

AVG(price) > 20;

100%

SELECT

product_type_id, AVG(price) FROM products;

SELECT

product_type_id, AVG(price) FROM products WHERE AVG(price) > 20 GROUP BY

product_type_id;

SELECT product_type_id, AVG(price) FROM products GROUP product_type_id WHERE AVG(price) > 20;

View this question

Want instant access to all verified answers on moodle.inthergroup.com?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank

Add to Chrome