SQL for Database Construction SQL views can be used to hide: None of these both of the above can be hidden by an SQL view. columns and rows only. complicated SQL syntax only. None of these both of the above can be hidden by an SQL view. columns and rows only. complicated SQL syntax only. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What SQL structure is used to limit column values of a table? The VALUE constraint None of these The LIMIT constraint The CHECK constraint The VALUE constraint None of these The LIMIT constraint The CHECK constraint ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: GROUP BY WHERE FROM ORDER BY GROUP BY WHERE FROM ORDER BY ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement used to create a view is CREATE VIEW. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement to create a view is: INSERT VIEW MAKE VIEW SELECT VIEW CREATE VIEW INSERT VIEW MAKE VIEW SELECT VIEW CREATE VIEW ANSWER DOWNLOAD EXAMIANS APP