SQL for Database Construction For what purposes are views used? To hide rows only To hide complicated SQL statements only To hide columns only All of these To hide rows only To hide complicated SQL statements only To hide columns only All of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an SQL virtual table that is constructed from other tables? Query results A relation Just another table A view Query results A relation Just another table A view ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement to create a view is: MAKE VIEW CREATE VIEW INSERT VIEW SELECT VIEW MAKE VIEW CREATE VIEW INSERT VIEW SELECT VIEW ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A view that contains a computed column can be easily updated. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction There are three SQL data modification operations: insert, modify and delete. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What SQL structure is used to limit column values of a table? The LIMIT constraint The CHECK constraint None of these The VALUE constraint The LIMIT constraint The CHECK constraint None of these The VALUE constraint ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS