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.
The use of transistors in circuit was a major advancement in the ...
An operating system will perform the following except ...
A teacher computed the average score of students in given test ...
The information transmission medium from location A to location B in space is called ...
While typing, a series of letters were highlighted and the keyboard key combination "Ctrl + B&q...
Which of the following file organizations requires primary Key? ...
A file organization that contains a reference number is called ...
Which of the following drawing tools would create special effects for texts? ...