This set of MCQ(multiple choice questions) focuses on the Data Base Management System NPTEL 2023 Week 3 Assignment Solutions.
The course introduces relational data models; entity-relationship modeling, SQL, data normalization, and database design. Further it introduces query coding practices using MySQL (or any other open system) through various assignments. Design of simple multi-tier client / server architectures based and Web-based database applications is also introduced.
Course layout (Answers link)
Answers COMING SOON! Kindly Wait!
Week 0: Assignment answers
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.
NOTE: You can check your answer immediately by clicking show answer button. This set contains 10 questions.
Now, start attempting the quiz.
Data Base Management System NPTEL 2023 Week 3 Quiz Solutions
Q1. Consider the relation Payments as follows:
What is the output of the following Relational Algebra?
a) UPI
b) Cash
c) NEFT
d) Card
Answer: a) UPI
Q2. Consider teh relation Payments as follows:
Which of the TransactionIDs will NOT be present in the output of R1-R2?
a) 42
b) 15
c) 14
d) 4
Answer: b) 15
Q3. Consider the relation Content(Channel, VideoTitle, Likes, Dislikes).
Choose the correct Tuple Relational Calculus that represents the following statement:
“Display the titles of those videos that are published on YouTube Channels and have more than 50,000 likes.”
Answer: c)
Q4. Consider the relation Content (Channel, VideoTitle, Likes, Dislikes).
Choose the correct Domain Relational Calculus that is equivalent to the following SQL query:
SELECT Channel, VideoTitle FROM Content
WHERE Dislikes<100;
Answer: a)
Q5. A C program, with embedded SQL query, allows the users to enter a date and an amount to check the transactions that were made on that day. The entered date is stored in the variable Tdate and the amount in variable amt. The SQL query returns the TransactioID and Amunt of those payments from Payments(Mode, TransactionID, PaymentDate, Amount) whose PaymentDate match with the user’s entered date and the Amount is more than the entered amount. Which of the following SQL queries is correct for the purpose?
Answer: a)
Q6. A cloth factory maintains a schema of manufactured Clothes where each clothing item is identified by a tag. The clothes are also associated with corresponding sizes and materials. However, each cloth can be designed by multiple designers. Which of the following schema correctly represents the Clothes entity set?
Answer: d)
Q7. Consider the three relational schemas:
Stories(Title, Author, Pages, StoryCount)
Books(Title, Author, Pages)
Educational(Title, Author, Pages, Subject)
Which of the Entity Relationship diagrams correspond to the given schemas?
Answer: c)
Q8. Consider the Entity Relationship Diagram:
Which of the following is/are true?
a) The participation of Organizer in Org.Conf is partial.
b) The participation of Conference in Org.Conf is partial.
c) Presenter is a composite attribute of Presentation.
d) Presenter is a multivalued attribute of Presentation.
Answer: b), d)
Q9. Consider the Entity Relationship Diagram:
What is the correct schema for Books?
a) Books(Acronym, PaperID, SessionID).
b) Books(Acronym, PaperID, SessionID).
c) Books(Acronym, PaperID, SessionID, Presenter).
d) Books(Presenter, Acronym, PaperID, SessionID).
Answer: b)
Q10. Consider the following instance of Organizer:
How many tuples will be returned by the following Relational Algebra?
a) 2
b) 6
c) 14
d) 16
Answer: a)
Data Base Management System NPTEL 2022 Week 3 Assignment Solutions
Q1.
Answer: b)
Q2.
Answer: b), d)
Q3.
Answer: a)
Q4.
Answer: b)
Q5.
Answer: c)
Q6.
Answer: d)
Q7.
Answer: a)
Q8.
Answer: a)
Q9.
Answer: a)
Q10.
Answer: b)
<< Prev- Data Base Management System Week 2 Assignment Solutions
>> Next- Data Base Management System Week 4 Assignment Solutions
NPTEL answers: Problem solving through programming in C
NPTEL answers: Principles of Management
Programming in Java NPTEL week 1 quiz answers
NPTEL – Python for Data Science assignment solutions
Nptel – Deep Learning assignment solutions
The above question set contains all the correct answers. But in any case, you find any typographical, grammatical or any other error in our site then kindly inform us. Don’t forget to provide the appropriate URL along with error description. So that we can easily correct it.
Thanks in advance.
For discussion about any question, join the below comment section. And get the solution of your query. Also, try to share your thoughts about the topics covered in this particular quiz.