Question

question 21
2 pts
to work with data, a dbms must retrieve the data from __ and place them in __.
○ permanent storage; ram
○ data files; procedure cache
○ temporary files; procedure cache
○ ram; data cache

Explanation:

To solve this, we recall how DBMS (Database Management System) works with data. Permanent storage (like hard drives) holds data long - term. When a DBMS needs to work with data, it first retrieves data from permanent storage. Then, it places the data in RAM (Random Access Memory) because RAM is used for temporary processing and quick access during operations. Let's analyze the options:

• Option 1: "permanent storage; RAM" fits the above explanation.
• Option 2: "data files; procedure cache" is incorrect. Data files are part of permanent storage but the second part (procedure cache) is for storing execution plans of SQL procedures, not for holding data being worked on.
• Option 3: "temporary files; procedure cache" is wrong. Temporary files are not the primary source for data retrieval in DBMS, and procedure cache is not for data storage during normal data processing.
• Option 4: "RAM; data cache" is incorrect as data is not retrieved from RAM initially (RAM is volatile and loses data on power - off, so permanent storage is the source).

Answer:

A. permanent storage; RAM