SQL for Database Construction A ________ is a stored program that is attached to a table or a view. embedded SELECT statement trigger pseudofile None of these embedded SELECT statement trigger pseudofile None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Code sharing Increased network traffic Greater security SQL can be optimized Code sharing Increased network traffic Greater security SQL can be optimized ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction For what purposes are views used? All of these To hide columns only To hide rows only To hide complicated SQL statements only All of these To hide columns only To hide rows only To hide complicated SQL statements only ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction There are three SQL data modification operations: insert, modify and delete. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL ALTER statement can be used to: add rows to the table. change the table structure. change the table data. delete rows from the table. add rows to the table. change the table structure. change the table data. delete rows from the table. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL command to create a table is: CREATE TABLE ALTER TABLE DEFINE TABLE MAKE TABLE CREATE TABLE ALTER TABLE DEFINE TABLE MAKE TABLE ANSWER DOWNLOAD EXAMIANS APP