What is an advantage of placing computations in SQL views? None of these To ensure that the results are consistent. To save users from having to write an expression. To accomplish both of the above. TRUE ANSWER : ? YOUR ANSWER : ?
A reason for using an SQL view to hide columns is: None of these to prevent the display of sensitive data only. to accomplish both of the above. to simplify a result only. TRUE ANSWER : ? YOUR ANSWER : ?
The SQL command to create a table is: DEFINE TABLE CREATE TABLE ALTER TABLE MAKE TABLE TRUE ANSWER : ? YOUR ANSWER : ?
What is an SQL virtual table that is constructed from other tables? Query results A view A relation Just another table TRUE ANSWER : ? YOUR ANSWER : ?
SQL statements can be embedded in triggers, stored procedures, and program code. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is an SQL trigger supported by Oracle? AFTER All of these BEFORE INSTEAD OF TRUE ANSWER : ? YOUR ANSWER : ?
There are three SQL data modification operations: insert, modify and delete. True False TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is NOT a type of SQL constraint? ALTERNATE KEY FOREIGN KEY UNIQUE PRIMARY KEY TRUE ANSWER : ? YOUR ANSWER : ?
The DROP TABLE statement: works whether or not referential integrity constraints would be violated. deletes the table structure only. is not an SQL statement. deletes the table structure along with the table data. TRUE ANSWER : ? YOUR ANSWER : ?