Database Parts - Quiz Explanation
Parts of a Database
The correct answers are indicated below, along with the text that explains the correct answers.
-
1.
Which portion of a database system contains the actual data elements, such as the name, address, or a phone number for a particular person?
Please select the best answer.
A.
Tables
B.
Columns
C.
Rows
D.
Databases
The correct answer is B.
Columns are the equivalent of cells on a spreadsheet, containing the working information that is stored in the system.
2.
Which of the following statements is false?
Please select the best answer.
A.
Tables contain one or more rows.
B.
Rows contain one or more databases of information.
C.
Columns contain the detailed information stored in the system.
D.
Databases contain one or more tables.
The correct answer is B.
Rows do not contain databases. Rather, rows contain the columns of information in the table.
2.
Which SQL statement is used to extract data from a database?
A.
Get
B.
Extract
C.
Open
D.
Select
The correct answer is D.
The Select statement is used to retrieve data from a table