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.
A program designed to detect and prevent malicious programs from a computer system is ...
The process of sending and receiving information from one place to another is called information ...
Which of the following data elements ranks highest in size? ...
A novice is discouraged from opening the CRT monitor for maintenance because ...
In e-mail context, bcc stands for ...
One disadvantage of electronic data processing is ...
A server is a computer that provides services to other computers called ...
The act of producing information from figures, text or images is called data ...
The Difference Engine and the Analytical Engine were invented by ...