MauryaHub PYQ Practice

Database Management System · Quiz 2 · Sep 2023

Database Management System · Quiz 2 · Sep 2023

← 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 / 15 published solutions

Question 81 MSQ · 2.0 marks

Source diagram or notation
A.Source diagram or notation
B.Source diagram or notation
C.Source diagram or notation
D.Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q81

Question 82 MCQ · 3.0 marks

Source diagram or notation
A.
2 NF
B.
1 NF
C.
3 NF
D.
BCNF

A published solution is not available for this question yet.

Report a correction for Q82

Question 83 MCQ · 3.0 marks

Consider a magnetic disk with 4 platters, 2 surfaces per platter, 1024 tracks per surface, and 2048 sectors per track, with a disk capacity of 8 GB. Find the capacity of one sector.
A.
2048 bytes per sector
B.
1024 bytes per sector
C.
512 bytes per sector
D.
256 bytes per sector

A published solution is not available for this question yet.

Report a correction for Q83

Question 84 MCQ · 3.0 marks

Source diagram or notation
A.Source diagram or notation
B.Source diagram or notation
C.Source diagram or notation
D.Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q84

Question 85 MCQ · 4.0 marks

Source diagram or notation
A.Source diagram or notation
B.Source diagram or notation
C.Source diagram or notation
D.Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q85

Question 86 MCQ · 4.0 marks

The G20 is a global forum that brings together the world’s major economies to discuss and cooperate on international economic and financial issues. The organizers of the G20 event have designed a database to store information about the participants, their countries, and the issues discussed. The original database is **G20Participants** (Participant_ID, Participant_Name, Participant_Email, Participant_Country,Country_Leader_Name,Country_GDP, Issue_Discussed) The functional dependencies are: F = {Participant_ID → Participant_Name, Participant_Email Participant_Country → Country_Leader_Name,Country_GDP Participant_ID → Participant_Country} The initial design of the database is as follows: Table 1: **Participants** (Participant_ID, Participant_Name, Participant_Email) Table 2: **Country** (Participant_Country,Country_Leader_Name,Country_GDP, Issue_Discussed) The database designers have identified that this design violates the third normal form (3NF) of database normalization. Which of the following changes would bring the database design into 3NF?
A.
Split the **Country** table into two tables, one for the issue discussed and merge with **Participants**.
B.
Remove Issue_Discussed and add Participant_ID in **Country** table. And create a new table for the issues discussed and link it to the **Participants**.
C.
Remove Issue_Discussed from **Country** and create a new table for the issues discussed and link it to the **Participants** tables using a foreign key.
D.
Remove Issue_Discussed from **Country** and create a new table for the issues discussed and link it to the **Participants** and **Country** tables using a foreign key.

A published solution is not available for this question yet.

Report a correction for Q86

Question 87 MSQ · 4.0 marks

Source diagram or notation
A.Source diagram or notation
B.Source diagram or notation
C.Source diagram or notation
D.Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q87

Question 88 MCQ · 3.0 marks

Consider the relation schema and the set of functional dependencies, and answer the sub questions.
Source diagram or notation
What is the total number of superkeys present in relation **R**?
A.
31
B.
32
C.
29
D.
33

A published solution is not available for this question yet.

Report a correction for Q88

Question 89 MSQ · 4.0 marks

Consider the relation schema and the set of functional dependencies, and answer the sub questions.
Source diagram or notationSource diagram or notation
A.Source diagram or notation
B.Source diagram or notation
C.Source diagram or notation
D.Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q89

Question 90 MCQ · 3.0 marks

Source diagram or notation
Based on the above data, answer the given subquestions.
The current table is in which normal form?
A.
1 NF
B.
2 NF
C.
3 NF
D.
BCNF

A published solution is not available for this question yet.

Report a correction for Q90

Question 91 MCQ · 4.0 marks

Source diagram or notation
Based on the above data, answer the given subquestions.
Which of the following decompositions will help to achieve BCNF?
A.Source diagram or notation
B.Source diagram or notation
C.Source diagram or notation
D.Source diagram or notation

A published solution is not available for this question yet.

Report a correction for Q91

Question 92 MSQ · 3.0 marks

Source diagram or notation
Based on the above data, answer the given subquestions.
Which of the following is/are candidate keys for relation **CAR**?
A.
(LicenseNo, EngineSerialNo)
B.
(LicenseNo, EngineSerialNo, Year)
C.
(LicenseNo, Model, Year)
D.
(LicenseNo)

A published solution is not available for this question yet.

Report a correction for Q92

Question 93 MCQ · 3.0 marks

Source diagram or notation
Based on the above data, answer the given subquestions.
If the relation **CAR** is decomposed into two relations **C1** and **C2**, which of the following is a lossless join decomposition?
A.
**C1**(LicenseNo, EngineSerialNo, Model ), **C2**(Model, Year)
B.
**C1**(LicenseNo, EngineSerialNo, Model ), **C2**(EngineSerialNo, Year)
C.
**C1**(LicenseNo, EngineSerialNo), **C2**(Model, Year)
D.
**C1**(LicenseNo, EngineSerialNo, Year), **C2**(LicenseNo, Year)

A published solution is not available for this question yet.

Report a correction for Q93

Question 94 NAT · 4.0 marks

Consider a string of pending block references in the order given: 4, 6, 4, 1, 3, 2, 4, 1, 4, 2. The system has a buffer with 4 slots. Assume that initially, the buffer is empty. If LRU buffer replacement policy is used, then what will be the value of the following expression? Number of misses − Number of hits

A published solution is not available for this question yet.

Report a correction for Q94

Question 95 NAT · 3.0 marks

Consider a binary search tree consisting of 15 elements. Let m be the maximum height possible for a given binary search tree, and n be the minimum height possible for a given binary search tree. What will be the value of m − n ?

A published solution is not available for this question yet.

Report a correction for Q95