Question

X: Database, Table, Index, Document, Field

y: Database, Collection, Index, Row, Column

Option 1:
x: Record, Table, Indicator, Document, Attribute
y: Database, Collection, Index, Row, Column

Option 2:
x: Datastore, Sheet, Key, Document, Attribute
y: Database, Collection, Index, Record, Field

Option 3:
x: Database, Spreadsheet, Key, Record, Attribute
y: Database, Set, Index, Row, Column

Option 4 (Correct):
x: Database, Table, Index, Document, Field
y: Database, Collection, Index, Row, Column

Answer 1

In a database, a table consists of rows and columns where each row represents a record and each column represents a field.

Step-by-step explanation:

Database Terminology:

The correct option is Option 4. In a database, a table consists of rows and columns where each row represents a record and each column represents a field. An index is used to optimize the retrieval of data. A document is a collection of fields and is typically used in NoSQL databases.

Terminology in Option 4:

• Database: A collection of related data.
• Table: A collection of rows and columns.
• Index: A data structure that improves the speed of data retrieval.
• Document: A record consisting of multiple fields stored in a NoSQL database.
• Field: A specific data element within a record.