A SQL view is a virtual table that is constructed from other tables or views. True False TRUE ANSWER : ? YOUR ANSWER : ?
A benefit of using a stored procedure is that it can be distributed to client computers. True False TRUE ANSWER : ? YOUR ANSWER : ?
What SQL structure is used to limit column values of a table? The CHECK constraint None of these The VALUE constraint The LIMIT constraint 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 : ?
A ________ is a program that performs some common action on database data and that is stored in the database. trigger pseudofile None of these stored procedure TRUE ANSWER : ? YOUR ANSWER : ?
Which of the following is an SQL trigger supported by Oracle? AFTER INSTEAD OF All of these BEFORE TRUE ANSWER : ? YOUR ANSWER : ?
What is not an advantage of stored procedures? Code sharing Increased network traffic SQL can be optimized Greater security TRUE ANSWER : ? YOUR ANSWER : ?
SQL has a JOIN ON syntax that can be used to create inner joins and outer joins. True False TRUE ANSWER : ? YOUR ANSWER : ?
Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause. False True TRUE ANSWER : ? YOUR ANSWER : ?