NYC CERTIFIED IT ADMINISTRATOR
(DATABASE) EXAM 2026/2027
SECTION 1: DATABASE FUNDAMENTALS (Questions 1-20)
Q1. 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
Correct Answer: C
Rationale: A DBMS is specialized software designed to store, retrieve, define, and
manage data in a database while enforcing security, concurrency, and integrity
constraints. Options A, B, and D describe functions of an OS, web browser, and
compiler respectively .
Q2. What does SQL stand for?
• A) Structured Query Language
• B) Simple Query List
• C) Sequential Query Logic
, • D) Standard Question Language
Correct Answer: A
Rationale: SQL (Structured Query Language) is the standard language used to
interact with relational databases for querying and managing data .
Q3. 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
Correct Answer: C
Rationale: The relational model, introduced by E.F. Codd, structures data into
relations (tables) with tuples (rows) and attributes (columns). Hierarchical uses tree
structures, network uses graphs, and object-oriented integrates programming
concepts .
Q4. Which key uniquely identifies a record in a table?
• A) Foreign key
• B) Primary key
• C) Composite key
• D) Alternate key
Correct Answer: B
Rationale: A primary key uniquely identifies each row in a table. It must contain
unique values and cannot contain NULL values .
Q5. What is normalization used for in database design?
, • A) Encrypting data
• B) Reducing data redundancy and improving data integrity
• C) Increasing storage size
• D) Creating backups
Correct Answer: B
Rationale: Normalization is the process of organizing data to minimize
redundancy and improve data integrity by eliminating data anomalies .
Q6. In the context of ACID properties, which property ensures that a
transaction is treated as a single, indivisible unit?
• A) Consistency
• B) Isolation
• C) Durability
• D) Atomicity
Correct Answer: D
Rationale: Atomicity guarantees that each transaction is "all or nothing" – if any
part fails, the entire transaction fails and the database state remains unchanged.
Consistency ensures valid state transitions, isolation handles concurrency, and
durability guarantees persistence after commit .
Q7. What is the purpose of a foreign key in relational databases?
• A) Encrypt data
• B) Link two tables together by referencing a primary key in another table
• C) Delete records automatically
• D) Store backups
Correct Answer: B
, Rationale: Foreign keys establish relationships between tables by referencing the
primary key of another table, enforcing referential integrity .
Q8. Which of the following best describes a database?
• A) A collection of random files
• B) An organized collection of structured data
• C) A software program for editing text
• D) A network protocol
Correct Answer: B
Rationale: A database is an organized collection of structured data stored
electronically, designed for efficient storage and retrieval .
Q9. What does a transaction ensure in database systems?
• A) Faster queries
• B) Data integrity through ACID properties
• C) Compressed storage
• D) Network routing
Correct Answer: B
Rationale: Transactions ensure ACID properties (Atomicity, Consistency,
Isolation, Durability), which guarantee data integrity even in the event of errors or
system failures .
Q10. What is a schema in a database?
• A) A backup file
• B) The database structure definition including tables, views, indexes, and
relationships
• C) A query result
• D) A report format
(DATABASE) EXAM 2026/2027
SECTION 1: DATABASE FUNDAMENTALS (Questions 1-20)
Q1. 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
Correct Answer: C
Rationale: A DBMS is specialized software designed to store, retrieve, define, and
manage data in a database while enforcing security, concurrency, and integrity
constraints. Options A, B, and D describe functions of an OS, web browser, and
compiler respectively .
Q2. What does SQL stand for?
• A) Structured Query Language
• B) Simple Query List
• C) Sequential Query Logic
, • D) Standard Question Language
Correct Answer: A
Rationale: SQL (Structured Query Language) is the standard language used to
interact with relational databases for querying and managing data .
Q3. 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
Correct Answer: C
Rationale: The relational model, introduced by E.F. Codd, structures data into
relations (tables) with tuples (rows) and attributes (columns). Hierarchical uses tree
structures, network uses graphs, and object-oriented integrates programming
concepts .
Q4. Which key uniquely identifies a record in a table?
• A) Foreign key
• B) Primary key
• C) Composite key
• D) Alternate key
Correct Answer: B
Rationale: A primary key uniquely identifies each row in a table. It must contain
unique values and cannot contain NULL values .
Q5. What is normalization used for in database design?
, • A) Encrypting data
• B) Reducing data redundancy and improving data integrity
• C) Increasing storage size
• D) Creating backups
Correct Answer: B
Rationale: Normalization is the process of organizing data to minimize
redundancy and improve data integrity by eliminating data anomalies .
Q6. In the context of ACID properties, which property ensures that a
transaction is treated as a single, indivisible unit?
• A) Consistency
• B) Isolation
• C) Durability
• D) Atomicity
Correct Answer: D
Rationale: Atomicity guarantees that each transaction is "all or nothing" – if any
part fails, the entire transaction fails and the database state remains unchanged.
Consistency ensures valid state transitions, isolation handles concurrency, and
durability guarantees persistence after commit .
Q7. What is the purpose of a foreign key in relational databases?
• A) Encrypt data
• B) Link two tables together by referencing a primary key in another table
• C) Delete records automatically
• D) Store backups
Correct Answer: B
, Rationale: Foreign keys establish relationships between tables by referencing the
primary key of another table, enforcing referential integrity .
Q8. Which of the following best describes a database?
• A) A collection of random files
• B) An organized collection of structured data
• C) A software program for editing text
• D) A network protocol
Correct Answer: B
Rationale: A database is an organized collection of structured data stored
electronically, designed for efficient storage and retrieval .
Q9. What does a transaction ensure in database systems?
• A) Faster queries
• B) Data integrity through ACID properties
• C) Compressed storage
• D) Network routing
Correct Answer: B
Rationale: Transactions ensure ACID properties (Atomicity, Consistency,
Isolation, Durability), which guarantee data integrity even in the event of errors or
system failures .
Q10. What is a schema in a database?
• A) A backup file
• B) The database structure definition including tables, views, indexes, and
relationships
• C) A query result
• D) A report format
