Database Management
Accenture Technical PrimermediumDatabase ManagementSelect Statement

Which statements are true regarding constraints?

Answer options

A
A column with the UNIQUE constraint can contain NULL values.
B
A foreign key cannot contain NULL values.
C
A constraint is enforced only for the INSERT operation.
D
A constraint cannot be disabled when the column contains data.

Correct answer: A column with the UNIQUE constraint can contain NULL values.

Explanation

Quick AnswerThe correct answer is A column with the UNIQUE constraint can contain NULL values. because it directly addresses the core logic of Database Management.

UNIQUE constraints allow NULL values (a NULL is not considered equal to another NULL).

Related Accenture Database Management questions

Tom has designed a payroll software for XYZ technology.The sofware will store the salary details into the database and l…In SQL is a case sensitive language and the data stored inside the table are case in-sensitive. Say true or false?Which of the following is not a valid relational database?Database is a shared collection of logically unrelated data, designed to meet the needs of an organization. State True o…Which of the following represents the degree of the relation?A table consists of ______ primary keys.

Practice more Accenture Database Management questions

PrimerPrep has 1400+ practice questions, 2026 simulations and coding hands-on — all free.

Database Management practice setAll subjects
Watch Walkthroughs!