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 : ?
What SQL structure is used to limit column values of a table? None of these The VALUE constraint The CHECK constraint The LIMIT constraint TRUE ANSWER : ? YOUR ANSWER : ?
A SQL view is a virtual table that is constructed from other tables or views. True False TRUE ANSWER : ? YOUR ANSWER : ?
When using the SQL INSERT statement: rows can either be inserted into a table one at a time or in groups. rows cannot be copied in mass from one table to another only. rows can be modified according to criteria only. rows can be inserted into a table only one at a time only. TRUE ANSWER : ? YOUR ANSWER : ?
What is an SQL virtual table that is constructed from other tables? A view Query results A relation Just another table TRUE ANSWER : ? YOUR ANSWER : ?
There are three SQL data modification operations: insert, modify and delete. False True TRUE ANSWER : ? YOUR ANSWER : ?
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: FROM GROUP BY WHERE ORDER BY TRUE ANSWER : ? YOUR ANSWER : ?
The DROP TABLE statement: works whether or not referential integrity constraints would be violated. is not an SQL statement. deletes the table structure only. deletes the table structure along with the table data. TRUE ANSWER : ? YOUR ANSWER : ?