NPTEL Data Base Management System Assignment 2 Answers 2023? This article will help you with the answer to the National Programme on Technology Enhanced Learning (NPTEL) Course “ Data Base Management System Assignment 2 “
Below you can find the answers for Data Base Management System Assignment 2 Answers 2023
NPTEL Data Base Management System Assignment 2 Answers 2023:-
Q.1. Table ACCOUNT is created using the following SQL query :
CREATE TABLE ACCOUNT(AcNo INTEGER, NAME VARCHAR (20), PRIMARY KEY (AcNo), CHECK (NAME LIKE ‘%Y’)); Which of the following SQL command(s) will result in an error?
- a) INSERT INTO ACCOUNT VALUES (1, ‘AKSHAY’);
- b) INSERT INTO ACCOUNT VALUES (NULL, ‘BIJAY’);
- c) INSERT INTO ACCOUNT VALUES (3, ‘ABHAY’);
- d) INSERT INTO ACCOUNT VALUES (4, ‘ANANDI’);
Answer:- d
For week 1 Answers:- Click Here
Q.2. A designer maintains the following relations:
• StyleName (Element, Style)
Which of the following option(s) is/are correct to find the names of the Element that has Style without having any color? Primary keys are underlined in the schemas.
Answer: B
Q.3. Consider two relations Table1 (A1,A2) and Table2 (A1, A3) as following :
Suppose Table3 (A1, A2, A3) is the output of natural full outer join of Table1 and Table2. Which of the following statement(s) is/are correct?
- a) Table3 does not contain (5, 7, null) and (2, 3, 7)
- b) Table3 contains (5, 7, 4), (3, null, 7) and (2, 3, null)
- c) Table3 contains (5, 7, 4) but not (2, 3, null) and (3, null, 7)
- d) Table3 contains (2, 3, 7) and (5, 7, null)
Answer:- A,c
Next Week Answers: Assignment 03
Q.4. A designer maintains the following instances:
What is a possible output if the following SQL Query is executed? SELECT COUNT(LOC) FROM Project, Module GROUP BY LOC;
- 8 4
- 12
- 2 1
- 3
Answer:- a
Q.5. Consider the following instance:
What is the output of the following SQL statement? select distinct Experiment Location from Experiment where Participant Count in( select ParticipantCount from Experiment where Experiment Location=’Lab2′ );
Answer:- a
Q.6. Given the schema (primary key is underlined) budget (month, expense) describe the result obtained by the following query. SELECT MAX(expense) AS exp FROM budget WHERE expense < (SELECT MAX (expense) FROM budget);
- a) Finds the highest expense from budget.
- b) Finds second highest expense from budget.
- c) Finds all expenses from budget that are less than the highest expense.
- d) Finds all expenses from budget that are equal to the highest expense.
Answer:- b
Q.7. Consider the following instance:
Which of the following output (s) is (are) displayed by the following SQL query? select NAME from Student where NAME like ‘%A%’ AND NAME NOT like ‘%Rathod’;
- a) Abhay Singh, Roshan Singh
- b) Abhay Singh, Roshan Singh, Smriti
- c) Smriti, Akshay Rathod
- d) Arijit Ray, Abhay Singh, Roshan Singh
Answer:- d
Q.8. Consider the following instance of Universities Details (StateName, #Central Universities, #State Universities, #Faculties) relation.
Identify the correct statement(s) to get the following output :
- a) SELECT * FROM UniversitiesDetails WHERE #Faculties>=20000;
- b) SELECT StateName, #State Universities, #Faculties FROM Universities Details WHERE #Faculties>=20000;
- c) SELECT StateName, #State Universities, #Faculties FROM UniversitiesDetails WHERE #Faculties>=20000 AND #Central Universities=1;
- d) SELECT StateName, #State Universities, #Faculties FROM UniversitiesDetails WHERE #Faculties>=20000 OR #Central Universities=1;
Answer:- b
Q.9. Consider the following instance of Universities Details (StateName, #Central Universities, #State Universities, #Faculties) relation.
Answer: D
Q.10. Consider the following instance of UniversitiesDetails (StateName, #Central Universities, #State Universities, #Faculties) relation.
Answer: B C
For other courses answers:- Visit
For Internship and job updates:- Visit
Disclaimer: We do not claim 100% surety of answers, these answers are based on our sole knowledge, and by posting these answers we are just trying to help students, so we urge do your assignment on your own.
if you have any suggestions then comment below or contact us at [email protected]
If you found this article Interesting and helpful, don’t forget to share it with your friends to get this information.
