DBMS MCQ Questions and Answers
DBMS MCQ questions with answers form a vital part of technical exams and campus interviews. This topic explores database concepts, normalization, SQL queries, transaction management, and ER models. Practicing programming questions and answers from this section strengthens your database design and query optimization skills. These questions are frequently asked in GATE, Infosys, TCS, and Wipro assessments, making them essential for students and professionals alike. Detailed solutions and explanations make this section perfect for both beginners and advanced learners aiming to master database management fundamentals.
DBMS MCQ
Showing 10 of
527 questions
161. An abstract model of the database from a business perspective best defines:
- physical design
- object design
- organizational view
- conceptual design
162. The process of creating small, stable data structures from complex groups of data when designing a relational database defines:
- data decomposition
- data structuring
- data transcribing
- normalization
163. Which of the following best describes a special organizational function for managing the organization
- database administration
- information management
- data analysis
- data administration
164. Data administration:
- establishes specific policies and procedures through which data can be managed as an organizational resource.
- establishes access rules and procedures.
- defines and organizes database structure and content.
- maintains the database
165. A collection of operations that performs a single logic function is called
- schedule
- transaction
- DBA
- none of the above
166. A table
- does not define logical order of records
- orders record by key field in a record
- orders records by the first field of a record
- imposes a logical order on record
167. Atomicity means 1 .complete commit 2. complete rollback 3. partial commit 4. partial roll back
- 1 only
- 2 only
- 1 and 2
- 3 and 4
168. Which of the following property ensures that the state of database is same when it ends as it was began
- Atomicity
- Consistency
- Isolation
- Durability
169. What is isolation
- The operation of one transaction does not affect the operation of other transaction
- Once a transaction is completed the results will persist
- The state of database is the same when it ends as it begins
- none
170. In strict relational terminology , an attribute is
- record
- entity
- field
- table