SQL for Database Construction A ________ is a program that performs some common action on database data and that is stored in the database. stored procedure pseudofile trigger None of these stored procedure pseudofile trigger None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL DELETE statement is used to delete both the table structure and table data. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an SQL virtual table that is constructed from other tables? Just another table A view A relation Query results Just another table A view A relation Query results ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Code sharing Greater security Increased network traffic SQL can be optimized Code sharing Greater security Increased network traffic SQL can be optimized ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What SQL structure is used to limit column values of a table? None of these The LIMIT constraint The CHECK constraint The VALUE constraint None of these The LIMIT constraint The CHECK constraint The VALUE constraint ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS