Views can be used to show the results of computed columns. True False TRUE ANSWER : ? YOUR ANSWER : ?
For what purposes are views used? All of these To hide complicated SQL statements only To hide rows only To hide columns only TRUE ANSWER : ? YOUR ANSWER : ?
A view that contains a computed column can be easily updated. True False TRUE ANSWER : ? YOUR ANSWER : ?
A ________ is a stored program that is attached to a table or a view. trigger pseudofile embedded SELECT statement None of these TRUE ANSWER : ? YOUR ANSWER : ?
SQL views can be used to hide: complicated SQL syntax only. None of these both of the above can be hidden by an SQL view. columns and rows only. TRUE ANSWER : ? YOUR ANSWER : ?
The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors. False True TRUE ANSWER : ? YOUR ANSWER : ?
The SQL statement to create a view is: CREATE VIEW MAKE VIEW INSERT VIEW SELECT VIEW TRUE ANSWER : ? YOUR ANSWER : ?
What SQL structure is used to limit column values of a table? The VALUE constraint The CHECK constraint The LIMIT constraint None of these TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is an SQL trigger supported by Oracle? AFTER BEFORE INSTEAD OF All of these TRUE ANSWER : ? YOUR ANSWER : ?