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
321. an RDBMS is_____________
- an approach intended to readily deal with many to many relationships
- an approach which logicaly views data as a collection of tables.
- an approach based on relational algebra
- both b & c
322. an RDBMS is_____________
- an approach intended to readily deal with many to many relationships
- an approach which logicaly views data as a collection of tables.
- an approach based on relational algebra
- both b & c
323. a two dimensional structure with data is called_____
- set
- tables
- group
- spread sheet
324. object types are used to create
- new data type
- data base object
- schema
- meta data
325. Which of the following statement(s) is (are) true with respect to data types?
- INTEGER data type can store decimal numbers exceeding that number 32,767.
- VARCHAR data type often reduces disk storage wastage when compared to CHAR data type.
- BLOB data is streams of bytes of fixed length.
- BYTE data type cannot store any type of binary data.
326. CLOB datatype accomodates character information upto
- 8 GB
- 2 GB
- 2000 bytes
- 4 GB
327. The characteristics of the database are
- Can be sharable
- related logically
- can be protected
- all the above
328. The functionalities of the RDBMS are
- Store data
- execute transactions
- Security
- all the above
329. Consider the relation R with four attributes A,B,C and D and the functional dependencies (A,B) (C,D) and C D . Which of the following statements is/are correct?
- ) C is a key for relation R.
- R is in 3NF
- Functional dependency C D violates 3NF
- ) R is in BCNF.
330. Consider the following relation and its sample data. (Consider that these are the only tuples for the given relation) EmpNo DeptNo ProjNo 1001 01 12 1001 01 13 1002 01 12 1003 01 14 Which of the following statements is/are correct?
- The functional dependency (EmpNo, DeptNo) ProjNo holds over R.
- The functional dependency DeptNo ProjNo holds over R.
- The functional dependency EmpNo DeptNo holds over R.
- The functional dependency ProjNo DeptNo do not holds over R.