Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
17.8k views
in Information Technology by (71.2k points)

Consider the following tables Library given below:

Library

Bid Name Author Price Mem_name Issue_Date Status
B01 Wings of Fire A.P.J Abdul Kalam 550 Sarita 2018-05-20 Returned
B02 The Monk who sold his Ferrari Robin Sharma 340 Simmi 2018-03-15 Not Returned
B03 You can win Shiv Khera 230 Rajat 2018-04-16 Returned
B04 Who moved my cheese Spencer Jhonson 450 Ram 2018-03-17 Not Returned
B05 Real Success Patrick Mather-Pike 250 Sia 2018-06-18 Not Returned

(i) Suggest the suitable data type for Issue_Date column.

(ii) Suggest the suitable SQL command to change the size of column name from 30 character to 50 characters.

(iii) Mention the significance of Bid column in table Library.

(iv) Suggest the suitable command to display a list of the books in a sequence so that first all the book’s name should be displayed which has been returned and after that all the book’s name which has not been returned should be displayed. 

1 Answer

+1 vote
by (76.3k points)
selected by
 
Best answer

(i) Date

(ii) alter table library modify name varchar(50);

(iii) Bid column will always have a unique value which will help uniquely identify each record of Library table.

(iv) Select name from library order by status desc;

No related questions found

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...