D426 EXAM SCRIPT 2026 QUESTIONS WITH
ANSWERS GRADED A+
◉ analog data. Answer: Historically most common before computers,
encoded as continuous variations on various physical media.
◉ digital data. Answer: most common today, recorded as 0's and 1's on
electronic and magnetic media.
◉ database designer. Answer: determines the format of each data
element and the overall database structure
◉ database user. Answer: a consumer of data in a database. can either
use an application or submit queries directly to the database. they use,
request and update data. to generate reports
◉ transaction. Answer: a group of queries that must be completed or
rejected as whole. will result in incomplete or incorrect data if not
terminated as a whole.
◉ Query processor. Answer: interprets queries, creates a plan to modify
the database or retrieve data, and returns query results to the application.
,◉ Query optimization. Answer: to ensure the most efficient instructions
are executed on the data from the processor.
◉ Storage Manager. Answer: translates the query processor instructions
into low-level file-system commands that modify or retrieve data.
◉ indexes. Answer: used by the storage manager to quickly locate data
◉ catalog. Answer: also called a data dictionary , a directory of tables,
columns and indexes as well as other database objects.
◉ relational database. Answer: a database that stores data in tables that
consist of rows and columns, similar to a spreadsheet
◉ SQL. Answer: Structured Query Language
◉ NoSQL. Answer: A new generation of database management systems
that is not based on the traditional relational database model.
◉ query. Answer: command for a database that typically inserts,
retrieves, updates and deletes data from the database.
, ◉ crud. Answer: Create, Read, Update, Delete
◉ statement. Answer: a database command such as a query that inserts ,
selects updates and deletes data
◉ SELECT. Answer: Retrieves data from a table
◉ UPDATE. Answer: modifies data in a table
◉ data type. Answer: indicates the type of data that can be stored in a
field of a column
◉ data independence. Answer: A condition in which data access is
unaffected by changes in the physical data storage characteristics.
◉ database model. Answer: Describes the relationship between the data
elements and provides a framework for organizing the data. contains 3
parts
data structures
operations
rules