SQL for Database Construction A reason for using an SQL view to hide columns is: 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. to prevent the display of sensitive data only. 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 A updatable view has its own data. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a stored program that is attached to a table or a view. pseudofile None of these trigger embedded SELECT statement pseudofile None of these trigger embedded SELECT statement ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is NOT a type of SQL constraint? ALTERNATE KEY PRIMARY KEY FOREIGN KEY UNIQUE ALTERNATE KEY PRIMARY KEY FOREIGN KEY UNIQUE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is an SQL trigger supported by Oracle? All of these BEFORE AFTER INSTEAD OF All of these BEFORE AFTER INSTEAD OF ANSWER DOWNLOAD EXAMIANS APP