1Z0-083 Practice Exam Tests Latest Updated on Nov-2021
Pass 1Z0-083 Exam in First Attempt Guaranteed Dumps!
How to book the Oracle Database Administration II Exam Number: 1Z0-083
You can schedule the exam anytime at Pearson VUE. You can pay directly from a credit card or redeem a voucher purchased from Oracle.
NEW QUESTION 58
Which two are true about common objects? (Choose two.)
- A. They can be only metadata-linked in an application container.
- B. They can exist in user-defined schemas only in application containers.
- C. They can be created only in CDB$ROOT.
- D. They can exist in CDB$ROOT and an application root.
- E. They can be created only in an application root.
- F. They can be extended data-linked in CDB$ROOT.
Answer: B,E
Explanation:
Reference:
https://blog.toadworld.com/2017/08/01/oracle-multi-tenant-application-containers-part-iii-sharing- of-data-in-application-common-objects
NEW QUESTION 59
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.
- A. 1, 3, 5, 7, 10
- B. 1, 3, 5, 6, 10
- C. 1, 2, 5, 7, 4, 10
- D. 1, 3, 5, 6, 9
- E. 1, 3, 5, 6, 10
- F. 1, 3, 5, 8, 6, 10
Answer: B
NEW QUESTION 60
For which two requirements can you use the user_tablespaces clause with the create pluggable database command?
- A. to exclude a temp tablespace when plugging in a PDB
- B. to specify the list of tablespaces to include when creating a PDB from the CDB seed
- C. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
- D. to specify a default tablespace in a PDB cloned from another PDB in the same CDB
- E. to include specific user tablespaces only when relocating a PDB
- F. to exclude all tablespaces except system, sysaux, and temp when plugging in a PDB
Answer: A,F
NEW QUESTION 61
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 62
Which two are true about OS groups and users for Oracle Grid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)
- A. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
- B. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
- C. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.
- D. The Oracle Grid Infrastructure installation must be owned by the grid user.
- E. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
- F. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
Answer: A,C
NEW QUESTION 63
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 64
Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)
- A. Flashback logs are automatically purged whenever the value of
DB_FLASHBACK_RETENTION_TARGET is changed. - B. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET only after there is space pressure.
- C. Flashback logs are monitored and proactively deleted when beyond the retention period defined in DB_FLASHBACK_RETENTION_TARGET before there is space pressure.
- D. Flashback logs are monitored for being older than the retention period defined in DB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.
- E. Flashback logs are automatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.
Answer: A,B
NEW QUESTION 65
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
- A. New templates can only be created by modifying an existing user-created template.
- B. Oracle DBCAtemplates can be used to create new databases and duplicate existing databases.
- C. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
- D. Oracle DBCA templates can store only logical structure and not database files.
- E. The Data Warehouse template is most suitable when transaction response time is the key criterion.
Answer: B,C
NEW QUESTION 66
Which three are true about Database Point-in-Time Recovery? (Choose three.)
- A. The database must be open RESETLOGS after Database Point-in-Time Recovery.
- B. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
- C. The target point for the recovery must be specified as a stime or System Change Number (SCN).
- D. The database must be in MOUNT state when performing Database Point-in-Time Recovery.
- E. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
- F. The Database must be in ARCHIVELOG mode.
Answer: A,D,F
Explanation:
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr006.htm#:~:text=Database%20point%2Din%2Dtime%20recovery%20(DBPITR)%20restores%20the,forward%20to%20the%20target%20time.
NEW QUESTION 67
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 68
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:
What is the outcome?
- A. Only the ORCL database instance, the Oracle ASM instance, and the +DATA and +FRA disk groups are started.
- B. Only the ORCL database instance and the +DATA and +FRA disk groups are started.
- C. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENER are started.
- D. Only the ORCL database and the ASM instances are started.
- E. Only the ORCL database instance is started.
Answer: A
NEW QUESTION 69
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
- A. New templates can only be created by modifying an existing user-created template.
- B. Oracle DBCA templates can be used to create new databases and duplicate existing databases.
- C. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
- D. Oracle DBCA templates can store only logical structure and not database files.
- E. The Data Warehouse template is most suitable when transaction response time is the key criterion.
Answer: B,C
Explanation:
Reference:
https://docs.oracle.com/database/121/ADMQS/GUID-2B8A3B5E-D319-4377-8B22- 8BB67DCC9885.htm#ADMQS0235
NEW QUESTION 70
You plan to install Oracle Grid Infrastructure for a Standalone Server and Oracle Database for the first time on a server.
Examine this command and its outcome:
Which two are true? (Choose two.)
- A. oracle must be the owner of every Oracle Database installation.
- B. oracle can own an Oracle Database installation but not an Oracle Grid Infrastructure installation.
- C. oracle will be an owner of the Oracle Inventory.
- D. oracle will be granted the SYSASM privilege when installing the Oracle Database software.
- E. The user account, oracle, and group, oinstall, can be used for all Oracle software installations.
Answer: C,E
NEW QUESTION 71
Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)
- A. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
- B. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
- C. A DBA must specify either a redundancy retention policy or a recovery window retention policy.
- D. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
- 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 72
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
- A. New templates can only be created by modifying an existing user-created template.
- B. Oracle DBCA templates can be used to create new databases and duplicate existing databases.
- C. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
- D. Oracle DBCA templates can store only logical structure and not database files.
- E. The Data Warehouse template is most suitable when transaction response time is the key criterion.
Answer: B,C
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/ADMQS/GUID-2B8A3B5E-D319-4377-8B22-
8BB67DCC9885.htm#ADMQS0235
NEW QUESTION 73
You issued this command:
RMAN> BACKUP RECOVERY FILES;
Which two are true? (Choose two.)
- A. All Oracle recovery files not in the current FRA that have not been backed up already, are backed up.
- B. All non-Oracle files in the current FRA that have not been backed up already, are backed up.
- C. All Oracle recovery files in the current fast recovery area (FRA) are backed up.
- D. These backups can be written to disk or SBT.
- E. All Oracle recovery files in the current FRA that have not been backed up already, are backed up.
Answer: C,D
Explanation:
https://blog.toadworld.com/rman_-_using_the_flash_recovery_area
NEW QUESTION 74
You have configured RMAN SBT channels to write backups to media.
You then take an RMAN backup by using this command:
Which three are true? (Choose three.)
- A. The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.
- B. The SPFILE is included in the self-contaied archival backup.
- C. The restore point is a label for the system change number (SCN) before the archival backup was taken.
- D. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
- E. The control file is included in the self-contained archival backup.
- F. All archive logs created after this backup are kept for two years.
Answer: B,E,F
NEW QUESTION 75
Which three are true in Oracle 19c and later releases? (Choose three.)
- A. Tablespaces never remain in read/write mode during transportable tablespace operations.
- B. A transportable data pump import can leave a plugged-in tablespace in read/write mode.
- C. A transportable data pump import can leave a plugged-in tablespace in read-only mode.
- D. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.
- E. Tablespaces always remain in read/write mode during transportable tablespace operations.
- F. Simultaneous data pump jobs can be limited at the pluggable database (PDB) level.
Answer: B,D,E
NEW QUESTION 76
......
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.
Oracle Database 19c Free Certification Exam Material from Pass4SureQuiz with 160 Questions: https://www.pass4surequiz.com/1Z0-083-exam-quiz.html
1Z0-083 Dumps Full Questions - Exam Study Guide: https://drive.google.com/open?id=1xSAmOBeiurVAn0H_NLqOwTaRyi_GaaVM