The SQL ALTER statement can be used to: change the table data. add rows to the table. change the table structure. delete rows from the table. TRUE ANSWER : ? YOUR ANSWER : ?
SQL statements can be embedded in triggers, stored procedures, and program code. True False TRUE ANSWER : ? YOUR ANSWER : ?
A view that contains a computed column can be easily updated. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is an SQL trigger supported by Oracle? All of these AFTER BEFORE INSTEAD OF TRUE ANSWER : ? YOUR ANSWER : ?
SQL has a JOIN ON syntax that can be used to create inner joins and outer joins. True False TRUE ANSWER : ? YOUR ANSWER : ?
A reason for using an SQL view to hide columns is: to prevent the display of sensitive data only. None of these to simplify a result only. to accomplish both of the above. TRUE ANSWER : ? YOUR ANSWER : ?
The SQL command to create a table is: ALTER TABLE DEFINE TABLE MAKE TABLE CREATE TABLE TRUE ANSWER : ? YOUR ANSWER : ?
What is not an advantage of stored procedures? Code sharing SQL can be optimized Increased network traffic Greater security TRUE ANSWER : ? YOUR ANSWER : ?
A SQL view is a virtual table that is constructed from other tables or views. False True TRUE ANSWER : ? YOUR ANSWER : ?