SQL for Database Construction SQL views can be used to hide: None of these both of the above can be hidden by an SQL view. columns and rows only. complicated SQL syntax only. None of these both of the above can be hidden by an SQL view. columns and rows only. complicated SQL syntax only. 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 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 Common types of SQL CHECK constraints include range checks and limiting columns values. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an advantage of placing computations in SQL views? To accomplish both of the above. To save users from having to write an expression. None of these To ensure that the results are consistent. To accomplish both of the above. To save users from having to write an expression. None of these 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. 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 to accomplish both of the above. to simplify a result only. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL DELETE statement is used to delete both the table structure and table data. True False True False ANSWER DOWNLOAD EXAMIANS APP