SQL for Database Construction Which of the following is NOT a type of SQL constraint? ALTERNATE KEY UNIQUE PRIMARY KEY FOREIGN KEY ALTERNATE KEY UNIQUE PRIMARY KEY FOREIGN KEY ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is an SQL trigger supported by Oracle? INSTEAD OF BEFORE AFTER All of these INSTEAD OF BEFORE AFTER All of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Common types of SQL CHECK constraints include range checks and limiting columns values. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction For what purposes are views used? To hide rows only To hide complicated SQL statements only To hide columns only All of these To hide rows only To hide complicated SQL statements only To hide columns only All of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an advantage of placing computations in SQL views? To ensure that the results are consistent. To save users from having to write an expression. To accomplish both of the above. None of these To ensure that the results are consistent. To save users from having to write an expression. To accomplish both of the above. None of these ANSWER DOWNLOAD EXAMIANS APP
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