WGU C170 EXAM WITH 100% CORRECT
AND VERIFIED ANSWERS LATEST UPDATE
Correct 52
100%
Incorrec 00
t
Your answers
1 of 52
Term
Which two SQL data types can represent images or
sounds?
Give this one a try later!
To retrieve data SELECT * FROM Owners;
TINYBLO
B LEFT JOIN
BINARY
Don't know?
2 of 52
,Definition
,ALTER TABLE `Salesperson` ADD INDEX 'city_index' (`city`)
Give this one a try later!
This database table has ten different employee numbers in the first column.
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?
A database administrator needs to modify an index on the
CUSTOMER table called IDX_NAME because
there are multiple customers with the same name. It has been determined
that it would be desirable to
modify the index to also include the telephone number.
Which command line will modify the IDX_NAME index on the
CUSTOMER table to include both NAME
and TELEPHONE as part of the index?
Which ALTER TABLE statement adds a foreign key constraint to a child
table?
The database administrator has been tasked with implementing an
index to speed up the retrieval of
data based on the city values. The database is using the InnoDB
engine. What is the correct syntax to create an index to be
built on the city field based on the database
information?
Don't know?
3 of 52
Definition
, Second normal form
Give this one a try later!
A database administrator needs to modify an index on the
CUSTOMER table called IDX_NAME because
there are multiple customers with the same name. It has been determined
that it would be desirable to
modify the index to also include the telephone number.
Which command line will modify the IDX_NAME index on the
CUSTOMER table to include both NAME
and TELEPHONE as part of the index?
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?
The database administrator has been tasked with implementing an
index to speed up the retrieval of
data based on the city values. The database is using the InnoDB engine.
What is the correct syntax to create an index to be built on the city
field based on the database
information?
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?
Don't know?
AND VERIFIED ANSWERS LATEST UPDATE
Correct 52
100%
Incorrec 00
t
Your answers
1 of 52
Term
Which two SQL data types can represent images or
sounds?
Give this one a try later!
To retrieve data SELECT * FROM Owners;
TINYBLO
B LEFT JOIN
BINARY
Don't know?
2 of 52
,Definition
,ALTER TABLE `Salesperson` ADD INDEX 'city_index' (`city`)
Give this one a try later!
This database table has ten different employee numbers in the first column.
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?
A database administrator needs to modify an index on the
CUSTOMER table called IDX_NAME because
there are multiple customers with the same name. It has been determined
that it would be desirable to
modify the index to also include the telephone number.
Which command line will modify the IDX_NAME index on the
CUSTOMER table to include both NAME
and TELEPHONE as part of the index?
Which ALTER TABLE statement adds a foreign key constraint to a child
table?
The database administrator has been tasked with implementing an
index to speed up the retrieval of
data based on the city values. The database is using the InnoDB
engine. What is the correct syntax to create an index to be
built on the city field based on the database
information?
Don't know?
3 of 52
Definition
, Second normal form
Give this one a try later!
A database administrator needs to modify an index on the
CUSTOMER table called IDX_NAME because
there are multiple customers with the same name. It has been determined
that it would be desirable to
modify the index to also include the telephone number.
Which command line will modify the IDX_NAME index on the
CUSTOMER table to include both NAME
and TELEPHONE as part of the index?
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?
The database administrator has been tasked with implementing an
index to speed up the retrieval of
data based on the city values. The database is using the InnoDB engine.
What is the correct syntax to create an index to be built on the city
field based on the database
information?
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?
Don't know?
