DBMS MCQ Questions and Answers

Practice Mode
Showing 10 of 527 questions
Q301
____________ data models are used to describe data at the lowest level
  • A Logical data model
  • B Physical data model
  • C Network data model
  • D None of the above
Answer: Option B
Q302
The data type which contains raw binary data otherwise the same as a LONG column is
  • A BFILE
  • B CLOB
  • C BLOB
  • D LONGRAW
Answer: Option C
Q303
A __________ provides the data security
  • A view
  • B Queries
  • C Commands
  • D All of the above
Answer: Option C
Q304
A ________ is an organized collection of logically related data.
  • A Column
  • B Composite attribute
  • C Database
  • D All of the above
Answer: Option C
Q305
. A ________ is an organized collection of logically related data.
  • A Column
  • B Composite attribute
  • C Database
  • D All of the above
Answer: Option C
Q306
Once the DBMS informs the user that a transaction has successfully completed, its effects should persist even if the system crashes before all its changes are reflected on disk. This property is called.
  • A consistency
  • B isolation
  • C durability
  • D atomicity
Answer: Option C
Q307
Name the buffer in which all the commands that are typed in are stored
  • A EDIT buffer
  • B STORE buffer
  • C both A & B
  • D none
Answer: Option A
Q308
How do you communicate with an RDBMS?
  • A using SQL
  • B using ORACLE
  • C using VC++
  • D none.
Answer: Option A
Q309
Deadlock occurs when
  • A transactions compete for the same resource.
  • B the DBMS cannot decide what to do next.
  • C the user requests a cascade abort
  • D a transaction cannot decide what to do next.
Answer: Option A
Q310
The role of a DBA includes which of the following topics?
  • A User interfaces, salary budgeting, performance monitoring.
  • B Supporting all programming languages which might be used with a database.
  • C Loading data, evaluating new database systems, performance monitoring.
  • D Installing databases, C++ programming, user support.
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