SQL for Database Construction Views can be used to show the results of computed columns. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction For what purposes are views used? To hide complicated SQL statements only All of these To hide rows only To hide columns only To hide complicated SQL statements only All of these To hide rows only To hide columns only ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement to create a view is: INSERT VIEW CREATE VIEW SELECT VIEW MAKE VIEW INSERT VIEW CREATE VIEW SELECT VIEW MAKE VIEW 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL statements can be embedded in triggers, stored procedures, and program code. 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 LIMIT constraint None of these The CHECK constraint The VALUE constraint The LIMIT constraint None of these The CHECK constraint The VALUE constraint ANSWER DOWNLOAD EXAMIANS APP