DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q161
An abstract model of the database from a business perspective best defines:
  • A physical design
  • B object design
  • C organizational view
  • D conceptual design
Answer: Option D
Q162
The process of creating small, stable data structures from complex groups of data when designing a relational database defines:
  • A data decomposition
  • B data structuring
  • C data transcribing
  • D normalization
Answer: Option D
Q163
Which of the following best describes a special organizational function for managing the organization
  • A database administration
  • B information management
  • C data analysis
  • D data administration
Answer: Option D
Q164
Data administration:
  • A establishes specific policies and procedures through which data can be managed as an organizational resource.
  • B establishes access rules and procedures.
  • C defines and organizes database structure and content.
  • D maintains the database
Answer: Option A
Q165
A collection of operations that performs a single logic function is called
  • A schedule
  • B transaction
  • C DBA
  • D none of the above
Answer: Option B
Q166
A table
  • A does not define logical order of records
  • B orders record by key field in a record
  • C orders records by the first field of a record
  • D imposes a logical order on record
Answer: Option A
Q167
Atomicity means 1 .complete commit 2. complete rollback 3. partial commit 4. partial roll back
  • A 1 only
  • B 2 only
  • C 1 and 2
  • D 3 and 4
Answer: Option C
Q168
Which of the following property ensures that the state of database is same when it ends as it was began
  • A Atomicity
  • B Consistency
  • C Isolation
  • D Durability
Answer: Option B
Q169
What is isolation
  • A The operation of one transaction does not affect the operation of other transaction
  • B Once a transaction is completed the results will persist
  • C The state of database is the same when it ends as it begins
  • D none
Answer: Option A
Q170
In strict relational terminology , an attribute is
  • A record
  • B entity
  • C field
  • D table
Answer: Option C

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test