NEW QUESTION 1
Identify three valid methods of opening, pluggable databases (PDBs).

• A. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from the root
• B. ALTER PLUGGABLE DATABASE OPEN ALL ISSUED from a PDB
• C. ALTER PLUGGABLE DATABASE PDB OPEN issued from the seed
• D. ALTER DATABASE PDB OPEN issued from the root
• E. ALTER DATABASE OPEN issued from that PDB
• F. ALTER PLUGGABLE DATABASE PDB OPEN issued from another PDB
• G. ALTER PLUGGABLE DATABASE OPEN issued from that PDB

Answer: AEG

NEW QUESTION 2
Identify two correct statements about multitenant architectures.

• A. Multitenant architecture can be deployed only in a Real Application Clusters (RAC) configuration.
• B. Multiple pluggable databases (PDBs) share certain multitenant container database (CDB) resources.
• C. Multiple CDBs share certain PDB resources.
• D. Multiple non-RAC CDB instances can mount the same PDB as long as they are on the same server.
• E. Patches are always applied at the CDB level.
• F. A PDB can have a private undo tablespace.

Answer: BE

NEW QUESTION 3
The persistent configuration settings for RMAN have default for all parameters. Identify four RMAN commands that produce a multi-section backup.

• A. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
• B. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
• C. BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
• D. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
• E. BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
• F. BACKUP SPFILE SECTION SIZE 1M;
• G. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;

Answer: ABEG

NEW QUESTION 4
A senior DBA asked you to execute the following command to improve performance: SQL> ALTER TABLE subscribe log STORAGE (BUFFER_POOL recycle);
You checked the data in the SUBSCRIBE_LOG table and found that it is a large table containing one million rows.
What could be a reason for this recommendation?

• A. The keep pool is not configure
• B. Automatic Workarea Management is not configure
• C. Automatic Shared Memory Management is not enable
• D. The data blocks in the SUBSCRIBE_LOG table are rarely accesse
• E. All the queries on the SUBSCRIBE_LOG table are rewritten to a materialized view.

Answer: D

NEW QUESTION 5
You conned using SQL Plus to the root container of a multitenant container database (CDB) with SYSDBA privilege.
The CDB has several pluggable databases (PDBs) open in the read/write mode. There are ongoing transactions in both the CDB and PDBs.
What happens alter issuing the SHUTDOWN TRANSACTIONAL statement?

• A. The shutdown proceeds immediately.The shutdown proceeds as soon as all transactions in the PDBs are either committed or rolled hack.
• B. The shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
• C. The shutdown proceeds as soon as all transactions in both the CDB and PDBs are either committed or rolled back.
• D. The statement results in an error because there are open PDBs.

Answer: B

NEW QUESTION 6
Examine the following command:
CREATE TABLE (prod_id number(4),
Prod_name varchar2 (20),
Category_id number(30),
Quantity_on_hand number (3) INVISIBLE);
Which three statements are true about using an invisible column in the PRODUCTS table?

• A. The %ROWTYPE attribute declarations in PL/SQL to access a row will not display the invisible column in the output.
• B. The DESCRIBE commands in SQL *Plus will not display the invisible column in the output.
• C. Referential integrity constraint cannot be set on the invisible column.
• D. The invisible column cannot be made visible and can only be marked as unuse
• E. A primary key constraint can be added on the invisible column.

Answer: ABE

NEW QUESTION 7
Which three statements are true about SQL plan directives?

• A. They are tied to a specific statement or SQL I
• B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.
• C. They are used to gather only missing statistics.
• D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.
• E. They instruct the optimizer to create only column group statistics.
• F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.

Answer: BDF

NEW QUESTION 8
You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:

What is the result of the last SET CONTAINER statement and why is it so?

• A. It succeeds because the PDB_ADMIN user has the required privileges.
• B. It fails because common users are unable to use the SET CONTAINER statement.
• C. It fails because local users are unable to use the SET CONTAINER statement.
• D. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

Answer: C

NEW QUESTION 9
You Execute the Following command to create a password file in the database server:
$ orapwd file = ‘+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12’
Which two statements are true about the password file?

• A. It records the usernames and passwords of users when granted the DBA role.
• B. It contains the usernames and passwords of users for whom auditing is enable
• C. Is used by Oracle to authenticate users for remote database administration.
• D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
• E. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

Answer: CE

NEW QUESTION 10
Which three resources might be prioritized between competing pluggable databases when creating a multitenant container database plan (CDB plan) using Oracle Database Resource Manager?

• A. Maximum Undo per consumer group
• B. Maximum Idle time
• C. Parallel server limit
• D. CPU
• E. Exadata I/O
• F. Local file system I/O

Answer: CDE

NEW QUESTION 11
You plan to migrate your database from a File system to Automata Storage Management (ASM) on same platform.
Which two methods or commands would you use to accomplish this task?

• A. RMAN CONVERT command
• B. Data Pump Export and import
• C. Conventional Export and Import
• D. The BACKUP AS COPY DATABASE . . . command of RMAN
• E. DBMS_FILE_TRANSFER with transportable tablespace

Answer: AD

NEW QUESTION 12
You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12C.
Examine the table definition:

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

• A. The valid time columns employee_time_start and employee_time_end are automatically create
• B. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
• C. The valid time columns are not populated by the Oracle Server automatically.
• D. The valid time columns are visible by default when the table is describe
• E. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.

Answer: ABE

NEW QUESTION 13
In order to exploit some new storage tiers that have been provisioned by a storage administrator, the partitions of a large heap table must be moved to other tablespaces in your Oracle 12c database?
Both local and global partitioned B-tree Indexes are defined on the table.
A high volume of transactions access the table during the day and a medium volume of transactions access it at night and during weekends.
Minimal disrupt ion to availability is required.
Which three statements are true about this requirement?

• A. The partitions can be moved online to new tablespaces.
• B. Global indexes must be rebuilt manually after moving the partitions.
• C. The partitions can be compressed in the same tablespaces.
• D. The partitions can be compressed in the new tablespaces.
• E. Local indexes must be rebuilt manually after moving the partitions.

Answer: ACD

NEW QUESTION 14
Which three statements are true concerning unplugging a pluggable database (PDB)?

• A. The PDB must be open in read only mode.
• B. The PDB must be dose
• C. The unplugged PDB becomes a non-CD
• D. The unplugged PDB can be plugged into the same multitenant container database (CDB)
• E. The unplugged PDB can be plugged into another CD
• F. The PDB data files are automatically removed from disk.

Answer: ADE

NEW QUESTION 15
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute the following command from the root container:
SQL > REVOKE create table FROM C # # A_ADMIN;
What is the result?

• A. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
• B. It fails and reports an error because the CONTAINER=ALL clause is not use
• C. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
• D. It fails and reports an error because the CONTAINER=CURRENT clause is not use
• E. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

Answer: A

NEW QUESTION 16
Identify two situations in which the alert log file is updated.

• A. Running a query on a table returns ORA-600: Internal Error.
• B. Inserting a value into a table returns ORA-01722: invalid number.
• C. Creating a table returns ORA-00955: name us already in used by an existing objects.
• D. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violate
• E. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.

Answer: AE

NEW QUESTION 17
Which two are true concerning a multitenant container database with three pluggable database?

• A. All administration tasks must be done to a specific pluggable database.
• B. The pluggable databases increase patching time.
• C. The pluggable databases reduce administration effort.
• D. The pluggable databases are patched together.
• E. Pluggable databases are only used for database consolidation.

Answer: CE

NEW QUESTION 18
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?

• A. When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically starte
• B. When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still starte
• C. When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
• D. When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

Answer: B

NEW QUESTION 19
Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

• A. By default, EM express is available for a database after database creation.
• B. You can use EM express to manage multiple databases running on the same server.
• C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.
• D. You cannot start up or shut down a database Instance by using EM express.
• E. You can create and configure pluggable databases by using EM express.

Answer: D

NEW QUESTION 20
You are administering a database and you receive a requirement to apply the following restrictions:
1.A connection must be terminated after four unsuccessful login attempts by user.
2.A user should not be able to create more than four simultaneous sessions.
3.User session must be terminated after 15 minutes of inactivity.
4.Users must be prompted to change their passwords every 15 days. How would you accomplish these requirements?

• A. by granting a secure application role to the users
• B. by creating and assigning a profile to the users and setting the REMOTE_OS_AUTHENT parameter to FALSE
• C. By creating and assigning a profile to the users and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameter to 4
• D. By Implementing Fine-Grained Auditing (FGA) and setting the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE.
• E. By implementing the database resource Manager plan and setting the SEC_MAX_FAILED_LOGIN_ATTEMPTS parameters to 4.

Answer: C

NEW QUESTION 21
Which three statements are true about Flashback Database?

• A. Flashback logs are written sequentially, and are archive
• B. Flashback Database uses a restored control file to recover a database.
• C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Are
• D. Flashback Database can recover a database to the state that it was in before a reset logs operation.
• E. Flashback Database can recover a data file that was dropped during the span of time of the flashback.
• F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.

Answer: CDF

NEW QUESTION 22
Which two statements are true about the use of the procedures listed in the v$sysaux_occupants.move_procedure column?

• A. The procedure may be used for some components to relocate component data to the SYSAUX tablespace from its current tablespace.
• B. The procedure may be used for some components to relocate component data from the SYSAUX tablespace to another tablespace.
• C. All the components may be moved into SYSAUX tablespace.
• D. All the components may be moved from the SYSAUX tablespace.

Answer: AB

NEW QUESTION 23
......