This set of MCQ(multiple choice questions) focuses on the Data Base Management System NPTEL 2022 Week 1 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. Data Base Management System NPTEL 2022 Week 1 Assignment Solution” contains 20 questions.
Now, start attempting the quiz.
Data Base Management System NPTEL 2022 Week 1 Assignment Solutions
Q1. Identify the correct statement(s) from the following.
a) The overall physical structure of the database is called physical schema.
b) The actual content of the database at a particular point in time is called an instance.
c) Data dictionary does not contain any database schema.
d) Physical schema describes how data is stored in the database and the relationships among the data
Answer: a), b)
Q2. Consider the following instance: MLDatabase
| Model | Accuracy | Dataset | TrainingData |
| M1 | 98 | DA | 11280 |
| M2 | 100 | DB | 29650 |
| M2 | NULL | DC | 148 |
| M2 | 100 | DA | 11280 |
| M3 | 45 | DC | 148 |
Identify the correct representation of MLDatabase schema.
a) MLDatabase(Model, Accuracy, Dataset, TrainingData)
b) MLDatabase(Model, Accuracy, Dataset, TrainingData)
c) MLDatabase(Model, Accuracy, Dataset, TrainingData)
d) MLDatabase(Model, Accuracy, Dataset, TrainingData)
Answer: a)
Q3. Identify the incorrect statement(s).
a) A Super Key is a set of one or more attributes that, taken collectively, allows us to uniquely identify an entity in the entity set.
b) A proper subset of a candidate key is called a Super Key.
c) The minimal set of attributes that allows us to uniquely identify an entity in the entity set is called a candidate key.
d) A proper subset of a Super Key is not always a Candidate Key.
Answer: b)
Q4. Consider two relations below. The primary keys are underlined. Identify all possible foreign key(s) from the options.
Employee(EmpID, Ename, Salary) where EmpID is of type integer, Ename is of type string, and Salary is of type decimal number.
Project(EmpID, Pnumber) where EmpID is of type integer, and Pnumber is of type string.
a) Ename
b) EmpID
c) Pnumber
d) EmpID, Pnumber
Answer: b)
Q5. Consider the following instance of ImageRec(Sl, DepthImage, Coord1, Coord2).
| Sl | DepthImage | Coord1 | Coord2 |
| 1 | 256 | 1 | 1 |
| 2 | 256 | 1 | 2 |
| 3 | 194 | 6 | 6 |
| 8 | 126 | 6 | 6 |
Which of the following is a Secondary Key in ImageRec?
a) {Sl, DepthImage}
b) {Coord1, Coord2}
c) {Coord2, DepthImage}
d) {Coord1, DepthImage}
Answer: c)
Q6. Consider the following instances:
How many tuples will be selected by σPlayer = Gamer(Game1 x Game2)?
a) 3
b) 4
c) 8
d) 9
Answer: b) 4
Q7. Consider the two tables given below:
Identify the correct statement from the following.
a) Cartesian product of Student and Teacher has six tuples.
b) Cartesian product of Student and Teacher is not possible.
c) There will be three tuples in the result of the natural join between Student and Teacher.
d) Natural join between Student and Teacher is not possible.
Answer: d)
Q8. Consider the following table:
a) II(Branch=Address) Λ (Salary>10000)(EmployeeDetails)
b) II(Branch=Address) v (Salary>10000)(EmployeeDetails)
c) σ(Branch=Address) Λ (Salary>10000)(EmployeeDetails)
d) σ(Branch=Address) v (Salary>10000)(EmployeeDetails)
Answer: c)
Q9. Consider the following tables:
a) R1 — R2
b) R2 — R1
c)( R1 U R2) ∩ ( R1 ∩ R2)
d) (R1 — R2) U (R2 — R1)
Answer: c)
Q10. Which of the following can be a candidate key for the following instance?
a) {EmpName}
b) {Branch}
c) {EmpName, Address}
d) {EmpName, Branch}
Answer: d)
<< Prev- Data Base Management System Week 0 Assignment Solutions
>> Next- Data Base Management System Week 2 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.