WGU C170 Data Management Critical and Objective Assessment Exam Questions and verified and correct Marking Scheme Newest 2024/2025

WGU C170 Data Management Critical and
Objective Assessment Exam Questions and
verified and correct Marking Scheme Newest
2024/2025


Which line, when added to the end of the statement, returns the total number of each
kind of product-by-product number - correct answer GROUP BY PRODNUM;


Which data definition language statement affects databases or objects in them - correct
answer ALTER


What does the DELETE statement do - correct answer It removes rows from a table.


Which condition must be in effect to use the INSERT INTO ... VALUES syntax for an
INSERT statement - correct answer The VALUES list must contain a value for each
non-null valued column in the table.


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 - correct answer Decimal


Which two SQL data types can represent images or sounds




INT
FLOAT
BINARY
TERNARY

, TINYBLOB
SOUNDBLOB - correct answer BINARY
TINYBLOB


CREATE TABLE CUSTOMER (CustomerID INT NOT NULL AUTO_INCREMENT,
LastName VARCHAR(100) NOT NULL, FirstName VARCHAR(100) NOT NULL,
PRIMARY KEY ( CustomerID ));


Which component of the command indicates the table's name - correct answer
CUSTOMER


Which method creates an empty copy of a table and then populates it from the original
table




INSERT TABLE ... SELECT followed by INSERT INTO ... LIKE :
CREATE TABLE ... LIKE followed by INSERT INTO ... SELECT :
CREATE TABLE ... INTO followed by INSERT INTO:
INSERT TABLE ... LIKE followed by SELECT: - correct answer CREATE TABLE ...
LIKE followed by INSERT INTO ... SELECT :


Refer to the given SQL syntax.
ALTER TABLE tbl_name action [, action ] ... ;


What does this syntax allowChoose 2 answers




Adding rows
Dropping indexes