- | P a g e
WGU D426 OBJECTIVE ASSESSMENT FINAL
EXAM NEWEST ACTUAL EXAM COMPLETE 260
QUESTIONS AND CORRECT ANSWERS
(VERIFIED ANSWERS) |ALREADY GRADED A+
- What is a software that reads and writes data in a database?
- THE CORRECT ANSWER is: Database management
system or DBMS
- What is a computer programming language for writing
database queries?
- THE CORRECT ANSWER is: Query language
- What is a command for a database that typically inserts new
data, retrieves data, updates data, or deletes data from a database?
- THE CORRECT ANSWER is: Query
- What is a group of queries that must be either completed or
rejected as a whole?
- THE CORRECT ANSWER is: A transaction
- | P a g e
- What interprets queries, creates a plan to modify the database
or retrieve data, and returns query results to the application?
- THE CORRECT ANSWER is: A query processor
- What translates the query processor instructions into low-
level file-system commands that modify or retrieve data?
- THE CORRECT ANSWER is: Store Manager
- What ensures transactions are properly executed?
- THE CORRECT ANSWER is: Transaction Manager
- What is a file containing a complete record of all inserts,
updates, and deletes processed by the database?
- THE CORRECT ANSWER is: The log
- What is a directory of tables, columns, indexes, and other
database objects?
- THE CORRECT ANSWER is: Catalog
- What is a column, used to identify individual rows of a
table?
- THE CORRECT ANSWER is: A key
- | P a g e
- Which phase implements database requirements in a specific
database system?
- THE CORRECT ANSWER is: Database Logical design
phase
- Which phase specifies database objects such as tables,
columns, data types, and indexes?
- THE CORRECT ANSWER is: Database design phase
- Which phase specifies database requirements without regard
to a specific database system?
- THE CORRECT ANSWER is: Database analysis phase
- Which phase adds indexes and specifies how tables are
organized on storage media?
- THE CORRECT ANSWER is: Database physical design
phase
- What is the name of a leading relational database system that
sponsored by Oracle?
- THE CORRECT ANSWER is: MySQL
- | P a g e
- What is a conceptual framework for database systems, with
three parts?
- THE CORRECT ANSWER is: Database model
- In a database model, what prescribes how data is organized?
- THE CORRECT ANSWER is: Data structures
- In a database mode, what manipulates data structures?
- THE CORRECT ANSWER is: Operations
- In a database mode, what governs valid data?
- THE CORRECT ANSWER is: Rules
- What command selects a subset of rows of a table?
- THE CORRECT ANSWER is: Select
- What command eliminates one or more columns of a table?
- THE CORRECT ANSWER is: Project
- What command lists all combination of rows of two tables?