C170 wgu already passed - Study guides, Class notes & Summaries

WGU C170 VHT2 TASK 1 NORMALIZATION AND DATABASE DESIGN / ALREADY PASSED 100%

WGU C170 - PRE-ASSESSMENT QUESTIONS AND ANSWERS ALREADY PASSED 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 meeting code Which delete rule sets column val...

AREA - in DB2, a named section of permanent storage space that is reserved to store the database. associative entity - another name for composite entity, bridge entity or linking table bridge entity - another name for composite entity, associative entity or linking table candidate key - a minimal superkey; that is, a key that dows not contain a subset of attributes that is itself a superkey. closure - A property of relational operators that permits the use of relational algebra operators ...

WGU C170 VHT2 TASK 1 NORMALIZATION AND DATABASE DESIGN / ALREADY PASSED 100% WGU C170 VHT2 TASK 1 NORMALIZATION AND DATABASE DESIGN / ALREADY PASSED 100% WGU C170 VHT2 TASK 1 NORMALIZATION AND DATABASE DESIGN / ALREADY PASSED 100% WGU C170 VHT2 TASK 1 NORMALIZATION AND DATABASE DESIGN / ALREADY PASSED 100% WGU C170 VHT2 TASK 1 NORMALIZATION AND DATABASE DESIGN / ALREADY PASSED 100% WGU C170 VHT2 TASK 1 NORMALIZATION AND DATABASE DESIGN / ALREADY PASSED 100% WGU C170 VHT2 TASK 1 NORMALIZATION AND...

An inequality condition is also known as a natural join and an equality condition is also called a theta join. - False When using a(n) _____ join, only rows that meet the given criteria are returned. - inner The statement SELECT * FROM T1, T2 produces a(n) _____ join. - cross A(n) _____ join will select only the rows with matching values in the common attribute(s). - natural If a designer wishes to create an inner join, but the two tables do not have a commonly named attribute, he can use...

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. algorithms - A process or set of operations in a calculation. automatic query optimization - A method by which a DBMS finds the most efficient access path for the execution of a query. B-tree index - An ordered data structure organized as an upside-down tree. bitmap index - An in...

WGU Course C170 - Data Management (Applications) Questions and Answers Already Passed 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-relationship diagram? A Many-to-many unary B Many-to-many binary C One-to-one unary D One-to-one binary A Which kind of rela...

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 Refer to the given SQL statement. CREATE TABLE member ( member_id INT UNSIGNED NOT NULL AUTO_INCREME...

DML - IUDS, CR insert, update, delete, select commit, rollback INSERT - add new rows UPDATE - modify data of existing rows DELETE - delete some/all records from database can be rolled back COMMIT - permanently saves ROLLBACK - undo changes SELECT - data retrieval WHERE - limits rows returned used before group by ORDER BY - OC sorts columns

AREA - in DB2, a named section of permanent storage space that is reserved to store the database. associative entity - another name for composite entity, bridge entity or linking table bridge entity - another name for composite entity, associative entity or linking table candidate key - a minimal superkey; that is, a key that dows not contain a subset of attributes that is itself a superkey. closure - A property of relational operators that permits the use of relational algebra operators ...