Database Management System - DBMS MCQ Questions and Answers Quiz

61. DA stands for:

  1. Define application
  2. Data administrator
  3. Database active
  4. All of these

62. Which command enables alteration the data stored in existing records:

  1. Deletion command
  2. Create command
  3. Update command
  4. All of these

63. Data Manipulation Language enables users to

  1. Deletion of information from the database
  2. Retrieval of information stored in database
  3. Insertion of new information into the database
  4. All of the above

64. A logical schema

  1. describes how data is actually stored on disk.
  2. is the entire database
  3. is a standard way of organizing information into accessible parts.
  4. All of the above

65. Which of the following is a group of one or more attributes that uniquely identifies a row?

  1. Determinant
  2. Key
  3. Tuple
  4. Relation

66. To eliminate duplicate rows ……………… is used

  1. DISTINCT
  2. NODUPLICATE
  3. ELIMINATE
  4. None of these

67. Which is installs, configures, troubleshoots and maintains a database system:

  1. DML
  2. DBA
  3. DDL
  4. SDL

68. Centralizing the integrity checking directly under the DBMS ………… duplication and ensures the consistency and validity of the database.

  1. Does not reduce
  2. Increases
  3. Skips
  4. Reduces

69. ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

  1. Domain Integrity Constraints
  2. Entity Integrity Constraints
  3. Referential Integrity Constraints
  4. Key Constraints

70. ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

  1. Domain Integrity Constraints
  2. Entity Integrity Constraints
  3. Referential Integrity Constraints
  4. Key Constraints
Tags

MCQ Multiple Choice Questions and Answers on Database Management System - DBMS

Database Management System - DBMS Question and Answer