SQL for Database Construction For what purposes are views used? 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 All of these To hide columns only 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 What SQL structure is used to limit column values of a table? The VALUE constraint The CHECK constraint The LIMIT constraint None of these The VALUE constraint The CHECK constraint The LIMIT constraint None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A benefit of using a stored procedure is that it can be distributed to client computers. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is an SQL trigger supported by Oracle? BEFORE All of these AFTER INSTEAD OF BEFORE All of these AFTER INSTEAD OF ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement used to create a view is CREATE VIEW. True False True False ANSWER DOWNLOAD EXAMIANS APP