SQL for Database Construction A reason for using an SQL view to hide columns is: to accomplish both of the above. None of these to simplify a result only. to prevent the display of sensitive data only. to accomplish both of the above. None of these to simplify a result only. to prevent the display of sensitive data only. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL command to create a table is: ALTER TABLE CREATE TABLE MAKE TABLE DEFINE TABLE ALTER TABLE CREATE TABLE MAKE TABLE DEFINE TABLE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL Server does not support the BEFORE trigger. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What SQL structure is used to limit column values of a table? The CHECK constraint None of these The VALUE constraint The LIMIT constraint The CHECK constraint None of these The VALUE constraint The LIMIT constraint ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS