SQL for Database Construction To update an SQL view, the DBMS must be able to associate the column(s) to be updated with: None of these a particular row in a particular underlying table. a particular column in a particular underlying table. a particular column in a particular row. None of these a particular row in a particular underlying table. a particular column in a particular underlying table. a particular column in a particular row. 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 Which is NOT one of the most common types of SQL CHECK constraints? Lists of values System date Comparing one column value to another within the same table Range checks Lists of values System date Comparing one column value to another within the same table Range checks ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is an SQL trigger supported by Oracle? BEFORE INSTEAD OF All of these AFTER BEFORE INSTEAD OF All of these AFTER 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 SQL Server does not support the BEFORE trigger. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS