Managing Storage   «Prev  Next»

Oracle Enhancements - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. An Oracle database receives external files containing document data every day. Which utility can use control-file mappings and LOBFILEs to load that data into LOB columns?
Please select the best answer.
  A. Oracle Enterprise Manager Cloud Control
  B. SQL*Loader
  C. Oracle Database Resource Manager
  D. Database Configuration Assistant (DBCA)

2. Oracle software is installed on a supported self-managed host. Which tool provides interactive and silent-mode workflows for creating a container database (CDB) and its pluggable databases (PDBs)?
Please select the best answer.
  A. SQL*Loader
  B. Data Pump Import
  C. Database Configuration Assistant (DBCA)
  D. Oracle Database Resource Manager

3. A public web application uses Oracle AI Database 26ai. Which statements correctly describe its web and database access design?
Please select all the correct answers.
  A. Visitors can access the application over HTTPS while the application connects to a private database endpoint.
  B. The server-side component that opens database sessions should protect its database credentials and use appropriate privileges.
  C. Network access rules, transport encryption, and database authorization address different requirements.
  D. A public website requires its database SQL listener to accept connections from every public IP address.

4. An application uses a global temporary table defined with ON COMMIT DELETE ROWS. What happens when its session commits the transaction?
Please select the best answer.
  A. The table definition is dropped for every session.
  B. The temporary rows become visible to other sessions.
  C. The session's temporary rows are cleared, while the table definition remains.
  D. The rows are retained until the database instance shuts down.

5. An administrator creates a custom Unified Auditing policy for updates to an application table in Oracle AI Database 26ai. What is the best next step to establish that the intended activity is being recorded?
Please select the best answer.
  A. Set AUDIT_TRAIL to DB and rely on traditional auditing.
  B. Enable the policy for the intended users, perform an authorized test operation, and inspect the corresponding unified audit records.
  C. Assume that creating the policy automatically enables it for every database user.
  D. Grant AUDIT_ADMIN to the application runtime account so that its updates are automatically audited.