QUESTION 5
A power failure occurred while several applications were interacting with a database named SAMPLE. When power was restored, the database could not be restarted because a user temporary table space named USER_TMPTS is damaged. What must be done to success-fully recover the database?

A. Restart the database by executing the command RESTART DATABASE sam-ple DROP PENDING TABLESPACES; drop and recreate the USER_TMPTS table space
B. Restart the database by executing the command RESTART DATABASE sam-ple DROP PENDING TABLESPACES; recreate the USER_TMPTS table space
C. Restart the database by executing the command RESTART DATABASE sam-ple DROP TABLESPACE (USER_TMPTS); recreate the USER_TMPTS ta-ble space
D. Restart the database by executing the command RESTART DATABASE sam-ple RECREATE TABLESPACES (USER_TMPTS)

QUESTION 6
Which of the following statements is NOT true about Label-Based Access Control (LBAC)?

A. LBAC can be used to restrict access to individual rows and columns.
B. Users that have been granted different LBAC security labels will get different results when they execute the same query.
C. Only users with SYSADM or SECADM authority are allowed to create secu-rity policies and security labels.
D. Security label components represent criteria that may be used to decide whether a user should have access to specific data.

Answers

QUESTION 5
The correct answer is A. If a problem occurs with a table space container during the restart process, the DROP PENDING TABLESPACES ([TS_Name]) option can be used to place one or more table spaces in “Drop Pending” state. This allows the database to be suc-cessfully restarted, after which the offending table space can be dropped and, if necessary, recreated. A list of troubled table space names can found in the administration notification log if a database restart operation fails because of table space container problems.

QUESTION 6
The correct answer is C. Security Administrator (SECADM) authority is a special database level of authority that is designed to allow special users to configure various label-based access control (LBAC) elements to restrict access to one or more tables that contain data to which they most likely do not have access themselves. Users with Security Administrator authority are only allowed to perform the following tasks:
• Create and drop security policies.
• Create and drop security labels.
• Grant and revoke security labels to/from individual users (using the GRANT SECURITY LABEL and REVOKE SECURITY LABEL SQL statements).
• Grant and revoke LBAC rule exemptions.
• Grant and revoke SETSESSIONUSER privileges (using the GRANT SETSESSIONUSER SQL statement).
• Transfer ownership of any object not owned by the Security Administrator (by executing the TRANSFER OWNERSHIP SQL statement). No other authority provides a user with these abilities, including System Administrator authority.