IBM IBM Certified Advanced Database Administrator C2090-610 Questions & Answers

• Question 81:

  By default, a column defined as a TIMESTAMP includes which attributes?

  A. No fractional digits or time zone.

  B. 6 fractional digits and no time zone.

  C. 12 fractional digits plus a time zone.

  D. 12 fractional digits and no time zone.

  Correct Answer: B

• Question 82:

  When an application using a temporary table terminates or disconnects from the database unexpectedly, what happens to the temporary table and any data stored in it?

  A. The data in the table is deleted and the table persists.

  B. The data in the table is deleted and the table is implicitly dropped.

  C. The temporary table is converted to a base table and the data is deleted.

  D. The temporary table is converted to a base table and the data is persistent.

  Correct Answer: B

• Question 83:

  A column mask that is to be used for row and column access control (RCAC) was created with the DISABLE option specified. What must be done if this mask is to be used to restrict access to data stored in a table named EMPLOYEE?

  A. The column mask must be enabled; the EMPLOYEE table must be altered to activate column access control.

  B. The column mask must be enabled (column access control for the EMPLOYEE table will be activated automatically).

  C. The EMPLOYEE table must be altered to activate column access control (the column mask will be enabled automatically).

  D. The EMPLOYEE table must be altered to activate column access control; row permission must be granted to everyone who needs to use thecolumn mask.

  Correct Answer: A

• Question 84:

  User USER1 holds both DBADM and SECADM authority and you want to separate database administration activities from security administration tasks. What authority must you have in order to revoke SECADM authority from user USER1 and assign it to someone else?

  A. DBADM

  B. DBCTRL

  C. SECADM

  D. DBMAINT

  Correct Answer: C

• Question 85:

  A table named EMPLOYEE was created as follows:

  

  Which action will prevent unauthorized users from accessing SSN data?

  A. Assign the SSN column to a restricted role that only authorized users can access.

  B. Only grant ACCESSCTRL authority for the SSN column to users who need to access SSN data.

  C. Alter the table definition so that SSN data is stored in a separate schema that only authorized users can access.

  D. Create a view for the EMPLOYEE table that does not contain the SSN column and require unauthorized users to use the view.

  Correct Answer: D

• Question 86:

  Which SQL statement will allow user USER1 to create a view on a table named EMPLOYEE?

  A. GRANT CREATETAB ON DATABASE TO user1

  B. GRANT SELECT ON TABLE employee TO user1

  C. GRANT CREATEVIEW ON DATABASE TO user1

  D. GRANT REFERENCES ON TABLE employee TO user1

  Correct Answer: B

• Question 87:

  A new user named USER1 needs to retrieve information from a database named MYDB. What authority must be granted to user USER1?

  A. DBCTRL authority

  B. SQLADM authority

  C. DATAACCESS authority

  D. ACCESSCTRL authority

  Correct Answer: C

• Question 88:

  Which privilege is required to invoke a user defined function?

  A. CALL

  B. USAGE

  C. EXECUTE

  D. REFERENCES

  Correct Answer: C

• Question 89:

  Which statement is true about an index that is used to support a UNIQUE constraint?

  A. It must not contain more than one column.

  B. It cannot be used in a referential constraint.

  C. It must be defined with the UNIQUE attribute.

  D. It must be defined as UNIQUE WHERE NOT NULL.

  Correct Answer: C

• Question 90:

  Which statement regarding triggers is true?

  A. Only one INSERT, UPDATE, or DELETE trigger can be defined per table.

  B. Triggers cannot be modified, they must be dropped and recreated with new definitions.

  C. Adding a trigger to a table that already has rows in it will cause triggered actions to be fired.

  D. Triggers can only be fired one time per statement irrespective of the number of rows affected.

  Correct Answer: B