SQL for Database Construction What is an advantage of placing computations in SQL views? To accomplish both of the above. To save users from having to write an expression. To ensure that the results are consistent. None of these To accomplish both of the above. To save users from having to write an expression. To ensure that the results are consistent. None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A SQL view is a virtual table that is constructed from other tables or views. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL command to create a table is: DEFINE TABLE CREATE TABLE MAKE TABLE ALTER TABLE DEFINE TABLE CREATE TABLE MAKE TABLE ALTER TABLE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction For what purposes are views used? To hide columns only All of these 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 ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: WHERE GROUP BY ORDER BY FROM WHERE GROUP BY ORDER BY FROM ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Views can be used to show the results of computed columns. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS