Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Which of the following trigger is executed once for each row in a transaction?
a. Row-level Triggers
b. Statement-level Triggers
c. Repetitive Triggers
d. All of the above
Q. Which of the following is the default trigger that is created using the CREATETRIGGER command?
a. Row level Trigger
b. Statement level Trigger
c. BEFORE Trigger
d. AFTER Trigger
Q. Which of the following command is used to delete a trigger?
a. DELETE TRIGGER
b. REPLACE TRIGGER
c. DROP TRIGGER
d. None of the above
Q. What is the name of a trigger that initiates another trigger?
a. Triggering Trigger
b. Automatic Initiation Trigger
c. Cascading Trigger
d. None of the above
Q. Which of the following specifies a boolean expression that must be true for the triggerto fire?
a. Trigger Action
b. Triggering Event
c. Trigger Restriction
d. None of the above
Q. Which of the following trigger will be executed before modifying each row affected bythe triggering statement?
a. Before Statement Trigger
b. After Row Trigger
c. Before Row Trigger
d. None of the above
Q. Which of the following is not true in case of triggers?
a. Triggers accept parameters.
b. Triggers are executed implicitly
c. Execution of triggers is transparent to the users.
d. A trigger can invoke another trigger.
Q. A database is divided into logical storage units called as
a. Tables
b. Records
c. Tablespaces
d. None of the above
Q. A file used to govern the initialization of the instance is known as
a. Shared file
b. Parameter file
c. Read-only file
d. None of the above
Q. SGA stands for
a. System Go Ahead
b. Software Global Area
c. System Global Area
d. None of the above
Q. Which of the following is true concerning a procedure?
a. You do not create them with SQL.
b. They do not need to have a unique name.
c. They include procedural and SQL statements.
d. They are the same thing as a function.
Q. A CASE SQL statement is which of the following?
a. A way to establish an IF-THEN-ELSE in SQL.
b. A way to establish a loop in SQL.
c. A way to establish a data definition in SQL.
d. All of the above.
Q. Which of the following statements is true concerning routines and triggers?
a. Both consist of procedural code.
b. Both have to be called to operate.
c. Both run automatically.
d. Both are stored in the database.
Q. How many bytes does each character in the UTF8 encoding take up?
a. 1
b. 2
c. 3
d. All mentioned above