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

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

Which of the following decisions would be part of Physical Database Design?Student data and enrollment data will be stored in two different tablesAn index file will be created on the last name of students in the Student tableThe Social Security number will be chosen as the primary key of the Student tableStudent data and enrollment data will be stored in two different tables at two different locationsReview AnswerNext

Question 8In the following student table, which attribute could be used as a primary key?Student first nameStudent last nameMobile numberCarl Merlo07445532123MarkNero074565323271 pointStudent last nameMobile numberStudent first name

Consider these following tables and only solve the query. Tables: 1) student: s_no (primary key), student_name, course_no (foreign key), age 2) courser-course-no (primary key), course-name. Query: Display all the student name, course name and also age of the students, whose age is between 23 to 27 and course having 'BCA'. Find out the students whose age is maximum.

Student Relation Student_ID   Student_Name   Dept_Name 0000 AAAAA Computer Science1111 BBBBB Computer Science2222 CCCCC  Business Administration Question 13Select one:a.CREATE TABLE Student(   Student_ID int,   Student_Name char(20),   Dept_Name char(20),);b.CREATE TABLE Student(   Student_ID int,   Student_Name varchar(100),   Dept_Name varchar(100),);c.CREATE TABLE Student(   Student_ID int,   Student_Name char(100),   Dept_Name char(100),);d.CREATE TABLE Student(   Student_ID char(20),   Student_Name char(100),   Dept_Name char(100),);