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.
NPTEL Data Base Management System Week 2 Assignment Answers 2023
1. Consider two relations StyleName and PrintStyle as follows:
An operation θ between StyleName and PrintStyle will generate the following output:
Identify the operation G.
a) natural join
b) natural left outer join
c) natural right outer join
d) natural full outer join
Answer:- d
2. Consider the following CREATE statements:
Answer:- a
3. Consider the following schema:
- loan (loan _number, branch_name, amount)
Answer:- b, d
4. Consider the following instance of the relation
BIDDINGTAB (PRODUCTID, HIGHESTBID, LOWESTBID, WINNER, BIDDERS)
Answer:- a
5. Consider the following instance of the relation
BIDDINGTAB (PRODUCTID, HIGHESTBID, LOWESTBID, WINNER, BIDDERS)
Answer:- b
6. Consider the following instance of the relational schema
PAYSCALE (POSITION, BASE_SALARY, EXPERIENCE)
Answer:- c
7. A role Manager has the privilege to perform select, insert, update and delete operations on all tables of database. A new role Software_Engineer is created and the following statement is executed.
Answer:- d
8. Consider the following instance of MountainDetails (MountainName, Altitude, StateName) relation.
Answer:- a
9. Consider the given relational schema: MountainDetails (MountainName, Altitude, StateName)
Answer:- b
10. Consider the given relational schema: MountainDetails (MountainName, Altitude, StateName)
Answer:- c
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
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
b) Happiens
c) Echoing Laughters
d) The haunting
Answer:- b
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?
a) 3
b) 4
c) 5
d) 6
Answer:- c
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
Answer:- a
4. Which attribute(s) is (are) represented by X in the above query?
a) gameID
b) gameID, Day
c)Day
d) Day, Score
Answer:- c
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
Answer:- a
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)
Answer:- d
👇For Week 03 Assignment Answers👇
7. Consider the following schema:
Answer:- a
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) ;
Answer:- b
For More NPTEL Answers:- CLICK HERE
Join Our Telegram:- CLICK HERE