SQL for Database Construction The SQL statement to create a view is: MAKE VIEW CREATE VIEW SELECT VIEW INSERT VIEW MAKE VIEW CREATE VIEW SELECT VIEW INSERT VIEW ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A benefit of using a stored procedure is that it can be distributed to client computers. True False True False 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 Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: WHERE FROM ORDER BY GROUP BY WHERE FROM ORDER BY GROUP BY ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction There are three SQL data modification operations: insert, modify and delete. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A reason for using an SQL view to hide columns is: to prevent the display of sensitive data only. None of these to simplify a result only. to accomplish both of the above. to prevent the display of sensitive data only. None of these to simplify a result only. to accomplish both of the above. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS