SQL for Database Construction What is an advantage of placing computations in SQL views? 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. To accomplish both of the above. None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a program that performs some common action on database data and that is stored in the database. trigger pseudofile stored procedure None of these trigger pseudofile stored procedure None of these 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
SQL for Database Construction What SQL structure is used to limit column values of a table? None of these The VALUE constraint The LIMIT constraint The CHECK constraint None of these The VALUE constraint The LIMIT constraint The CHECK constraint ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement to create a view is: SELECT VIEW CREATE VIEW INSERT VIEW MAKE VIEW SELECT VIEW CREATE VIEW INSERT VIEW MAKE VIEW 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