Package deal
WGU C170 Comprehensive Test Bank
Guaranteed A+
[Show more]Guaranteed A+
[Show more]FJ01 C170 Final Exam Tips |Updated| 
2024 
CREATE TABLE statements and data type assignments 
create table employee 
(first varchar(15), 
last varchar(20), 
age number(3), 
address varchar(30), 
city varchar(20), 
state varchar(20)); 
CREATE TABLE ... LIKE 
CREATE TABLE new_tbl_name LIKE tbl_name; 
...
Preview 2 out of 7 pages
Add to cartFJ01 C170 Final Exam Tips |Updated| 
2024 
CREATE TABLE statements and data type assignments 
create table employee 
(first varchar(15), 
last varchar(20), 
age number(3), 
address varchar(30), 
city varchar(20), 
state varchar(20)); 
CREATE TABLE ... LIKE 
CREATE TABLE new_tbl_name LIKE tbl_name; 
...
WGU C170 Data Management – 
Applications 100% Correct Answers 
|Verified| Updated 
domain *Ans* In data modeling, the construct used to organize and describe an 
attribute's set of possible values 
superkey *Ans* An attribute or attributes that uniquely identify each entity in a table. 
Any co...
Preview 2 out of 9 pages
Add to cartWGU C170 Data Management – 
Applications 100% Correct Answers 
|Verified| Updated 
domain *Ans* In data modeling, the construct used to organize and describe an 
attribute's set of possible values 
superkey *Ans* An attribute or attributes that uniquely identify each entity in a table. 
Any co...
C170 Final Exam |Question and Answer| 
100% Correct 
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? *Ans* Many-to-many 
Which two examples are attributes? *Ans* An employee number 
A ...
Preview 2 out of 11 pages
Add to cartC170 Final Exam |Question and Answer| 
100% Correct 
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? *Ans* Many-to-many 
Which two examples are attributes? *Ans* An employee number 
A ...
WGU C170 Chapter 5 Exam Review 
|Question and Answer| 100% Correct 
access plan *Ans* 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. 
algorithm...
Preview 2 out of 5 pages
Add to cartWGU C170 Chapter 5 Exam Review 
|Question and Answer| 100% Correct 
access plan *Ans* 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. 
algorithm...
C170 - PRE-ASSESSMENT GUIDING 
QUESTIONS |100% CORRECT| #LATEST 
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 *Ans* Ma...
Preview 3 out of 27 pages
Add to cartC170 - PRE-ASSESSMENT GUIDING 
QUESTIONS |100% CORRECT| #LATEST 
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 *Ans* Ma...
WGU C170 Chapter 2 Exam Review 
|Question and Answer| 100% Correct 
binary relationship *Ans* An ER term for an association (relationship) between two 
entities. For example, PROFESSOR teaches CLASS. 
cardinality *Ans* An attribute that can be further subdivided to yield additional 
attributes. F...
Preview 2 out of 5 pages
Add to cartWGU C170 Chapter 2 Exam Review 
|Question and Answer| 100% Correct 
binary relationship *Ans* An ER term for an association (relationship) between two 
entities. For example, PROFESSOR teaches CLASS. 
cardinality *Ans* An attribute that can be further subdivided to yield additional 
attributes. F...
C170 Exam Review |Question and 
Answer| 100% Correct 
WGU C170 Data Management – 
Applications 100% Correct Answers 
|Verified| Updated 
domain *Ans* In data modeling, the construct used to organize and describe an 
attribute's set of possible values 
superkey *Ans* An attribute or attributes ...
Preview 2 out of 9 pages
Add to cartC170 Exam Review |Question and 
Answer| 100% Correct 
WGU C170 Data Management – 
Applications 100% Correct Answers 
|Verified| Updated 
domain *Ans* In data modeling, the construct used to organize and describe an 
attribute's set of possible values 
superkey *Ans* An attribute or attributes ...
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Stuvia is a marketplace, so you are not buying this document from us, but from seller AceTests. Stuvia facilitates payment to the seller.
No, you only buy these notes for $17.49. You're not tied to anything after your purchase.
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now