Database Management System (DBMS)

101. DML is a languages by which user accesses or manipulates the ___________:

  1. Data model
  2. Data consistency
  3. Data integration
  4. Data sharing

Correct answer: (A)
Data model

102. Which is the central component of the DBMS software that can also be termed as the database control system:

  1. Data consistency
  2. Data integration
  3. Data sharing
  4. Data manager

Correct answer: (D)
Data manager

103. Which is stored information about description of data in the database:

  1. Data files
  2. Data dictionary
  3. Database
  4. Data administrator

Correct answer: (B)
Data dictionary

104. After conversion of high level queries into low level commands for file access and is called compiled ___________:

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

Correct answer: (B)
DML

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

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

Correct answer: (A)
DBA

106. Which is incorporated to create an appropriate physical database that is transformed by a logical data model:

  1. SDL
  2. VDL
  3. Both
  4. None

Correct answer: (D)
None

107. SQL stands for:

  1. System query language
  2. Sequential query language
  3. Sets query languages
  4. None of these

Correct answer: (B)
Sequential query language

108. CSV stands for:

  1. Command system values
  2. Comma system values
  3. Command separated values
  4. Comma separated values

Correct answer: (D)
Comma separated values

109. PDF stands for:

  1. Physical data format
  2. Portable document format
  3. Physical document format
  4. Portable data format

Correct answer: (B)
Portable document format

110. XML stands for:

  1. Xtensible markup languages
  2. Xtensible memory languages
  3. Both
  4. None

Correct answer: (A)
Xtensible markup languages

Page 11 of 45