10th Class Computers Science Database Management 2 Question Bank

done Case-Based - Data Base Management System Total Questions - 7

• 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:

   
  A)
  Both Query (i) and (iv) will display the desired data. done clear
  B)
  Both Query (i) and (ii) will display the desired data. done clear
  C)
  Both Query (iii) and (iv) will display the desired data. done clear
  D)
  Both Query (ii) and (iii) will display the desired data done clear
  View Solution play_arrow

• question_answer2)
  The Primary Key for StuLibrary Table is/are .......
  A)
  BookID done clear
  B)
  BookID,StuID done clear
  C)
  BookID,Issued_date done clear
  D)
  Issued_date done clear
  View Solution play_arrow

• question_answer3)
  Which of the following SQL Query will fetch ID of those issued books which have not been returned?
  A)
  SELECT BookID from StuLibrary where BookID is NULL done clear
  B)
  SELECT BookID from StuLibrary where StuID is NULL done clear
  C)
  SELECT BookID from StuLibrary where Issued_date is NULL done clear
  D)
  SELECT BookID from StuLibrary where Return_date is NULL done clear
  View Solution play_arrow

• question_answer4)
  The Alternate Key for Student Table will be.................... .
  A)
  StuName             done clear
  B)
  StuContact done clear
  C)
  StuAadhar                     done clear
  D)
  StuClass done clear
  View Solution play_arrow

• question_answer5)
  Which of the following SQL Query will display dates on which number of issued books is greater than 5?
  A)
  SELECT Issued_date from StuLibrary GROUP BY Issued_date where COUNT(*) > 5 done clear
  B)
  SELECT Issued_date from StuLibrary GROUP BY Return_date having count(*)>5 done clear
  C)
  SELECT Issued_date from StuLibrary GROUP BY Issued_date having count(*) > 5 done clear
  D)
  SELECT Issued_date from StuLibrary GROUP BY Return_date where COUNT(*)>5 done clear
  View Solution play_arrow

• 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
  A)
  One record in the Student table relates to many records in the Print Job table done clear
  B)
  One field in the Student table relates to many records in the Print Job table done clear
  C)
  One record in the Student table relates to many fields in the Print Job table done clear
  D)
  One field in the Student table relates to many fields in the Print Job table done clear
  View Solution play_arrow

• 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
  A)
  Key                      done clear
  B)
  Field done clear
  C)
  Table                 done clear
  D)
  Record done clear
  View Solution play_arrow