ACD100

ACD100 practice questions, page 4 of 5, with answer review and explanations.

Question 16

During User Acceptance Testing (UAT), a tester operating in the test environment asks you to change a data point in one of the tables. In the development environment, you navigate to the database and adjust the data point that the tester described. What is the issue with the steps taken?

  1. According to Appian best practices, changes should not be made directly in a database.
  2. The change to the database was made in the wrong environment.
  3. As an associate, you should not be communicating or coordinating directly with testers.
  4. The change was made without formally seeking approval from DevOps.

Question 17

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

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

Question 18

What is a Foreign Key?

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

Question 19

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?

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

Question 20

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

  1. -1
  2. 0
  3. null
  4. 500