A benefit of using a stored procedure is that it can be distributed to client computers. True False TRUE ANSWER : ? YOUR ANSWER : ?
A reason for using an SQL view to hide columns is: to prevent the display of sensitive data only. None of these to simplify a result only. to accomplish both of the above. TRUE ANSWER : ? YOUR ANSWER : ?
What is not an advantage of stored procedures? SQL can be optimized Greater security Increased network traffic Code sharing TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is an SQL trigger supported by Oracle? All of these INSTEAD OF BEFORE AFTER TRUE ANSWER : ? YOUR ANSWER : ?
Common types of SQL CHECK constraints include range checks and limiting columns values. False True TRUE ANSWER : ? YOUR ANSWER : ?
A view that contains a computed column can be easily updated. True False TRUE ANSWER : ? YOUR ANSWER : ?
The SQL command to create a table is: ALTER TABLE MAKE TABLE DEFINE TABLE CREATE TABLE TRUE ANSWER : ? YOUR ANSWER : ?
A stored procedure is a program that performs some common action on database data and is stored in the database. False True TRUE ANSWER : ? YOUR ANSWER : ?
The SQL ALTER statement can be used to: change the table structure. change the table data. add rows to the table. delete rows from the table. TRUE ANSWER : ? YOUR ANSWER : ?