FC0-U71 · Question #48
A database administrator creates a new database and assigns the primary key. Which of the following database types has the administrator created?
The correct answer is C. Relational. A Relational database organizes data into structured tables (rows and columns) and uses a primary key to uniquely identify each record and establish relationships between tables. Primary keys are a defining feature of the relational model (e.g., MySQL, PostgreSQL, SQL Server). Do
Question
A database administrator creates a new database and assigns the primary key. Which of the following database types has the administrator created?
Options
- ADocument
- BKey/value
- CRelational
- DNon-structured
How the community answered
(44 responses)- B2% (1)
- C93% (41)
- D5% (2)
Explanation
A Relational database organizes data into structured tables (rows and columns) and uses a primary key to uniquely identify each record and establish relationships between tables. Primary keys are a defining feature of the relational model (e.g., MySQL, PostgreSQL, SQL Server). Document databases (A) store data as semi-structured documents (e.g., JSON/BSON) without requiring a primary key in the relational sense. Key/value databases (B) use a simple key-value pair structure without tables. Non-structured (D) refers to unstructured data stores that lack a defined schema.
Topics
Community Discussion
No community discussion yet for this question.