Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: FROM GROUP BY WHERE ORDER BY TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is an SQL trigger supported by Oracle? INSTEAD OF AFTER BEFORE All of these TRUE ANSWER : ? YOUR ANSWER : ?
The DROP TABLE statement: deletes the table structure only. deletes the table structure along with the table data. works whether or not referential integrity constraints would be violated. is not an SQL statement. TRUE ANSWER : ? YOUR ANSWER : ?
A benefit of using a stored procedure is that it can be distributed to client computers. False True TRUE ANSWER : ? YOUR ANSWER : ?
A trigger is a stored program that is attached to a database. True False TRUE ANSWER : ? YOUR ANSWER : ?
What is an advantage of placing computations in SQL views? To ensure that the results are consistent. To accomplish both of the above. To save users from having to write an expression. None of these TRUE ANSWER : ? YOUR ANSWER : ?
What is an SQL virtual table that is constructed from other tables? A view A relation Just another table Query results TRUE ANSWER : ? YOUR ANSWER : ?
A reason for using an SQL view to hide columns is: None of these to accomplish both of the above. to prevent the display of sensitive data only. to simplify a result only. TRUE ANSWER : ? YOUR ANSWER : ?