dumpstool logo
Which two statements are true about the Database Configuration Assistant (DBCA)? (Choose two.)
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?
You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure.
In which three ways can you re-create the lost disk group and restore the data? (Choose three.)
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart.
Examine the following command and its output:
$ crsctl config has
CRS-4622: Oracle High Availability Services auto start is enabled.
What does this imply?
You want to reduce fragmentation and reclaim unused space for the SALES table but not its dependent objects. During this operation, you want to ensure the following:
i. Long-running queries are not affected.
ii. No extra space is used.
iii. Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv. Unused space is reclaimed both above and below the high water mark.
Which ALTER TABLE option would you recommend?
You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns? (Choose two.)
Which three features work together, to allow a SQL statement to have different cursors for the same statement based on different selectivity ranges? (Choose three.)
Which two are true concerning a multitenant container database with three pluggable database? (Choose two.)
You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform? (Choose two.)
You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server.
All databases of all versions use Automatic Storage Management (ASM).
Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group? (Choose three.)
Which four actions are possible during an Online Data file Move operation? (Choose four.)
Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance.
What should you use to achieve this?
After implementing full Oracle Data Redaction, you change the default value for the NUMBER data type as follows:
After changing the value, you notice that FULL redaction continues to redact numeric data with zero.
What must you do to activate the new default value for numeric full redaction?
An application accesses a small lookup table frequently. You notice that the required data blocks are getting aged out of the default buffer cache.
How would you guarantee that the blocks for the table never age out?
You are the DBA supporting an Oracle 11g Release 2 database and wish to move a table containing several DATE, CHAR, VARCHAR2, and NUMBER data types, and the table’s indexes, to another tablespace.
The table does not have a primary key and is used by an OLTP application.
Which technique will move the table and indexes while maintaining the highest level of availability to the application?
Which two must be installed or configured either manually or by DBCA in order to use Enterprise Manager
Database Express (EM Express)? (Choose two.)
You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.
You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?
Which two statements are true about SQL*Loader Express Mode in an Oracle 12c database? (Choose two.)
Which two statements correctly describe the relationship between data files and logical database structures? (Choose two.)
Which three statements are true about user account administration? (Choose three.)
Which three database operations can be performed only at MOUNT state? (Choose three.)
You plan to install the Oracle Database 12c software. You want to use Oracle Automatic Storage Management (ASM) for storage and Oracle Restart for managing components. Oracle Grid Infrastructure for a Standalone Server is already installed on the server.
Which three statements must be true for successful installation of the Oracle Database 12c software? (Choose three.)
An employee salary in the non-partitioned EMPLOYEES table, has been updated but the transaction is uncommitted.
Which two types of lock are held by the transaction? (Choose two.)
All of your database instances use SPFILES.
You executed this command in one of them:
ALTER SYSTEM SET MEMORY_MAX_TARGET=1024M;
Which statement is true?
One of your databases has archive logging enabled and RMAN backups are taken at regular intervals.
The data file for the USERS tablespace is corrupt.
Which command must you execute before starting the recovery of this tablespace?
You determine that database performance is sub-optimal due to hard parsing statements. Automatic Shared Memory Management (ASMM) is disabled for your database instance.
Which tool would you use to get advice on how to improve performance?
Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In UNIX? (Choose three.)
You want to flash back a test database by five hours.
You issue this command:
SQL > FLASHBACK DATABASE TO TIMESTAMP (SYSDATE - 5/24);
Which two statements are true about this flashback scenario? (Choose two.)
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:
There is enough free space in the disk group for mirroring to be done.
What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?
A redaction policy was added to the SAL column of the SCOTT.EMP table:
All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)
Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:
What are three possible causes for the latch-related wait events?
Examine the parameters for a database instance:
Which two statements are true? (Choose two.)
Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.
You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:
SQL > SHUTDOWN IMMEDIATE
SQL > STARTUP MOUNT
SQL > FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”;
Examine following commands:
1. ALTER PLUGGABLE DATABASE ALL OPEN;
2. ALTER DATABASE OPEN;
3. ALTER DATABASE OPEN RESETLOGS;
Which command or commands should you execute next to allow updates to the flashback back schema?
In your production database, data manipulation language (DML) operations are executed on the SALES table.
You have noticed some dubious values in the SALES table during the last few days. You are able to track users, actions taken, and the time of the action for this particular period but the changes in data are not tracked. You decide to keep track of both the old data and new data in the table long with the user information.
What action would you take to achieve this task?
The HR user updates the salary of one of the employees in the non-partitioned EMPLOYEES table, but does not commit the transaction.
Which two types of lock exist in this situation? (Choose two.)
In your database, the RESOURCE_LIMIT parameter is set to TRUE.
You create the profile:
Which two statements are true about users and their sessions that are subject to this profile? (Choose two.)
In your database instance, the UNDO_RETENTION parameter is set to 1000 and undo retention is not guaranteed for the fixed size undo tablespace.
Which statement is true about undo retention?
Which two utilities can NOT configure a new listener on port 1526? (Choose two.)
Which statement is true about using the Export/Import method for migrating data when upgrading to Oracle Database 12c?
In your Oracle 12c database, you plan to execute the command:
SQL> CREATE TABLESPACE tbs1 DATAFILE ‘/u02/oracle/data/tbs01.dbf’ SIZE 50M;
The u02 file system has 1 GB of free space available.
What is the outcome?
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE
‘ /mydir/rman_change_track.f’;
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true? (Choose three.)
The user SCOTT owns the CUST table that is placed in the SALES tablespace. The user SCOTT opens a session and executes commands as follows:
SQL> INSERT INTO cust VALUES(101, 'JACK');
1 row created.
SQL> INSERT INTO cust VALUES(102, 'SMITH');
1 row created.
As a DBA, you execute the following command from another session:
ALTER TABLESPACE sales READ ONLY;
Which statement is true regarding the effect of this command on the transaction in Scott's session?
Examine the parameters for your database instance:
Which three statements are true about the process of automatic optimization by using cardinality feedback? (Choose three.)
On your Oracle 12c database, you Issue the following commands to create indexes
SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;
SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);
Which two statements are correct? (Choose two.)
TESTED 22 Sep 2025