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

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. In order to undo the work of transaction after last commit which one should be used?

  • (A) view
  • (B) commit
  • (C) rollback
  • (D) flashback

A

Admin • 833.24K Points
Coach

Q. Which of the following function is used to find the column count of the particular resultset?

  • (A) getmetadata()
  • (B) metadata()
  • (C) getcolumn()
  • (D) get count()

A

Admin • 833.24K Points
Coach

Q. Which of the following is used as the embedded SQL in COBOL?

  • (A) exec sql <embedded sql statement >;
  • (B) exec sql <embedded sql statement > end-exec
  • (C) exec sql <embedded sql statement >
  • (D) exec sql <embedded sql statement > end exec;

A

Admin • 833.24K Points
Coach

Q. Which of the following is used to distinguish the variables in SQL from the host language variables?

  • (A) .
  • (B) –
  • (C) :
  • (D) ,

A

Admin • 833.24K Points
Coach

Q. Which of the following is used to access large objects from a database ?

  • (A) setblob()
  • (B) getblob()
  • (C) getclob()
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. A is a special kind of a store procedure that executes in response to certain action on the table like insertion, deletion or updation of data.

  • (A) procedures
  • (B) triggers
  • (C) functions
  • (D) none of the mentioned

A

Admin • 833.24K Points
Coach

Q. Triggers are supported in

  • (A) delete
  • (B) update
  • (C) views
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. What are the after triggers?

  • (A) triggers generated after a particular operation
  • (B) these triggers run after an insert, update or delete on a table
  • (C) these triggers run after an insert, views, update or delete on a table
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. The variables in the triggers are declared using

  • (A) –
  • (B) @
  • (C) /
  • (D) /@

A

Admin • 833.24K Points
Coach

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

  • (A) .txt
  • (B) .pls
  • (C) .ora
  • (D) .sql

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.