NPTEL Data Base Management System Assignment 2 Answers: 2022:- All the Answers provided below to help the students as a reference, You must submit your assignment at your own knowledge.
About Data Base Management System
Databases form the backbone of all major applications today – tightly or loosely coupled, intranet or internet based, financial, social, administrative, and so on. Structured Database Management Systems (DBMS) based on relational and other models have long formed the basis for such databases. Consequently, Oracle, Microsoft SQL Server, Sybase etc. have emerged as leading commercial systems while MySQL, PostgreSQL etc. lead in open source and free domain.
CRITERIA TO GET A CERTIFICATE
Average assignment score = 25% of average of best 6 assignments out of the total 8 assignments given in the course.
Exam score = 75% of the proctored certification exam score out of 100
Final score = Average assignment score + Exam score
YOU WILL BE ELIGIBLE FOR A CERTIFICATE ONLY IF AVERAGE ASSIGNMENT SCORE >=10/25 AND EXAM SCORE >= 30/75. If one of the 2 criteria is not met, you will not get the certificate even if the Final score >= 40/100.
You can find Data Base Management System Assignment 2 Answers below.
NPTEL Data Base Management System Assignment 2 Answers 2022 – September
1. Consider the following instance:
Consider the query:
SELECT title, author FROM books WHERE theme LIKE “y” AND genre NOT LIKE “r” ORDER BY theme DESC Which title will be present in the first (topmost) tuple of the output produced by the above query?
a) The Cause
c) Echoing Laughters
d) The haunting
2. Consider the following instance:
Consider the following queries:
CREATE VIEW THEMEVIEW AS
SELECT theme FROM books WHERE author LIKE “% %”
SELECT COUNT (*) FROM THEMEVIEW;
What is the final output after the two queries are executed?
Answers will be Uploaded Shortly and it will be Notified on Telegram, So JOIN NOW
3. Consider the following instance:
Which is the correct option to change the value of game ID from 3 to 2?
a) UPDATE scoreboard SET game ID=2 WHERE game ID=3
b) ALTER TABLE scoreboard SET gameID=2 WHERE game ID =3
c) ALTER scoreboard SET game ID=2 WHERE gameID=3
d) UPDATE TABLE scoreboard SET gameID=2 WHERE game ID=3
4. Which attribute(s) is (are) represented by X in the above query?
b) gameID, Day
d) Day, Score
5. Consider the following two tables:
a) Supplier NATURAL LEFT OUTER JOIN Product
b) Supplier INNER JOIN Product
c) Supplier NATURAL RIGHT OUTER JOIN Product
d) Supplier NATURAL FULL OUTER JOIN Product
6. Consider the following schema:
player (p_id, tournament.code, month, match.count)
In the player schema, p_id uniquely identifies every record.
Given that a player cannot play more than 5 matches in a month for a tournament, identify the correct CHECK constraint for the create query of this table.
a) CONSTRAINT CK_mat-count for CHECK (if match_count < 6)
b) CONSTRAINT CKmat.count for CHECK (if match_count< 6 is true)
c) CONSTRAINT CK_mat.count CHECK (if match.count < 6)
d) CONSTRAINT CK_mat.count CHECK (match.count < 6)
👇For Week 03 Assignment Answers👇
7. Consider the following schema:
8. Consider the following instance of the relation BookDetails. BookDetails (BOOK_ID, YEAR_PUB, BOOK-TITLE, AUTHOR NAME, TOTAL.SOLD_COPIES)
Answer:- b, d
9. Consider the following instance of the relation BookDetails. BookDetails (B0OKID, YEARPUB, BOOK.TITLE, AUTHOR_NAME, TOTAL SOLD_COPIES)
Answer:- For Answer Click Here
10. Consider the following relation schema: BookDetails (B00K_ID, YEAR_PUB, BOOK TITLE, AUTHOR NAME, TOTAL SOLD.cOPIES).
Identify the correct statement to create an INDEX on B00K_ID and BOOK-TITLE of BookDetails relation named as ‘Books’.
a) Create INDEX Books TO BookDetails (B0OK_ID, BOOK_TITLE);
b) Create INDEX Books ON BookDetails (BOOK_ID, BOOK_TITLE);
c) Create INDEX Books AS BookDetails (B00K_ID, BOOK_TITLE);
d) Create INDEX Books OF BookDetails (BOOK_ID, BOOK_TITLE) ;