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 What is an advantage of placing computations in SQL views? To accomplish both of the above. None of these To save users from having to write an expression. To ensure that the results are consistent. To accomplish both of the above. None of these To save users from having to write an expression. To ensure that the results are consistent. 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. to simplify a result only. None of these to accomplish both of the above. to prevent the display of sensitive data only. to simplify a result only. None of these to accomplish both of the above. 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 embedded SELECT statement pseudofile trigger None of these embedded SELECT statement pseudofile trigger ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL statements can be embedded in triggers, stored procedures, and program code. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS