SQL for Database Construction What SQL structure is used to limit column values of a table? The CHECK constraint The LIMIT constraint None of these The VALUE constraint The CHECK constraint The LIMIT constraint None of these The VALUE constraint ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is an SQL trigger supported by Oracle? BEFORE INSTEAD OF AFTER All of these BEFORE INSTEAD OF AFTER All of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an advantage of placing computations in SQL views? 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 To save users from having to write an expression. To ensure that the results are consistent. To accomplish both of the above. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data. False True False True 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 Lists of values Range checks Comparing one column value to another within the same table System date Lists of values Range checks ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction For what purposes are views used? To hide rows only All of these To hide columns only To hide complicated SQL statements only To hide rows only All of these To hide columns only To hide complicated SQL statements only ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS