C170, WGU Full Study Pack
1. 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
2. Which two examples are attributes?: An employee
number A meeting code
3. 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
4. member_id INT UNSIGNED NOT NULL
AUTO_INCREMENT, PRIMARY KEY (member_id),
last_name VARCHAR(20) NOT NULL,
first_name VARCHAR(20) NOT NULL,
suffix VARCHAR(5) NULL,
expiration DATE NULL,
Which two columns are created as something other than variable-length
strings in this statement?: member_id
expiration
5. This database table has ten different employee numbers in the first
col- umn. Employee_ID is the primary
key. In addition, it has ten different names in the second column and
two office addresses repeated five
,times each in the third column.
Which action should be used to translate this data into third normal form?-
: Move the data from the third column into its own table.
6. A database manager starts to convert data that has been normalized
into a form that conforms to the
relational model. A simple primary key has been established and all
the repeating groups have been
deleted.
In which form is this data?: Second normal form
7. Two attributes in two related tables have the exact same domain of
values.
The attribute is a primary
key in one table.
Which kind of key is the attribute in the other table?: Foreign
8. SELECT PRODNUM,
PRODNAME FROM PRODUCT
,Which line should be added to the end of the statement to return the
product numbers and product
names for products that cost 20 dollars?: WHERE PRODCOST=20;
9. What does WHERE identify in a basic SQL SELECT statement?: The
rows to be included
10. Refer to the given SQL
statement. SELECT EMPNUM
FROM EMPLOYEE
Which line added to the end of the statement returns employee numbers
of at least 1000?: WHERE EMPNUM >= 1000;
11. SELECT PRODNUM,
SUM(QUANTITY) FROM SALESPERSON
Which line, when added to the end of the statement, returns the total
number of each kind of product
by product number?: GROUP BY PRODNUM;
12.Which data definition language statement affects databases or objects
in them?: ALTER
13.What does the DELETE statement do?: It removes rows from a table.
14.Which condition must be in effect to use the INSERT INTO ... VALUES
syntax for an INSERT statement?: The VALUES list must contain a
value for each non-null valued column in the
table.
15. CREATE TABLE
, mytbl (
f FLOAT(10,4),
c CHAR(15) NOT NULL DEFAULT
'none', i TINYINT UNSIGNED NULL
);
Which kind of data type is FLOAT in this statement?: Decimal
16.Which two SQL data types can represent images or sounds?:
TINYBLOB BINARY
17. CREATE TABLE CUSTOMER
(CustomerID INT NOT NULL
AUTO_INCREMENT, LastName VARCHAR(100)
NOT NULL, FirstName VARCHAR(100) NOT
NULL,
1. 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
2. Which two examples are attributes?: An employee
number A meeting code
3. 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
4. member_id INT UNSIGNED NOT NULL
AUTO_INCREMENT, PRIMARY KEY (member_id),
last_name VARCHAR(20) NOT NULL,
first_name VARCHAR(20) NOT NULL,
suffix VARCHAR(5) NULL,
expiration DATE NULL,
Which two columns are created as something other than variable-length
strings in this statement?: member_id
expiration
5. This database table has ten different employee numbers in the first
col- umn. Employee_ID is the primary
key. In addition, it has ten different names in the second column and
two office addresses repeated five
,times each in the third column.
Which action should be used to translate this data into third normal form?-
: Move the data from the third column into its own table.
6. A database manager starts to convert data that has been normalized
into a form that conforms to the
relational model. A simple primary key has been established and all
the repeating groups have been
deleted.
In which form is this data?: Second normal form
7. Two attributes in two related tables have the exact same domain of
values.
The attribute is a primary
key in one table.
Which kind of key is the attribute in the other table?: Foreign
8. SELECT PRODNUM,
PRODNAME FROM PRODUCT
,Which line should be added to the end of the statement to return the
product numbers and product
names for products that cost 20 dollars?: WHERE PRODCOST=20;
9. What does WHERE identify in a basic SQL SELECT statement?: The
rows to be included
10. Refer to the given SQL
statement. SELECT EMPNUM
FROM EMPLOYEE
Which line added to the end of the statement returns employee numbers
of at least 1000?: WHERE EMPNUM >= 1000;
11. SELECT PRODNUM,
SUM(QUANTITY) FROM SALESPERSON
Which line, when added to the end of the statement, returns the total
number of each kind of product
by product number?: GROUP BY PRODNUM;
12.Which data definition language statement affects databases or objects
in them?: ALTER
13.What does the DELETE statement do?: It removes rows from a table.
14.Which condition must be in effect to use the INSERT INTO ... VALUES
syntax for an INSERT statement?: The VALUES list must contain a
value for each non-null valued column in the
table.
15. CREATE TABLE
, mytbl (
f FLOAT(10,4),
c CHAR(15) NOT NULL DEFAULT
'none', i TINYINT UNSIGNED NULL
);
Which kind of data type is FLOAT in this statement?: Decimal
16.Which two SQL data types can represent images or sounds?:
TINYBLOB BINARY
17. CREATE TABLE CUSTOMER
(CustomerID INT NOT NULL
AUTO_INCREMENT, LastName VARCHAR(100)
NOT NULL, FirstName VARCHAR(100) NOT
NULL,
