WGU C170 Data Management

Sales order 1NF WGU C170 Data Management - Applications Performance Assessment. EXPLANATION: I am going to call this table the "Order Table" I also need to make sure that this table contains a primary Key, in this particular table I am going to make the “OrderID” and “DonutID” the Primary Key (composite key), the reason I chose to use OrderID and DonutID as the primary key is because Order ID or DonutID by themselves do not guarantee Uniqueness but when combined uniqueness is...

WGU C170 - Data Management – Applications, 100% Accurate. VERIFIED. 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 a...

WGU C170 Top Questions and Accurate answers. Rated 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 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 INT UNSIGNED NOT NULL AUTO_INCRE...

WGU C170 Data Management Application Exam Questions and answers, rated A+. AREA - -In DB2, a named section of permanent storage space that is reserved to store the database. associative entity - -See composite entity. bridge entity - -See composite entity. candidate key - -A minimal superkey; that is, a key that does not contain a subset of attributes that is itself a superkey. See key. closure - -A property of relational operators that permits the use of relational algebra oper...

C170 Performance Assessment Questions & Answers, 100% Accurate. VERIFIED. Syntax for updating a specific column in a specific row - -UPDATE <table> SET <atrribute> = <value> WHERE <primary key> = <value>; Syntax for deleting a row - -DELETE FROM <TableName> WHERE <PrimaryKey> = <#>; Syntax for creating a view - -CREATE VIEW <name> AS SELECT <columnname> CONCAT (<attribute>, ' ', <attribute>) AS <newname&...

C170 Data Management - Applications SQL Syntax, Questions & Answers. VERIFIED. CREATE TABLE syntax DDL - -CREATE TABLE tableName ( colName dataType constraint INDEX indexName (colName) PRIMARY KEY (colName, colName) or colName dataType PRIMARY KEY FOREIGN KEY (colName, colName) REFERENCES tableName (colName) ); CREATE INDEX syntax DDL - -CREATE [UNIQUE] INDEX indexName ON tableName (colName); UNIQUE should only be used on a column that should not have duplicate values. ...

Other Practice Tests C170 FJ01. Exam Quizzes & Answers. VERIFIED.

C170 Data Management – Applications, Top Exam Questions and answers. VERIFIED. A database model - -is a conceptual framework for database software The relational model - -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 structures. 3. Rules that govern valid relational data. A domain - -is a named set of possible database values, such as integers, dictionary words,...

C170 Data Management Application. Top Exam Questions and answers, Rated 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 Which kind of relationship is displayed in this entity-relationship diagram? - -Many-to-Many Unary Which kind of relationship is displayed in this entity-relationship diagram? - -Unary one-to-one How is this portion of the entity-rel...

WGU C170 PA. Exam Questions and answers, 100% Accurate. 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 kind of relationship is displayed in this entity-relationship diagram? - -Many-to-many unary Which two examples are attributes? Choose 2 answers - -AN Employee number, and meeting code Which delete rule sets column values in a child tabl...