QUESTION NO: 1
You have a production Oracle 12c database running on a host.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1. Create directory structures similar to the production database on all new machines.
2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3. Create a database clone template for the database.
4. Run the Database Configuration Assistant (DBCA) to create the database.
5. Run OUI in graphical mode on each machine.
6. Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.
You have a production Oracle 12c database running on a host.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed. You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1. Create directory structures similar to the production database on all new machines.
2. Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3. Create a database clone template for the database.
4. Run the Database Configuration Assistant (DBCA) to create the database.
5. Run OUI in graphical mode on each machine.
6. Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.
Correct Answer: B
Vote an answer
QUESTION NO: 2
Which two statements are true about the (PMON) background process in Oracle Database 12c? (Choose two.)
Which two statements are true about the (PMON) background process in Oracle Database 12c? (Choose two.)
Correct Answer: D,E
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 3
Which Oracle Database component is audited by default if the unified Auditing option is enabled?
Which Oracle Database component is audited by default if the unified Auditing option is enabled?
Correct Answer: A
Vote an answer
QUESTION NO: 4
Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:
What are three possible causes for the latch-related wait events?
Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:
What are three possible causes for the latch-related wait events?
Correct Answer: A,B,E
Vote an answer
QUESTION NO: 5
Examine the parameters:
Your database instance is started with a PFILE.
You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
Which is the outcome?
Examine the parameters:
Your database instance is started with a PFILE.
You want to increase the size of the buffer cache. Free memory is available to increase the size of the buffer cache.
You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
Which is the outcome?
Correct Answer: D
Vote an answer
QUESTION NO: 6
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
Which two statements are true? (Choose two.)
Examine the resources consumed by a database instance whose current Resource Manager plan is displayed.
Which two statements are true? (Choose two.)
Correct Answer: B,C
Vote an answer
QUESTION NO: 7
Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration? (Choose four.)
Which four operations performed after the Oracle Restart installation are automatically added to the Oracle Restart configuration? (Choose four.)
Correct Answer: A,B,E,F
Vote an answer
Explanation: Only visible for Actual4test members. You can sign-up / login (it's free).
QUESTION NO: 8
In one of your databases, unified auditing is enabled and an SH.SALES table exists.
You can successfully execute these commands:
Which statement is true about SALES_POL?
In one of your databases, unified auditing is enabled and an SH.SALES table exists.
You can successfully execute these commands:
Which statement is true about SALES_POL?
Correct Answer: D
Vote an answer
QUESTION NO: 9
In your database, archive logging and control file autobackup are enabled.
The data files and redo log files are intact but control files are impacted due to media failure.
In which two recovery scenarios must you use the RESETLOGS option? (Choose two.)
In your database, archive logging and control file autobackup are enabled.
The data files and redo log files are intact but control files are impacted due to media failure.
In which two recovery scenarios must you use the RESETLOGS option? (Choose two.)
Correct Answer: A,B
Vote an answer