NYC Certified IT Administrator (Database) Exam Practice Questions And Correct Verified Answers Plus Rationales 2026 (GUARANTEED PASS)

NYC Certified IT Administrator (Database) Exam Practice Questions And Correct Verified Answers Plus Rationales 2026 (GUARANTEED PASS) Question 1 Which SQL command is used to remove all records from a tabl e but keep the table structure? A) DELETE B) TRUNCATE C) DROP D) REMOVE VERIFIED ANSWER: B) TRUNCATE Rationale: TRUNCATE removes all rows from a table without affecting its structure, unlike DROP which deletes the table entirely, and DELETE which can be slower and uses more transaction log space. Question 2 What is the default port for MySQL database server? A) 1521 B) 1433 C) 3306 D) 5432 VERIFIED …