Ready to test your Knowledge?
Try out our new practice tests completely free!
exam preparation banner icon

Database Concepts Study Set 2

Computing

Quiz 12 :

James River Jewelry Project Questions

Quiz 12 :

James River Jewelry Project Questions

search
arrow
SQL views can be used to layer built-in SQL functions.
Free
True False
Answer:

Answer:

True

arrow
An SQL virtual table is called a view.
Free
True False
Answer:

Answer:

True

arrow
SQL triggers use the SQL keywords BEFORE,INSTEAD OF,and AFTER.
Free
True False
Answer:

Answer:

True

arrow
The SQL statement DROP VIEW ViewName is used to delete a view from a database.
True False
Answer:
arrow
SQL triggers can be used with SQL operations INSERT,UPDATE,and DELETE.
True False
Answer:
arrow
SQL views can be used to hide columns.
True False
Answer:
arrow
SQL views can be used to hide rows.
True False
Answer:
arrow
The SQL statement ALTER EXISTING VIEW ViewName AS is used to modify a view.
True False
Answer:
arrow
The Oracle DBMS supports the SQL BEFORE trigger.
True False
Answer:
arrow
SQL views can be used to display the results of computed columns.
True False
Answer:
arrow
SQL views contain their own data.
True False
Answer:
arrow
SQL triggers can be used when the DBMS receives an INSERT request.
True False
Answer:
arrow
SQL views are constructed from SELECT statements.
True False
Answer:
arrow
A stored program that is attached to a table or view is called a stored procedure.
True False
Answer:
arrow
SQL statements used to construct views cannot contain the WHERE clause.
True False
Answer:
arrow
The SQL command CREATE VIEW is used to create view structures.
True False
Answer:
arrow
SQL views can be used to hide complicated SQL syntax.
True False
Answer:
arrow
When an SQL SELECT statement is used to retrieve data from a view instance,the maximum number of columns that can be specified in the SELECT is the same as the number of columns in the table underlying the view.
True False
Answer:
arrow
The SQL keyword ORDER BY can be used with SELECT statements that are retrieving data from view instances to sort the results of the SELECT.
True False
Answer:
arrow
The SQL command SELECT is used to retrieve data from view instances.
True False
Answer:
Showing 1 - 20 of 70