Question 2 MCQ · 3.0 marks
48
32
64
16
A published solution is not available for this question yet.
Database Management System · Quiz 2 · May 2024
Database Management System · Quiz 2 · May 2024
← Course papers · Start practice / exam
Questions and published explanations below are available without starting a test. Some questions may not have a published solution yet.
0 / 14 published solutions
Question 3 MCQ · 3.0 marks
not in 2NF
in 2NF but not in 3NF
in 3NF but not in 2NF
in both 2NF and 3NF
A published solution is not available for this question yet.
Question 4 MCQ · 3.0 marks
a: 500, b: 23, c: 676
a: 676, b: 20, c: 500
a: 500, b: 23, c: 500
a: 500, b: 20, c: 676
A published solution is not available for this question yet.
Question 5 MCQ · 4.0 marks
A published solution is not available for this question yet.
Question 6 MCQ · 4.0 marks
1 NF
2 NF
3 NF
BCNF
A published solution is not available for this question yet.
Question 7 MCQ · 4.0 marks
2
3
4
5
A published solution is not available for this question yet.
Question 8 MCQ · 4.0 marks
Consider a disk with a sector size of 512 bytes, 3000 tracks/surface, 50 sectors/track, and 8 double-
sided platters. Which of the following is the correct choice for the number of cylinders and block
size?
Number of cylinders= 3000, block size= 1536
Number of cylinders= 6000, block size= 256
Number of cylinders= 3000, block size= 256
Number of cylinders= 6000, block size= 786
A published solution is not available for this question yet.
Question 9 MCQ · 4.0 marks
X covers Y
Y covers X
Both X covers Y and Y covers X
Neither X covers Y nor Y covers X
A published solution is not available for this question yet.
Question 10 MSQ · 2.0 marks
Which of the following commands will make changes in the Data Dictionary?
UPDATE
DELETE
TRUNCATE
ALTER
A published solution is not available for this question yet.
Question 11 MSQ · 3.0 marks
A published solution is not available for this question yet.
Question 12 MSQ · 3.0 marks
A published solution is not available for this question yet.
Question 13 MSQ · 5.0 marks
Relation **Student** is in 3NF when F1 is the Functional dependencies set.
Relation **Student** is in 3NF when F2 is the Functional dependencies set.
Relation **Student** is in 3NF when F3 is the Functional dependencies set.
Relation **Student** is in 3NF when F4 is the Functional dependencies set.
A published solution is not available for this question yet.
Question 14 MCQ · 4.0 marks
Use the data given below and answer the given subquestions.
The current table is in which normal form?
1 NF
2 NF
3 NF
BCNF
A published solution is not available for this question yet.
Question 15 MCQ · 4.0 marks
Use the data given below and answer the given subquestions.
Which of the following decompositions will help to achieve BCNF?
**PDSA**
**Section Id :** 64065360924
**Section Number :** 2
**Section type :** Online
**Mandatory or Optional :** Mandatory
**Number of Questions :** 17
**Number of Questions to be attempted :** 17
**Section Marks :** 50
**Display Number Panel :** Yes
**Section Negative Marks :** 0
**Group All Questions :** No
**Enable Mark as Answered Mark for Review and**
No
**Clear Response :**
**Section Maximum Duration :** 0
**Section Minimum Duration :** 0
**Section Time In :** Minutes
A published solution is not available for this question yet.