Tables, Columns and Rows — Learn free

Self-check

Questions 1–10 of 10

1. In the family example for tables, columns and rows, what does the whole family represent?
Question 1A. A columnB. A rowC. A tableD. A databaseE. A key
2. Name, Relationship and Date of Birth for each family member are called what in a table?
Question 2A. RowsB. Columns or fieldsC. TablesD. DatabasesE. Records
3. "John, Grandfather, born 1 January 1950" — the details of one person — form what?
Question 3A. A columnB. A rowC. A tableD. A databaseE. A field
4. What is a database table made of?
Question 4A. Only columnsB. Only rowsC. All rows and columns togetherD. A single valueE. Several databases
5. What does a database consist of?
Question 5A. Exactly one tableB. Many tables with different kinds of datasets, such as salary, employee and departmentC. Only unstructured filesD. One row per databaseE. A single column
6. Another word for a table's "columns" is:
Question 6A. FieldsB. RowsC. KeysD. TablesE. Indexes
7. In the family example for tables, columns and rows, how many family members were listed?
Question 7A. ThreeB. FourC. FiveD. SixE. Eight
8. If a Family table has six members and three details each, how many rows and columns does it have?
Question 8A. Three rows and six columnsB. Six rows and three columnsC. Eighteen rowsD. One row and eighteen columnsE. Six rows and six columns
9. Which of these would be a sensible name for the table in the family example?
Question 9A. FamilyB. GrandfatherC. 1 January 1950D. NameE. Row
10. Which statement is TRUE?
Question 10A. A row describes one kind of property across all membersB. A column holds the details of one memberC. A row holds the details of one member; a column is one kind of detail across membersD. Tables and databases are the same thingE. A table can have rows but no columns