A developer creates a primary key on an existing table. Which rule is enforced automatically for the primary key columns?

AThey can contain NULL values if the index is clustered

BThey are implicitly NOT NULL

CThey must also be foreign keys

DThey are converted to UNIQUEIDENTIFIER

More Design and develop database solutions Questions

76 questions

Full Microsoft Certified: SQL AI Developer Associate Practice Test

All topics covered

All Microsoft Certified: SQL AI Developer Associate Questions

Browse by topic

Related Questions

A team wants multiple tables to draw numbers from the same ordered sequence. Which feature should th...

easy

A report must show row values as they existed at 2026-02-01 12:00 UTC from a system-versioned tempor...

easy

A JSON document contains a `city` property with the scalar value `London`. Which function is the bes...

easy

A database model uses SQL Graph. Which statement correctly describes node and edge tables?...

easy

An engineer is partitioning a table in Azure SQL Database. Which filegroup can be used for the parti...

medium

View all Design and develop database solutions questions

Educational Content — CertQnA practice questions are written against official exam objectives, covering the same domains tested on the real exam. All content is original and independent — not actual exam questions, not affiliated with any certification vendor. Learn more about our content policy

Discussion

Be the first to share your understanding of this concept

⚠️ Discussion is for concept clarification only. Do not share or request actual exam questions or answers.