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
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
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
Tags :
GATE & PSU CSDatabasesAug 3GATE & PSU CS
