Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. (TCO 3) What constraint can only be applied at table level or with an ALTER statement? (Points : 4) Foreign key Not null Single

2. (TCO 3) What constraint can only be applied at table level or with an ALTER statement? (Points : 4) Foreign key Not null Single field primary key Composite primary key

Question 3. 3. (TCO 3) You are creating a table called Department with fields for the primary key DeptID (Integer) and department name (VARCHAR). What (if anything) is wrong with the following code? CREATE TABLE Department ( deptID INTEGER Primary Key, deptName VARCHAR(10) NOT NULL, ); (Points : 4)

You must use curly braces, not parentheses. The comma after NOT NULL must be removed. The keywords cannot be in uppercase. Nothing is wrong.

7. (TCO 7) A left join returns _____. (Points : 4) rows in the left table that dont satisfy the join condition unmatched rows from both the left and right tables rows in the right table that dont satisfy the join condition the Cartesian product of the two tables

Question 8. 8. (TCO 7) What type of subquery is executed once for each row processed by the main query? (Points : 4)
Correlated Uncorrelated Inner Outer

Question 9. 9. (TCO 7) Which of the following statements is correct? (Points : 4)
WHERE operates on groups formed by aggregate functions and HAVING operates on individual rows. WHERE can only be used along with HAVING. HAVING can only be used along with WHERE. WHERE operates on individual rows and HAVING operates on groups formed by aggregate functions.

Question 10. 10. (TCO 9) Assuming the SELECT statement below is a proper query, which is true regarding the following statement? CREATE VIEW example AS SELECT vendor_name, SUM(invoice_total) AS Invoice Sum FROM vendors JOIN invoices ON vendors.vendor_id = invoices.vendor_id GROUP BY vendor_name ORDER BY vendor_name; (Points : 4)

It will fail because the GROUP BY clause is not allowed in a view. It will fail because SUM function is not allowed in a view. It will fail because ORDER BY clause is not allowed in a view. It will succeed.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Management Databases And Organizations

Authors: Richard T. Watson

2nd Edition

0471180742, 978-0471180746

More Books

Students also viewed these Databases questions

Question

6. What questions would you suggest should be included?

Answered: 1 week ago