WGU C170 Data Management
Western Governors University
Page 2 out of 20 results
Sort by
-
WGU Data Management - Applications - C170 OA GSA1, Exam Questions and answers. Graded A+
- Exam (elaborations) • 2 pages • 2023
-
Available in package deal
-
- $7.99
- + learn more
WGU Data Management - Applications - C170 OA GSA1, Exam Questions and answers. Graded A+ 
 
 
Add New Row - -INSERT INTO table_name (column1, column2, ...) 
VALUES (value1, value2, value3, ...); 
 
Update Row - -UPDATE table_name 
SET column1 = value1, column2 = value2, ... 
WHERE condition; 
 
Delete Row - -DELETE FROM table_name 
WHERE condition; 
 
Inner Join - -SELECT column_name(s) 
FROM table1 
INNER JOIN table2 
ON n_name = n_name;
-
WGU C170 - Data Management Applications Questions and answers. VERIFIED.
- Exam (elaborations) • 3 pages • 2023
-
Available in package deal
-
- $7.99
- + learn more
WGU C170 - Data Management Applications Questions and answers. VERIFIED. 
 
 
Create Database Syntax - -CREATE DATABASE db_name; 
 
Simple SFW query syntax - -SELECT * FROM db_name WHERE column_name operator value; 
 
Cardinality: Inside or outside? - -Outside 
 
Modality: Inside or outside? - -Inside 
 
What commands are used with data definition? - -create, alter, drop, truncate, comment, rename 
 
What commands are used with data manipulation? - -Select, Insert, Update, Delete, Merge, Call, E...
-
WGU C170 Test questions & Answers. Graded A+. VERIFIED.
- Exam (elaborations) • 4 pages • 2023
-
Available in package deal
-
- $7.99
- + learn more
WGU C170 Test questions & Answers. Graded A+. VERIFIED. 
 
 
ON DELETE SET NULL 
A setting when creating a foreign key that says if a record in the parent table is deleted, then the corresponding records in the child table have their key value set to NULL. 
 
 
ON DELETE RESTRICT 
A setting when creating a foreign key that says when data is removed from a parent table and there is a Foreign Key associated with the child table you will receive an error or it will fail to delete. 
 
 
ON DELETE CA...
-
WGU C170, WGU Full Study Pack, Exam Questions and answers. Graded A+. VERIFIED.
- Exam (elaborations) • 47 pages • 2023
-
Available in package deal
-
- $11.49
- + learn more
WGU C170, WGU Full Study Pack, Exam Questions and answers. Graded A+. VERIFIED. 
 
 
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? - -Many-to-many 
 
Which two examples are attributes? - -An employee number 
A meeting code 
 
Which delete rule sets column values in a child table to a missing value when the matching data is 
deleted from the parent table? - -Set-to-Null 
 
member_id...
-
WGU C170 Data Management Applications. Exam Questions and answers, Graded A+
- Exam (elaborations) • 12 pages • 2023
-
Available in package deal
-
- $8.49
- + learn more
WGU C170 Data Management Applications. Exam Questions and answers, Graded 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? - -Many-to-many 
 
Refer to Diagram #2 
 
Which kind of relationship is displayed in this entity-relationship diagram? - -Many-to-many unary 
 
Refer to Diagram #3 
 
Which kind of relationship is displayed in this entity-relationship diagram? - -Unary o...
Want to regain your expenses?
-
WGU C170 Data Management – Applications. Exam Review, graded A+. VERIFIED.
- Exam (elaborations) • 6 pages • 2023
-
Available in package deal
-
- $8.49
- + learn more
WGU C170 Data Management – Applications. Exam Review, graded A+. VERIFIED. 
 
 
domain - -In data modeling, the construct used to organize and describe an attribute's set of possible values 
 
superkey - -An attribute or attributes that uniquely identify each entity in a table. Any composite key with this is also this. 
 
candidate key - -A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey 
 
entity integrity - -The property of a relationa...
-
WGU C170 - PRE-ASSESSMENT Questions and answers. Data assessment. VERIFIED.
- Exam (elaborations) • 21 pages • 2023
-
Available in package deal
-
- $10.49
- + learn more
WGU C170 - PRE-ASSESSMENT Questions and answers. Data assessment. VERIFIED. 
 
 
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 - -Many-to-many 
 
Which two examples are attributes? 
 
Choose 2 answers 
 
A person attending a meeting 
An employee number 
A sales meeting 
A meeting code - -An employee number 
A mee...
-
WGU C170, Exam Review Questions and answers. VERIFIED. Latest updates.
- Exam (elaborations) • 14 pages • 2023
-
Available in package deal
-
- $9.49
- + learn more
WGU C170, Exam Review Questions and answers. VERIFIED. Latest updates. 
 
 
Access plan - -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 - -An alternative name for a column or table in a SQL statement. 
 
ALTER TABLE - -The SQL command used to make changes to table structure. When the command is followed by a keyword (ADD or MODIFY), it...
-
WGU C170 - Data Management – Applications, Exam Review Questions and answers, graded A+. VERIFIED.
- Exam (elaborations) • 34 pages • 2023
-
Available in package deal
-
- $11.49
- + learn more
WGU C170 - Data Management – Applications, Exam Review Questions and answers, graded A+. VERIFIED. 
 
 
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 
One or more attributes that determine other attributes. 
 
 
Determination 
The role o...
-
WGU C170 Data Management Applications| Questions And Answers With Verified Tests
- Exam (elaborations) • 24 pages • 2023
-
- $13.99
- + learn more
WGU C170 Data Management Applications| Questions 
And Answers With Verified Tests 
What is a table? A table is a persistent representation of a logical relation that is a 
relation whose contents can be saved for permanent use. 
What are the characteristics of a relational table? The characteristics of a relational 
table are that a table is perceived as a two-dimensional structure composed of rows and 
columns, each row (tuple) represents a single entity occurrence within the set, each 
column ...
How much did you already spend on Stuvia? Imagine there are plenty more of you out there paying for study notes, but this time YOU are the seller. Ka-ching! Discover all about earning on Stuvia