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

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 is the right syntax for the assertion?

  • (A) create assertion ‘assertion-name’ check ‘predicate’;
  • (B) create assertion check ‘predicate’ ‘assertion-name’;
  • (C) create assertions ‘predicates’;
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. Data integrity constraints are used to:

  • (A) control who is allowed access to the data
  • (B) ensure that duplicate records are not entered into the table
  • (C) improve the quality of data entered for a specific property (i.e., table column)
  • (D) prevent users from changing the values stored in the table

A

Admin • 833.24K Points
Coach

Q. Dates must be specified in the format

  • (A) mm/dd/yy
  • (B) yyyy/mm/dd
  • (C) dd/mm/yy
  • (D) yy/dd/mm

A

Admin • 833.24K Points
Coach

Q. A on an attribute of a relation is a data structure that allows the database system to find those tuples in the relation that have a specified value for that attribute efficiently, without scanning through all the tuples of the relation.

  • (A) index
  • (B) reference
  • (C) assertion
  • (D) timestamp

A

Admin • 833.24K Points
Coach

Q. Which of the following is used to store movie and image files?

  • (A) clob
  • (B) blob
  • (C) binary
  • (D) image

A

Admin • 833.24K Points
Coach

Q. The user defined data type can be created using

  • (A) create datatype
  • (B) create data
  • (C) create definetype
  • (D) create type

A

Admin • 833.24K Points
Coach

Q. Values of one type can be converted to another domain using which of the following?

  • (A) cast
  • (B) drop type
  • (C) alter type
  • (D) convert

A

Admin • 833.24K Points
Coach

Q. Which of the following closely resembles Create view?

  • (A) create table . . .like
  • (B) create table . . . as
  • (C) with data
  • (D) create view as

A

Admin • 833.24K Points
Coach

Q. In contemporary databases, the top level of the hierarchy consists of each of which can contain

  • (A) catalogs, schemas
  • (B) schemas, catalogs
  • (C) environment, schemas
  • (D) schemas, environment

A

Admin • 833.24K Points
Coach

Q. The database administrator who authorizes all the new users, modifies the database and takes grants privilege is

  • (A) super user
  • (B) administrator
  • (C) operator of operating system
  • (D) all of the mentioned

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.