Practice 1Z0-083 Questions With Certification guide Q&A from Training Expert ValidDumps
Free Oracle 1Z0-083 Test Practice Test Questions Exam Dumps
Understanding functional and technical aspects of Oracle Database Administration II Exam Number: 1Z0-083
The following will be discussed in the ORACLE 1Z0-083 dumps:
- Creating an Oracle Database by using DBCA
- Oracle Database: Deploy, Patch and Upgrade Workshop
- Transporting Data
- Diagnosing Failures
- Duplicating a Database
- Patching Grid Infrastructure and Oracle Database
- Performing Recovery
- Using Flashback Technologies
- Restore and Recovery Concepts
- RMAN Troubleshooting and Tuning
NEW QUESTION 29
Which two are true about changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)
- A. After the change, only one undo tablespace can exist in CDB$ROOT.
- B. After the change, each existing PDB has to be reopened for the new undo mode to take effect.
- C. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
- D. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
- E. Undo tablespaces existing in PDBs must be dropped before the change.
- F. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
Answer: C,D
NEW QUESTION 30
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)
- A. AWR snapshots must be deleted when no longer required by ADDM.
- B. ADDM can recommend extending the buffer cache.
- C. ADDM performs its analysis only when a DBA requests it.
- D. By default, AWR snapshots are automatically purged after eight days.
- E. By default, MMON creates an AWR snapshot every 30 minutes.
- F. ADDM can recommend shrinking the buffer cache.
Answer: A,D,F
Explanation:
Explanation/Reference: https://books.google.com.pk/books?id=DeQkU5E75DUC&pg=PA869&lpg=PA869&dq=By+default,
+AWR+snapshots+are+automatically+purged+after+eight
+days&source=bl&ots=DfoGmJfCMy&sig=ACfU3U0Pf2RgIs72LUV4HUzs5UIXI8sXEQ&hl=en&sa=X&ved=2ah UKEwjb8bKhu9noAhUwTxUIHRpYAuMQ6AEwA3oECAsQLA#v=onepage&q=By%20default%2C%20AWR%
20snapshots%20are%20automatically%20purged%20after%20eight%20days&f=false
NEW QUESTION 31
Which three are true? (Choose three.)
- A. Application-common TSDP policies are always container specific.
- B. Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.
- C. Application-common OLS policies can be created in an application root inside an install/patch BEGIN-END block.
- D. Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.
- E. Unified auditing can be automatically synchronized to all application PDBs in an application container.
- F. Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.
- G. Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.
Answer: B,E,F
NEW QUESTION 32
Automatic Shared Memory Management is disabled for one of your database instances.
Some SQL statements perform poorly due to excessive hard parse activity, thereby degrading performance.
What would be your next step?
- A. Run the SQL Tunning Advisor.
- B. Run the Memory Advisor for the Program Global Area.
- C. Run the SQL Access Advisor.
- D. Run the Memory Advisor for the shared pool.
- E. Run the Memory Advisor for the System Global Area.
Answer: D
NEW QUESTION 33
Examine the command for creating pluggable database PDB2 in container database CDB2.
Select three options, any one of which is required for it to execute successfully. (Choose three.)
- A. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
- B. Add the FILE_NAME_CONVERT clause to the statement and enable Oracle Managed Files (OMF)
- C. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
- D. Set only the PDB_FILE_NAME_CONVERT parameter.
- E. Add only the CREATE_FILE_DEST clause to the statement.
- F. Enable only OMF.
Answer: A,E,F
NEW QUESTION 34
Which three are located by using environment variables? (Choose three.)
- A. the Optimal Flexible Architecture (OFA) compliant path to store Oracle software and configuration files.
- B. default directories for temporary files used by temporary tablespaces
- C. the list of a disk group names to be mounted by an Oracle Automatic Storage Management (ASM) instance at startup
- D. the maximum number of database files that can be opened by a database instance
- E. the temporary disk space used by Oracle Installer during installation
- F. the location of Oracle Net Services configuration files
Answer: B,D,F
NEW QUESTION 35
A container database (CDB) contains two pluggable databases PDB1 and PDB2.
The LOCAL_UNDO_ENABLED database property is set to FALSE in the CDB. Data file 24 of PDB2 was deleted and you need to restore and recover it.
The only RMAN backup that exists was created with the BACKUP DATABASE command while connected to CDB$ROOT.
Which three are true? (Choose three.)
- A. Data file 24 can be restored and recovered while connected to CDB$ROOT.
- B. Data file 24 can be recovered while connected to PDB2.
- C. Data file 24 can be recovered only while connected to PDB2.
- D. Data file 24 can be restored only while connected to CDB$ROOT.
- E. Data file 24 can be restored only while connected to PDB2.
- F. Data file 24 can be recovered while connected to CDB$ROOT.
Answer: A,E,F
NEW QUESTION 36
You issued this command:
RMAN> BACKUP RECOVERY AREA FORCE;
Which three are true? (Choose three.)
- A. All files in any previous FRA that have not yet been backed up, are backed up.
- B. All Oracle recovery files normally written to the FRA and which have been backed up already to the current FRA, are backed up.
- C. All Oracle recovery files normally written to the FRA and which have not yet been backed up, are backed up.
- D. All Oracle recovery files normally written to the FRA and which have been backed up already to in any previous FRA, are backed up.
- E. All files in any previous FRA that have been backed up already, are backed up.
- F. All files in the current FRA that have been backed up already, are backed up.
- G. All files in the current fast recovery area (FRA) that have not yet been backed up, are backed up.
Answer: C,E,G
NEW QUESTION 37
Examine this configuration:
1. The orcl database data files are in Automatic Storage Management (Oracle ASM) disk group +data.
2. orcl uses disk group +fra for the Fast Recovery Area.
3. listener is the listener for orcl.
4. The database, listener, ASM instance, and ASM disk groups are managed by Oracle Restart.
5. All components are currently shut down.
You execute this command:
$ srvctl start database -d ORCL
What is the outcome?
- A. The ORCL database, the Oracle ASM instances, the +data and +fra disk groups, and the listener are started.
- B. Only the orcl database instance and the +data and +fra disk groups are started.
- C. Only the orcl database and the ASM instances are started.
- D. Only the orcl database instance, the Oracle ASM instance, and the +data and +fra disk groups are started.
- E. Only the orcl database instance is started.
Answer: A
NEW QUESTION 38
Which two are true about monitoring waits for sessions and services?
- A. v$session_wait and v$session both contain details of the event on which a waiting session is currently waiting.
- B. v$session_wait and v$session both contain details of the event on which a non-waiting session last waited.
- C. v$session_event displays all waits for all past and existing sessions if the wait has occurred at least once for a session.
- D. v$session_wait_class displays waits broken down by wait class only for waiting sessions.
- E. v$service_event displays wait counts for every wait event whether waited on or not, for each service.
Answer: C,E
NEW QUESTION 39
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:
Which table or set of tables will exist after the Flashback operation has completed?
- A. none of the tables, because all three tables will be dropped
- B. CDB1_TAB only
- C. CDB1_TAB and APP_PDB1_TAB
- D. CDB1_TAB and APP_ROOT_TAB
- E. CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB
Answer: E
NEW QUESTION 40
Which three are true about opatchauto? (Choose three.)
- A. It performs a shutdown and then a restart of all processes in both Oracle Grid Infrastructure and Oracle Database home during the patching process.
- B. It must be invoked by a user with root user privileges.
- C. Users must always input patch plans to opatchauto.
- D. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
- E. It applies patches in nonrolling mode by default.
- F. It is used to apply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.
- G. Patches are applied via opatchauto.
Answer: B,D,G
NEW QUESTION 41
Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)
- A. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
- B. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
- C. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
- D. A DBA must specify either a redundancy retention policy or a recovery window retention policy.
- E. The RMAN SHOW ALL command displays only settings with nondefault values.
- F. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
- G. A target database's persistent RMAN configuration settings are always stored in the target's control file
Answer: A,B,G
NEW QUESTION 42
Which two are true about the Automatic Database Diasnostic Monitor (ADDM)? (Choose two.)
- A. Results are written to the alert log.
- B. It analyzes a period of time corresponding to the last day of activity.
- C. It runs automatically after each AWR snapshot.
- D. A DBA can run it manually.
- E. It analyzes a period of time corresponding to the 12 hours of activity.
Answer: A,C
NEW QUESTION 43
A user complains about poor database performance.
You want to verify if the user's session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?
- A. V$SESSION
- B. V$SESSTAT
- C. V$SESSION_WAIT
- D. V$SESSION_EVENT
- E. V$SESSION_WAIT_CLASS
Answer: E
NEW QUESTION 44
The users tablespace consists of data files 3 and 4 and must always be online in read/write mode. Which two are true about using RMAN to perform an open database back up of this tablespace?
- A. Backups must be contained in backup sets.
- B. The database must be registered in an RMAN catalog.
- C. Backups can be taken only if the database is in archivelog mode.
- D. Backups can be done incrementally.
- E. Only consistent backups can be created.
- F. Backups must be done incrementally.
Answer: C,D
NEW QUESTION 45
Which three are true about the SQL Tuning Advisor? (Choose three.)
- A. It considers all SQL statements being analyzed by the advisor task as a group.
- B. It checks each query being analyzed for missing statistics.
- C. It only recommends syntactic changes to SQL statements.
- D. It checks each query being analyzed for stale statistics.
- E. It builds SQL profiles for each poorly performing SQL statement to prevent regressions.
- F. It can recommend semantic changes to SQL statements.
Answer: B,D,E
Explanation:
Reference:
https://docs.oracle.com/database/121/TGSQL/tgsql_sqltune.htm#TGSQL540
NEW QUESTION 46
Which three are true about transporting databases across platforms using Recovery Manager (RMAN) image copies? (Choose three.)
- A. Data files can be converted on the source system.
- B. The password file is automatically converted by RMAN.
- C. Databases can be transported between systems with different endian formats.
- D. A new DBID is automatically created for the transported database.
- E. Data files can be converted on the destination system.
- F. By default, the transported database will use Oracle Managed Files (OMF)
Answer: A,C,E
Explanation:
Password file is automatically converted by RMAN.
NEW QUESTION 47
Which two are true about unplugging an application container from a container database and plugging it into a different container database?
- A. The application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.
- B. It requires local undo mode in both container databases.
- C. Unplugging the application root from a CDB unplugs all its application PDBs.
- D. It requires only local undo mode in the database where the application container will be unplugged.
- E. Plugging the application root into a different CDB plugs In all its application PDBs.
- F. Application PDBs In the application container must be unplugged before the application root Is unplugged.
Answer: C,F
NEW QUESTION 48
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)
- A. AWR snapshots must be deleted when no longer required by ADDM.
- B. ADDM can recommend extending the buffer cache.
- C. ADDM performs its analysis only when a DBA requests it.
- D. By default, AWR snapshots are automatically purged after eight days.
- E. By default, MMON creates an AWR snapshot every 30 minutes.
- F. ADDM can recommend shrinking the buffer cache.
Answer: B,D,F
NEW QUESTION 49
Which two are true about Optimizer Statistics? (Choose two.)
- A. They are gathered by the SQL Tuning Advisor.
- B. They are ignored by Optimizer if they are stale.
- C. They provide real-time data about schema objects.
- D. They can be gathered by the DBMS_STATS package.
- E. By default, they are automatically gathered by a maintenance job.
Answer: D,E
NEW QUESTION 50
......
Certification Path for Oracle Database Administration II Exam Number: 1Z0-083
Oracle Database Administration II Exam Number: 1Z0-083 is an advanced exam. Successful completion by candidates of Data Administrator I and II will allow them to achieve Oracle Certified Database Administrator status.
Average Salary of Oracle Database Administration II Exam Number: 1Z0-083 Certified Professionals
The average salary is between $69k and $127k.
Prepare Top Oracle 1Z0-083 Exam Audio Study Guide Practice Questions Edition: https://www.validdumps.top/1Z0-083-exam-torrent.html
Dumps Practice Exam Questions Study Guide for the 1Z0-083 Exam: https://drive.google.com/open?id=1HpUS7-hD-iEz4fQDOEfzejv9rHkIXHeX