SQL for Database Construction A reason for using an SQL view to hide columns is: to prevent the display of sensitive data only. to accomplish both of the above. to simplify a result only. None of these to prevent the display of sensitive data only. to accomplish both of the above. to simplify a result only. None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL ALTER statement can be used to: add rows to the table. delete rows from the table. change the table structure. change the table data. add rows to the table. delete rows from the table. change the table structure. change the table data. 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 A benefit of using a stored procedure is that it can be distributed to client computers. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an SQL virtual table that is constructed from other tables? Just another table Query results A view A relation Just another table Query results A view A relation ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The DROP TABLE statement: deletes the table structure only. deletes the table structure along with the table data. works whether or not referential integrity constraints would be violated. is not an SQL statement. deletes the table structure only. deletes the table structure along with the table data. works whether or not referential integrity constraints would be violated. is not an SQL statement. ANSWER DOWNLOAD EXAMIANS APP