WorksheetsTerminologies In Database
Total questions: 8
Worksheet time: 4mins
When dealing with databases, a row is a;
a. Link
b. router
c. record
d. column
A foreign key is;
a. A composite key in a table
b. A candidate key
c. A field in one table that is used as a secondary key in another table
d. A field or collections of fields in one table that refers to the primary key in another table
What is a column when dealing with databases?
a. An upright pillar
b. A vertical group of cells, within a table
c. A group of adjacent cells
d. Items stored horizontally in a database
Datatype refers to;
a. A data item, defined by the values it can take
b. Monies that I have saved
c. The number of rows and columns in a database
d. The number of records used to store data in a database
5. Name a data type found in databases
a. Primary key
b. table
c. Row (record)
d. Date/Time
Why is a primary key important?
a. Because it’s the first key in the table
b. Because there are too many keys in the database
c. Because it serves as a unique identifier for a row of data.
d. Because it allows you to open the entire database.
A secondary key is;
a. A candidate key until the primary key is selected
b. A second way to open the Lab door
c. A second table in a database
d. Two columns with the same data in a database
The name of the datatype that uses numbers is called;
a. Number
b. Logical
c. textual
d. Date/time
