SQL for Database Construction SQL statements can be embedded in triggers, stored procedures, and program code. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement to create a view is: INSERT VIEW MAKE VIEW SELECT VIEW CREATE VIEW INSERT VIEW MAKE VIEW SELECT VIEW CREATE VIEW ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Increased network traffic Greater security Code sharing SQL can be optimized Increased network traffic Greater security Code sharing SQL can be optimized ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL DELETE statement is used to delete both the table structure and table data. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is an SQL trigger supported by Oracle? AFTER All of these INSTEAD OF BEFORE AFTER All of these INSTEAD OF BEFORE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS