QUESTION: 13

Review the following table.
Given the following options are in mySQL, which option correctly alters the last row on the table?

INSERT price = 0.9 -
INTO product -
WHERE product_id = 3;
MODIFY product -
UPDATE price = 0.9 -
WHERE product_id = 3;
SET product -
(price) VALUES (0.9)
WHERE product_id = 3;
UPDATE product -
SET price = 0.9 -
WHERE product_id = 3;

Answer(s): D

Reveal Solution Next Question

QUESTION: 14

What is a Foreign Key?

The key that cannot be used in any other table.
The key that joins two tables together.
The key that uniquely identifies a record.
The key that uniquely identifies a record when joined with another column.

Answer(s): B

Reveal Solution Next Question

QUESTION: 15

You need to edit data in a table. You ate currently using the following statement:
INSERT INTO product (productId, productName) VALUES (3, "App1e"); What is the issue?

You should be using an UPDATE statement.
You forgot the WHERE clause in your statement.
You should be using a CREATE statement.
You should be using an EDIT statement.

Answer(s): A

Explanation:

CREATE TABLE table_name (
column1 datatype,
column2 datatype,
....
);

Reveal Solution Next Question

QUESTION: 16

When using "a!pagingInfo()" within "a!queryEntity()", which batch size value will return all items?

-1
0
null
500

Answer(s): A

Reveal Solution Next Question

Free ACD100 Exam Braindumps (page: 5)

QUESTION: 13

QUESTION: 14

QUESTION: 15

Explanation:

QUESTION: 16

ACD100 Discussions & Posts