D426 Data Management Foundations New Pre Assessment Practice Exam Questions with Verified Correct Answers

D426 Data Management Foundations New Pre-

Assessment Practice Exam Questions with

Verified Correct Answers

Which statement correctly adds the values 'Strawberry' and 'Red' for the type and color
columns, respectively, in the 'fruits' table?

A. INSERT INTO fruits (type, color) VALUES ('Strawberry', 'Red');

B. INSERT INTO fruits (type, color) VALUES ('Strawberry', 'Red', 'Seedless');

C. INSERT INTO fruits (type, color) VALUES ('Red', 'Strawberry');

D. INSERT INTO fruits (type, 'Strawberry'), (color, 'Red');

A. INSERT INTO fruits (type, color) VALUES ('Strawberry', 'Red');

Which DROP statement deletes a column from an existing table?

A. DROP COLUMN column_name FROM table_name;

B. DROP table_name COLUMN column_name;

C. ALTER TABLE DROP COLUMN column_name FROM table_name;

D. ALTER TABLE table_name DROP COLUMN column_name;

D. ALTER TABLE table_name DROP COLUMN column_name;

What is an example of an expression in SQL?

A. City = 'Beijing'

B. 134

,C. INSERT

D. 'Welcome'

A. City = 'Beijing'

What does the % operator return when using numeric values?

A. The quotient when dividing one value by another

B. The quotient when dividing one value by another

C. The additive inverse (i.e., opposite) of a value

D. The remainder when dividing one value by another

D. The remainder when dividing one value by another

You are inserting a new record into a table. The primary key column is using an auto-
incrementing integer. What value should you specify for the primary key column in your
INSERT statement?

A. Omit the primary key column from the INSERT statement

B. Include the primary key column and specify a value of 0

C. Include the primary key column and specify a negative value

D. Omit any column with an integer data type

A. Omit the primary key column from the INSERT statement

Which language element includes a term with a special meaning for the language processor?

A. Literal

B. Keyword

C. Identifier

D. Expression

, B. Keyword

Which statement uses valid syntax for the DELETE statement in SQL?

A. DELETE FROM table_name WHERE condition;

B. DELETE table_name WHERE condition;

C. DELETE * FROM table_name WHERE condition;

D. DELETE FROM table_name;

A. DELETE FROM table_name WHERE condition;

Which SQL command uses the correct syntax to add a new employee John Doe to the
Employee table?

A. INSERT INTO Employee (Name) Values ( 'John Doe' );INSERT Values INTO Employee ( 'John
Doe' );

B. INSERT INTO Employee (Name) Values ( 'John Doe' );

C. INSERT Values INTO Employee ( John Doe );

D. INSERT INTO Employee (Name) Values ( John Doe );

B. INSERT INTO Employee (Name) Values ( 'John Doe' );

Which SQL data type should be used to store the price of a grocery item, ensuring accuracy to
the cent?

A. INT

B. FLOAT

C. DECIMAL(6,2)

D. VARCHAR(2)

C. DECIMAL(6,2)