Free Oracle 1Z1-083 Test Practice Test Questions Exam Dumps [Q38-Q61]

NO.38 Automatic Shared Memory Management is disabled for one of your database instances.
SomeSQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?

NO.39 Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK DATABASE is ON. You execute these commands: $ sqlplus sys/orac1e_4U@localhost:1521/cdb1 SQL> SELECT current_scn FROM v$database; CURRENT_SCN ———————–2074756 SQL> CREATE TABLE cdb1_tab(c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> CREATE TABLE app_root_tab (c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> CREATE TABLE app_pdb1_tab (c1 NUMBER) ; Table created. SQL> conn / as sysdba Connected. SQL> ALTER PLUGGABLE DATABASE app_root CLOSE; Pluggable database altered. SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756; Flashback complete. Which table or set of tables will exist after the Flashback operation has completed?

NO.40 Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor?
(Choose two.)

NO.41 Which two are true about Oracle Database Configuration Assistant (DBCA)? (Choose two.)

NO.42 Choose three. Which three are true about Recovery Manager (RMAN) active database duplication?

NO.43 Examine these queries and their output:

An online RMAN backup of the CDB was taken an hour before Restore Point R1was created.
You want to recover PDB1 to Restore Point R1.
How do you achieve this?

NO.44 Which two are true about a Recovery Manager (RMAN) duplication without a target connection?

NO.45 Which three are true about Automatic Workload Repository (AWR)?

NO.46 Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

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

NO.48 Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

NO.49 Choose the best answer. On the 10th of August, you implement an incremental database backup strategy and configure a recovery window of five days. Level 0 backups are taken on the 10th, 17th, and 24th of August. Differential level 1 incremental backups are taken daily between the level 0 backups. Today is the 26th of August. Which backups will be obsolete?

NO.50 Which two are true about Oracle instance recovery? (Choose three.)

NO.51 When backing up to the Oracle Fast Recovery Area (FRA), you determine that the backup takes too long and suspect a performance bottleneck.
Which two are true about diagnosing and tuning these problems?

NO.52 Examine this configuration:
1. CDB1 is a container database running in archivelog mode.
2. Multiple uncommitted transactions are running in CDB1.
3. Redo log groups 1 and 2 are inactive.
4. Redo log group 3 is the current group.
All members of redo log group 3 are lost before it is archived. Examine these possible steps:
1. SHUTDOWN ABORT
2. STARTUP NOMOUNT
3. STARTUP MOUNT
4. ALTER DATABASE MOUNT
5. RESTORE DATABASE
6. RECOVER DATABASE NOREDO
7. RECOVER DATABASE UNTIL AVAILABLE
8. RESTORE ARCHIVELOG ALL
9. ALTER DATABASE OPEN
10. ALTER DATABASE OPEN RESETLOGS
Choose the minimum required steps in the correct order to recover the database.

NO.53 Which three are true about requirements for various FLASHBACKoperations? (Choose three.)

NO.54 Choose two. Which two are true about RMAN duplexed backup sets?

NO.55 Which two are true about the Oracle database methodology? (Choose two.)

NO.56 Choose three. Which three are true about using Database Upgrade Assistant (DBUA) to upgrade a database?

NO.57 Choose three. You must migrate a non-CDB Oracle 11g Database to a CDB without first performing an upgrade to the non-CDB. User-defined objects are stored in several tablespaces in the non-CDB. Which three methods can you use?

NO.58 Choose three. Which three are true about a whole database backup?

NO.59 Which two are true about gathering optimizer statistics?

NO.60 Choose two. Which two are true about RMAN persistent configuration settings, administration, and their effects?

NO.61 Which three are true about performing an Oracle Database install on Linux? (Choose three.)