Question
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 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started