wiz-icon
MyQuestionIcon
MyQuestionIcon
1
You visited us 1 times! Enjoying our articles? Unlock Full Access!
Question

In MS-Access, a table can have _________ primary key/keys.

A
One
Right on! Give the BNAT exam to get a 100% scholarship for BYJUS courses
B
Two
No worries! We‘ve got your back. Try BYJU‘S free classes today!
C
Three
No worries! We‘ve got your back. Try BYJU‘S free classes today!
D
Four
No worries! We‘ve got your back. Try BYJU‘S free classes today!
E
None of these
No worries! We‘ve got your back. Try BYJU‘S free classes today!
Open in App
Solution

The correct option is A One

In MS-Access, a table can have one primary key/keys.

It is a good practice to have a PK on every table, but it's not a MUST. Most probably you will need a unique index, and/or a clustered index (which is PK or not) depending on your need. "PRIMARY KEY constraints identify the column or set of columns that have values that uniquely identify a row in a table.

SQL PRIMARY KEY Constraint. The PRIMARY KEY constraint uniquely identifies each record in a database table. Primary keys must contain UNIQUE values, and cannot contain NULL values. A table can have only one primary key, which may consist of single or multiple fields.


flag
Suggest Corrections
thumbs-up
0
Join BYJU'S Learning Program
similar_icon
Related Videos
thumbnail
lock
Computers in Accounting
ACCOUNTANCY
Watch in App
Join BYJU'S Learning Program
CrossIcon