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

Question #12

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 #13

Which three are true about Oracle Grid Infrastructure for a Standalone Server?

A. It requires Oracle ASMLibto manage Automatic Storage Management (ASM) disks.

B. It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.

C. Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installation owner.

D. It requires Oracle ASM Filter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks.

E. It requires the operating sys em oracle_base environment variable to be predefined before installation.

F. It creates one disk group during installation.

Discussion 0

Correct Answer: B,D,F Vote an answer

Question #14

Which two statements are true about RMAN duplexed backups?

A. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.

B. It is not supported for image copies.

C. It is only supported for backups to tape via the media management interface.

D. Duplex backups can contain only data files and control files.

E. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

Discussion 0

Correct Answer: B,E Vote an answer

Question #15

Examine this configuration:
1. CDB1is a container database.
2. PDB1 and PDB2are pluggable databases in CDB1.
3. PDB1 and PDB2are OPENin READ WRITEmode.
You execute these commands successfully:

Which two are true? (Choose two.)

A. PDB1 is closed.

B. Uncommitted transactions in PDB1 have been rolled back.

C. CDB1 is in MOUNT state

D. Uncommitted transactions in CDB1 and PDB1 have been rolled back.

E. CDB1 is shut down.

Discussion 0

Correct Answer: A,B Vote an answer

Question #16

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments. On further investigation, you f ind that buffer busy waits is caused by contention on data blocks.
Which option would you consider first to decrease the wait event immediately?

A. Using Automatic Segment Space Management (ASSM)

B. Decreasing PCTFREE

C. Increasing db_buffer_cache based on t he V$DB_CACHE_ADVICE recommendation

D. Decreasing PCTUSED

E. Increasing the number of DBWN process

Discussion 0

Correct Answer: A Vote an answer

Question #17

You plan to perform cross-platform PDB transport using XTTS.
Which two are true? (Choose two.)

A. The source and target platforms must have the same endianness.

B. The source PDB must be in MOUNT state.

C. The source PDB must not be an application root.

D. Automatic conversion of endianness occurs.

E. A backup of the PDB must exist, taken using the BACKUP command with the TO PLATFORM clause.

F. The source PDB can be in MOUNT or OPEN state.

Discussion 0

Correct Answer: A,B Vote an answer

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

Question #18

Which three are true about upgrading an application in an application container?

A. An application name and version number must be specified to upgrade the application.

B. An application root clone gets created automatically.

C. The upgrade can be performed when connected either to CDB$ROOT or to PDB$SEED.

D. After an application upgrade, the application container's PDBs remain synchronized with the existing application root.

E. After an application upgrade, the application container's PDBs are automatically synchronized with the application root clone.

F. The upgrade must be performed when connected to CDB$ROOT.

Discussion 0

Correct Answer: A,B,E Vote an answer

Question #19

Which two are true about duplicating pluggable databases (PDBs) with RMAN? (Choose two.)

A. All tablespaces belonging to a PDB must be duplicated when duplicating the PDB.

B. Two or more PDBs can be duplicated with the same RMAN DUPLICATE command.

C. A user with SYSDBA or SYSBACKUP must be logged in with RMAN to the PDB to duplicate it.

D. CDB$ROOT and PDB$SEED are automatically duplicated.

E. The auxiliary instance is automatically created with ENABLE_PLUGGABLE_DATABASE = TRUE.

Discussion 0

Correct Answer: B,D Vote an answer

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

Question #20

Which three are true about the tools for diagnosing Oracle Database failure situations? (Choose three.)

A. RMAN can always repair corrupt blocks.

B. The Automatic Diagnostic Repository (ADR) has a separate home directory for each instance of each Oracle product that is installed and uses it.

C. The Data Recovery Advisor uses the ADR.

D. The ADR command-line utility (ADRCI) can package incident information to send to Oracle Support.

E. Flashback commands help with repairing physical errors.

F. The ADR can store metadata in an Oracle Database repository.

Discussion 0

Correct Answer: B,C,D Vote an answer

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

Question #21

Which two are true about Rapid Home Provisioning of Oracle software? (Choose two.)

A. It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.

B. It can be used only for Oracle Grid Infrastructure, including Oracle Restart.

C. It can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle Restart.

D. It can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle Restart.

E. It can be used for applications and middleware.

Discussion 0

Correct Answer: D,E Vote an answer

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

Question #22

Which three are true about block media recovery? (Choose three.)

A. To use it, Flashback Database must be enabled.

B. The target database for which one or more blocks are to be recovered must be in the OPEN state.

C. A block being recovered is not accessible.

D. It can be performed on noncorrupt blocks.

E. It cannot repair logical corruption.

F. The data file containing the block being recovered remains online.

Discussion 0

Correct Answer: A,C,F Vote an answer

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

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

Download Free Oracle 1Z1-083 Demo