SQL for Database Construction SQL views can be used to hide: complicated SQL syntax only. None of these columns and rows only. both of the above can be hidden by an SQL view. complicated SQL syntax only. None of these columns and rows only. both of the above can be hidden by an SQL view. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an advantage of placing computations in SQL views? To save users from having to write an expression. To ensure that the results are consistent. To accomplish both of the above. None of these To save users from having to write an expression. To ensure that the results are consistent. To accomplish both of the above. None of these 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 Which of the following is NOT a type of SQL constraint? FOREIGN KEY ALTERNATE KEY PRIMARY KEY UNIQUE FOREIGN KEY ALTERNATE KEY PRIMARY KEY UNIQUE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a stored program that is attached to a table or a view. embedded SELECT statement trigger None of these pseudofile embedded SELECT statement trigger None of these pseudofile ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which is NOT one of the most common types of SQL CHECK constraints? Range checks Comparing one column value to another within the same table System date Lists of values Range checks Comparing one column value to another within the same table System date Lists of values ANSWER DOWNLOAD EXAMIANS APP