Subject
Computer Technology (Bank)
Topic
Operating System
Which of the following statement is true?
Which of the following statement is true?
ক)
Foreign key fields don\’t allow duplicate valuesখ)
In primary key field you can enter duplicate valueগ)
In an indexed field you may or may not enter duplicate value depending upon settingঘ)
All statements are trueExplanation
The correct statement is that **in an indexed field, you may or may not enter a duplicate value depending upon the setting**. Indexes are primarily used for faster data retrieval, and they can be configured as unique (no duplicates allowed) or non-unique (duplicates allowed). * Option A is incorrect because Foreign Keys often *do* allow duplicate values (unless constrained otherwise); the rule for uniqueness primarily applies to Primary Keys. * Option B is incorrect because a Primary Key field **never** allows duplicate values; it must contain unique identifiers for every record.Related questions
The ______ is a wild card that represents one or more characters.In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful.Dcl provides commands to perform actions likeThe Search tool CANNOT be used on which major Access object?Microsoft Access is aThe content and application of the Search tool CANNOT be retained when you ______.Following is not a database modelSwapping