WGU C175 Proficiency knowledge test Exam
Questions and certified Answers 2024/2025
Record - correct answer a collection of related data items
Record type - correct answer structural definition of every record in file
Record occurrence - correct answer specific record of file
Re-engineering - correct answer data and information systems are aggressively used
to redesign business processes for maximum efficiency
Referential integrity - correct answer every value of a foreign key must match a value
of an existing primary key
Relation table - correct answer 2D table that has specific characteristics.
-rows must contain instances of an entity.
-Columns is an attribute
-Cells hold a single value
-all values in a column use same data type
-each column has a unique name
-order of row or column is unimportant
-no two rows can be the same
Relations - correct answer are tables not all tables are relations
Relational algebra - correct answer It is a formal system for manipulating relations.
Retrieve or Read - correct answer It refers to the data without changing it.
,Sequential access - correct answer It means the retrieval of all or a portion of the
records of a file one after another, in some sequence, starting from the beginning, until
all the required records have been retrieved
Simple linear file - correct answer It is a collection of records listed one after the other
on a long line
Surrogate key - correct answer used when no primary key can be identified no value
when numbers are used ie employee id #
Transitive Dependencies - correct answer non-key attribute is functionally dependent
on another.
Tuple - correct answer Rows
Unique key - correct answer data value is unique for each row ie: employee ID
Vertical add - correct answer add all necessary records underneath the related row
4 Major DBMS approaches - correct answer 1-Hierarchial
2-Network
3-Relational (preferred)
4- Object oriented
* (SQL) in the SELECT clause - correct answer It indicates that all attributes of the
selected row are to be retrieved
AND (SQL) operator - correct answer It displays a record if more than one condition is
true.
, AVG ( ) (SQL) function - correct answer It returns the average value of a numeric
column.
BETWEEN (SQL) operator - correct answer It allows you to specify a range of numeric
values in a search
Data definition - correct answer It is operationalized with a data definition language
(DDL), 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.
DDL data definition langauge - correct answer 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.
Data management - correct answer There are two aspects: data definition and data
manipulation
DML data management language - correct answer users communicate data
manipulation command to the DBMS; select, insert, update, delete, merge etc.
DISTINCT (SQL) operator - correct answer It is used to eliminate duplicate rows in a
query result.
Embedded mode - correct answer Inserts higher level language program then
executes as program in DB
IN (SQL) operator - correct answer It allows you to specify a list of character strings to
be included in a search.
JOIN (SQL) clause - correct answer It is used to combine rows from more than one
table, based on a common field between them.
Questions and certified Answers 2024/2025
Record - correct answer a collection of related data items
Record type - correct answer structural definition of every record in file
Record occurrence - correct answer specific record of file
Re-engineering - correct answer data and information systems are aggressively used
to redesign business processes for maximum efficiency
Referential integrity - correct answer every value of a foreign key must match a value
of an existing primary key
Relation table - correct answer 2D table that has specific characteristics.
-rows must contain instances of an entity.
-Columns is an attribute
-Cells hold a single value
-all values in a column use same data type
-each column has a unique name
-order of row or column is unimportant
-no two rows can be the same
Relations - correct answer are tables not all tables are relations
Relational algebra - correct answer It is a formal system for manipulating relations.
Retrieve or Read - correct answer It refers to the data without changing it.
,Sequential access - correct answer It means the retrieval of all or a portion of the
records of a file one after another, in some sequence, starting from the beginning, until
all the required records have been retrieved
Simple linear file - correct answer It is a collection of records listed one after the other
on a long line
Surrogate key - correct answer used when no primary key can be identified no value
when numbers are used ie employee id #
Transitive Dependencies - correct answer non-key attribute is functionally dependent
on another.
Tuple - correct answer Rows
Unique key - correct answer data value is unique for each row ie: employee ID
Vertical add - correct answer add all necessary records underneath the related row
4 Major DBMS approaches - correct answer 1-Hierarchial
2-Network
3-Relational (preferred)
4- Object oriented
* (SQL) in the SELECT clause - correct answer It indicates that all attributes of the
selected row are to be retrieved
AND (SQL) operator - correct answer It displays a record if more than one condition is
true.
, AVG ( ) (SQL) function - correct answer It returns the average value of a numeric
column.
BETWEEN (SQL) operator - correct answer It allows you to specify a range of numeric
values in a search
Data definition - correct answer It is operationalized with a data definition language
(DDL), 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.
DDL data definition langauge - correct answer 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.
Data management - correct answer There are two aspects: data definition and data
manipulation
DML data management language - correct answer users communicate data
manipulation command to the DBMS; select, insert, update, delete, merge etc.
DISTINCT (SQL) operator - correct answer It is used to eliminate duplicate rows in a
query result.
Embedded mode - correct answer Inserts higher level language program then
executes as program in DB
IN (SQL) operator - correct answer It allows you to specify a list of character strings to
be included in a search.
JOIN (SQL) clause - correct answer It is used to combine rows from more than one
table, based on a common field between them.
