WGU C175 Data Management Chapter one on
fundamentals on Databases Information
Questions and certified answers 2024/2025
Performance Tuning - correct answer Activities that make a database perform more
efficiently in terms of storage and access speed
Physical Data Format - correct answer the way a computer "sees" stores data
Query - correct answer A question or task asked by an end user of a database in the
form of SQL code. A specific request for data manipulation issued by the end user or the
application to the DBMS
Query Language - correct answer A non-procedural language that is used by a DBMS
to manipulate its data. An example of a query language is SQL
Query Result Set - correct answer the collection of data rows returned by a query
Record - correct answer A collection of related (logically connected) fields
Role - correct answer In Oracle, a named collection of database access privileges that
authorize a user to connect to a database and use it system resources
Router - correct answer An intelligent device used to connect dissimilar networks.
Hardware/software equipment that connects multiple and diverse networks
Semistructured Data - correct answer Data that has already been processed to some
extent
Single-user Database - correct answer A database that supports only one user at a
time
, Social Media - correct answer Web and mobile technologies that enable "anywhere,
anytime, always on" human interactions
Structural Dependence - correct answer A data characteristic in which a change in the
database schema affects data access, thus requiring changes in all access programs
Structural Independence - correct answer A data characteristic in which changes in the
database schema do not affect data access
Structured Data - correct answer Data that has been formatted to facilitate storage,
use, and information generation
Structured Query Language (SQL) - correct answer A powerful and flexible relational
database language composed of commands that enable users to create database and
table structures, perform various types of data manipulation and data administration,
and query the database to extract useful information
Unstructured Data - correct answer Data that exists in its original, raw state; that is, in
the format in which it was collected
Website - correct answer Refers to the web server and the collection of web pages
stored on the local hard disk of the server computer
Workgroup Database - correct answer A multiuser database that usually supports
fewer than 50 users or is used for a specific department in an organization
atomic attribute - correct answer An attribute that cannot be further subdivided to
produce meaningful components. For example, a person's last name attribute cannot be
meaningfully subdivided.
atomicity - correct answer The transaction property that requires all parts of a
transaction to be treated as a single, indivisible, logical unit of work. All parts of a
transaction must be completed or the entire transaction is aborted.
fundamentals on Databases Information
Questions and certified answers 2024/2025
Performance Tuning - correct answer Activities that make a database perform more
efficiently in terms of storage and access speed
Physical Data Format - correct answer the way a computer "sees" stores data
Query - correct answer A question or task asked by an end user of a database in the
form of SQL code. A specific request for data manipulation issued by the end user or the
application to the DBMS
Query Language - correct answer A non-procedural language that is used by a DBMS
to manipulate its data. An example of a query language is SQL
Query Result Set - correct answer the collection of data rows returned by a query
Record - correct answer A collection of related (logically connected) fields
Role - correct answer In Oracle, a named collection of database access privileges that
authorize a user to connect to a database and use it system resources
Router - correct answer An intelligent device used to connect dissimilar networks.
Hardware/software equipment that connects multiple and diverse networks
Semistructured Data - correct answer Data that has already been processed to some
extent
Single-user Database - correct answer A database that supports only one user at a
time
, Social Media - correct answer Web and mobile technologies that enable "anywhere,
anytime, always on" human interactions
Structural Dependence - correct answer A data characteristic in which a change in the
database schema affects data access, thus requiring changes in all access programs
Structural Independence - correct answer A data characteristic in which changes in the
database schema do not affect data access
Structured Data - correct answer Data that has been formatted to facilitate storage,
use, and information generation
Structured Query Language (SQL) - correct answer A powerful and flexible relational
database language composed of commands that enable users to create database and
table structures, perform various types of data manipulation and data administration,
and query the database to extract useful information
Unstructured Data - correct answer Data that exists in its original, raw state; that is, in
the format in which it was collected
Website - correct answer Refers to the web server and the collection of web pages
stored on the local hard disk of the server computer
Workgroup Database - correct answer A multiuser database that usually supports
fewer than 50 users or is used for a specific department in an organization
atomic attribute - correct answer An attribute that cannot be further subdivided to
produce meaningful components. For example, a person's last name attribute cannot be
meaningfully subdivided.
atomicity - correct answer The transaction property that requires all parts of a
transaction to be treated as a single, indivisible, logical unit of work. All parts of a
transaction must be completed or the entire transaction is aborted.
