CUET-UG SERIES Dbms
Database Introduction
5 previous year questions.
Volume: 5 Ques
Yield: Medium
High-Yield Trend
5
2023 Chapter Questions 5 MCQs
01
PYQ 2023
easy
dbms ID: cuet-ug-
Match List - I with List - II.
Choose the correct answer from the options given below:
List - I | List - II | ||
| (A) | Data Base Schema | (I) | Limitation on the type of data |
| (B) | Data Constraint | (II) | Data about data |
| (C) | Meta Data | (III) | State or snapshot of the database |
| (D) | Database Instance | (IV) | Visual or logical architecture |
Choose the correct answer from the options given below:
1
(A)-(II), (B)-(I), (C)-(IV), (D)-(III)
2
(A)-(III), (B)-(I), (C)-(IV), (D)-(II)
3
(A)-(II), (B)-(IV), (C)-(I), (D)-(III)
4
(A)-(IV), (B)-(I), (C)-(II), (D)-(III)
02
PYQ 2023
medium
dbms ID: cuet-ug-
File system becomes difficult to handle when number of files increases and volume of data also grows. Identify the limitations of file system.
1
Data isolation
2
Data constraint
3
Data dictionary
4
Degree
03
PYQ 2023
medium
dbms ID: cuet-ug-
Consider the table below: UNIFORM
Which of the following tuples cannot be inserted into the UNIFORM table ?
| Vcode | Vname | Vcolor |
|---|---|---|
| 1 | Shirt | White |
| 2 | Pant | Grey |
| 3 | Skirt | Grey |
Which of the following tuples cannot be inserted into the UNIFORM table ?
1
4, Ribbon, Red
2
5, NULL, White
3
2, Belt, Blue
4
7, handkerchief, NULL
04
PYQ 2023
medium
dbms ID: cuet-ug-
Consider the following statements:
(A) Each attribute in a relation has a unique name
(B) All data values in an attribute must be from the same domain
(C) A special value NULL is used to represent values that are unknown
(D) A database constraint allow different types of data to inserted into the table
Choose the correct answer from the options given below:
(A) Each attribute in a relation has a unique name
(B) All data values in an attribute must be from the same domain
(C) A special value NULL is used to represent values that are unknown
(D) A database constraint allow different types of data to inserted into the table
Choose the correct answer from the options given below:
1
(A), (B) and (C) only
2
(A), (B) only
3
(A), (C), (D) only
4
(A), (B), (C) and (D) only
05
PYQ 2023
medium
dbms ID: cuet-ug-
____ is the logical architecture of a Database while ____ after loading data in a database.
1
Meta-Data, DB Schema
2
DB Schema, DB Instance
3
Meta-Data, DB Instance/div>
4
DB Instance, DB Schema