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 Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause. True False True False ANSWER DOWNLOAD EXAMIANS APP
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 column in a particular underlying table. a particular column in a particular row. a particular row in a particular underlying table. None of these a particular column in a particular underlying table. a particular column in a particular row. a particular row in a particular underlying table. 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 ensure that the results are consistent. To save users from having to write an expression. To accomplish both of the above. None of these To ensure that the results are consistent. To save users from having to write an expression. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which is NOT one of the most common types of SQL CHECK constraints? 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 Lists of values ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL views can be used to hide: complicated SQL syntax only. None of these columns and rows only. both of the above can be hidden by an SQL view. complicated SQL syntax only. None of these columns and rows only. both of the above can be hidden by an SQL view. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS