Question: No Service 73% 2:02 PM a instructure-uploads.s3.amazonaws.com #10. How many rows can be added to a table by executing the ALTER TABLE .. . ADD

 No Service 73% 2:02 PM a instructure-uploads.s3.amazonaws.com #10. How many rows

No Service 73% 2:02 PM a instructure-uploads.s3.amazonaws.com #10. How many rows can be added to a table by executing the ALTER TABLE .. . ADD" command? A. 1 C. 3 B. 2 D. unlimited #11. Which of the following is not a valid column constraint? A. PRIMARY KEYS B. UNIQUE C.CHECK FOREIGN KEY #12, which of the following keywords allows the user to delete a record from a table, even if rows in constraint? referential integrity! another table reference the record through a FOREIGN KEY Hint: The DBMS allows it because the DBMS itself will enforce CASCADE CASCADE ON DELETE CASCADE CONSTRAINTS B. D. DROP E. ON DELETE CASCADE Which of the following commands removes all orders placed before April 1, 2009? DELETE FROM orders WHERE orderdate 01-APR-09'; orderdate > 01-APR-09'; DROP FROM orders WHERE C. REMOVE FROM orders WHERE DELETE FROM orders WHERE #14. A DDL command can be undone by closing the session window using the "X" in the title bar A. TRUE B. FALSE #15. A rollback occurs automatically when the user closes the session window using the "X" in the title bar A. TRUE B. FALSE #16 script file? Which of the following is the standard extension used for a scr sql script .spt

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!