Question

Which of the following is NOT CORRECT about the roles of the DBMS components? (1 Point) Select one: The job of the query processor is to handle the modifications of both data and schema. The job of the storage manager is to modify the information to the data storage when requested. The job of the query processor and query optimizer is to issue commands to the storage manager The job of the query processor is to obtain information requested from the data storage All of the above. None of the above.

Answer 1

Correct Answer:

The job of the query processor is to handle the modifications of both data and schema.

Explanation:

The query processor is responsible for the execution of the database queries and the storage manager is responsible for the modification of the data stored.

The query processor get the input commands in the form of SQL text and then optimizer will optimize that query and then the query will be executed.

So, only the first option statement is false and all other statements are true.

So, the first option is correct.