Use Table 1 to answer the following ques...
Use Table 1 to answer the following question.
Table 1: TableStudent
| Reg No | House |
Age |
| 18/001 | Yellow | 14 |
| 18/002 | Blue | 15 |
| 18/003 | Yellow | 15 |
Columns 2 and 3 in Table 1 cannot be used as primary key because both fields contain
Different datatypes
Duplicate values
The same datatype
Only strings and numbers respectively
Correct answer is B
Columns 2 and 3 in Table 1 cannot be used as a primary key because both fields contain duplicate values.
A primary key is a unique identifier for each record in a database table. It ensures that each record has a distinct value, allowing for efficient data retrieval and maintaining data integrity. In the given TableStudent, the "House" column (Column 2) and the "Age" column (Column 3) both contain duplicate values. For example, the House column has two records with the value "Yellow" and the Age column has two records with the value "15". Since a primary key must have unique values, neither of these columns can be used as the primary key.
When information is conveyed from one space to another, it is referred to as information ...
When performing computer recovery operations after a system crash, the startup disk is used to ...
Which of the following is true about digital computers? ...
The following software are web browsers except ...
The process of drawing inference from a piece of information is called ...
In the model; Furniture (Table, Chair, Wardrobe) Furniture is... ...
A system analyst is a person who ...
Which of the following is not a preventive maintenance measure? ...
The following feature are found in the toolbox of CorelDraw application except ...