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 The SQL ALTER statement can be used to: change the table data. add rows to the table. change the table structure. delete rows from the table. change the table data. add rows to the table. change the table structure. delete rows from the table. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a stored program that is attached to a table or a view. pseudofile embedded SELECT statement None of these trigger pseudofile embedded SELECT statement None of these trigger 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 None of these trigger stored procedure pseudofile None of these trigger stored procedure ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Code sharing SQL can be optimized Increased network traffic Greater security Code sharing SQL can be optimized Increased network traffic Greater security ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction For what purposes are views used? All of these To hide rows only 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 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS