Introduction to Database Systems Week 1 Quiz Answers Nptel
Are you looking for NPTEL Introduction to Database Systems Week 1 Quiz Answers ? You’ve come to the right place! Access the most accurate answers at Progiez.
Table of Contents
Introduction to Database Systems Week 1 Quiz Answers (Jan-Apr 2026)
Que1. The RDBMS stores data and meta-data separately.
a) True
b) False
Que2. The data type of an attribute is not part of meta-data.
a) True
b) False
Que3. A record can have a data element with an undefined type.
a) True
b) False
Que4. An RDBMS can not manage more than one database.
a) True
b) False
Que5. Schema is the description of the database.
a) True
b) False
Que6. One must define the logical schema of the database to design a database.
a) True
b) False
Que7. A database system does not hide “the process of storing and maintaining the data on disks” from the users.
a) True
b) False
Que8. The view level abstraction hides the database logical schema from the users.
a) True
b) False
Que9. RDBMS can provide concurrent access to its users.
a) True
b) False
Que10. A log is a record of all the database update operations.
a) True
b) False
These are Introduction to Database Systems Week 1 Quiz Answers
Que11. The recovery manager is responsible for bringing the database back into a consistent state when a failure occurs.
a) True
b) False
Que12. Recovery-manager may sometimes fail to bring the database back into a consistent state.
a) True
b) False
Que13. Which of the following is(are) typical database application(s)?
a) Credit card system
b) Online reservation system
c) Chat application system
d) All of the above
Que14. _ _ _ _ process stores copies of the database tables in several different locations simultaneously.
a) Paging
b) Query answering
c) Buffering
d) Replication
Que15. Consider the statements given below:
S1: Conceptual level schema is derived from the Representational-level schema.
S2: Representational-level schema is derived from the Conceptual level schema.
Choose the correct option:
a) S1: True; S2: False
b) S1: True; S2: True
c) S1: False; S2: True
d) S1: False; S2: False
These are Introduction to Database Systems Week 1 Quiz Answers
Que16. Consider the statements given below:
S1: The Logical Data Independence allows us to modify the logical-level schema without affecting the view-level schema.
S2: The Physical Data Independence allows us to modify the physical-level schema without affecting the logical-level schema.
Choose the correct option:
a) S1: True; S2: True
b) S1: True; S2: False
c) S1: False; S2: True
d) S1: False; S2: False
Que17. Which abstraction level of the database system describes how the data is actually stored?
a) Physical level
b) Logical level
c) View level
d) None of the above
Que18. What is the most appropriate matching between the following sets?
S1: {a: ER Model; b: Relational Model}
S2: {p: Record-based model; q: Conceptual level model; r: High-level data model; s: Representational level model}
a) a–p; b–q; a–r; b–s
b) a–p; b–q; a–s; b–r
c) a–q; b–p; a–r; b–s
d) a–q; b–p; a–s; b–r
These are Introduction to Database Systems Week 1 Quiz Answers
Que19. Typically, a database administrator (DBA) is NOT responsible for:
a) Authorizing access to the database
b) Identifying database security breaches
c) Populating the records
d) To acquire required hardware and software resources
Introduction to Database Systems Week 1 Quiz Answers (Jan-Apr 2025)
Course Link: Click Here
1. Which of the following statements is incorrect regarding databases?
- It captures information about a real-world enterprise or part of an enterprise.
- It is maintained to serve specific data management needs of an enterprise.
- Activities of the enterprise are supported by the database and continually update the database.
- It is difficult to access the data stored in a database. Complex queries have to be written to get even simple data.
2. Which of the following statements is incorrect regarding functionalities of databases?
- Allows for a standard method of data retrieval through queries.
- Queries are returned efficiently.
- Doesn’t have facilities to provide data backup. In case of a failure, all data is lost.
- Allows for a large number of concurrent users with minimal drop-off in performance
3. Which of the following statements best describes a Physical Data Model?
- It is a high-level description of informational needs underlying the design of a database
- It is used to represent only the logical part of the database
- It is a data model explaining the schema of the database
- It is a description of the database giving details about record formats, file structures etc.
These are Introduction to Database Systems Week 1 Quiz Answers
4. Which of the following is true about an ER model?
- It consists of the various tables and links among them in the domain being modeled along with operations to be performed on data.
- It consists of the various tables and links among them in the domain being modeled.
- It consists of the various entity types of interest and the relationships among them in the domain being modeled.
- It consists of the various entity types of interest and the relationships among them in the domain being modeled along with operations to be performed on data.
5. Consider the following sets
M = { p: Recovery Manager; q: Transaction Manager; r: Buffer Manager; s: RDBMS Run-time System}
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 — w; q — x; r — z; s — y;
- p — z; q — w; r — y; s — x;
- p — w; q — z; r — x; s — y;
- p — z; q — w; r — z; s — y;
These are Introduction to Database Systems Week 1 Quiz Answers
6. Which of the following best describes the conventional role of a Data Analyst
- Person who uses embedded SQL in a high-level language and develops programs to handle functional requirements of an information system.
- Person who designs the logical scheme of a database system.
- Person who uses SQL to generate answers for complex queries.
- Person who monitors usage and creates necessary index structures to speed up query execution.
7. 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: Naive users require a deep understanding of an information system to use it.
S4: Naive users do not require a deep understanding of an information system to use it.
Choose the correct option:
- S1 and S3 are TRUE
- S1 and S4 are TRUE
- S2 and S3 are TRUE
- S2 and S4 are TRUE
These are Introduction to Database Systems Week 1 Quiz Answers
8. The ability to modify physical-level schema without affecting the logical-level/view-level schema is called:
- Logical Data Independence
- View Data Independence
- Physical Data Independence
- Application Data Independence
9. Requirements collection is the first step while creating a database system.
- True
- False
10. Application programmers don’t need a complete understanding of the database schema or views.
- True
- False
11. Indexes are added to databases to speed up query execution.
- True
- False
These are Introduction to Database Systems Week 1 Quiz Answers
12. OS file systems have the advantage of allowing concurrent users, while compared to a RDBMS system.
- True
- False
13. Which of the following are generally stored in the disk storage of an RDBMS system?
- View Definitions.
- Index Structures.
- Database Log.
- User cookies.
Nptel Introduction to Database Systems Week 1 Quiz Answers
For answers to others Nptel courses, please refer to this link: NPTEL Assignment