SQL for Database Construction The SQL statement to create a view is: SELECT VIEW CREATE VIEW MAKE VIEW INSERT VIEW SELECT VIEW CREATE VIEW MAKE VIEW INSERT VIEW 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 A ________ is a program that performs some common action on database data and that is stored in the database. pseudofile trigger None of these stored procedure pseudofile trigger None of these stored procedure ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What SQL structure is used to limit column values of a table? None of these The CHECK constraint The LIMIT constraint The VALUE constraint None of these The CHECK constraint The LIMIT constraint The VALUE constraint ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Greater security Code sharing SQL can be optimized Increased network traffic Greater security Code sharing SQL can be optimized Increased network traffic ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS