2021 Realistic ExamCost 1Z1-083 Dumps PDF - 100% Passing Guarantee
Free Oracle 1Z1-083 Exam Questions & Answer
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:
- Oracle Database: Backup and Recovery Workshop
- Recovery and Flashback
- Configuring and Using RMAN
- Creating CDBs and Regular PDBs
- Backup and Duplicate
- Oracle Database: Managing Multitenant Architecture Ed 1
- Backup Strategies and Terminology
- Manage Security in Multitenant databases
- Upgrading and Transporting CDBs and Regular PDBs
- Manage Application PDBs
- Manage CDBs and PDBs
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:
- Restore and Recovery Concepts
- Creating an Oracle Database by using DBCA
- Using Flashback Technologies
- Duplicating a Database
- RMAN Troubleshooting and Tuning
- Transporting Data
- Performing Recovery
- Patching Grid Infrastructure and Oracle Database
- Oracle Database: Deploy, Patch and Upgrade Workshop
- Diagnosing Failures
NEW QUESTION 44
Which three are true about Rapid Home Provisioning of Oracle software? (Choose three.)
- A. It can be used to patch existing Oracle software installations.
- B. It can be used to create templates of Oracle homes as gold images of only Oracle databases.
- C. It can be used only on nodes with Oracle Grid Infrastructure installed.
- D. It can be used to upgrade only single-instance databases running on Oracle Restart.
- E. It can be used to deploy new homes without disrupting active databases.
- F. It can be used to create a single-instance Oracle Database in an already-installed Oracle home.
Answer: A,B,C
NEW QUESTION 45
Examine these queries and their output:
An online RMAN backup of the CDB was taken an hour before Restore Point R1 was created. You want to recover PDB1 to Restore Point R1.
How do you achieve this?
- A. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to PDB1.
- B. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to CDB$ROOT.
- C. This cannot be done due to the lack of a clean restore point.
- D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQL while connected to CDB$ROOT.
- E. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMAN while connected to PDB1.
Answer: A
NEW QUESTION 46
For which two requirements can you use the USER_TABLESPACE clause with the CREATE PLUGGABLE DATABASE command? (Choose two.)
- A. to exclude a temp tablespace when plugging in a PDB
- B. to specify a default tablespace in a PDB cloned from another PDB in the same CDB.
- C. to specify the list of user tablespaces to include when moving a non-CDB to a PDB
- D. to specify the list oftablespaces to include when creating a PDB from the CDB seed
- E. to exclude all tablespaces except SYSTEM, SYSAUX, and TEMPwhen plugging in a PDB
- F. to include specific user tablespaces only when relocating a PDB
Answer: A,D
NEW QUESTION 47
Which three are true about the Oracle Optimizer? (Choose three.)
- A. It can re-optimize execution plans after previous executions detect suboptimal plans.
- B. It considers object statistics when generating execution plans for SQL statements.
- C. It updates stale object statistics in the Data Dictionary.
- D. It can only use SQL Plan Directives tied to the SQL statement for which a plan is being generated.
- E. It considers the filters in WHERE clauses when generating execution plans for SQL statements.
- F. It obeys all hints.
Answer: B,C,D
NEW QUESTION 48
Which three are true about managing memory components in an Oracle database instance? (Choose three.)
- A. On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.
- B. Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.
- C. With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.
- D. With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.
- E. Automatic Memory Management must be used together with locking the System Global Area into physical memory.
- F. With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.
Answer: A,C,F
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/TGDBA/tune_shared_pool.htm
NEW QUESTION 49
Your SALES_ROOT application container has two application PDBs.
The SALES_APP application has a common table, FIN.REVENUE, in the two PDBs.
Examine this query and its output:
Which two are true? (Choose two.)
- A. The REVENUE table must be a list-partitioned table.
- B. The CONTAINERS clause cannot be used in queries on the REVENUE table.
- C. The REVENUE table partitions are not pruned across the PDBs automatically.
- D. A container map exists for the REVENUE table, but is not enabled.
- E. The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.
- F. The MAPTABLE table is a metadata-linked table.
Answer: C,E
NEW QUESTION 50
Which three are true in Oracle 19c and later releases? (Choose three.)
- A. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
- B. If the password file location changes, then the new location is used automatically by the Oracle Server.
- C. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
- D. Unified Auditing can be configured to audit only events that are issued directly by an audited user.
- E. Schema Only accounts can be granted administrator privileges.
- F. All the Oracle-supplied accounts are Schema Only accounts.
Answer: C,E,F
Explanation:
Reference:
https://mandysandhu.com/2018/04/30/oracle-database-18c-schema-only-accounts/
NEW QUESTION 51
Which two are true about RMAN persistent configuration settings, administration, and their effects?
- A. Backups written to the fast recovery area (FRA) that are obsolete based on the redundancy retention policy can be deleted automatically to free space.
- B. Backups older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
- C. A DBA must specify either a redundancy retention policy or a recovery window retention policy.
- D. A target database's persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
- E. A target database's persistent RMAN configuration settings are always stored in the target's control file
Answer: B,E
NEW QUESTION 52
Which two are true about a Recovery Manager (RMAN) duplication without a target connection?
- A. RMAN "pushes" the backups of the database to be duplicated over the network to the auxiliary instance.
- B. RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.
- C. RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.
- D. The undo tablespace clause is always required when no connection exists to the target instance.
- E. The undo tablespace clause is always required when no connection exists to the recovery catalog and the target database is closed.
Answer: C,E
NEW QUESTION 53
Which two are true about RMAN backups when using a media manager? (Choose two.)
- A. The media manager layer (MML) routines provided by Oracle support any vendors' media management products.
- B. By default, a request for a proxy copy may result in a backup set being created.
- C. A media manager is required to create RMAN image copies.
- D. A media manager always writes RMAN requested backups to tape.
- E. A media manager is required to create RMAN proxy copies.
Answer: C,D
NEW QUESTION 54
Which three are true about using an RMAN Recovery Catalog with a pluggable database (PDB) target connection in Oracle Database 19c and later releases? (Choose three.)
- A. The base catalog must be used by RMAN when performing point-in-time recovery for the PDB registered in the Virtual Private Catalog.
- B. The target PDB must be registered in a Virtual Private Catalog.
- C. The target PDB must be registered in both the base catalog and the Virtual Private Catalog.
- D. The base catalog owner must give the Virtual Private Catalog access to metadata for one or more PDBs.
- E. The base catalog must be enabled for Virtual Private Catalog use.
- F. The target PDB must be registered in a base catalog.
Answer: A,B,D
NEW QUESTION 55
Which two are true about RMAN encryption?
- A. Dual-mode encrypted backups can be restored only if both the password and the keystore used for encryption are available.
- B. RMAN can encrypt the Oracle Database password file.
- C. RMAN encryption keys are stored in a database keystore.
- D. The set encryption command overrides encryption settings specified by the configure encryption command.
- E. Password encryption can be persistently configured using the configure encryption command.
Answer: C,D
NEW QUESTION 56
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 57
Examine this configuration:
1. CDB1is a container database.
2. PDB1and PDB2 are pluggable databases in CDB1.
You execute these commands successfully:
Which two are true? (Choose two.)
- A. PDB1and PDB2are in MOUNTstate.
- B. PDB1 and PDB2 are in READ ONLYstate.
- C. CDB$ROOTis in MOUNTstate.
- D. PDB$SEEDis in READ ONLYstate.
- E. Redo logs are opened.
Answer: D,E
NEW QUESTION 58
Examine this configuration:
* CDB1 is a container database.
* PDB1 and PDB2 are pluggable databases in CDB1.
* PDB1 and PDB2 are OPEN in READ WRITE mode.
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. Uncommitted transactions in CDB1 and PDB1 have been rolled back.
- D. CDB1 is in MOUNT state
- E. CDB1 is shut down.
Answer: A,B
NEW QUESTION 59
Which two are true about creating RMAN backups for an Oracle container database?
- A. The backup pluggable database command can be used to back up cdb$root.
- B. The backup database plus archivelog command will back up archive logs when RMAN is connected to a PDB.
- C. spfile backups can be created while connected to an application root PDB.
- D. The backup database command will create a pluggable database (PDB) backup when RMAN is connected to a PDB.
- E. Tablespaces from different PDBs with identical names must be backed up by connecting RMAN separately to each PDB to back up the tablespaces.
Answer: B,D
NEW QUESTION 60
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)
- A. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
- B. Existing Oracle Database instances must be shut down before starting the upgrade.
- C. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
- D. Only the griduser can perform the upgrade.
- E. An existing Oracle base can be used.
- F. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
Answer: B,C,D
Explanation:
Explanation/Reference: https://docs.oracle.com/database/121/CWLIN/procstop.htm#CEGEDCDB
NEW QUESTION 61
In performance management, which two factors might reduce the ability of an application to scale to a large number of users? (Choose two.)
- A. poorly written SQL
- B. the number of tablespaces containing tables updated by a transaction
- C. the number of data files containing extents belonging to tables updated by a transaction
- D. poorly trained users who do not commit transactions
- E. issuing multiple savepoints during a transaction
Answer: A,B
NEW QUESTION 62
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 63
Which three are true about interpreting Recovery Manager (RMAN) error stacks returned to standard output?
(Choose three.)
- A. Media Management errors appear as a line with "sbtio".
- B. Media Management errors appear as a line with "Additional information" and a number.
- C. If an RMAN command fails, the output will identify the channel ID where the failure occurred.
- D. If an RMAN command fails, the output will only identify the command that failed.
- E. Media Management errors appear as a line with "sbtio" and a number.
- F. Some messages in the error stack are not errors.
Answer: A,B,C
NEW QUESTION 64
Which three are true about requirements for various FLASHBACK operations? (Choose three.)
- A. FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
- B. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.
- C. FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
- D. FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
- E. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
- F. FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
Answer: C,D,E
NEW QUESTION 65
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?
- A. Data file 24 can be restored only while connected to CDB$ROOT.
- B. Data file 24 can be recovered while connected to PDB2.
- C. Data file 24 can be restored only while connected to PDB2.
- D. Data file 24 can be recovered while connected to CDB$ROOT.
- E. Data file 24 can be restored and recovered while connected to CDB$ROOT.
- F. Data file 24 can be recovered only while connected to PDB2.
Answer: A,B,F
NEW QUESTION 66
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process?
- A. AWR snapshots must be deleted when no longer required by ADDM.
- B. ADDM can recommend extending the buffer cache.
- C. By default, AWR snapshots are automatically purged after eight days.
- D. By default, MMON creates an AWR snapshot every 30 minutes.
- E. ADDM can recommend shrinking the buffer cache.
- F. ADDM performs its analysis only when a DBA requests it.
Answer: C,E,F
NEW QUESTION 67
......
Verified 1Z1-083 dumps Q&As Latest 1Z1-083 Download: https://www.examcost.com/1Z1-083-practice-exam.html
Updated 100% Cover Real 1Z1-083 Exam Questions - 100% Pass Guarantee: https://drive.google.com/open?id=1PQFxEkgbA7w4We9qb-4jYVMjRa7is2l5
