NYC Certified IT Administrator (Database) Exam |
230 Practice Questions & Answers with
Rationales | Latest Study Guide | Instant Pdf
Download Just Released
10 Most Tested Topics
1. Database Fundamentals & Architecture — DBMS concepts, relational databases,
schemas, keys, constraints, and ACID properties.
2. SQL & T-SQL — SELECT, INSERT, UPDATE, DELETE, DDL/DML/DCL, joins,
filtering, grouping, functions, and stored procedures.
3. Database Design & Normalization — data modeling, relationships, primary/foreign
keys, normalization, and database schemas.
4. Indexing & Performance Tuning — indexes, query optimization, execution
performance, and troubleshooting CPU, memory, I/O, and disk issues.
5. Database Administration — installation, configuration, patching, maintenance,
monitoring, and database management.
6. Backup & Recovery — backup types, restoration strategies, transaction logs, disaster
recovery, and recovery objectives.
7. Database Security — authentication, authorization, roles, permissions, security
delegation, encryption, and data privacy.
8. Transactions & Concurrency — transaction management, isolation, locking,
concurrency control, and data consistency.
9. High Availability, Replication & HADR — SQL Server HADR solutions, replication,
availability, and disaster-recovery concepts.
10. SSIS, SSRS & ETL — data integration, Extract-Transform-Load processes, reporting
services, and data warehouse concepts
Q1. Which SQL statement is used to retrieve data from a database?
A. UPDATE
B. SELECT
,C. ALTER
D. DELETE
Answer: B. SELECT
Rationale: SELECT retrieves rows and columns from one or more database tables.
Q2. Which database object primarily stores related records in rows and columns?
A. Table
B. Trigger
C. View
D. Procedure
Answer: A. Table
Rationale: A relational table organizes data into rows and columns.
Q3. What is the primary purpose of a primary key?
A. Encrypt data
B. Identify each row uniquely
C. Sort every column
D. Create backups
Answer: B. Identify each row uniquely
Rationale: A primary key provides a unique identifier for each table row.
,Q4. Which constraint prevents duplicate values in a column?
A. CHECK
B. DEFAULT
C. UNIQUE
D. FOREIGN KEY
Answer: C. UNIQUE
Rationale: UNIQUE prevents duplicate values within the constrained column or column
combination.
Q5. Which SQL command adds new rows to a table?
A. INSERT
B. CREATE
C. MERGE
D. ALTER
Answer: A. INSERT
Rationale: INSERT adds new records to an existing table.
Q6. Which command modifies existing records?
A. UPDATE
B. CREATE
, C. GRANT
D. DROP
Answer: A. UPDATE
Rationale: UPDATE changes values in rows that satisfy a specified condition.
Q7. Which SQL command removes selected rows?
A. DROP
B. DELETE
C. REMOVE
D. CLEAR
Answer: B. DELETE
Rationale: DELETE removes rows while leaving the table structure intact.
Q8. Which clause filters rows in a SELECT query?
A. ORDER BY
B. GROUP BY
C. WHERE
D. FROM
Answer: C. WHERE
Rationale: WHERE limits returned or affected rows based on a condition.
230 Practice Questions & Answers with
Rationales | Latest Study Guide | Instant Pdf
Download Just Released
10 Most Tested Topics
1. Database Fundamentals & Architecture — DBMS concepts, relational databases,
schemas, keys, constraints, and ACID properties.
2. SQL & T-SQL — SELECT, INSERT, UPDATE, DELETE, DDL/DML/DCL, joins,
filtering, grouping, functions, and stored procedures.
3. Database Design & Normalization — data modeling, relationships, primary/foreign
keys, normalization, and database schemas.
4. Indexing & Performance Tuning — indexes, query optimization, execution
performance, and troubleshooting CPU, memory, I/O, and disk issues.
5. Database Administration — installation, configuration, patching, maintenance,
monitoring, and database management.
6. Backup & Recovery — backup types, restoration strategies, transaction logs, disaster
recovery, and recovery objectives.
7. Database Security — authentication, authorization, roles, permissions, security
delegation, encryption, and data privacy.
8. Transactions & Concurrency — transaction management, isolation, locking,
concurrency control, and data consistency.
9. High Availability, Replication & HADR — SQL Server HADR solutions, replication,
availability, and disaster-recovery concepts.
10. SSIS, SSRS & ETL — data integration, Extract-Transform-Load processes, reporting
services, and data warehouse concepts
Q1. Which SQL statement is used to retrieve data from a database?
A. UPDATE
B. SELECT
,C. ALTER
D. DELETE
Answer: B. SELECT
Rationale: SELECT retrieves rows and columns from one or more database tables.
Q2. Which database object primarily stores related records in rows and columns?
A. Table
B. Trigger
C. View
D. Procedure
Answer: A. Table
Rationale: A relational table organizes data into rows and columns.
Q3. What is the primary purpose of a primary key?
A. Encrypt data
B. Identify each row uniquely
C. Sort every column
D. Create backups
Answer: B. Identify each row uniquely
Rationale: A primary key provides a unique identifier for each table row.
,Q4. Which constraint prevents duplicate values in a column?
A. CHECK
B. DEFAULT
C. UNIQUE
D. FOREIGN KEY
Answer: C. UNIQUE
Rationale: UNIQUE prevents duplicate values within the constrained column or column
combination.
Q5. Which SQL command adds new rows to a table?
A. INSERT
B. CREATE
C. MERGE
D. ALTER
Answer: A. INSERT
Rationale: INSERT adds new records to an existing table.
Q6. Which command modifies existing records?
A. UPDATE
B. CREATE
, C. GRANT
D. DROP
Answer: A. UPDATE
Rationale: UPDATE changes values in rows that satisfy a specified condition.
Q7. Which SQL command removes selected rows?
A. DROP
B. DELETE
C. REMOVE
D. CLEAR
Answer: B. DELETE
Rationale: DELETE removes rows while leaving the table structure intact.
Q8. Which clause filters rows in a SELECT query?
A. ORDER BY
B. GROUP BY
C. WHERE
D. FROM
Answer: C. WHERE
Rationale: WHERE limits returned or affected rows based on a condition.
