Exam 12: Introduce the topic of importing Microsoft Excel 2016 data into a database table

Which of the following is an SQL trigger that Oracle supports?

SQL triggers can be used when the DBMS receives an INSERT request.

SQL triggers are used for providing default values,validity checking,updating views,and performing referential integrity actions.

What are SQL stored procedures and how are they used?

SQL views can be used to hide complicated SQL syntax.

Stored procedures have the advantage of all choices except ________.

A stored program that is stored within the database and compiled when used is called a trigger.

Which of the following is not an SQL trigger?

A stored program that is attached to the database is called ________.

A stored program that is attached to a table or view is called ________.

Although it cannot be used in creating an SQL VIEW,the SQL SELECT statements retrieving view instances can include ________.

The SQL statement used to delete a view from a database is ________.

SQL views are constructed from ________.

Describe a situation where a SQL MERGE statement is appropriately used in a table.

Microsoft Access ________ can use previously stored view equivalent Access queries the same way an SQL SELECT statement uses SQL views.

SQL triggers can be used with SQL operations INSERT,UPDATE,and DELETE.

SQL views contain their own data.

SQL views are constructed from SELECT statements.

Since an SQL view is essentially a stored query,Microsoft Access queries can be used to implement SQL view equivalents.

Unlike application code,stored procedures are never distributed to the client computers.