Oracle Oracle Certifications 1Z0-083 Questions & Answers

• Question 131:

  Which three are true about Oracle Restart? (Choose three).

  A. It can be configured to automatically attempt to restart various components after a hardware or software failure.

  B. While starting any components, it automatically attempts to start all dependencies first and in proper order.

  C. It runs from the Oracle Grid Infrastructure home.

  D. If you shut down a database instance with SQL*Plus, Oracle Restart interprets this as a database failure and attempts to restart the instance.

  E. The Server Control (SRVCTL) utility can be used to start and stop Oracle Restart.

  F. It runs periodic check operations to monitor the health of Oracle components.

  Correct Answer: ABF

• Question 132:

  Which two statements are true about the Database Configuration Assistant (DBCA)?

  A. It can configure Automatic Storage Management (ASM) diskgroups.

  B. It can be used to copy an existing Oracle database to a new host and apply any patches necessary in the new host.

  C. It can be used to add a new tablespace.

  D. It can be used to create a database template from an existing database.

  E. It can generate SQL database creation scripts.

  Correct Answer: DE

• Question 133:

  You execute this command successfully:

  SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

  What is the outcome?

  A. It creates a binary backup of the control file.

  B. It updates the alert log with the location and contents of the control file

  C. It creates a file that contains SQL statements to re-create the control file.

  D. It creates a file that contains RMAN scripts to create a duplicate database.

  E. It creates a copy of the control file in the fast recovery area (FRA).

  Correct Answer: C

• Question 134:

  Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)?

  A. Tracking the most recent read time for a table segment in a user tablespace

  B. Tracking the most recent write time for a table segment in a user tablespace

  C. Tracking insert time by row for table rows

  D. tracking the most recent write time for each block in a table segment

  E. Tracking the most recent read time for a table segment in the SYSTEM tablespace

  F. Tracking the most recent write time for a table segment in the SYSAUX tablespace Correct

  Correct Answer: ABD

• Question 135:

  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. Decreasing PCTUSED

  B. Decreasing PCTFREE

  C. Increasing the number of DBWN process

  D. Using Automatic Segment Space Management (ASSM)

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

  Correct Answer: D

• Question 136:

  (Choose two) You configured the Fast Recovery Area (FRA) for your database. The database instance is in ARCHIVELOG mode. The default location for the archived redo log files is the FRA.

  Which two files are removed automatically if space is required in the FRA as per the retention policy?

  A. user-managed backups of data files and control files

  B. flashback logs

  C. RMAN backups that are obsolete

  D. archived redo log files that have multiple copies in a different archive location

  Correct Answer: BC

• Question 137:

  You want to create a test database as a replica of your production database with minimum intervention from a DBA. Which method would you use?

  A. Use DBCA to create a template from the existing database to contain the database structure with data files and then use the same template to create the database in the new location.

  B. Use Database Configuration Assistant (DBCA) to create a template from the existing database to contain the database structure.

  C. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

  D. Use DBCA to create a template from the existing database to contain the database structure and then manually copy the data by using Oracle Data Pump.

  Correct Answer: A

• Question 138:

  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 to fetch information from the latest Automatic Workload Repository (AWR) snapshots

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

  D. by running ADDM in diagnostic mode

  Correct Answer: A

• Question 139:

  Examine the query and its output executed In an RDBMS Instance:

  

  Which three statements are true about the users (other than sys) in the output?

  A. TheC# # B_ADMIN user can perform all back up and recovery operation susing RMAN only.

  B. The C # # C_ADMIN user can perform the data guard operation with Data Guard Broker.

  C. The C # # A_ADMIN user can perform wallet operations.

  D. The C # # D_ADMIN user can perform backup and recovery operations for Automatic Storage Management (ASM).

  E. The C # # B_ADMIN user can perform all backup and recovery operations using RMAN or SQL* Plus.

  Correct Answer: BCE

• Question 140:

  You are working on an Oracle Database 19c database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two).)

  A. Flashback logs are not archived.

  B. Flashback logs are maintained in redo log files.

  C. Flashback logs are maintained in the Flash Recovery Area.

  D. Flashback logs are used to maintain Flashback Database related errors.

  E. Flashback logs need to be cleared manually after you disable Flashback Database.

  Correct Answer: AC