SQL views can be used to hide: None of these both of the above can be hidden by an SQL view. complicated SQL syntax only. columns and rows only. TRUE ANSWER : ? YOUR ANSWER : ?
For what purposes are views used? All of these To hide columns only To hide rows only To hide complicated SQL statements only TRUE ANSWER : ? YOUR ANSWER : ?
The SQL command to create a table is: MAKE TABLE DEFINE TABLE ALTER TABLE CREATE TABLE TRUE ANSWER : ? YOUR ANSWER : ?
What SQL structure is used to limit column values of a table? The VALUE constraint The CHECK constraint None of these The LIMIT constraint TRUE ANSWER : ? YOUR ANSWER : ?
The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors. True False TRUE ANSWER : ? YOUR ANSWER : ?
If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data. True False TRUE ANSWER : ? YOUR ANSWER : ?
Common types of SQL CHECK constraints include range checks and limiting columns values. True False TRUE ANSWER : ? YOUR ANSWER : ?
The SQL statement to create a view is: INSERT VIEW CREATE VIEW MAKE VIEW SELECT VIEW TRUE ANSWER : ? YOUR ANSWER : ?
The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships. False True TRUE ANSWER : ? YOUR ANSWER : ?