1
Data Management - Foundations - D426 Questions with
Answers (100% Correct Answers
A database application Answer: Software that helps business users
interact with database systems
Database administrator Answer: Person responsible for securing the
database system and enforcing user access and system availability
procedures
Authorization Answer: The process of limiting user access to specific
tables, columns, or rows in a database
Rules in databases Answer: Mechanisms that ensure data is consistent
with structural and business logic
Query processor Answer: Interprets queries, plans modifications or
data retrieval, and returns results efficiently using optimization
Storage manager Answer: Translates queries into file-system
commands and uses indexes to access large databases efficiently
Transaction manager Answer: Ensures transactions execute properly
and restores consistency after failures or conflicts
© 2025 All rights reserved
,2
INSERT Answer: SQL command to add rows to a table
SELECT Answer: SQL command to retrieve data from a table
UPDATE Answer: SQL command to modify existing table data
DELETE Answer: SQL command to remove rows from a table
CREATE TABLE Answer: SQL command that defines a new table's
structure, including column names and data types
INT Answer: A data type that stores integer values
DECIMAL Answer: A data type that stores fractional numeric values
VARCHAR Answer: A data type that stores text values
DATE Answer: A data type that stores year, month, and day values
Analysis phase Answer: Specifies database requirements using
entities, relationships, and attributes, independent of database systems
Logical design Answer: Converts entities and attributes into tables,
columns, and keys for a specific DBMS
Physical design Answer: Adds indexes and defines storage layout,
optimizing query performance without changing query results
© 2025 All rights reserved
, 3
Data independence Answer: Principle that physical design changes do
not affect query results
API (Application Programming Interface) Answer: Interface that
simplifies SQL use in general-purpose programming languages
MySQL Command-Line Client Answer: A text interface included with
MySQL Server for executing SQL commands and returning results or
errors
Tuple Answer: An ordered collection of values (e.g., (a, b, c)) used to
represent rows
Table Answer: A database structure with a name, fixed set of columns,
and variable set of rows
Column Answer: A table element with a name and a data type
Row Answer: An unnamed tuple of values in a table corresponding to
columns
Data type Answer: A named set of values from which column values
are drawn
Synonyms for table Answer: Table = File = Relation
© 2025 All rights reserved
Data Management - Foundations - D426 Questions with
Answers (100% Correct Answers
A database application Answer: Software that helps business users
interact with database systems
Database administrator Answer: Person responsible for securing the
database system and enforcing user access and system availability
procedures
Authorization Answer: The process of limiting user access to specific
tables, columns, or rows in a database
Rules in databases Answer: Mechanisms that ensure data is consistent
with structural and business logic
Query processor Answer: Interprets queries, plans modifications or
data retrieval, and returns results efficiently using optimization
Storage manager Answer: Translates queries into file-system
commands and uses indexes to access large databases efficiently
Transaction manager Answer: Ensures transactions execute properly
and restores consistency after failures or conflicts
© 2025 All rights reserved
,2
INSERT Answer: SQL command to add rows to a table
SELECT Answer: SQL command to retrieve data from a table
UPDATE Answer: SQL command to modify existing table data
DELETE Answer: SQL command to remove rows from a table
CREATE TABLE Answer: SQL command that defines a new table's
structure, including column names and data types
INT Answer: A data type that stores integer values
DECIMAL Answer: A data type that stores fractional numeric values
VARCHAR Answer: A data type that stores text values
DATE Answer: A data type that stores year, month, and day values
Analysis phase Answer: Specifies database requirements using
entities, relationships, and attributes, independent of database systems
Logical design Answer: Converts entities and attributes into tables,
columns, and keys for a specific DBMS
Physical design Answer: Adds indexes and defines storage layout,
optimizing query performance without changing query results
© 2025 All rights reserved
, 3
Data independence Answer: Principle that physical design changes do
not affect query results
API (Application Programming Interface) Answer: Interface that
simplifies SQL use in general-purpose programming languages
MySQL Command-Line Client Answer: A text interface included with
MySQL Server for executing SQL commands and returning results or
errors
Tuple Answer: An ordered collection of values (e.g., (a, b, c)) used to
represent rows
Table Answer: A database structure with a name, fixed set of columns,
and variable set of rows
Column Answer: A table element with a name and a data type
Row Answer: An unnamed tuple of values in a table corresponding to
columns
Data type Answer: A named set of values from which column values
are drawn
Synonyms for table Answer: Table = File = Relation
© 2025 All rights reserved
