A financial services company is implementing a unified audit policy named `FIN_AUDIT_POLICY` to monitor all `SELECT`, `INSERT`, and `UPDATE` operations on the `CUSTOMERS` table. After enabling the policy, the security officer notices that actions performed by the `SYS` user are not being captured. What must be done to ensure `SYS` user actions are also audited by this policy?
A database administrator is analyzing a performance issue where a specific batch job runs significantly slower than expected. The AWR report indicates high 'db file sequential read' wait events associated with the job's SQL statements. What is the most likely cause of this performance bottleneck?
A DBA needs to create a new pluggable database (PDB) named `SALES_PDB` by cloning an existing PDB called `TEMPLATE_PDB`. The source `TEMPLATE_PDB` must remain online and available for read-write operations during the entire cloning process. Which clause must be included in the `CREATE PLUGGABLE DATABASE` statement to satisfy this requirement?
A database administrator is tasked with loading a large, comma-separated values (CSV) file named `products.csv` into the `PRODUCTS` table. The DBA wants to bypass the SQL engine and write data blocks directly to the datafiles for maximum performance. Which SQL*Loader option should be used in the control file or command line?
True or False: In an Oracle 23ai database, temporary undo is stored in a dedicated temporary undo tablespace.
An administrator manages a large data warehouse and needs to enable resumable space allocation for a critical overnight data loading session to prevent failures due to unexpected space shortages. What are TWO valid methods to enable this feature for the session? (Select TWO).
A developer needs to create a new table, `APP_LOGS`, which will store high-volume, transient log data. To optimize space utilization and reduce fragmentation, the administrator wants to ensure that space freed by `DELETE` operations is immediately available for new `INSERT`s within the same block. Which storage setting should be used during table creation?
A new DBA is reviewing the database architecture. They need to understand which physical files store all the user and application data for the database. Which physical database structure serves this primary purpose?
A systems administrator is configuring a client machine to connect to an Oracle database server. The administrator does not want to manage a local `tnsnames.ora` file on every client. They want to use a simplified connection string that includes the hostname, port, and service name directly. Which Oracle Net naming method should they use?
A database is started using the `STARTUP MOUNT` command. At this stage, which of the following actions can a DBA perform? (Select TWO).