SQL for Database Construction When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Common types of SQL CHECK constraints include range checks and limiting columns values. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a stored program that is attached to a table or a view. trigger None of these pseudofile embedded SELECT statement trigger None of these pseudofile embedded SELECT statement ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an SQL virtual table that is constructed from other tables? Query results Just another table A relation A view Query results Just another table A relation A view 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 Which is NOT one of the most common types of SQL CHECK constraints? System date Comparing one column value to another within the same table Range checks Lists of values System date Comparing one column value to another within the same table Range checks Lists of values ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS