SQL for Database Construction What is not an advantage of stored procedures? Code sharing Increased network traffic SQL can be optimized Greater security Code sharing Increased network traffic SQL can be optimized Greater security ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL views can be used to hide: None of these columns and rows only. both of the above can be hidden by an SQL view. complicated SQL syntax only. None of these columns and rows only. both of the above can be hidden by an SQL view. complicated SQL syntax only. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is NOT a type of SQL constraint? FOREIGN KEY PRIMARY KEY ALTERNATE KEY UNIQUE FOREIGN KEY PRIMARY KEY ALTERNATE KEY UNIQUE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction There are three SQL data modification operations: insert, modify and delete. True False True False ANSWER DOWNLOAD EXAMIANS APP
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 What is an SQL virtual table that is constructed from other tables? A relation Just another table A view Query results A relation Just another table A view Query results ANSWER DOWNLOAD EXAMIANS APP