Time Left - 10:00 mins

IIIT Hyderabad Practice Quiz : Databases-2

Attempt now to get your rank among 319 students!

Question 1

Consider the set of relations given below and SQL query implemented on the relations:

Student: Roll_Number, Name, DOB

Courses: Course_No, CourseName, Instructor

Enroll: Roll_no, Course_No, Grade

SELECT DISTINCT Name

FROM Student, Courses, Enroll

WHERE Student.Roll_No= Enroll.Roll_No

AND Courses.Instructor= RAVI

AND Courses.Course_No= Enroll.Course_No

AND Enroll.Grade=A

Which of the following set is computed by the given SQL Query?

Question 2

Identify the capabilities of SELECT statement.

  1. Projection
  2. Selection
  3. Data Control
  4. Transaction

Question 3

Consider an ordered file with 1,00,000 records stored on a disk using un-spanned file organization. Block size is 2048 bytes and record length 256 bytes. If primary indexing is used over a field of size 10 bytes and block pointer size is 6 bytes. Then number of block access is required to search for a record.

Question 4

In the reflexive rule, true dependencies generated are classified as:

Question 5

Generalization is a bottom up design process that combines several entities sets, which share the same features into a higher-level entity set
  • 319 attempts
  • 0 upvotes
  • 3 comments
Mar 23GATE & PSU CS

Posted by:

Harshita AgarwalHarshita AgarwalMember since Jul 2020
Share this quiz   |