Nptel Introduction to Database Systems Week 1 Assignment Answer

 

Week 1 : Assignment 1

Due date: 2025-02-05, 23:59 IST.

Assignment not submitted

1 point

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.

1 point

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

1 point

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.

1 point

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.

1 point

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;

1 point

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.

1 point

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

1 point

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

State TRUE or FALSE

1 point

Requirements collection is the first step while creating a database system.

 True

 False

1 point

Application programmers don’t need a complete understanding of the database schema or views.

 True

 False

1 point

Indexes are added to databases to speed up query execution.

 True

 False

1 point

OS file systems have the advantage of allowing concurrent users, while compared to a RDBMS system.

 True

 False

1 point

Which of the following are generally stored in the disk storage of an RDBMS system?

 View Definitions.

 Index Structures.

 Database Log.

 User cookies.