WGU C170 Problem set Exam Questions with
all answers Correctly provided Latest
2024/2025
logical view - correct answer Is a mapping onto a physical table or tables that allows
an end user to access only a specified portion of data.
Response time - correct answer Is the delay from the time that the Enter Key is
pressed to execute a query until the result appears on screen.
Throughput - correct answer Is the measure of how many queries from simultaneous
users must be satisfied in a given period of time by the application set and the database
that it supports.
Client/server architecture - correct answer Client/server architecture is a network
architecture in which the server manages services consumed by the client. It is also
known as two-tier architecture.
Database directory - correct answer Database directory is an organized repository of
databases that stores attributes such as the database character set and collation.
GUI (graphical user interface) - correct answer GUI is a computer program that
enables a user to communicate with a computer through the use of graphical icons.
MySQL - correct answer MySQL is an open source RDBMS based on SQL (structure
query language) and used for adding, removing, and modifying information in the
database.
Option file - correct answer Option file is an appropriate way of specifying commonly
used options on the command line while executing a program.
, RDBMS (relational database management system) - correct answer RDBMS is a
program that lets you create, update, and administer a relational database.
Schema - correct answer In a relational database, a schema defines tables, fields in
each table, and relationships between fields and tables.
DB2 - correct answer DB2 is a relational database management system product from
IBM that serves a number of operating system platforms.
DCL - correct answer Data control language is used to control access to data stored in
a database.
DDL - correct answer Data definition language - involves instructing the DBMS
software on what tables will be in the database, what attributes will be in the tables,
which attributes will be indexed, and so forth.
DML - correct answer Data manipulation language refers to the four basic operations
that can and must be performed on data stored in any DBMS: data retrieval, data
update, insertion of new records, and deletion of existing records.
EER (enhanced entity-relationship) diagram - correct answer EER diagram is a
conceptual data model incorporating extensions to the original entity-relationship model
used in the design of databases.
SQL - correct answer Is a comprehensive database management language which
incorporates DML and DDL
BLOB (binary large objects) - correct answer BLOB is a collection of binary data stored
as a single entity in a database management system. It holds up to 65,535 bytes of
data.
ENUM - correct answer ENUM is a special data type that enables for a variable to be a
set of predefined constants.
all answers Correctly provided Latest
2024/2025
logical view - correct answer Is a mapping onto a physical table or tables that allows
an end user to access only a specified portion of data.
Response time - correct answer Is the delay from the time that the Enter Key is
pressed to execute a query until the result appears on screen.
Throughput - correct answer Is the measure of how many queries from simultaneous
users must be satisfied in a given period of time by the application set and the database
that it supports.
Client/server architecture - correct answer Client/server architecture is a network
architecture in which the server manages services consumed by the client. It is also
known as two-tier architecture.
Database directory - correct answer Database directory is an organized repository of
databases that stores attributes such as the database character set and collation.
GUI (graphical user interface) - correct answer GUI is a computer program that
enables a user to communicate with a computer through the use of graphical icons.
MySQL - correct answer MySQL is an open source RDBMS based on SQL (structure
query language) and used for adding, removing, and modifying information in the
database.
Option file - correct answer Option file is an appropriate way of specifying commonly
used options on the command line while executing a program.
, RDBMS (relational database management system) - correct answer RDBMS is a
program that lets you create, update, and administer a relational database.
Schema - correct answer In a relational database, a schema defines tables, fields in
each table, and relationships between fields and tables.
DB2 - correct answer DB2 is a relational database management system product from
IBM that serves a number of operating system platforms.
DCL - correct answer Data control language is used to control access to data stored in
a database.
DDL - correct answer Data definition language - involves instructing the DBMS
software on what tables will be in the database, what attributes will be in the tables,
which attributes will be indexed, and so forth.
DML - correct answer Data manipulation language refers to the four basic operations
that can and must be performed on data stored in any DBMS: data retrieval, data
update, insertion of new records, and deletion of existing records.
EER (enhanced entity-relationship) diagram - correct answer EER diagram is a
conceptual data model incorporating extensions to the original entity-relationship model
used in the design of databases.
SQL - correct answer Is a comprehensive database management language which
incorporates DML and DDL
BLOB (binary large objects) - correct answer BLOB is a collection of binary data stored
as a single entity in a database management system. It holds up to 65,535 bytes of
data.
ENUM - correct answer ENUM is a special data type that enables for a variable to be a
set of predefined constants.
