LawMint Sign in

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?

Select one answer

Question 2

Which is not a Data Model?

Select one answer

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.

AC
24
34
43
52
72
95
64

What is the set of all tuples that must be additionally deleted to preserve referential integrity when the tuple (2, 4) is deleted?

Select one answer

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?

Select one answer

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?

Select one answer

Question 6

A relational schema for a train reservation database is given below:

Passenger

PidP NameAge
0Sachin65
1Rahul66
2Sourav67
3Anil69

Reservation

PidClassTid
0AC8200
1AC8201
2SC8201
5AC8203
1SC8204
3AC8202

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)

Select one answer

Question 7

To determine what products customers purchase together with other products is called ___________.

Select one answer

Question 8

Match the following:

IEmpid1Multivalued
IIName2Derived
IIIAge3Composite
IVContact No.4Unique
Select one answer

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 :

Select one answer

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?

Select one answer

Continue practising

The practice pack for Jammu & Kashmir and Ladakh SET (JKSET/LASET) is coming soon to LawMint.

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.