SQL for Database Construction What is an SQL virtual table that is constructed from other tables? A view Query results A relation Just another table A view Query results A relation Just another table 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 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. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Greater security SQL can be optimized Increased network traffic Code sharing Greater security SQL can be optimized Increased network traffic Code sharing ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL statements can be embedded in triggers, stored procedures, and program code. True False True False 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 System date Range checks Lists of values Comparing one column value to another within the same table System date Range checks Lists of values ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A updatable view has its own data. True False True False ANSWER DOWNLOAD EXAMIANS APP