WGU C170 DATA MANAGEMENT
APPLICATIONS GSA1 CERTIFICATION SCRIPT
◍ The M:N Relationship.
Answer: This relationship cannot be implemented as such in the relational
model however, it can be implemented by creating a new entity in 1:M
relationships with the original entities.
◍ CREATE VIEW.
Answer: A SQL command that creates a logical, "virtual" table. The view
can be treated as a real table.
◍ Manual query optimization.
Answer: An operation mode that requires the end user or programmer to
define the access path for the execution of a query.
◍ Replacing a subquery with an equivalent join is called what?.
Answer: Flattening
◍ International Organization for Standardization (ISO).
Answer: An organization formed to develop standards for diverse network
systems.
◍ Create a table with complex constraints on string columns.
Answer: CREATE TABLE TableName (ColumnName1
DataType,ColumnName2 DataType,CHECK (ColumnName1
Constraint),CHECK (ColumnName2 Constraint));
◍ inner join.
Answer: A join operation in which only rows that meet a given criterion are
, selected. The join criterion can be an equality condition (natural join or
equijoin) or an inequality condition (theta join). The inner join is the most
commonly used type of join. Contrast with outer join.
◍ updatable view.
Answer: A view that can update attributes in base tables that are used in the
view.
◍ regular entity.
Answer: See strong entity.
◍ authentication.
Answer: The process through which a DBMS verifies that only registered
users can access the database.
◍ middleware.
Answer: The computer software that allows clients and servers to
communicate within the client/server architecture. It is used to insulate
client processes from the network protocols and the details of the server
process protocols.
◍ input/output (I/O) request.
Answer: A low-level data access operation that reads or writes data to and
from computer devices.
◍ PRODUCT.
Answer: An operator used to yield all possible pairs of rows from two
tables.customer × agent
◍ static query optimization.
Answer: A query optimization mode in which the access path to a database
is predetermined at compilation time.
◍ manual query optimization.
Answer: An operation mode that requires the end user or programmer to
define the access path for the execution of a query.
◍ bitmap index.
, Answer: An index that uses a bit array (0s and 1s) to represent the existence
of a value or condition
◍ mandatory participation.
Answer: A relationship in which one entity occurrence must have a
corresponding occurrence in another entity. For example, an EMPLOYEE
works in a DIVISION. (A person cannot be an employee without being
assigned to a company's division.)
◍ index key.
Answer: See index.
◍ Correlated subquery.
Answer: A subquery that executes once for each row in the outer query. A
feature is that the outer subquery initiates the process of execution in a
subquery.
◍ GROUP BY.
Answer: A SQL clause used to create frequency distributions when
combined with any of the aggregate functions in a SELECT statement.
◍ superkey.
Answer: An attribute or attributes that uniquely identify each entity in a
table. See key.
◍ updatable view.
Answer: A view that can update attributes in base tables that are used in the
view.
◍ predicate logic.
Answer: Used extensively in mathematics to provide a framework in which
an assertion (statement of fact) can be verified as either true or false.
◍ inner join.
Answer: A join operation in which only rows that meet a given criterion are
selected. The join criterion can be an equality condition (natural join or
equijoin) or an inequality condition (theta join). The inner join is the most
, commonly used type of join. Contrast with outer join.
◍ weak relationship.
Answer: A relationship in which the primary key of the related entity does
not contain a primary key component of the parent entity.
◍ subquery.
Answer: A query that is embedded (or nested) inside another query. Also
known as a nested query or an inner query.
◍ COMMIT.
Answer: The SQL command that permanently writes data changes to a
database.
◍ "A salesperson manages zero to many other salespersons, and a salesperson
is managed by exactly one other salesperson."What is the name of this
model?.
Answer: One-to-many unary relationship
◍ composite key.
Answer: A multiple-attribute key.
◍ 22. Which query illustrates performing an outer join of the Movie table with
a different table?- SELECT M.Title, A.Name FROM Movie M, Actor
AWHERE M.ActorID = A.ActorID;- SELECT M.Title, A.Name FROM
Movie M, Actor AWHERE M.ActorID = A.MovieID;- SELECT M.Title,
A.Name FROM Movie M RIGHT JOIN Actor AON M.ActorID =
A.ActorID;- SELECT M.Title, A.Actor FROM Movie MINNER JOIN
Actor A ON M.ActorID = A.ActorID.
Answer: SELECT M.Title, A.Name FROM Movie MRIGHT JOIN Actor A
ON M.ActorID = A.ActorID;
◍ FROM.
Answer: A SQL clause that specifies the table or tables from which data is
to be retrieved.
◍ simple attribute.
APPLICATIONS GSA1 CERTIFICATION SCRIPT
◍ The M:N Relationship.
Answer: This relationship cannot be implemented as such in the relational
model however, it can be implemented by creating a new entity in 1:M
relationships with the original entities.
◍ CREATE VIEW.
Answer: A SQL command that creates a logical, "virtual" table. The view
can be treated as a real table.
◍ Manual query optimization.
Answer: An operation mode that requires the end user or programmer to
define the access path for the execution of a query.
◍ Replacing a subquery with an equivalent join is called what?.
Answer: Flattening
◍ International Organization for Standardization (ISO).
Answer: An organization formed to develop standards for diverse network
systems.
◍ Create a table with complex constraints on string columns.
Answer: CREATE TABLE TableName (ColumnName1
DataType,ColumnName2 DataType,CHECK (ColumnName1
Constraint),CHECK (ColumnName2 Constraint));
◍ inner join.
Answer: A join operation in which only rows that meet a given criterion are
, selected. The join criterion can be an equality condition (natural join or
equijoin) or an inequality condition (theta join). The inner join is the most
commonly used type of join. Contrast with outer join.
◍ updatable view.
Answer: A view that can update attributes in base tables that are used in the
view.
◍ regular entity.
Answer: See strong entity.
◍ authentication.
Answer: The process through which a DBMS verifies that only registered
users can access the database.
◍ middleware.
Answer: The computer software that allows clients and servers to
communicate within the client/server architecture. It is used to insulate
client processes from the network protocols and the details of the server
process protocols.
◍ input/output (I/O) request.
Answer: A low-level data access operation that reads or writes data to and
from computer devices.
◍ PRODUCT.
Answer: An operator used to yield all possible pairs of rows from two
tables.customer × agent
◍ static query optimization.
Answer: A query optimization mode in which the access path to a database
is predetermined at compilation time.
◍ manual query optimization.
Answer: An operation mode that requires the end user or programmer to
define the access path for the execution of a query.
◍ bitmap index.
, Answer: An index that uses a bit array (0s and 1s) to represent the existence
of a value or condition
◍ mandatory participation.
Answer: A relationship in which one entity occurrence must have a
corresponding occurrence in another entity. For example, an EMPLOYEE
works in a DIVISION. (A person cannot be an employee without being
assigned to a company's division.)
◍ index key.
Answer: See index.
◍ Correlated subquery.
Answer: A subquery that executes once for each row in the outer query. A
feature is that the outer subquery initiates the process of execution in a
subquery.
◍ GROUP BY.
Answer: A SQL clause used to create frequency distributions when
combined with any of the aggregate functions in a SELECT statement.
◍ superkey.
Answer: An attribute or attributes that uniquely identify each entity in a
table. See key.
◍ updatable view.
Answer: A view that can update attributes in base tables that are used in the
view.
◍ predicate logic.
Answer: Used extensively in mathematics to provide a framework in which
an assertion (statement of fact) can be verified as either true or false.
◍ inner join.
Answer: A join operation in which only rows that meet a given criterion are
selected. The join criterion can be an equality condition (natural join or
equijoin) or an inequality condition (theta join). The inner join is the most
, commonly used type of join. Contrast with outer join.
◍ weak relationship.
Answer: A relationship in which the primary key of the related entity does
not contain a primary key component of the parent entity.
◍ subquery.
Answer: A query that is embedded (or nested) inside another query. Also
known as a nested query or an inner query.
◍ COMMIT.
Answer: The SQL command that permanently writes data changes to a
database.
◍ "A salesperson manages zero to many other salespersons, and a salesperson
is managed by exactly one other salesperson."What is the name of this
model?.
Answer: One-to-many unary relationship
◍ composite key.
Answer: A multiple-attribute key.
◍ 22. Which query illustrates performing an outer join of the Movie table with
a different table?- SELECT M.Title, A.Name FROM Movie M, Actor
AWHERE M.ActorID = A.ActorID;- SELECT M.Title, A.Name FROM
Movie M, Actor AWHERE M.ActorID = A.MovieID;- SELECT M.Title,
A.Name FROM Movie M RIGHT JOIN Actor AON M.ActorID =
A.ActorID;- SELECT M.Title, A.Actor FROM Movie MINNER JOIN
Actor A ON M.ActorID = A.ActorID.
Answer: SELECT M.Title, A.Name FROM Movie MRIGHT JOIN Actor A
ON M.ActorID = A.ActorID;
◍ FROM.
Answer: A SQL clause that specifies the table or tables from which data is
to be retrieved.
◍ simple attribute.
