NEW QUESTION 1
Which three types of files are created by expdp operations? (Choose three.)

• A. SQL files
• B. dump files
• C. reject files
• D. log files
• E. input data files
• F. bad files
• G. control files

Answer: ABD

NEW QUESTION 2
The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE. UNDOTBS2 is the active undo tablespace.
Examine these commands:



USER1 executes DML, which generates more than 2 MB of UNDO. What is the result and why?

• A. It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.
• B. It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.
• C. It suspends the transaction, which can be resumed by increasing USER1’s quota on UNDOTBS2.
• D. It returns an error because UNDOTBS2 has RETENTION GUARANTEE.
• E. It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.
• F. It returns an error because UNDOTBS2 is fixed size.

Answer: F

NEW QUESTION 3
Which two are responsibilities of an Oracle DBA regarding database availability, backup, and recovery?

• A. decreasing Mean Time Between Failures (MTBF) by configuring FLASHBACK mode
• B. implementing FLASHBACK DATA ARCHIVE to decrease MTBF
• C. ensuring that critical components are protected by implementing redundancy
• D. decreasing Mean Time to Recover (MTTR) by configuring FLASHBACK mode
• E. implementing FLASHBACK DATA ARCHIVE to decrease MTTR

Answer: CD

NEW QUESTION 4
Which two are true about Oracle Database Cloud Service (DBCS)? (Choose two.)

• A. Third-party tools can be used with database instances in the cloud.
• B. Oracle-supplied tools can be used with database instances in the cloud.
• C. Database instances in the cloud can be accessed only by using SSH.
• D. DBCS only creates compute nodes; the Oracle Database software must be installed and the database created.
• E. Database instances in the cloud can be accessed only by using Oracle*Net.

Answer: BC

NEW QUESTION 5
Which two are true about incomplete recovery? (Choose two.)

• A. Incremental backups cannot be used to roll forward the database while performing it.
• B. Uncommitted transactions will be rolled back after it completes.
• C. It is possible only when the database is in MOUNT state.
• D. The database must have FLASHBACK enabled in order to perform it.
• E. Only RMAN backupsets can be used to restore a database as part of it.

Answer: DE

NEW QUESTION 6
Which two statements are true about Oracle Data Pump? (Choose two.)

• A. expdp and impdp are its client components.
• B. impdp always uses conventional path inserts when importing data.
• C. The DBMS_DATAPUMP package can be used only with Data Pump clients
• D. It cannot be used to export data as of a previous SCN.
• E. impdp can change target data file names, schemas, and tablespaces during import.

Answer: AC

NEW QUESTION 7
In your database, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)

• A. Grant the CREATE SESSION privilege without ADMIN OPTION to other users.
• B. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.
• C. Execute DML statements in the HR schema.
• D. Log in to the database instance.
• E. Revoke the CREATE SESSION privilege from other users.
• F. Execute DDL statements in the HR schema.

Answer: BDE

NEW QUESTION 8
Which two are true about Oracle database wait events that are described in V$EVENT_NAME? (Choose two.)

• A. They reveal the cause of performance problems.
• B. They are grouped into classes.
• C. They are maintained at the session and system level.
• D. They display how often a database instance performs particular operations.
• E. All events might be used by an instance regardless of parameter settings.

Answer: AB

NEW QUESTION 9
Which three are true about Oracle Managed Files (OMF)? (Choose three.)

• A. If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_CREATE_FILE_DEST by default.
• B. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
• C. If only DB_CREATE_FILE_DEST is specified, only the data files and temp files are OMF.
• D. If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.
• E. If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, the data files and temp files are placed in DB_CREATE_ONLINE_LOG_DEST_1 by default.
• F. If only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF.

Answer: ABF

NEW QUESTION 10
For which three purposes is UNDO used? (Choose three.)

• A. flashback queries
• B. FLASHBACK TABLE <tablename> TO BEFORE DROP operations
• C. the roll forward phase of instance recovery
• D. RESTORE DATABASE operations
• E. ROLLBACK operations
• F. read consistency

Answer: AEF

NEW QUESTION 11
Which three failures require intervention for recovery? (Choose three.)

• A. a user error such as dropping the wrong table
• B. network interface card (NIC) failure
• C. user process failure
• D. statement failure
• E. media failure

Answer: ACE

NEW QUESTION 12
Which two tasks can be performed in the NOMOUNT state? (Choose two.)

• A. re-creating control files
• B. full database recovery
• C. enabling online redo log archiving
• D. renaming data files
• E. creating a database

Answer: AE

NEW QUESTION 13
Which two are true about users who are granted SYSDBA or SYSOPER privileges? (Choose two.)

• A. Only users granted SYSDBA can query or update tables in all user schemas.
• B. Only users granted SYSDBA can take a complete backup of a database.
• C. Users granted either SYSDBA or SYSOPER connect to an instance as SYS.
• D. Users granted either SYSDBA or SYSOPER can mount or open a database.
• E. Only users granted SYSDBA can start up and shut down a database instance.
• F. Users granted either SYSDBA or SYSOPER can query data in all user schemas.

Answer: BC

NEW QUESTION 14
In your database, you want to create a tablespace of non-standard block size by using this command: CREATE TABLESPACE ns_tbs
DATAFILE ‘/u01oracle/data/nstbs_f01.dbf’ SIZE 100M BLOCKSIZE 16K;
Which is a requirement for this command to succeed?

• A. All other DB_nK_CACHE_SIZE parameters should be set to zero.
• B. The DB_16K_CACHE_SIZE parameter should be set to a value that can be accommodated in the available SGA.
• C. The value of the DB_CACHE_SIZE parameter should not be 16 KB.
• D. The DB_16K_CACHE_SIZE parameter should be set to a value less than that of DB_CACHE_SIZE.
• E. The DB_BLOCK_SIZE parameter must be set to a value greater than 16 KB.

Answer: B

NEW QUESTION 15
Which two tasks can you perform by using DBCA for a new database?

• A. Register it with an available Enterprise Manager Management server.
• B. Configure a nonstandard block size.
• C. Configure incremental backups.
• D. Enable flashback.
• E. Create user tablespaces.

Answer: AE

NEW QUESTION 16
Which three statements are true about an spfile? (Choose three)

• A. It contains only static initialization parameters.
• B. It is the first file processed at instance startup.
• C. It can be edited by SYS when the database instance is shut down.
• D. It must exist for a database instance to start.
• E. It can be used to create a pfile.
• F. It contains initialization parameters whose values can be changed using the ALTER SYSTEM command.

Answer: DEF

NEW QUESTION 17
Which is true about security rules on a compute node?

• A. The port used for HTTPS connections is enabled by default based on a predefined security rule.
• B. A security rule can restrict IP addresses that can connect to a database instance on a compute node.
• C. A new database deployment on a compute node automatically enables a set of predefined security rules.
• D. New security rules can be defined to use only the TCP protocol but multiple port numbers.
• E. A compute node port can be enabled only if it is associated with an existing security rule.

Answer: C

NEW QUESTION 18
A user complains about poor database performance. You suspect that the user’s session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user’s session is currently waiting? (Choose two.)

• A. V$SYSTEM_EVENT
• B. V$SESSION_EVENT
• C. V$SESSION_WAIT_CLASS
• D. V$SESSION_WAIT
• E. V$SESSION

Answer: BD

NEW QUESTION 19
Which two are true about the roles? (Choose two.)

• A. All privileges and roles granted to a user are enabled by default when the user logs in.
• B. The SET ROLE statement can be used once per session.
• C. The SET ROLE statement enables as well as disables roles in a session.
• D. A role must be disabled before it can be revoked from a user.
• E. The ALTER USER statement must be used to set specific default roles for a user.

Answer: AC

NEW QUESTION 20
Which three actions are required to manually upgrade a database to Oracle Database 12c Release 2? (Choose three.)

• A. Run the Pre-Upgrade information tool on the source database.
• B. Take all user tablespaces offline before starting the upgrade.
• C. Copy the network configuration files from the existing database home to the new Oracle home location.
• D. Run the Parallel Upgrade utility from the new Oracle home.
• E. Run Oracle Net Configuration Assistant (NETCA) to configure the listening protocol address and service information for the new release of Oracle Database.
• F. Make all user tablespaces “read only” before starting the upgrade.
• G. Start the existing database in upgrade mode.

Answer: ADG

NEW QUESTION 21
......