Database Management System - DBMS MCQ Questions and Answers Quiz

131. In RDBMS, Data is presented as a collection of............

  1. Relations
  2. Table
  3. Attributes
  4. Entities

132. The relational model is based on the concept that data is organized and stored in two-dimensional tables called ……………………….

  1. Relations
  2. Fields
  3. Records
  4. Keys

133. In an ER model, …………… is described in the database by storing its data.

  1. Relationship
  2. Entity
  3. Attribute
  4. Notation

134. The three basic techniques to control deadlocks are: deadlock ………………, deadlock detection, and deadlock avoidance.

  1. rollback
  2. prevention
  3. prohibition
  4. Commits

135. A tuple is a(n):

  1. row of a table
  2. column of a table
  3. two dimensional table
  4. key of a table

136. The……………… lock allows concurrent transactions to access the same row as long as they require the use of different fields within that row.

  1. row-level
  2. table-level
  3. page-level
  4. field-level

137. The number of tuples in a relation is called its ………… While the number of attributes in a relation is called its ………………..

  1. Rows, Columns
  2. Degree, Cardinality
  3. Cardinality, Degree
  4. Columns, Rows

138. Which of the following in not a function of DBA?

  1. Schema Definition
  2. Network Maintenance
  3. Routine Maintenance
  4. Authorization for data access

139. After conversion of high level queries into low level commands for file access and is called compiled………………

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

140. Which are the not features of a DBMS which provide a number of advantages for data management:

  1. SDL
  2. DML
  3. DDL
  4. None of these
Tags

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

Database Management System - DBMS Trivia Questions and Answers PDF

Database Management System - DBMS Question and Answer

Spreading Knowledge Across the World

USA - United States of America  Canada  United Kingdom  Australia  New Zealand  South America  Brazil  Portugal  Netherland  South Africa  Ethiopia  Zambia  Singapore  Malaysia  India  China  UAE - Saudi Arabia  Qatar  Oman  Kuwait  Bahrain  Dubai  Israil  England  Scotland  Norway  Ireland  Denmark  France  Spain  Poland  and many more....