Jammu & Kashmir and Ladakh SET (JKSET/LASET) Database Management Systems Previous Year Questions
Try the preview and open any solution for a worked explanation.
Jammu & Kashmir and Ladakh SET (JKSET/LASET) practice pack
The practice pack for Jammu & Kashmir and Ladakh SET (JKSET/LASET) is coming soon to LawMint.
Question 1
Which one of the following statements is not correct?
Question 2
Which is not a Data Model?
Question 3
The following table has two attributes A and C where A is the primary key and C is the foreign key referencing A with ON DELETE CASCADE.
| A | C |
|---|---|
| 2 | 4 |
| 3 | 4 |
| 4 | 3 |
| 5 | 2 |
| 7 | 2 |
| 9 | 5 |
| 6 | 4 |
What is the set of all tuples that must be additionally deleted to preserve referential integrity when the tuple (2, 4) is deleted?
Question 4
Let E1 and E2 be two entities in an ER diagram with simple single-valued attributes. R1 and R2 are two relationships between E1 and E2, where R1 is one-to-many and R2 is many-to-many. R1 and R2 do not have any attributes of their own. What is the minimum number of tables required to represent this situation in the relational model?
Question 5
Consider the following relation schema pertaining to a student’s database:
Student (Rollno, name, address)
Enroll (Rollno, courseno, coursename)
Where the primary keys are shown in bold, and Rollno in Enroll is a foreign key referencing Student. The number of tuples in the student and Enroll tables are 120 and 6, respectively. What are the maximum and minimum number of tuples that can be present in (student * Enroll), where ‘*’ denotes natural join?
Question 6
A relational schema for a train reservation database is given below:
Passenger
| Pid | P Name | Age |
|---|---|---|
| 0 | Sachin | 65 |
| 1 | Rahul | 66 |
| 2 | Sourav | 67 |
| 3 | Anil | 69 |
Reservation
| Pid | Class | Tid |
|---|---|---|
| 0 | AC | 8200 |
| 1 | AC | 8201 |
| 2 | SC | 8201 |
| 5 | AC | 8203 |
| 1 | SC | 8204 |
| 3 | AC | 8202 |
What pid’s are returned by the following SQL query for the above instance of the tables?
SELECT pid FROM Reservation WHERE class = 'AC' AND EXISTS(SELECT * FROM passenger WHERE age > 65 AND Passenger.pid = Reservation.pid)
Question 7
To determine what products customers purchase together with other products is called ___________.
Question 8
Match the following:
| I | Empid | 1 | Multivalued |
| II | Name | 2 | Derived |
| III | Age | 3 | Composite |
| IV | Contact No. | 4 | Unique |
Question 9
Given the relation R(A, B, C, D) and the set F= {AB → C, B → D, D → B} find the candidate keys of the relation :
Question 10
Consider the set of relations shown below and the SQL query that follows :
Students: (Roll_number, Name, Date_of_birth)
Courses: (Course_number, Course_name,Instructor)
Grades: (Roll_number, Course_number, Grade)
SELECT distinct Name FROM Students, Courses, Grades WHERE Students.Roll_number = Grades.Roll_number and Courses.Instructor = Shyam and Courses.Course_number = Grades.Course_number and Grades.Grade = A
Which of the following sets is computed by the above query?
Previous papers with Database Management Systems questions
Jammu & Kashmir and Ladakh SET (JKSET/LASET) practice pack
The practice pack for Jammu & Kashmir and Ladakh SET (JKSET/LASET) is coming soon to LawMint.