Which is NOT one of the most common types of SQL CHECK constraints? System date Lists of values Comparing one column value to another within the same table Range checks TRUE ANSWER : ? YOUR ANSWER : ?
Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause. False True TRUE ANSWER : ? YOUR ANSWER : ?
The DROP TABLE statement: deletes the table structure along with the table data. is not an SQL statement. deletes the table structure only. works whether or not referential integrity constraints would be violated. TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is an SQL trigger supported by Oracle? INSTEAD OF AFTER BEFORE All of these TRUE ANSWER : ? YOUR ANSWER : ?
What is not an advantage of stored procedures? SQL can be optimized Increased network traffic Greater security Code sharing 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 SELECT VIEW MAKE VIEW INSERT VIEW TRUE ANSWER : ? YOUR ANSWER : ?
A ________ is a stored program that is attached to a table or a view. None of these embedded SELECT statement trigger pseudofile TRUE ANSWER : ? YOUR ANSWER : ?
For what purposes are views used? To hide rows only To hide columns only To hide complicated SQL statements only All of these TRUE ANSWER : ? YOUR ANSWER : ?