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 A SQL view is a virtual table that is constructed from other tables or views. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A trigger is a stored program that is attached to a database. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: WHERE FROM GROUP BY ORDER BY WHERE FROM GROUP BY ORDER BY 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. None of these trigger pseudofile stored procedure None of these trigger pseudofile stored procedure ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an advantage of placing computations in SQL views? None of these To save users from having to write an expression. To accomplish both of the above. To ensure that the results are consistent. None of these To save users from having to write an expression. To accomplish both of the above. To ensure that the results are consistent. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS