SQL for Database Construction A ________ is a stored program that is attached to a table or a view. None of these trigger embedded SELECT statement pseudofile None of these trigger embedded SELECT statement pseudofile ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A view that contains a computed column can be easily updated. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an advantage of placing computations in SQL views? None of these To accomplish both of the above. To save users from having to write an expression. To ensure that the results are consistent. None of these To accomplish both of the above. To save users from having to write an expression. To ensure that the results are consistent. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which is NOT one of the most common types of SQL CHECK constraints? Comparing one column value to another within the same table Lists of values System date Range checks Comparing one column value to another within the same table Lists of values System date Range checks 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 ORDER BY GROUP BY WHERE FROM ORDER BY GROUP BY ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS