NEW QUESTION 1
DATADIR1 and DATADIR2 are database directory objects.
Examine this command:
[oracle@host01 ~] expdp system/oracle \
> FULL=y \
> DUMPFILE=datadir1:full%U.dmp, datadir2: full2%U.dmp \
> FILESIZE=2G \
> PARALLEL=4 \
> LOGFILE= datadir1:/expfull.log
> JOB_NAME= expfull
Which two are true about the expdp operation? (Choose two.)

• A. It creates a dump file for the entire database.
• B. It fails if the total size of the dump file is more than 2 GB.
• C. It creates a dump file only for objects in the SYSTEM schema.
• D. It creates a master table to store details of the export operation.
• E. It starts only when four worker processes are available.

Answer: AE

NEW QUESTION 2
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 3
The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations.
Each database has a tnsnames.ora file defining DALLAS_DB as a service name. Examine this command:
CREATE DATABASE LINK dblink1 CONNECT TO scott IDENTIFIED BY tiger USING ‘dallas_db’;
How do you execute the command so that only SCOTT in BOSTON_DB can access the SCOTT schema in DALLAS_DB?

• A. as SCOTT in BOSTON_DB
• B. as SYS in both the databases
• C. as SCOTT in BOSTON_DB and SYS in DALLAS_DB
• D. as SCOTT in both the databases
• E. as SCOTT in DALLAS_DB

Answer: D

NEW QUESTION 4
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 5
Which two are true about the AL32UTF8 character set? (Choose two.)

• A. It is used to encode data for columns of any data type.
• B. It supports multilingual databases.
• C. It uses less space than other character sets, for all data types.
• D. It is used to store PL/SQL source code.
• E. It improves the I/O performance of a database compared to other character sets.

Answer: BC

NEW QUESTION 6
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 7
Which two types of files are opened by a database instance in the NOMOUNT state?

• A. control files
• B. the alert log
• C. the initialization parameter file
• D. data files
• E. online redo logs

Answer: CD

NEW QUESTION 8
Which three are true about the Oracle Optimizer? (Choose three.)

• A. It determines the optimal table join order and method.
• B. It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.
• C. It can optimize only SELECT statements.
• D. It will only generate SQL Plan Directives specific to a given SQL statement.
• E. It can re-optimize execution plans after previous executions detect suboptimal plans.
• F. It updates stale object statistics in the Data Dictionary.

Answer: ABC

NEW QUESTION 9
Your client application and Oracle database are located on different hosts. Which statement is true about establishing a connection between them?

• A. Oracle Connection Manager must be installed on the client.
• B. Net service names must be configured on both the client and database servers.
• C. The Listener Control utility must be installed on the client if you are using the default listener on the server.
• D. Only Oracle Net can be used.
• E. Oracle Net Listener is required.

Answer: D

NEW QUESTION 10
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 11
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 12
Which is true about revoking roles?

• A. Only users who are granted the DBA role can revoke a role.
• B. Only users who are granted SYSDBA can revoke a role.
• C. Users who have the GRANT ANY ROLE privilege can revoke any role.
• D. Users who are granted a role with ADMIN OPTION can revoke that role only from users to whom they have granted the role.
• E. Users can revoke a role that is granted to them through other roles.

Answer: D

NEW QUESTION 13
Which three are true about Oracle Database backup taken with RMAN?

• A. A whole backup contains all data blocks of all data files.
• B. RMAN cannot backup REDO logs.
• C. A full backup contains all data blocks from one or more data files.
• D. An RMAN image copy can be written only to disk.
• E. Only offline backup are consistent.
• F. RMAN always includes the control file in a backup.

Answer: CDF

NEW QUESTION 14
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 15
Which two are true about Oracle recovery and data protection solutions? (Choose two.)

• A. RMAN can be used to FLASHBACK a database.
• B. RMAN can be used to roll back committed transactions.
• C. Data Recovery Advisor can be used to restore a single file from an RMAN backupset.
• D. Data Recovery Advisor can be used to validate backup strategies.
• E. Oracle Data Guard can prevent data loss caused by a site failure.

Answer: AE

NEW QUESTION 16
Examine the command: CREATE USER user1 IDENTIFIED BY user123
DEFAULT TEMPORARY TABLESPACE temp
QUOTA 5M ON system PROFILE hr_user PASSWORD EXPIRE;
Which two are true? (Choose two.)

• A. The PASSWORD EXPIRE clause is invalid because passwords are controlled by the HR_USER profile.
• B. USER1 requires a quota to be able to store objects in the default permanent tablespace.
• C. USER1 will be prompted for a new passport at first login.
• D. A quota on the temporary tablespace must be specified to enable USER1 to perform queries and transactions.
• E. USER1’s account is locked.

Answer: BD

NEW QUESTION 17
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 18
Examine this command and its partial output:

Why does the DB01.abc.com service show unknown status?

• A. The listener does not listen on the default port 1521.
• B. The SID_LIST_LISTENER section is missing in the LISTENER.ORA file.
• C. The service is dynamically registered.
• D. The service is statically registered.
• E. The LOCAL_LISTENER parameter list does not contain LISTENER_1.

Answer: B

NEW QUESTION 19
Which two are prerequisites for shrinking a table online?

• A. It must have a unique key constraint.
• B. It must not have any referential integrity constraints.
• C. It must not have any DML triggers.
• D. It must be in a tablespace that uses Automatic Segment Space Management (ASSM) .
• E. It must have row movement enabled.

Answer: AB

NEW QUESTION 20
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 21
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 22
Which two operations can be performed on external tables? (Choose two.)

• A. creating invisible indexes
• B. creating views
• C. creating partitions
• D. creating public synonyms
• E. executing UPDATE statements

Answer: BD

NEW QUESTION 23
......