FC0-U71 · Question #144
A database administrator creates an outline for a database structure. Which of the following did the administrator create?
The correct answer is D. Schema. A database administrator creates a schema to define the complete logical structure of a database.
Question
A database administrator creates an outline for a database structure. Which of the following did the administrator create?
Options
- ATable
- BRow
- CColumn
- DSchema
How the community answered
(20 responses)- A5% (1)
- B5% (1)
- D90% (18)
Why each option
A database administrator creates a schema to define the complete logical structure of a database.
A table is a specific component within a database schema that holds related data.
A row (also known as a record or tuple) is a single entry of data within a table.
A column (also known as a field or attribute) represents a specific type of data within a table.
A database schema is the blueprint or logical structure of an entire database, defining how data is organized and how the relations among them are associated. It includes definitions for tables, fields (columns), data types, indexes, and constraints.
Concept tested: Database schema definition
Source: https://learn.microsoft.com/en-us/sql/relational-databases/tables/schemas-database-engine?view=sql-server-ver16
Topics
Community Discussion
No community discussion yet for this question.