SQL for Database Construction What is an advantage of placing computations in SQL views? To accomplish both of the above. To ensure that the results are consistent. To save users from having to write an expression. None of these To accomplish both of the above. To ensure that the results are consistent. To save users from having to write an expression. 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. stored procedure pseudofile trigger None of these stored procedure pseudofile trigger None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL Server does not support the BEFORE trigger. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is an SQL trigger supported by Oracle? AFTER INSTEAD OF BEFORE All of these AFTER INSTEAD OF BEFORE All of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a stored program that is attached to a table or a view. None of these trigger pseudofile embedded SELECT statement None of these trigger pseudofile embedded SELECT statement ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What SQL structure is used to limit column values of a table? The LIMIT constraint None of these The CHECK constraint The VALUE constraint The LIMIT constraint None of these The CHECK constraint The VALUE constraint ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS