Database Management System (DBMS) MCQs with answers Page - 139

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. Which of the following specifies a boolean expression that must be true for the trigger to fire?

  • (A) Trigger Action
  • (B) Triggering Event
  • (C) Trigger Restriction
  • (D) None of the above

A

Admin • 833.24K Points
Coach

Q. Which of the following trigger will be executed before modifying each row affected by the triggering statement?

  • (A) Before Statement Trigger
  • (B) After Row Trigger
  • (C) Before Row Trigger
  • (D) None of the above

A

Admin • 833.24K Points
Coach

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.

A

Admin • 833.24K Points
Coach

Q. A database is divided into logical storage units called as

  • (A) Tables
  • (B) Records
  • (C) Tablespaces
  • (D) None of the above

A

Admin • 833.24K Points
Coach

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

A

Admin • 833.24K Points
Coach

Q. SGA stands for

  • (A) System Go Ahead
  • (B) Software Global Area
  • (C) System Global Area
  • (D) None of the above

A

Admin • 833.24K Points
Coach

Q. This statement fails when executed: CREATE OR REPLACE TRI GGER CALC_TEAM_AVG AFTER I NSERT ON PLAYER BEGIN INSERT INTO PLAYER_BATSTAT ( PLAYER_I D, SEASON_YEAR, AT_BATS, HI TS) VALUES ( : NEW. I D, 1 997, 0, 0) ; END; To which type must you convert the trigger to correct the error?

  • (A) Row
  • (B) Statement
  • (C) ORACLE FORM trigger
  • (D) Before

A

Admin • 833.24K Points
Coach

Q. The OLD and NEW qualifiers can be used in which type of trigger?

  • (A) Row level DML trigger
  • (B) Row level system trigger
  • (C) Statement level DML trigger
  • (D) Row level application trigger

A

Admin • 833.24K Points
Coach

Q. Trigger are not supported in

  • (A) Delete
  • (B) Update
  • (C) Views
  • (D) All of the mentioned

A

Admin • 833.24K Points
Coach

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 AFTERINSERT trigger.

  • (A) for insert, on
  • (B) On, for insert
  • (C) For, insert
  • (D) Both a and c

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.