Which database object is used to store data?

Question

BlackTom AI · Accepted Answer

Tables are the primary database objects that actually hold and persist data in rows and columns.

1. Relevant knowledge points and concepts
- Table: a structured object composed of columns (fields) and rows (records) where data values are stored. Tables often include constraints (e.g., primary keys) to ensure uniqueness and integrity.
- Query: a request (often SQL) to retrieve, filter, join, or transform data from one or more tables; queries do not themselves store persistent data (unless used to create a table).
- Form: a user interface element used to enter, edit, or view data stored in tables.
- Report: a formatted presentation of data (for printing or review) created from tables or query results.

2. Step-by-step reasoning
- Databases are organized so that the persistent storage unit is a table. Each table represents an entity (e.g., Customers) and contains rows for each instance and columns for attributes.
- When you insert data, it is written into a table’s rows. Retrieval and presentation of that data are done via queries, forms, or reports, which depend on the table’s stored data.
- Therefore, the object that is directly used to store data is the table.

3. Calculations / intermediate steps
- No numeric calculations are required. Logical steps: insert → stored in table row; select → query reads from table; display/edit → form reads/writes to table; report → reads from table/query.

4. Why the correct answer is correct
- A table provides the persistent, structured storage for records. Other objects reference or present that stored data but do not serve as the underlying storage container.

5. Why other options are incorrect
- a. Query: retrieves/manipulates data but does not inherently store it (unless specifically used to create a new table).
- b. Form: a UI for data entry/display, not the storage layer.
- d. Report: a formatted output of data, not where data is stored.

6. Conclusion
The correct answer is c. Table, which matches the provided answer.

Which database object is used to store data?单项选择题

类似问题

The primary object in a database for collecting and storing data is called a

What is the minimum number of tables possible in a relational DBMS?

In the following SQL statement, what does "STUDENT" represent? SELECT EagleID FROM STUDENT;