SQL for Database Construction For what purposes are views used? To hide complicated SQL statements only To hide columns only To hide rows only All of these To hide complicated SQL statements only To hide columns only To hide rows only All of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL statements can be embedded in triggers, stored procedures, and program code. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement to create a view is: CREATE VIEW INSERT VIEW MAKE VIEW SELECT VIEW CREATE VIEW INSERT VIEW MAKE VIEW SELECT VIEW ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an advantage of placing computations in SQL views? To save users from having to write an expression. None of these To accomplish both of the above. To ensure that the results are consistent. To save users from having to write an expression. None of these To accomplish both of the above. To ensure that the results are consistent. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL views can be used to hide: complicated SQL syntax only. both of the above can be hidden by an SQL view. None of these columns and rows only. complicated SQL syntax only. both of the above can be hidden by an SQL view. None of these columns and rows 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: FROM WHERE GROUP BY ORDER BY FROM WHERE GROUP BY ORDER BY ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS