[Week 1] NPTEL Introduction to Database Systems Assignment Answers 2024

Join Our WhatsApp Group Join Now
Join Us On Telegram Join Now

NPTEL Introduction to Database Systems Week 1 Assignment Answers 2024

1. Storing data and meta-data separately makes RDBMS general-purpose and flexible.

  • True
  • False
Answer :- 

2. “Data Model” is nothing but a data structure where data is stored.

  • True
  • False
Answer :- 

3. An RDBMS can typically manage more than one database.

  • True
  • False
Answer :- 

4. A database can not be created unless an RDBMS is used.

  • True
  • False
Answer :- 

5. Relational data model provides the concept of “Entity”.

  • True
  • False
Answer :- 

6. ER Model is NOT a representational-level data model.

  • True
  • False
Answer :- 

7. Three-schema architecture is part of the Entity-Relationship Data Model.

  • True
  • False
Answer :- 

8. Transaction Manager takes control of the system when it recovers after a failure.

  • True
  • False
Answer :- 

9. People who make use of application programs need to know the logical schema of the database completely.

  • True
  • False
Answer :- 

10. People who develop the application programs need not know the physical schema of the database.

  • True
  • False
Answer :- 

11. People who develop the application programs need to know the logical schema of the database completely.

  • True
  • False
Answer :- 

12. A “log” in the RDBMS keeps track of update operations of all transactions.

  • True
  • False
Answer :- 

13. Complete the sentence: Logical Data Independence is the ability to modify…

  • physical-level schema without affecting the logical-level schema
  • the logical-level schema with no effect on view-level schema.
  • view-level schema without affecting logical-level schema.
  • logical-level schema without affecting physical-level schema.
Answer :- 

14. Complete the sentence: Physical Data Independence is the ability to modify…

  • physical-level schema without affecting the logical-level schema
  • the logical-level schema with no effect on view-level schema.
  • view-level schema without affecting logical-level schema.
  • logical-level schema without affecting physical-level schema.
Answer :- 

15. An Entity-Relationship (ER) Model represents:

  • The various entity types of interest and the relationships among them in the domain being modeled.
  • Various tables and links among them in the domain being modeled.
  • The various entity types of interest and the relationships among them in the domain being modeled along with operations to be performed on data.
  • Various tables and links among them in the domain being modeled along with operations to be performed on data.
Answer :- 

16. A person who develops a high-level language program that meets a functional requirement of the database is usually called:

  • A naive user
  • An application programmer
  • A data analyst
  • A DB administrator
Answer :- 

17. The people playing the following role need​ NOT​ have an understanding of the complete logical schema of the database:

  • Data-entry Operator
  • Application Programmer
  • Data Analyst
  • Database Administrator
Answer :- 

18.

Consider the following statements:

   S1: A view usually provides access to a part of the data relevant to a group of users
   S2: A view usually provides access to the complete database
   S3: The feature of defining views is to be compulsorily provided by the RDBMS
   S4: The feature of defining views may not be provided by an RDBMS.

   Choose the correct option:

  • S1 and S3 are TRUE
  • S1 and S4 are TRUE
  • S2 and S3 are TRUE
  • S2 and S4 are TRUE
Answer :- 

19.

Consider the following sets:

   M = { p: RDBMS Run-time System; q: Transaction Manager; r: Buffer Manager;

    s: Recovery Manager}

   F = { w: Transaction Error Handling; x: Concurrency Control; y: Query Execution; z: Paging}

   What is the most appropriate matching between sets M and F?

  • p — y; q — x; r — z; s — w;
  • p — z; q — w; r — y; s — x;
  • p — y; q — z; r — x; s — w;
  • p — w; q — x; r — z; s — y;
Answer :- 

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top