DATA MANAGEMENT FOUNDATIONS CORE DATABASE SKILLS BLUEPRINT UPDATED ACTUAL

DATA MANAGEMENT FOUNDATIONS CORE DATABASE SKILLS BLUEPRINT UPDATED
ACTUAL EXAM QUESTIONS CORRECT ANSWERS GRADED A PLUS




Question:
Database administrator (DBA).

Answer:
Secures the DB, manages access, and enforces availability procedures.



Question:
Authorization.

Answer:
Limits user access to specific tables, columns, or rows.



Question:
Business rules.

Answer:
Rules that keep data consistent with structural and policy constraints.



Question:
Query processor.

Answer:
Parses queries, optimizes plans, and returns results.



Question:
Storage manager.

,Answer:
Executes low-level file operations and uses indexes to locate data.



Question:
Transaction manager.

Answer:
Ensures ACID execution and recovery from failures.



Question:
CRUD: INSERT.

Answer:
Adds new rows to a table.



Question:
CRUD: SELECT.

Answer:
Retrieves data from a table.



Question:
CRUD: UPDATE.

Answer:
Modifies existing rows in a table.



Question:
CRUD: DELETE.

Answer:

,Removes rows from a table.



Question:
CREATE TABLE.

Answer:
Defines a new table with columns and data types.



Question:
DROP TABLE.

Answer:
Deletes a table and all its rows.



Question:
ALTER TABLE.

Answer:
Adds, drops, or modifies columns or constraints of a table.



Question:
INT.

Answer:
Data type for integers.



Question:
DECIMAL(M,D).

Answer:
Data type for fixed-precision numbers.

, Question:
VARCHAR(N).

Answer:
Data type for variable-length text up to N chars.



Question:
DATE.

Answer:
Data type for year, month, day.



Question:
Tuple.

Answer:
Ordered list of values; order matters.



Question:
Table.

Answer:
Set of rows with a fixed tuple of columns; rows have no inherent order.



Question:
Row (record, tuple).

Answer:
Unordered tuple of values matching the table's columns.