SQL for Database Construction What is not an advantage of stored procedures? Increased network traffic Greater security SQL can be optimized Code sharing Increased network traffic Greater security SQL can be optimized Code sharing ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a stored program that is attached to a table or a view. None of these pseudofile trigger embedded SELECT statement None of these pseudofile trigger embedded SELECT statement ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL command to create a table is: ALTER TABLE DEFINE TABLE CREATE TABLE MAKE TABLE ALTER TABLE DEFINE TABLE CREATE TABLE MAKE TABLE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The DROP TABLE statement: deletes the table structure only. works whether or not referential integrity constraints would be violated. deletes the table structure along with the table data. is not an SQL statement. deletes the table structure only. works whether or not referential integrity constraints would be violated. deletes the table structure along with the table data. is not an SQL statement. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A reason for using an SQL view to hide columns is: to accomplish both of the above. to simplify a result only. to prevent the display of sensitive data only. None of these to accomplish both of the above. to simplify a result only. to prevent the display of sensitive data only. None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A stored procedure is a program that performs some common action on database data and is stored in the database. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS