SQL for Database Construction What is not an advantage of stored procedures? Increased network traffic Greater security SQL can be optimized Code sharing Increased network traffic Greater security SQL can be optimized Code sharing ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Common types of SQL CHECK constraints include range checks and limiting columns values. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a stored program that is attached to a table or a view. trigger embedded SELECT statement pseudofile None of these trigger embedded SELECT statement pseudofile None of these 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 Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Three types of triggers are: BEFORE, AFTER and EXCEPTION. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS