1Z0-083 by Oracle Actual Free Exam Q&As

Question 1

Which three are true about Oracle Restart?

A. It is used in both clustered and non-clustered environments. B. The Server Control (SRVCTL) utility can be used to start and stop Oracle Restart. C. It runs from the Oracle Grid Infrastructure home. D. It can manage Oracle Database instances, Oracle Net Listeners, and Oracle Automatic Storage Management instances. E. You can add and remove components from an Oracle Restart configuration with Server Control (SRVCTL) commands. F. If you shut down a database instance with SQL*Plus, Oracle Restart interprets this as a database failure and attempts to restart the instance.

Discussion 0

Correct Answer: A,D,E Vote an answer

Question 2

Which three are true about opatchauto? (Choose three.)

A. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked. B. It must be invoked by a user with root user privileges. C. It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations. D. Users must always input patch plans to opatchauto. E. It applies patches in nonrolling mode by default. F. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process. G. Patches are applied via opatchauto.

Discussion 0

Correct Answer: B,C,F Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

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 "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE
100M; B. BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M; C. BACKUP SPFILE SECTION SIZE 1M; D. BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M; E. BACKUP ARCHIVELOG ALL SECTION SIZE 25M; F. BACKUP TABLESPACE SYSTEM SECTION SIZE 100M; G. BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;

Discussion 0

Correct Answer: B,D,E,F Vote an answer

Question 4

Application PDBs, SALES_APP1and SALES_APP2, must be created and they must access common tables of the SALES_APPapplication.
Examine these steps:
1. Install the SALES_APPapplication, including the common tables, in the application root.
2. Install the SALES_APPapplication in the application root and the common tables in both the CDB root and the application root.
3. Create an application seed.
4. Install the SALES_APPapplication in the application seed.
5. Create the SALES_APP1and SALES_APP2application PDBs.
6. Sync the SALES_APP1and SALES_APP2application PDBs with the application root.
7. Sync the SALES_APP1and SALES_APP2application PDBs with the application seed.
8. Sync the application seed with the application root.
Which are the minimum required steps in the correct sequence?

A. 2, 5, 6 B. 1, 3, 5, 7 C. 3, 4, 1, 6, 8 D. 1, 5, 6 E. 1, 3, 5, 6, 7

Discussion 0

Correct Answer: D Vote an answer

Question 5

Which two are true about memory advisors? (Choose two.)

A. If Automatic Memory Management is enabled, the Shared Pool Advisor and Buffer Cache Advisor are available to set the maximum size for these individual System Global Area components. B. If Automatic Memory Management is enabled, no memory advisors are available. C. If Automatic Shared Memory Management is enabled, both the SGA Advisor and PGA Advisor are always available. D. If Manual Shared Memory Management is enabled, only the Shared Pool Advisor and Buffer Cache Advisor are available. E. All memory advisors use data from Automatic Workload Repository.

Discussion 0

Correct Answer: C,E Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 6

You enable Flashback Data Archive for a table for which you want to track and save all transactions for four years. After some time, the requirement changes for keeping transactions from four to two years. You execute the following command to change the requirement:
SQL> ALTER FLASHBACK ARCHIVE fdal MODIFY RETENTION 2 YEAR;
What is the outcome?

A. All the flashback data archives are purged and the subsequently created flashback archives are maintained for two years B. An error is returned because the retention period cannot be reduced. C. All historical data older than two years, if any, is archived to flashback logs and the flashback archive is set to new retention time. D. All historical data older than two years, if any, is purged from the flashback archive FDA1.

Discussion 0

Correct Answer: D Vote an answer

Question 7

Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

Which three are true? (Choose three.)

A. An application seed PDB is created for APP1. B. A default service is created for the application root APP1. C. An application root PDB is created for APP1. D. Application PDBs that are subsequently created in the APP1application container will be cloned from APP1$SEED. E. APP1 can never be unplugged. F. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

Discussion 0

Correct Answer: B,C,F Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Question 8

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. Taking a new snapshot and comparing it with a preserved snapshot. B. Compare Period ADDM report C. AWR Compare Period report D. Active Session History (ASH) report

Discussion 0

Correct Answer: C Vote an answer

Question 9

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_V.SAL column only if the SCOTT session has the MGR role set. B. Data is never redacted for the EMP_V.SAL column. C. Data is redacted for the EMP_V.SAL column only if the SCOTT session does not have the MGR role set. D. Data is redacted for the EMP.SAL column only if the SCOTT session does not have the MGR role set. E. Data is redacted for EMP.SAL column only if the SCOTT session has the MGR role set.

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).

Oracle Database Administration II - 1Z0-083 Exam Practice Test