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
52. One of the cause of the failure of file system
- Data availability
- Fixed records
- Sequential records
- Lack of security
53. Data concurrency means
- Accessing multiple table records
- Access by multiple users
- Doing sequential multiple deletes
- Doing sequential multiple inserts
54. Main cause of failure of network model
- Impossible modification of data design
- Failure to explain the many-many relation
- Failure to explain the one-many relation
- Failure to explain the many-all relation
55. What among is not implemented by CODD
- Existence of data is not in the table
- Defining the constraints separately
- Both the above
- None of these
56. Normalization main important aim is
- to remove the data redundancy between the columns
- to have least redundancy dependency on primary key
- to more flexible access
- All the above
57. De-Normalization is required when
- To make strict data redundancy
- To make all column dependency on primary key
- To create as many related tables
- To more flexible access in order to avoid lengthy joins
58. Chose the correct sequence regarding select clause
- Where-group by-having
- Where
- Group by
- Having - order by
59. The function greatest/least works on
- List of same field values
- Set of different datatyped columns
- Set of same datatyped columns
- None of these