WGU C170 DATA MANAGEMENT
APPLICATIONS GSA1 COMPREHENSIVE
STUDY GUIDE
◍ right outer join.
Answer: In a pair of tables to be joined, a join that yields all of the rows in
the right table, including the ones with no matching values in the other table.
For example, a right outer join of CUSTOMER with AGENT will yield all
of the AGENT rows, including the ones that do not have a matching
CUSTOMER row. See also left outer join and outer join.
◍ iterative process.
Answer: A process based on repetition of steps and procedures.
◍ COMMIT.
Answer: The SQL command that permanently writes data changes to a
database.
◍ Write the SQL query to "Retrieve the entire record for salesperson 186":.
Answer: SELECT *FROM SALESPERSONWHERE SPNUM=186;
◍ view.
Answer: A virtual table based on a SELECT query that is saved as an object
in the database.
◍ manual statistical generation mode.
Answer: A mode of generating statistical data access information for query
optimization. In this mode, the DBA must periodically run a routine to
generate the data access statistics—for example, running the RUNSTAT
command in an IBM DB2 database.
,◍ Which SQL command is an example of data definition language (DDL)?-
UPDATE- ALTER- SELECT- DELETE.
Answer: CREATE, ALTER, OR DROP
◍ A federated database name for a participating database object, such as tables
and columns..
Answer: Nickname
◍ CREATE TABLE.
Answer: A SQL command that creates a table's structures using the
characteristics and attributes given.
◍ existence-dependent.
Answer: A property of an entity whose existence depends on one or more
other entities. In such an environment, the existence-independent table must
be created and loaded first because the existence-dependent key cannot
reference a table that does not yet exist.
◍ 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.
◍ single-valued attribute.
Answer: An attribute that can have only one value.
◍ SQL performance tuning.
Answer: Activities to help generate a SQL query that returns the correct
answer in the least amount of time, using the minimum amount of resources
at the server end
◍ Determinant.
Answer: Any attribute in a specific row whose value directly determines
other values in that row.
◍ Write the SQL query to "Find the customer numbers, customer names, and
headquarters cities of those customers with the customer numbers greater
than 1000. List the results in alphabetic order by headquarters cities (and
, have the customer names within the same city alphabetized)":.
Answer: SELECT CUSTNUM, CUSTNAME, HQCITYFROM
CUSTOMERWHERE CUSTNUM>1000ORDER BY HQCITY,
CUSTNAME;
◍ Dynamic statistical generation mode.
Answer: In a DBMS, the capability to automatically evaluate and update the
database access statistics after each data access operation.
◍ CREATE TABLE.
Answer: A SQL command that creates a table's structures using the
characteristics and attributes given.
◍ A database offered as a PaaS cloud service..
Answer: Cloud Database
◍ full functional dependence.
Answer: A condition in which an attribute is functionally dependent on a
composite key but not on any subset of the key.
◍ relational schema.
Answer: The organization of a relational database as described by the
database administrator.
◍ 57. Which rows will always be included in the result set if Table A is right
joined with Table B?- Only rows in Tales A and B that share the join
condition- All rows in Table B- All rows in Table A- Only rows in Tables A
and B that do not share the join condition.
Answer: All rows in Table B
◍ Participants.
Answer: An ER term for entities that participate in a relationship.
◍ DROP INDEX.
Answer: A SQL command used to delete database objects such as tables,
views, indexes, and users.
◍ Key attributes.
, Answer: The attributes that form a primary key
◍ Ensures transactions are properly executed..
Answer: Transaction Manager
◍ CREATE VIEW.
Answer: A SQL command that creates a logical, "virtual" table. The view
can be treated as a real table.
◍ 31. All changes to a table structure are made using the _____ command,
followed by a keyword that produces the specific changes a user wants to
make.- ALTER TABLE- UPDATE TABLE- COMMIT TABLE- DELETE
TABLE.
Answer: ALTER TABLE
◍ Represents a union of the data sets.
Answer: OR
◍ cardinality.
Answer: A property that assigns a specific value to connectivity and
expresses the range of allowed entity occurrences associated with a single
occurrence of the related entity.
◍ manual statistical generation mode.
Answer: A mode of generating statistical data access information for query
optimization. In this mode, the DBA must periodically run a routine to
generate the data access statistics—for example, running the RUNSTAT
command in an IBM DB2 database.
◍ BETWEEN.
Answer: In SQL, a special comparison operator used to check whether a
value is within a range of specified values.
◍ Database designer specifies a function on the column value consistent with a
WHERE clause. Can be applied to any index type. Considered when the
WHERE clause format is different than the storage format..
Answer: Function Index
APPLICATIONS GSA1 COMPREHENSIVE
STUDY GUIDE
◍ right outer join.
Answer: In a pair of tables to be joined, a join that yields all of the rows in
the right table, including the ones with no matching values in the other table.
For example, a right outer join of CUSTOMER with AGENT will yield all
of the AGENT rows, including the ones that do not have a matching
CUSTOMER row. See also left outer join and outer join.
◍ iterative process.
Answer: A process based on repetition of steps and procedures.
◍ COMMIT.
Answer: The SQL command that permanently writes data changes to a
database.
◍ Write the SQL query to "Retrieve the entire record for salesperson 186":.
Answer: SELECT *FROM SALESPERSONWHERE SPNUM=186;
◍ view.
Answer: A virtual table based on a SELECT query that is saved as an object
in the database.
◍ manual statistical generation mode.
Answer: A mode of generating statistical data access information for query
optimization. In this mode, the DBA must periodically run a routine to
generate the data access statistics—for example, running the RUNSTAT
command in an IBM DB2 database.
,◍ Which SQL command is an example of data definition language (DDL)?-
UPDATE- ALTER- SELECT- DELETE.
Answer: CREATE, ALTER, OR DROP
◍ A federated database name for a participating database object, such as tables
and columns..
Answer: Nickname
◍ CREATE TABLE.
Answer: A SQL command that creates a table's structures using the
characteristics and attributes given.
◍ existence-dependent.
Answer: A property of an entity whose existence depends on one or more
other entities. In such an environment, the existence-independent table must
be created and loaded first because the existence-dependent key cannot
reference a table that does not yet exist.
◍ 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.
◍ single-valued attribute.
Answer: An attribute that can have only one value.
◍ SQL performance tuning.
Answer: Activities to help generate a SQL query that returns the correct
answer in the least amount of time, using the minimum amount of resources
at the server end
◍ Determinant.
Answer: Any attribute in a specific row whose value directly determines
other values in that row.
◍ Write the SQL query to "Find the customer numbers, customer names, and
headquarters cities of those customers with the customer numbers greater
than 1000. List the results in alphabetic order by headquarters cities (and
, have the customer names within the same city alphabetized)":.
Answer: SELECT CUSTNUM, CUSTNAME, HQCITYFROM
CUSTOMERWHERE CUSTNUM>1000ORDER BY HQCITY,
CUSTNAME;
◍ Dynamic statistical generation mode.
Answer: In a DBMS, the capability to automatically evaluate and update the
database access statistics after each data access operation.
◍ CREATE TABLE.
Answer: A SQL command that creates a table's structures using the
characteristics and attributes given.
◍ A database offered as a PaaS cloud service..
Answer: Cloud Database
◍ full functional dependence.
Answer: A condition in which an attribute is functionally dependent on a
composite key but not on any subset of the key.
◍ relational schema.
Answer: The organization of a relational database as described by the
database administrator.
◍ 57. Which rows will always be included in the result set if Table A is right
joined with Table B?- Only rows in Tales A and B that share the join
condition- All rows in Table B- All rows in Table A- Only rows in Tables A
and B that do not share the join condition.
Answer: All rows in Table B
◍ Participants.
Answer: An ER term for entities that participate in a relationship.
◍ DROP INDEX.
Answer: A SQL command used to delete database objects such as tables,
views, indexes, and users.
◍ Key attributes.
, Answer: The attributes that form a primary key
◍ Ensures transactions are properly executed..
Answer: Transaction Manager
◍ CREATE VIEW.
Answer: A SQL command that creates a logical, "virtual" table. The view
can be treated as a real table.
◍ 31. All changes to a table structure are made using the _____ command,
followed by a keyword that produces the specific changes a user wants to
make.- ALTER TABLE- UPDATE TABLE- COMMIT TABLE- DELETE
TABLE.
Answer: ALTER TABLE
◍ Represents a union of the data sets.
Answer: OR
◍ cardinality.
Answer: A property that assigns a specific value to connectivity and
expresses the range of allowed entity occurrences associated with a single
occurrence of the related entity.
◍ manual statistical generation mode.
Answer: A mode of generating statistical data access information for query
optimization. In this mode, the DBA must periodically run a routine to
generate the data access statistics—for example, running the RUNSTAT
command in an IBM DB2 database.
◍ BETWEEN.
Answer: In SQL, a special comparison operator used to check whether a
value is within a range of specified values.
◍ Database designer specifies a function on the column value consistent with a
WHERE clause. Can be applied to any index type. Considered when the
WHERE clause format is different than the storage format..
Answer: Function Index
