CUET-UG SERIES Computer-science
Dbms
4 previous year questions.
Volume: 4 Ques
Yield: Medium
High-Yield Trend
2
2025 2
2023 Chapter Questions 4 MCQs
01
PYQ 2023
medium
computer-science ID: cuet-ug-
Which of the following is the limitation of DBMS ?
1
Data Consistency
2
Increased Complexity
3
Controlled Data redundancy
4
Data Independency
02
PYQ 2023
medium
computer-science ID: cuet-ug-
Which of the following are true about DBMS ?
(A) Each attribute should have unique name
(B) Order of attribute is immaterial
(C) Each tuple should be unique
(D) The values of attributes do not belong to same domain
(E) An attribute can have multiple values in tuple
Choose the correct answer from the options given below :
(A) Each attribute should have unique name
(B) Order of attribute is immaterial
(C) Each tuple should be unique
(D) The values of attributes do not belong to same domain
(E) An attribute can have multiple values in tuple
Choose the correct answer from the options given below :
1
(A), (B) and (E) only
2
(A), (B), (C) and (D) only
3
(A), (B) and (C) only
4
(A), (B) and (D) only
03
PYQ 2025
medium
computer-science ID: cuet-ug-
Given two relations:
Employee with structure as (ID, Name, Address, Phone, Deptno)
Department with structure as (Deptno, Dname)
__________ is used to represent the relationship between two relations Employee and Department.
Employee with structure as (ID, Name, Address, Phone, Deptno)
Department with structure as (Deptno, Dname)
__________ is used to represent the relationship between two relations Employee and Department.
1
Primary key
2
Alternate key
3
Foreign key
4
Candidate key
04
PYQ 2025
medium
computer-science ID: cuet-ug-
Match List-I with List-II.
| List-I | List-II |
|---|---|
| (A) Primary key | (III) Attribute used to uniquely identify a tuple. |
| (B) Degree | (I) Total number of attributes in a table. |
| (C) Foreign key | (II) Attribute used to relate two tables. |
| (D) Constraint | (IV) A restriction on the type of data that can be inserted in a column. |
1
(A)-(I), (B)-(II), (C)-(III), (D)-(IV)
2
(A)-(III), (B)-(I), (C)-(II), (D)-(IV)
3
(A)-(I), (B)-(II), (C)-(IV), (D)-(III)
4
(A)-(III), (B)-(IV), (C)-(I), (D)-(II)