Hello NPTEL Learners, In this article, you will find NPTEL Data Base Management System Assignment 2 Week 2 Answers 2023. All the Answers are provided below to help the students as a reference don’t straight away look for the solutions, first try to solve the questions by yourself. If you find any difficulty, then look for the solutions.
NPTEL Data Base Management System Assignment 3 Answers 2023 Join Group👇
Note: We are trying to give our best so please share with your friends also.
NPTEL Data Base Management System Assignment 2 Answers 2023:
We are updating answers soon Join Group for update: CLICK HERE
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’);
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)
NPTEL Data Base Management System Assignment 3 Answers Join Group👇
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
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′ );
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.
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
NPTEL Data Base Management System Week 2 Answers Join Group👇
CLICK HERE
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;
Q.9. Consider the following instance of Universities Details (StateName, #Central Universities, #State Universities, #Faculties) relation.
Identify the correct SQL command that creates a view as Universities Info with StateName and #Central Universities that enlist members whose StateName has 2nd character ‘e’.
- Answer: D
Q.10. Consider the following instance of UniversitiesDetails (StateName, #Central Universities, #State Universities, #Faculties) relation.
Identify the correct statement(s) to find the StateName whose #Central Universities is greater than or equal to 2 and #Faculties is greater than or equal to 18000 but less than or equal to 25000.
- Answer: B C
NPTEL Data Base Management System Assignment 2 Answers Join Group👇
Disclaimer: This answer is provided by us only for discussion purpose if any answer will be getting wrong don’t blame us. If any doubt or suggestions regarding any question kindly comment. The solution is provided by Chase2learn. This tutorial is only for Discussion and Learning purpose.
About NPTEL Data Base Management System Course:
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.
Course Outcome:
- Week 1:Course Overview. Introduction to RDBMS
- Week 2:Structured Query Language (SQL)
- Week 3:Relational Algebra. Entity-Relationship Model
- Week 4:Relational Database Design
- Week 5:Application Development. Case Studies. Storage and File Structure
- Week 6:Indexing and Hashing. Query Processing
- Week 7: Query Optimization. Transactions (Serializability and Recoverability)
- Week 8:Concurrency Control. Recovery Systems. Course Summarization.
CRITERIA TO GET A CERTIFICATE:
Average assignment score = 25% of average of best 8 assignments out of the total 12 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.
If you have not registered for exam kindly register Through https://examform.nptel.ac.in/
Join Our Telegram Group:- CLICK HERE
