Q. The CREATE TRIGGER statement is used to create the trigger. THE _____ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.

View solution

Q. What are the after triggers ?

View solution

Q. The variables in the triggers are declared using

View solution

Q. The default extension for an Oracle SQL*Plus file is:

View solution

Q. Triggers ________ enabled or disabled.

View solution

Q. To include integrity constraint in a existing relation use :

View solution

Q. Which of the following is not a integrity constraint ?

View solution

Q. Which of the following is the right syntax for assertion?

View solution

Q. Which of the following can be addressed by enforcing a referential integrity constraint?

View solution

Q. Drop Table cannot be used to drop a table referenced by a _________ constraint.

View solution

Q. ____________ is preferred method for enforcing data integrity.

View solution

Q. SQL stands for ________ .

View solution

Q. The SQL command to create a table is:

View solution

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

View solution

Q. The DROP TABLE statement:

View solution

Q. SQL views can be used to hide:

View solution

Q. The SQL statement to create a view is:

View solution

Q. To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:

View solution

Q. Which of the following is NOT a type of SQL constraint?

View solution

Q. A ________ is a program that performs some common action on database data and that is stored in the database.

View solution