Time Left - 12:00 mins

Database : Nuclear Quiz 3

Attempt now to get your rank among 217 students!

Question 1

Data file contains 1 million records and tree order n=100,than what is the maximum number of nodes to be accessed if B+ tree index is used?

Question 2

Storing the files in certain order is called the file organization. Which among the following is not the objective of the organization.

Question 3

If every functional dependency in set E is also in closure of F then this is classified as :

Question 4

Consider the relation scheme of the relation SCHEDULE shown below. What is the highest Normal form of this relation?
SCHEDULE (Stud_ID, Class, Stud_Name, Stud_Major, Class_Time, Building_Room, Instructor)
Assume the following functional dependencies
Stud_ID Stud_Name
Stud_ID Stud_Major
Class Class_Time
Class Building_Room
Class Instructor

Question 5

Consider the following FD set on R(A,B,C)

The canonical cover of this set is

Question 6

Which of the following is a correct attribute set for one of the tables for the correct answer to the above question?

Question 7

Expressive power of relational algebra is equal to

Question 8

Which of the following is NOT a GROUP BY function?

Question 9

Which of the following is not true regarding Conflict equal and view equal schedule?

Question 10

Which among the following schedules is an irrecoverable Schedule?
  • 217 attempts
  • 0 upvotes
  • 1 comment
Aug 3GATE & PSU CS