REVATURE EXAM SCRIPT 2026 COMPLETE QUESTIONS AND ANSWERS

REVATURE EXAM SCRIPT 2026 COMPLETE
QUESTIONS AND ANSWERS



◉ DDL. Answer: Data Definition Language
- Used to define the schema of the database
-- CREATE: creates and defines the table
-- ALTER: modifies an existing table
-- TRUNCATE: Removes all data from the table, leaves the schema,
cannot rollback, ignores constraints
-- DROP: Drops the table, cannot rollback


◉ DML. Answer: Data Manipulation Language
- SELECT: Reads rows
- INSERT: Adds a new row
- UPDATE: Updates an existing row
- DELETE: Removes an existing row


◉ DCL. Answer: Data Control Language
- Used to manage access to the database
-- GRANT: Can give user limited/all permissions

, -- REVOKE: Can remove permissions


◉ TCL. Answer: Transaction Control Language
- COMMIT: Must be done to make the data persist/become a transaction
-- Persists to the hard drive, done in memory (works like signing a
commitment)
- ROLLBACK: undo UNCOMMITTED changes
- SAVEPOINT: enables rolling back to a different savepoint


◉ Truncate vs Delete. Answer: TRUNCATE cannot be rolled back and
ignores constraints since it is a DDL


◉ DATE vs TIMESTAMP. Answer: DATE and TIMESTAMP both
record the time of the transaction, but TIMESTAMP includes
milliseconds and nanoseconds


◉ Types of Integrity. Answer: Domain Integrity: All values in a column
must be the same type


Entity Integrity: Each row is identifiable by a Primary Key


Referential Integrity: When a table includes a Foreign Key referencing
another table, the FK must point to a valid value