A SQL view is a virtual table that is constructed from other tables or views. False True TRUE ANSWER : ? YOUR ANSWER : ?
For what purposes are views used? To hide complicated SQL statements only All of these To hide rows only To hide columns only TRUE ANSWER : ? YOUR ANSWER : ?
There are three SQL data modification operations: insert, modify and delete. True False TRUE ANSWER : ? YOUR ANSWER : ?
A reason for using an SQL view to hide columns is: to accomplish both of the above. None of these to simplify a result only. to prevent the display of sensitive data only. TRUE ANSWER : ? YOUR ANSWER : ?
A ________ is a program that performs some common action on database data and that is stored in the database. pseudofile trigger stored procedure None of these TRUE ANSWER : ? YOUR ANSWER : ?
What SQL structure is used to limit column values of a table? The VALUE constraint None of these The LIMIT constraint The CHECK constraint TRUE ANSWER : ? YOUR ANSWER : ?
When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables. True False TRUE ANSWER : ? YOUR ANSWER : ?