0
question_answer1) Direction: Q.1 to 5 I. A school in Delhi uses database management system to store student details. The school maintains a database 'school record' under which there are two tables. Student Table: Maintains general details about every student enrolled in school. StuLibraryTable: To store details of issued books. BookID is the unique identification number issued to each book. Minimum issue duration of a book is one Day. STUDENT Field Type StuID numeric StuName Varchar(20) StuAddress Varchar(50) StuFatherName Varchar(20) StuContact numeric StuAadhar numeric StuClass Varchar(5) StuSection Varchar(1) StuLibrary Field Type BookID numeric StuID numeric Issued_date Date Return_date Date Identify the SQL Query which displays the data of StuLibrary table in ascending order of StudentID. (i) Select * from StuLibrary Order By BookID. (ii) Select * from StuLibrary Order By StuID (iii) Select * from StuLibrary Order By StuID ASC (iv) Select * from StuLibrary Order By StuID DESC Choose the correct option:
question_answer2) The Primary Key for StuLibrary Table is/are .......
question_answer3) Which of the following SQL Query will fetch ID of those issued books which have not been returned?
question_answer4) The Alternate Key for Student Table will be.................... .
question_answer5) Which of the following SQL Query will display dates on which number of issued books is greater than 5?
question_answer6) II. Use the following information to answer questions below: Vinesh Public School uses database management software to organize the teacher and student use of printers. The relationships between the Student, Teacher and Print Job tables are represented below. In the one-to-many relationship between the Student table and the Print Job table
question_answer7) Given below is a view of a section of the Student table: STUDENTID FIRSTNAME LASTNAME YEAROFBIRTH CLASS S103 DANISH ARORA 1996 10 S325 SURESH BAROTH 1995 10 S624 AMIT SHARMA 1996 10 S74 SUDHIR RAJPUT 1997 10 S913 VIJAY VERMA 1998 9 In this view of the Student table LastName is a
Please Wait you are being redirected....
You need to login to perform this action.You will be redirected in 3 sec
OTP has been sent to your mobile number and is valid for one hour
Your mobile number is verified.