IBM IBM Certifications C2090-558 Questions & Answers

• Question 31:

  Which configuration parameter allows you to reduce the dependency on local OS user accounts and to enable a DBSA to grant database server access to specific users without the OS user accounts?

  A. USERMAPPING

  B. IFX_EXTEND_ROLE

  C. SECURITY_LOCALCONNECTION

  D. ADMIN_USER_MODE_WITH_DBSA

  Correct Answer: A

• Question 32:

  What are the three major steps in implementing Label-Based Access Control (LBAC) in an instance environment? (Choose three.)

  A. Define a security policy with access rules.

  B. Assign security labels to users and data elements

  C. Create security label definitions using set, tree, and/or array components

  D. Disable role separation since LBAC supersedes anything role separation might provide and it interferes with LBAC.

  E. Create and install either general or user-specific sysdbopen() functions so that LBAC is active when users connect to the instance.

  Correct Answer: ABC

• Question 33:

  Given the following: CREATE TABLE customer (customer_num INT, company CHAR(25)); Which of the following SQL statements will return an error?

  A. INSERT INTO customer VALUES (453);

  B. INSERT INTO customer VALUES (453, '"ABC Company");

  C. INSERT INTO customer (company) VALUES ("ABC Company");

  D. INSERT INTO customer (customer_num, company) VALUES (453, "ABC Company");

  Correct Answer: A

• Question 34:

  Which two statements cause Stored Procedure Language (SPL) routine optimization? (Choose two.)

  A. CALL PROCEDURE

  B. CREATE PROCEDURE

  C. OPTIMIZE PROCEDURE

  D. EXECUTE PROCEDURE

  E. UPDATE STATISTICS FOR PROCEDURE

  Correct Answer: BE

• Question 35:

  When you execute an INSERT statement, the database server will insert a NULL value into any column that meets which two conditions? (Choose two.)

  A. Columns that are used in indexes.

  B. Columns that are used in constraints.

  C. You provide no value for a specific column.

  D. Where a zero is specified in the VALUES clause of a serial column.

  E. Where you specify the NULL keyword in the VALUES clause for a specific column.

  Correct Answer: CE

• Question 36:

  Which keyword is used to determine whether a comparison is true for every value returned from a subquery?

  A. ALL

  B. ANY

  C. EACH

  D. EVERY

  Correct Answer: A

• Question 37:

  Which statement can be used to roll back SQL statements within a transaction?

  A. END WORK

  B. COMMIT WORK

  C. ROLLBACK WORK

  D. ROLLBACK WORK TO SAVEPOINT

  Correct Answer: D

• Question 38:

  Which two statements will update all rows in the customer table? (Choose two.)

  A. update customer set fname = "xyz";

  B. modify customer set fname = "xyz";

  C. modify customer set fname = "xyz" where 1 = 1;

  D. update customer set fname = "xyz" where 1 = 1;

  E. update customer set fname = "xyz" for all;

  Correct Answer: AD

• Question 39:

  Which two SQL commands can be used to invoke a stored procedure? (Choose two.)

  A. RUN function

  B. CALL function

  C. CALL procedure

  D. EXECUTE function

  E. EXECUTE procedure

  Correct Answer: DE

• Question 40:

  Which of the following can be used in a SELECT statement to set one or more qualifying conditions to a group of records after they are formed?

  A. HAVING

  B. WHERE

  C. GROUP BY

  D. ORDER BY

  Correct Answer: A