SQL for Database Construction The SQL statement to create a view is: MAKE VIEW INSERT VIEW CREATE VIEW SELECT VIEW MAKE VIEW INSERT VIEW CREATE VIEW SELECT VIEW ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is an SQL trigger supported by Oracle? BEFORE All of these AFTER INSTEAD OF BEFORE All of these AFTER INSTEAD OF ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Code sharing SQL can be optimized Increased network traffic Greater security Code sharing SQL can be optimized Increased network traffic Greater security ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A updatable view has its own data. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction For what purposes are views used? To hide columns only To hide complicated SQL statements only All of these To hide rows only To hide columns only To hide complicated SQL statements only All of these To hide rows only ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL views can be used to hide: None of these columns and rows only. complicated SQL syntax only. both of the above can be hidden by an SQL view. None of these columns and rows only. complicated SQL syntax only. both of the above can be hidden by an SQL view. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS