Free Oracle 1Z0-083 Practice Test & Real Exam Questions, Page 1

Question #1

You notice that the performance of your production 24/7 Oracle 12c database has 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. Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

B. Enable Memory Access Mode, which reads performance data from SGA.

C. Use emergency monitoring to fetch data directly from SGA for analysis.

D. Use Active Session History (ASH) data and hang analysis in regular performance monitoring,

E. Run ADDM in diagnostic mode.

Discussion 0

Correct Answer: C Vote an answer

Question #2

Which two are true about PDB archive files?

A. They contain all the data files only in compressed form for a PDB.

B. They contain a PDB manifest file and all the data files in compressed form for a PDB.

C. They contain all the data files only in uncompressed form for a PDB.

D. They must be created using the DBMS_PDB package.

E. They contain a PDB manifest file and all the data files in uncompressed form for a PDB.

F. DBMS_PDB.CHECK_PLUG_COMPATIBILITY can be run against a PDB archive.

Discussion 0

Correct Answer: B,F Vote an answer

Question #3

Which operating system group is NOT needed to perform an Oracle Database installation?

A. OSRACDBA

B. OSOPER

C. OSDBA

D. OSKMDBA

E. OSASM

Discussion 0

Correct Answer: B Vote an answer

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

Question #4

Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB?
(Choose two.)

A. After the change, any user with the required privilege can create an undo tablespace in the PDBs.

B. Undo tablespaces existing in PDBs must be dropped before the change.

C. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.

D. After the change, only one undo tablespace can exist in CDB$ROOT.

E. After the change, each existing PDB has to be reopened for the new undo mode to take effect.

F. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.

Discussion 0

Correct Answer: C,E Vote an answer

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

Question #5

Examine this command:
$ rhpctl move database -sourcehome Oracle_home_path -destinationhome
Oracle_home_path
For which two purposes can you use this command? (Choose two.)

A. to switch the Oracle Database home when using a centralized Rapid Home Provisioning server

B. to switch to a patched Oracle Database home

C. to switch an existing Oracle Database home to a newer release of Oracle software on the same server

D. to switch to a read-only Oracle home

E. to switch back to the previous Oracle home as part of a rollback operation

Discussion 0

Correct Answer: B,E Vote an answer

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

Question #6

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs.
How can you detect the cause of the degraded performance?

A. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis

B. by running ADDM in diagnostic mode

C. by using Active Session History (ASH) data and performing hang analysis

D. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots

Discussion 0

Correct Answer: A Vote an answer

Question #7

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: create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_time); 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 created.

B. Thesamestatementmayfilteronbothtransactiontimeandvalidtemporaltimebyusingthe 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 described.

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.

Discussion 0

Correct Answer: A,B,C Vote an answer

Question #8

Which three are true about an application container? (Choose three.)

A. It can contain multiple applications.

B. It must have an application seed PDB.

C. Two application containers can share an application seed PDB.

D. It can contain a single application.

E. An application PDB can belong to multiple application containers.

F. It must have an application root PDB.

Discussion 0

Correct Answer: A,D,F Vote an answer

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

Question #9

In performance management, which two factors might reduce the ability of an application to scale to a large number of users? (Choose two.)

A. the number of tablespaces containing tables updated by a transaction

B. poorly trained users who do not commit transactions

C. issuing multiple savepoints during a transaction

D. the number of data files containing extents belonging to tables updated by a transaction

E. poorly written SQL

Discussion 0

Correct Answer: B,E Vote an answer

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

Question #10

Which three resources are always shared among CDB$ROOT and pluggable databases (PDBs)?
(Choose three.)

A. undo tablespaces

B. SYSAUX tablespaces

C. the data dictionary in CDB$ROOT

D. the log writer process (LGWR)

E. temporary tablespaces

F. the Process Monitor Process (PMON)

Discussion 0

Correct Answer: C,D,F Vote an answer

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

Question #11

In one of your databases, unified auditing is enabled and an SH.SALES table exists. You successfully execute these commands:
SQL> CREATE AUDIT POLICY sales_pol ACTIONS select on sh.sales;
SQL> AUDIT POLICY sales_pol;
Which statement is true about SALES_POL?

A. It is only enabled for user SH.

B. Audit records are always stored in an external audit file.

C. Only successful queries of SH.SALES are written to the audit trail.

D. It is enabled for all users having SELECT privilege on SH.SALES.

Discussion 0

Correct Answer: D Vote an answer

Free Oracle 1Z0-083 Practice Test & Real Exam Questions

Download Free Oracle 1Z0-083 Demo