IIIT Hyderabad Practice Quiz : Databases-2

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?

Identify the capabilities of SELECT statement.

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

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.

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

Generalization is a bottom up design process that combines several entities sets, which share the same features into a higher-level entity set