SQL for Database Construction Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: GROUP BY ORDER BY FROM WHERE GROUP BY ORDER BY FROM WHERE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A stored procedure is a program that performs some common action on database data and is stored in the database. True False True False ANSWER DOWNLOAD EXAMIANS APP
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 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
SQL for Database Construction For what purposes are views used? To hide columns only 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 ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL Server does not support the BEFORE trigger. True False True False ANSWER DOWNLOAD EXAMIANS APP