WGU C170 DATA MANAGEMENT APPLICATION QUESTIONS WITH THE CORRECT ANSWERS

WGU C170 DATA MANAGEMENT APPLICATION QUESTIONS WITH
THE CORRECT ANSWERS




domain - correct answer- b b b


In data modeling, the construct used to organize and describe an attribute's set of possi
b b b b b b b b b b b b b b


ble values b




superkey - correct answer- b b b


An attribute or attributes that uniquely identify each entity in a table. Any composite key
b b b b b b b b b b b b b b b


with this is also this.
b b b b




candidate key - correct answer- b b b b


A minimal superkey; that is, a key that does not contain a subset of attributes that is itsel
b b b b b b b b b b b b b b b b b


f a superkey
b b




entity integrity - correct answer-
b b b b


The property of a relational table that guarantees each entity has a unique value in a pri
b b b b b b b b b b b b b b b b


mary key and that the key has no null values
b b b b b b b b b




referential integrity - correct answer- b b b b


A condition by which a dependent table's foreign key must have either a null entry or a
b b b b b b b b b b b b b b b b b


matching entry in the related table b b b b b




data dictionary - correct answer-
b b b b


A DBMS component that stores metadata. It contains the data definition & their charact
b b b b b b b b b b b b b


eristics and relationships; may also include data external to the DBMS
b b b b b b b b b b




system catalog - correct answer-b b b b


A detailed system data dictionary that describes all objects in a database
b b b b b b b b b b b




homonym - correct answer- b b b


The use of the same name to label different attributes, much like similar-
b b b b b b b b b b b b


sounding words with different meanings b b b b

, synonym - correct answer- b b b


The use of different names to identify the same object, such as an entity, an attribute, or
b b b b b b b b b b b b b b b b b


a relationship. These should generally be avoided.
b b b b b b




not null and unique - correct answer-
b b b b b b


Any candidate key must have these two constraints enforced
b b b b b b b b




cardinality - correct answer- b b b


Term for how many instances of one object are related to instances of another object (
b b b b b b b b b b b b b b b


maximum)

modality - correct answer- b b b


Term for whether an instance of a specific entity is optional or mandatory in a relationshi
b b b b b b b b b b b b b b b


p (minimum)
b




connectivity - correct answer- b b b


Term for the classification of the relationship between entities. Classifications include 1:
b b b b b b b b b b b


1, 1:M, and M:N
b b b




CREATE SCHEMA AUTHORIZATION - correct answer-b b b b b


SQL command to create a database schema
b b b b b b




DEFAULT - correct answer- b b b


SQL option to define a default value for a column (when no value is given)
b b b b b b b b b b b b b b




CHECK - correct answer- b b b


SQL command to validate data in an attribute, used during table column creation
b b b b b b b b b b b b




CREATE TABLE AS - correct answer- b b b b b


SQL command to create a new table based on a query in the user's database schema
b b b b b b b b b b b b b b b




HAVING - correct answer- b b b


SQL option that restricts a selection of grouped rows based on a condition
b b b b b b b b b b b b




EXISTS - correct answer-SQL option that checks whether a subquery returns any rows
b b b b b b b b b b b b




DECIMAL - correct answer- b b b


SQL data type like the NUMBER specification, but the storage length is a minimum spe
b b b b b b b b b b b b b b


cification

True - correct answer-
b b b


True or false: if an INSERT or SELECT command is embedded inside a program for lat
b b b b b b b b b b b b b b b


er use, the attribute list should always be used, as the table may change over time
b b b b b b b b b b b b b b b




inner join - correct answer-
b b b b


A join operation in which only rows that meet a given criterion are selected. The most co
b b b b b b b b b b b b b b b b


mmon type of join b b b