Question 3In a bookshop database, the complete information about one specific book is referred to as a ______________.1 pointColumnTableRecord

1 pointA(n) .............. describes how the data is organized in a database.

Read the passage and answer the following questions: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.StuLibrary Table : 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.Identify the SQL Query which displays the data of StuLibrary table in ascending order of StudentID*1 pointSelect * from StuLibrary Order By BookID;Select * from StuLibrary Group By StuID;Select * from StuLibrary Order By StuID ASC;Select * from StuLibrary Order By StuID DESC;The Primary Key for StuLibrary Table is/are*1 pointBookIDBookID, StuIDBookID, Issued_dateIssued_dateWhich of the following SQL Query will fetch ID of those issued books which have not been returned?*1 pointSELECT BookID from StuLibrary where BookID is NULL;SELECT BookID from StuLibrary where StuID is NULL;SELECT BookID from StuLibrary where Issued_date is NULL;SELECT BookID from StuLibrary where Return_date is NULL;The Alternate Key for Student Table will be*1 pointStuNameStuContactStuAadharStuClassBackSubmitClear form

In a Books table with columns BookID, ISBN, and Title, which of the following sets of columns can be considered a candidate key?

7. Five books (A, B, C, D and E) are placed on the table. A is under E, C is over D, B is under A, D is over E. Which book touches the table?ABCDE

Possibility High School maintains a database containing tables related to its students and the subjects offered. Which of the following represents a table within the database?*1 pointa student's namea student's recordall the personal data on studentsthe age of a student