NEW QUESTION 1
Your 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?

• A. Oracle Data Pump.
• B. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD to move the indexes.
• C. An ALTER TABLE MOVE to move the table and ALTER INDEX REBUILD ONLINE to move the indexes.
• D. Online Table Redefinition.
• E. Edition-Based Table Redefinition.

Answer: D

NEW QUESTION 2
You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:

Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?

• A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
• B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
• C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
• D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
• E. Re-create the password file in the Oracle Database 12c format.

Answer: BD

NEW QUESTION 3
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

• A. Tracking the most recent read time for a table segment in a user tablespace
• B. Tracking the most recent write time for a table segment in a user tablespace
• C. Tracking insert time by row for table rows
• D. Tracking the most recent write time for a table block
• E. Tracking the most recent read time for a table segment in the SYSAUX tablespace
• F. Tracking the most recent write time for a table segment in the SYSAUX tablespace

Answer: ABD

NEW QUESTION 4
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 5
You execute the following piece of code with appropriate privileges:

User SCOTT has been granted the CREATE SESSION privilege and the MGR role.
Which two statements are true when a session logged in as SCOTT queries the SAL column in the view and the table?

• A. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set.
• B. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.
• C. Data is never redacted for the EMP_V.SAL column.
• D. Data is redacted for the EMP_V.SAL column only if the SCOTT session has the MGR role set.
• E. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set.

Answer: AC

NEW QUESTION 6
In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20.
Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

• A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• B. Setting the target tablespace to read-only
• C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED
• D. Setting the target tablespace offline
• E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

Answer: BC

NEW QUESTION 7
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 8
Your multitenant container (CDB) containing three pluggable databases (PDBs) is running in ARCHIVELOG mode. You find that the SYSAUX tablespace is corrupted in the root container.
The steps to recover the tablespace are as follows:
\1.Mount the CDB.
\2.Close all the PDBs.
\3.Open the database.
\4.Apply the archive redo logs.
\5.Restore the data file.
\6.Take the SYSAUX tablespace offline.
\7.Place the SYSAUX tablespace online.
\8.Open all the PDBs with RESETLOGS.
\9.Open the database with RESETLOGS.
\10.Execute the command SHUTDOWN ABORT.
Which option identifies the correct sequence to recover the SYSAUX tablespace?

• A. 6, 5, 4, 7
• B. 10, 1, 2, 5, 8
• C. 10, 1, 2, 5, 4, 9, 8
• D. 10, 1, 5, 8, 10

Answer: A

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

• A. Re-enable redaction policies that use FULL data redaction.
• B. Re-create redaction policies that use FULL data redaction.
• C. Re-connect the sessions that access objects with redaction policies defined on them.
• D. Flush the shared pool.
• E. Restart the database instance.

Answer: E

NEW QUESTION 10
Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

Which three are prerequisites for successful execution of the command?

• A. The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.
• B. All the user-defined tablespaces must be in read-only mode on the source database.
• C. The export dump file must be created before starting the import on the target database.
• D. The source and target database must be running on the same platform with the same endianness.
• E. The path of data files on the target database must be the same as that on the source database.
• F. The impdp operation must be performed by the same user that performed the expdp operation.

Answer: ABD

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

• A. Only 1
• B. Only 2
• C. Only 3
• D. 3 and 1
• E. 1 and 2

Answer: D

NEW QUESTION 12
You notice that the performance of your production 24/7 Oracle database significantly degradeD. Sometimes you are not able to connect to the instance because it hangs. You do not want to restart the database instance.
How can you detect the cause of the degraded performance?

• A. Enable Memory Access Mode, which reads performance data from SG
• B. Use emergency monitoring to fetch data directly from SGA analysis.
• C. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
• D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
• E. Run ADDM in diagnostic mode.

Answer: B

NEW QUESTION 13
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 14
You use the segment advisor to help determine objects for which space may be reclaimeD. Which three statements are true about the advisor given by the segment advisor?

• A. It may advise the use of online table redefinition for tables in dictionary managed tablespace.
• B. It may advise the use of segment shrink for tables in dictionary managed tablespaces it the no chained rows.
• C. It may advise the use of online table redefinition for tables in locally managed tablespaces
• D. It will detect and advise about chained rows.
• E. It may advise the use of segment shrink for free list managed tables.

Answer: ADE

NEW QUESTION 15
You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.
Which method or feature should you use?

• A. Compare Period ADDM report
• B. AWR Compare Period report
• C. Active Session History (ASH) report
• D. Taking a new snapshot and comparing it with a preserved snapshot

Answer: B

NEW QUESTION 16
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 17
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?

• A. The ASM compatibility attribute controls the format of the disk group metadat
• B. RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group.
• C. The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group.
• D. The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group.
• E. The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10 g database.

Answer: ABD

NEW QUESTION 18
The following parameter are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE
You want to manage the SQL plan evolution task manually. Examine the following steps:
1. Set the evolve task parameters.
2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function.
3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function.
4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function.
5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps:

• A. 2, 4, 5
• B. 2, 1, 4, 3, 5
• C. 1, 2, 3, 4, 5
• D. 1, 2, 4, 5

Answer: B