WGU C170 Data Management

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. 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. 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. 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+ 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...

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. 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. 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. 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 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 ...