NYC CERTIFIED IT ADMINISTRATOR (DATABASE) EXAM PRACTICE QUESTIONS AND ANSWERS
ALREADY GRADED A+| 100% VERIFIED SOLUTIONS………...
Core Domains
Database Fundamentals and Architecture
SQL and Query Optimization
Database Administration and Maintenance
Backup, Recovery, and Disaster Recovery
Database Security and Access Control
Performance Monitoring and Tuning
High Availability and Replication
NYC Data Governance and Compliance
ETL and Data Warehousing
Troubleshooting and Incident Response
Introduction
The NYC Certified IT Administrator (Database) Exam Practice Test is designed to assess the
comprehensive knowledge and applied decision-making skills required of database administrators
in New York City government. The examination evaluates competency across database
fundamentals, SQL programming, backup and recovery, security and compliance, performance
tuning, high availability, and NYC-specific data governance requirements. Candidates are tested on
,their ability to apply regulatory standards including the NY SHIELD Act and FOIL, troubleshoot
complex database issues, and make sound administrative decisions in real-world scenarios.
Through multiple-choice and scenario-based questions, the exam emphasizes critical thinking,
technical proficiency, and adherence to NYC Cyber Command security standards.
SECTION ONE: QUESTIONS 1–100
Question 1
Which of the following best describes the primary purpose of a Database Management System
(DBMS)?
A. To manage the operating system's file storage
B. To provide an interface for users to browse the internet
🟢 C. To efficiently store, retrieve, and manage data while ensuring security and integrity
D. To compile programming code into executable files
🔴 RATIONALE: A DBMS is specialized software designed to store, retrieve, define, and manage
data in a database. It enforces security, concurrency, and integrity constraints, making it essential
for enterprise data management.
Question 2
What does the acronym SQL stand for?
🟢 A. Structured Query Language
B. Simple Query List
,C. Sequential Query Logic
D. Standard Question Language
🔴 RATIONALE: SQL (Structured Query Language) is the standard language used to interact with
relational databases for querying and managing data.
Question 3
Which database model organizes data in tables consisting of rows and columns with predefined
relationships?
A. Hierarchical model
B. Network model
🟢 C. Relational model
D. Object-oriented model
🔴 RATIONALE: The relational model structures data into relations (tables) with tuples (rows) and
attributes (columns). Hierarchical uses trees, network uses graphs, and object-oriented integrates
OOP concepts.
Question 4
Which key uniquely identifies a record in a table?
A. Foreign key
🟢 B. Primary key
, C. Composite key
D. Alternate key
🔴 RATIONALE: A primary key uniquely identifies each record in a table and cannot contain
NULL values. This ensures that every row is distinguishable.
Question 5
What is a foreign key used for in a relational database?
A. To encrypt data in a table
🟢 B. To link two tables together
C. To delete records automatically
D. To store database backups
🔴 RATIONALE: Foreign keys establish relationships between tables by referencing the primary
key of another table. This enforces referential integrity in the database.
Question 6
Which normal form eliminates repeating groups from a table?
🟢 A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
ALREADY GRADED A+| 100% VERIFIED SOLUTIONS………...
Core Domains
Database Fundamentals and Architecture
SQL and Query Optimization
Database Administration and Maintenance
Backup, Recovery, and Disaster Recovery
Database Security and Access Control
Performance Monitoring and Tuning
High Availability and Replication
NYC Data Governance and Compliance
ETL and Data Warehousing
Troubleshooting and Incident Response
Introduction
The NYC Certified IT Administrator (Database) Exam Practice Test is designed to assess the
comprehensive knowledge and applied decision-making skills required of database administrators
in New York City government. The examination evaluates competency across database
fundamentals, SQL programming, backup and recovery, security and compliance, performance
tuning, high availability, and NYC-specific data governance requirements. Candidates are tested on
,their ability to apply regulatory standards including the NY SHIELD Act and FOIL, troubleshoot
complex database issues, and make sound administrative decisions in real-world scenarios.
Through multiple-choice and scenario-based questions, the exam emphasizes critical thinking,
technical proficiency, and adherence to NYC Cyber Command security standards.
SECTION ONE: QUESTIONS 1–100
Question 1
Which of the following best describes the primary purpose of a Database Management System
(DBMS)?
A. To manage the operating system's file storage
B. To provide an interface for users to browse the internet
🟢 C. To efficiently store, retrieve, and manage data while ensuring security and integrity
D. To compile programming code into executable files
🔴 RATIONALE: A DBMS is specialized software designed to store, retrieve, define, and manage
data in a database. It enforces security, concurrency, and integrity constraints, making it essential
for enterprise data management.
Question 2
What does the acronym SQL stand for?
🟢 A. Structured Query Language
B. Simple Query List
,C. Sequential Query Logic
D. Standard Question Language
🔴 RATIONALE: SQL (Structured Query Language) is the standard language used to interact with
relational databases for querying and managing data.
Question 3
Which database model organizes data in tables consisting of rows and columns with predefined
relationships?
A. Hierarchical model
B. Network model
🟢 C. Relational model
D. Object-oriented model
🔴 RATIONALE: The relational model structures data into relations (tables) with tuples (rows) and
attributes (columns). Hierarchical uses trees, network uses graphs, and object-oriented integrates
OOP concepts.
Question 4
Which key uniquely identifies a record in a table?
A. Foreign key
🟢 B. Primary key
, C. Composite key
D. Alternate key
🔴 RATIONALE: A primary key uniquely identifies each record in a table and cannot contain
NULL values. This ensures that every row is distinguishable.
Question 5
What is a foreign key used for in a relational database?
A. To encrypt data in a table
🟢 B. To link two tables together
C. To delete records automatically
D. To store database backups
🔴 RATIONALE: Foreign keys establish relationships between tables by referencing the primary
key of another table. This enforces referential integrity in the database.
Question 6
Which normal form eliminates repeating groups from a table?
🟢 A. First Normal Form (1NF)
B. Second Normal Form (2NF)
C. Third Normal Form (3NF)
D. Boyce-Codd Normal Form (BCNF)
