WGU C170 -WESTERN GOVERNORS UNIVERSITY DATA MANAGEMENT APPLICATIONS EXAM PREPARATION BUNDLE

A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? A One-to-one B One-to-many C One-to-one binary D Many-to-many D Which kind of relationship is displayed in this entity-relations...

Domain In data modeling, the construct used to organize and describe an attribute's set of possible values. Primary key (PK) An identifier composed of one or more attributes that uniquely identifies a row. Also, a candidate key selected as a unique entity identifier. A minimal superkey. Key On...

domain - correct answer In data modeling, the construct used to organize and describe an attribute's set of possible values superkey - correct answer An attribute or attributes that uniquely identify each entity in a table. Any composite key with this is also this. candidate key - correct ans...

domain - correct answer In data modeling, the construct used to organize and describe an attribute's set of possible values superkey - correct answer An attribute or attributes that uniquely identify each entity in a table. Any composite key with this is also this. candidate key - correct ans...

Create Database Syntax - correct answer CREATE DATABASE db_name; Simple SFW query syntax - correct answer SELECT * FROM db_name WHERE column_name operator value; Cardinality: Inside or outside? - correct answer Outside Modality: Inside or outside? - correct answer Inside What commands ar...

Create Database Syntax - correct answer CREATE DATABASE db_name; Simple SFW query syntax - correct answer SELECT * FROM db_name WHERE column_name operator value; Cardinality: Inside or outside? - correct answer Outside Modality: Inside or outside? - correct answer Inside What commands ar...

Add New Row - correct answer INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, value3, ...); Update Row - correct answer UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; Delete Row - correct answer DELETE FROM table_name WHERE condition; ...

A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? - correct answer Many-to-many Refer to Diagram #2 Which kind of relationship is displayed in this entity-relationship diagram? - c...

Access plan - correct answer A set of instructions generated at application compilation time that is created and managed by a DBMS. The access plan predetermines how an application's query will access the database at run time. Alias - correct answer An alternative name for a column or table in a...

A salesperson is authorized to sell many products and a product can be sold by many salespersons. Which kind of binary relationship does this scenario describe? One-to-one One-to-many Many-to-many One-to-one binary - correct answer Many-to-many Which two examples are attributes? ...

If integer values are relatively small, what should be used instead of INT? - correct answer SMALLINT What is the SQL command that allows a user to list the contents of a table? - correct answer SELECT What is the process the DBMS uses to verify that only registered users access the database? ...

A database model - correct answer is a conceptual framework for database software The relational model - correct answer is a database model based on mathematical principles, with three parts: 1. A data structure that prescribes how data is organized. 2. Operations that manipulate data structure...

The order of the rows and columns is important to the DBMS. True or False - correct answer False PRODUCT yields all possible pairs of rows from two tables, also known as the _______ product. - correct answer Cartesian According to Codd's ______ rule of relation database, "Application pro...

AREA - correct answer In DB2, a named section of permanent storage space that is reserved to store the database. associative entity - correct answer See composite entity. bridge entity - correct answer See composite entity. candidate key - correct answer A minimal superkey; that is, a key t...