Up To The Immediate Present 1z0-083 Testing Software For Oracle Database Administration II Certification

NEW QUESTION 1
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 savedtwo years after the archival backup was taken.
• B. The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.
• C. All archive logs created after this backup are kept for two years.
• D. The SPFILE is included in the self-contaied archival backup.
• E. The control file is included in the self-contained archival backup.
• F. The restore point is a label for the system change number (SCN) before the archival backup was taken.

Answer: CDE

NEW QUESTION 2
A database is configured in ARCHIVELOG mode.
A full RMAN backup exists but no control file backup to trace has been taken. A mediafailure has occurred. In which two scenarios is incomplete recovery required? (Choose two.)

• A. after losing a SYSAUX tablespace data file
• B. after losing all members of an INACTIVE online redo log group
• C. after losing all members of the CURRENT onlineredo log group
• D. after losing all copies of the control file
• E. after losing an UNDO tablespace that is in use

Answer: BD

NEW QUESTION 3
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 toRestore Point R1. How do you achieve this?

• A. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMANwhile connected to PDB1.
• B. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQLwhile connected to PDB1.
• C. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQLwhile connected to CDB$ROOT.
• D. Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMANwhile connected to CDB$ROOT.
• E. This cannot be done due to the lack of aclean restore point.

Answer: B

NEW QUESTION 4
Examine this configuration:
* 1.The ORCL database data files are in Automatic Storage Management (Oracle ASM) disk group +DATA. * 2.ORCL uses disk group +FRAfor 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. The ORCL database, the Oracle ASM instances, the +DATA and +FRA disk groups, and the LISTENERare started.
• B. Only the ORCL database instance is 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 and the +DATA and +FRA disk groups are started.

Answer: D

NEW QUESTION 5
Which three are true about an application seed pluggable database (PDB)? (Choose three.)

• A. It is automatically synchronized with its application root PDB when an application is upgraded.
• B. It cannot be added to an application container after the application container has already been created.
• C. A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.
• D. It is automatically synchronized with its application root PDB when an application is installed.
• E. It cannot be dropped from its application container.
• F. A new application PDB created by cloning an application seed PDB canhave an up-to-date version of the application installed after cloning completes.
• G. It is not required in an application container.

Answer: DFG

NEW QUESTION 6
Which two are true about unplugging an application container from a container database and plugging it into a different container database?

• A. It requires local undo mode in both container databases.
• B. It requires only local undo mode in the database where the application container will be unplugged.
• C. Plugging the application root into a different CDB plugs In all its application PDBs.
• D. Application PDBs In the application container must beunplugged before the application root Is unplugged.
• E. Unplugging the application root from a CDB unplugs all its application PDBs.
• F. The application root of an application container should be plugged Into the other CDB before Its application PDBs are plugged in.

Answer: DE

NEW QUESTION 7
YourSALES_ROOTapplication container has two application PDBs. TheSALES_APPapplication has a common table,FIN.REVENUE, in the two PDBs. Examine this query and its output:

Which two are true? (Choose two.)

• A. The CONTAINERS clause cannot be used in queries on the REVENUEtable.
• B. The REVENUE table must be a list-partitioned table.
• C. The MAPTABLE tables defines a logical partition key on a commonly used column for the REVENUE table.
• D. The MAPTABLE table is a metadata-linked table.
• E. A container map exists for theREVENUE table, but is not enabled.
• F. The REVENUE table partitions are not pruned across the PDBs automatically.

Answer: CE

NEW QUESTION 8
Which two are true about Oracle Optimizer Statistics, their use, and their collection? (Choose two.)

• A. The number of table rows is considered when evaluating the cost of accessing a table using an index.
• B. Index balanced B*Tree height is considered whenevaluating the cost of using an index.
• C. The Statistics Advisor can help recommend the best way to gather statistics.
• D. Statistics collected using DBMS_STATS always yield the best optimizer result.
• E. The Statistics Advisor generates actions for all recommendations.

Answer: CD

NEW QUESTION 9
Which three are true in Oracle 19c and later releases? (Choose three.)

• A. If the password file location changes, then the new location is used automatically by the Oracle Server.
• B. Schema Only accounts can be granted administrator privileges.
• C. All the Oracle-supplied accounts are Schema Only accounts.
• D. Privilege Analysis is included in Oracle Enterprise Edition and no longer requires Database Vault.
• E. Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.
• F. Unified Auditing can be configured to audit only events that are issued directly by an audited user.

Answer: BCD

NEW QUESTION 10
Which three are true about Recovery Manager (RMAN) in Oracle Database 19c and later releases? (Choose three.)

• A. It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.
• B. It isalways possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.
• C. A Virtual Private Catalog used to register a container database must be created in a pluggable database.
• D. A Virtual Private Catalog used to registera container database can be created in a pluggable database.
• E. It is always possible for RMAN to connect to a pluggable database as a target.
• F. A Virtual Private Catalog used to register a container database can be created in a non-container database.

Answer: DEF

NEW QUESTION 11
Which three are true about Database Point-in-Time Recovery? (Choose three.)

• A. The database must have FLASHBACK DATABASE ON to perform Database Point-in-Time Recovery.
• B. Thedatabase must be in MOUNT state when performing Database Point-in-Time Recovery.
• C. Database Point-in-Time Recovery is performed by the Managed Recovery Process (MRP)
• D. The Database must be in ARCHIVELOG mode.
• E. The target point for the recovery must bespecified as a stime or System Change Number (SCN).
• F. The database must be open RESETLOGS after Database Point-in-Time Recovery.

Answer: BDF

Explanation:
https://docs.oracle.com/cd/B19306_01/backup.102/b14192/flashptr006.htm#:~:text=Database%20point%2Din%

NEW QUESTION 12
Examine this configuration:
CDB1is a container database.
PDB1andPDB2arepluggable databases inCDB1.
PDB1andPDB2areOPENinREAD WRITEmode.
You execute these commands successfully:

Which two are true? (Choose two.)

• A. Uncommitted transactions in PDB1 have been rolled back.
• B. PDB1 is closed.
• C. Uncommitted transactions in CDB1 and PDB1 have been rolled back.
• D. CDB1 is shut down.
• E. CDB1 is in MOUNT state

Answer: AB

NEW QUESTION 13
A database is configured in ARCHIVELOG mode.
Full RMAN backups are taken and no backup to trace has been taken of the control file. A media failure has occurred.
In which two scenarios is complete recovery possible? (Choose two.)

• A. when any archived log from, before, or after the most recent backup is corrupt.
• B. after losing all copies of the control file
• C. after losing an archived log from after the most recent backup
• D. after losing an archived log from before the most recent backup
• E. after losing the SYSTEM tablespace

Answer: DE

NEW QUESTION 14
Which two are true about Oracle Flashback features? (Choose two.)

• A. FLASHBACK QUERY can retrieve REDO records from ONLINE and ARCHIVED REDO LOG files.
• B. FLASHBACKVERSION QUERY can retrieve REDO records from ONLINE and ARCHIVED REDOLOG files.
• C. FLASHBACK TABLE can undrop a column.
• D. FLASHBACK DROP can undrop an index when undropping a table.
• E. After a database is restored from flashback logs using the FLASHBACKDATABASE command, it is sometimes rolled forward using redo logs.

Answer: DE

NEW QUESTION 15
Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the Manageability Monitor (MMON) background process? (Choose three.)

• A. ADDM can recommend shrinking the buffer cache.
• B. ADDM can recommend extending the buffer cache.
• C. By default, MMON creates an AWR snapshot every 30 minutes.
• D. ADDM performs itsanalysis only when a DBA requests it.
• E. By default, AWR snapshots are automatically purged after eight days.
• F. AWR snapshots must be deleted when no longer required by ADDM.

Answer: AEF

NEW QUESTION 16
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)

• A. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
• B. Oracle DBCA templates can store only logical structure and not database files.
• C. New templates can only be created by modifying an existing user-created template.
• D. The Data Warehouse template is most suitable when transaction response time is the key criterion.
• E. Oracle DBCAtemplates can be used to create new databases and duplicate existing databases.

Answer: AE

NEW QUESTION 17
Which two are true about RMAN duplexed backup sets? (Choose two.)

• A. A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.
• B. A non-duplexed backup set written to disk can be duplexed to disk bybacking up the backup set that is already on disk.
• C. A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.
• D. A non-duplexed backup set written to disk can be duplexed to tape by backing upthe backup set that is already on disk.
• E. A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.
• F. A duplexed backup set always uses twice as many SBT channels as a non-duplexedbackup set for the same number of files.

Answer: DF

NEW QUESTION 18
Which two are true about OS groups and users for OracleGrid Infrastructure and the Oracle Relational Database Management System (RDBMS)? (Choose two.)

• A. By default, members of the OSASM group can access Automatic Storage Management and RDBMS instances.
• B. The primary group for the Oracle Grid Infrastructure and Oracle Database owners must be the Oracle Inventory group.
• C. The Oracle Grid Infrastructure installation must be owned by the grid user.
• D. The Oracle Grid Infrastructure owner owns Oracle Restart and Oracle Automatic Storage Management binaries.
• E. The Oracle Grid Infrastructure owner must have OSOPER, OSBACKUPDBA, and OSKMDBA as secondary groups.
• F. The same OSDBA group must be used for Automatic Storage Management and the Oracle Database.

Answer: EF

NEW QUESTION 19
Which two are facets of performance planning that should always be considered or implemented for an Oracle Database environment? (Choose two.)

• A. defining primary keys for all tables to speed up all queries
• B. using check constraints to speed upupdates
• C. defining foreign keys for all tables to speed up joins
• D. the physical data model
• E. the configuration of storage arrays

Answer: AE

NEW QUESTION 20
Oracle Managed Files (OMF) is enabled in a CDB and thiscommand is successfully executed:

Which three are true? (Choose three.)

• A. Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.
• B. An application seed PDB is created for APP1.
• C. An application root PDB is created for APP1.
• D. A default service is created for the application root APP1.
• E. Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.
• F. APP1 can never be unplugged.

Answer: ABE

NEW QUESTION 21
......