NEW QUESTION 1
In your database, USERS is the default permanent tablespace. Examine the commands and their outcome:

You plan to execute the commands:

Which two statements are true? (Choose two.)

• A. The MYTAB table is created in the SYSTEM tablespace but no rows can be inserted into the table by USER02.
• B. The MYTAB table is created in the SYSTEM tablespace and rows can be inserted into the table by USER02.
• C. The MYTAB table is created in the USERS tablespace but no rows can be inserted into the table by USER02.
• D. The CREATE TABLE statement generates an error because the SYSDBA privilege does not provide any space quota on the SYSTEM tablespace by default.
• E. The MYTAB table is owned by the SYS use

Answer: BE

NEW QUESTION 2
You executed the following command to create a password file in the database server:
$ orapwd file = orapworcl entries = 5 ignorecase=N
Which statement describes the purpose of the above password file?

• A. It records usernames and passwords of users when granted the DBA role
• B. It contains usernames and passwords of users for whom auditing is enabled
• C. It is used by Oracle to authenticate users for remote database administrator
• D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups

Answer: C

NEW QUESTION 3
Which two statements are true about the Database Configuration Assistant (DBCA)? (Choose two.)

• A. It can be used to create a database template from an existing database.
• B. It can be used to add a new tablespace.
• C. It can generate SQL database creation scripts.
• D. It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.
• E. It can configure Automatic Storage Management (ASM) diskgroups.

Answer: AC

Explanation: References: https://docs.oracle.com/cd/E17559_01/em.111/e16599/appdx_creating_db_templates.htm#CJACEDCD

NEW QUESTION 4
Which background process does Automatic Shared Memory Management use to coordinate the sizing of memory components?

• A. PMON
• B. SMON
• C. MMNL
• D. MMAN
• E. MMON

Answer: D

NEW QUESTION 5
You executed the following query:
SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG;
Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

• A. The time when the last flashback operation in your database was performed
• B. The time when the first flashback operation in our database was performed
• C. The approximate time and the lowest system change number (SCN) to which you can flash back your database
• D. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance

Answer: C

NEW QUESTION 6
The HR user owns the BONUSES table. HR grants privileges to the user TOM by using the command: SQL> GRANT SELECT ON bonuses TO tom WITH GRANT OPTION;
TOM then executes this command to grant privileges to the user JIM: SQL> GRANT SELET ON hr.bonuses TO jim; Which statement is true?

• A. TOM cannot revoke the SELECT ON HR.BONUSES privilege from JIM.
• B. HR can revoke the SELECT ON HR.BONUSES privilege from JIM.
• C. JIM can grant the SELECT ON HR.BONUSES privilege to other users, but cannot revoke the privilege from them.
• D. HR can revoke the SELECT ON HR.BONUSES privilege from TOM, which will automatically revoke the SELECT ON HR.BONUSES privilege from JIM.

Answer: D

NEW QUESTION 7
One of your databases supports an OLTP workload. The default UNDO tablespace is fixed size with:
1. RETENTION NOGUARANTEE
2. UNDO_RETENTION is 12 minutes
User SCOTT gets this error after a query on the SALES table has run for more than 15 minutes: ORA-01555: snapshot too old
Which three factors taken separately or in some combination might be the cause? (Choose three.)

• A. An update was made to the SALES table after the query began
• B. An update to the SALES table was committed after the query began
• C. A committed delete to the SALES table was made more than 12 minutes before the query began
• D. An uncommitted update to the SALES table was made more than 12 minutes before the query began
• E. A committed update to the SALES table was made more than 12 minutes before the query began
• F. An uncommitted delete to the SALES table was made more than 12 minutes before the query began
• G. An update was made to the SALES table before the query began

Answer: ADE

NEW QUESTION 8
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) violated.
• E. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.

Answer: AE

Explanation: The alert log is a chronological log of messages and errors, and includes the following items:
*All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur
* Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements
* Messages and errors relating to the functions of shared server and dispatcher processes
* Errors occurring during the automatic refresh of a materialized view
* The values of all initialization parameters that had nondefault values at the time the database and instance start Note:
* The alert log file (also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file is: database startup, shutdown, log switches, space errors, etc. This file should constantly be monitored to detect unexpected messages and corruptions.

NEW QUESTION 9
Which two statements are true about a server parameter file (SPFILE)? (Choose two.)

• A. An SPFILE can be created from a PFILE or from memory.
• B. A PFILE can be used to start up a database instance even if an SPFILE exists.
• C. An SPFILE must reside in the ORACLE_HOME/dbs directory.
• D. An SPFILE can be created only before a database instance is started.
• E. An SPFILE contains only those dynamic parameters that can be changed without having to restart the database instance.

Answer: AB

NEW QUESTION 10
Which two services may you see on the My Service Dashboard page? (Choose two.)

• A. Network Cloud Service
• B. User Cloud Service
• C. Compute Cloud Service
• D. Database Cloud Service

Answer: CD

NEW QUESTION 11
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it. This consumes a lot of undo tablespace and generates lots of redo.
Which two actions would you take to solve this problem? (Choose two.)

• A. Increase the size of the temporary tablespace.
• B. Enable Automatic Memory Management (AMM).
• C. Enable undo retention guarantee.
• D. Enable temporary undo for the database.
• E. Increase the size of the redo log buffe

Answer: AD

NEW QUESTION 12
Which Oracle Database component is audited by default if the unified Auditing option is enabled?

• A. Oracle Data Pump
• B. Oracle Recovery Manager (RMAN)
• C. Oracle Label Security
• D. Oracle Database Vault
• E. Oracle Real Application Security

Answer: B

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

• 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 tablespac

Answer: AB

NEW QUESTION 14
In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.
How would you accomplish this?

• A. Setting a metric threshold
• B. Implementing Database Resource Manager
• C. Enabling resumable timeout for user sessions
• D. Decreasing the value of the IDLE_TIME resource limit in the default profile

Answer: B

NEW QUESTION 15
Which three statements are true about adaptive SQL plan management? (Choose three.)

• A. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
• B. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
• C. It adds new, bettor plans automatically as fixed plans to the baseline.
• D. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
• E. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

Answer: ADE

Explanation: With adaptive SQL plan management, DBAs no longer have to manually run the verification or evolve process for non- accepted plans. When automatic SQL tuning is in COMPREHENSIVE mode, it runs a verification or evolve process for all SQL statements that have non-accepted plans during the nightly maintenance window. If the non-accepted plan performs better than the existing accepted plan (or plans) in the SQL plan baseline, then the plan is automatically accepted and becomes usable by the optimizer. After the verification is complete, a
persistent report is generated detailing how the non-accepted plan performs compared to the accepted plan performance. Because the evolve process is now an AUTOTASK, DBAs can also schedule their own evolve job at end time.
Note:
* The optimizer is able to adapt plans on the fly by predetermining multiple subplans for portions of the plan.
* Adaptive plans, introduced in Oracle Database 12c, enable the optimizer to defer the final plan decision for a statement until execution time. The optimizer instruments its chosen plan (the default plan) with statistics collectors so that it can detect at runtime, if its cardinality estimates differ greatly from the actual number of rows seen by the operations in the plan. If there is a significant difference, then the plan or a portion of it will be automatically adapted to avoid suboptimal performance on the first execution of a SQL statement.

NEW QUESTION 16
Which three statements are true about the Pre-Upgrade Information Tool? (Choose three.)

• A. It generates a script to recompile invalid objects post-upgrade.
• B. The preupgrade_fixups.sql script is created to list and describe issues in the source database.
• C. A log file, preupgrade.log, is created that contains the output of the Pre-Upgrade Information tool.
• D. It checks for required tablespaces and if they are not available, creates them automatically.
• E. The preupgrade_fixups.sql script is executed automatically to fix issues in the source database.
• F. The postupgrade_fixups.sql script is created to address issues that can be fixed after a database has been upgraded.

Answer: ACE

Explanation: References https://docs.oracle.com/database/122/UPGRD/using-preupgrade-information-tool-for-oracle- database.htm#UPG

NEW QUESTION 17
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? (Choose two.)

• 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

Explanation: Note:
* DBMS_REDACT.FULL completely redacts the column data.
* DBMS_REDACT.NONE applies no redaction on the column data. Use this function for development testing purposes. LOB columns are not supported.
* The DBMS_REDACT package provides an interface to Oracle Data Redaction, which enables you to mask (redact) data that is returned from queries issued by low-privileged users or an application.
* If you create a view chain (that is, a view based on another view), then the Data Redaction policy also applies throughout this view chain. The policies remain in effect all of the way up through this view chain, but if another policy is created for one of these views, then for the columns affected in the subsequent views, this new policy takes precedence.

NEW QUESTION 18
Which task would you recommend before using the Database Upgrade Assistant (DBUA) to upgrade a single-instance Oracle 11g R2 database to Oracle Database 12c?

• A. shutting down the database instance that is being upgraded
• B. executing the catctl.pl script to run the upgrade processes in parallel
• C. running the Pre-Upgrade Information Tool
• D. copying the listener.ora file to the new ORACLE_HOME

Answer: C

Explanation: References:
http://docs.oracle.com/cd/E11882_01/server.112/e23633/upgrade.htm#UPGRD12395