The Secret Of Oracle 1z0-083 Test

NEW QUESTION 1
Which four are true about RMAN backup sets? (Choose four.)

• A. A backup piece can belong to only one backup set.
• B. A data file can be split into multiple sections stored in different backup sets.
• C. A data file canbe split into multiple sections stored in different backup pieces in the same backup set.
• D. Blocks from multiple data files can be contained in one backup piece,
• E. A backup set can contain only one backup piece.
• F. A backup set must be written to media.
• G. A backup set must be written to disk.
• H. Blocks from multiple data files can be contained in one backup set,

Answer: BEFH

NEW QUESTION 2
Which three are true about RMAN persistent configuration settings, administration, and their effects? (Choose three.)

• A. A target database’s persistent RMAN configuration settings are always stored in the target’s control file
• B. Backup older than the recovery window retention policy are always deleted automatically if the backup location has insufficient space.
• C. Backups written to the fast recovery area (FRA) that are oboslete based on the redundancy retention policy can be deleted automatically to free space.
• D. The RMAN SHOW ALL command displays only settings with nondefault values.
• E. A target database’s persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.
• F. The V$RMAN_CONFIGURATION view displays only settings with values that have been modified.
• G. A DBA must specify either a redundancy retention policy or a recovery window retention policy.

Answer: ABF

NEW QUESTION 3
Which four are true about duplicating a database using Recovery Manager (RMAN)? (Choose four.)

• A. Duplication can be done by having the auxiliary databaseinstance pull backup sets from the target database instance.
• B. A connection to an auxiliary instance is always required.
• C. A subset of the target database can be duplicated.
• D. A new DBID is always created for the duplicated database.
• E. A connection tothe recovery catalog instance is always required.
• F. A backup of the target database is always required.
• G. Duplication can be done by having the target database instance push copies to the auxiliary database instance.
• H. A connection to the target database instance is always required.

Answer: ABCG

Explanation:
A duplicate database is a copy of your target database. With the FOR STANDBY clause, it keeps the same unique database identifier(DBID); If FOR STANDBY not specified it creates a new DBID. The duplicate database can include the same content or only a subset from the source database. It can be in the same host or a separate host. The principal work of the duplication is performed by the auxiliary channels.These channels correspond to a server session on the auxiliary instance on the destination host for backup based duplication. For active database duplication the target channels perform the work of pushing data file copies to the auxiliary instance (if number of allocated target channels is greater than the number of allocated auxiliary channels).

NEW QUESTION 4
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 5
Which three are true about Automatic Workload Repository (AWR)? (Choose three.)

• A. By default, AWR snapshots are taken every 60 minutes.
• B. Its collection level is determined by the value of theSTATISTICS_LEVEL database parameter.
• C. By default, AWR snapshots are retained for 7 days.
• D. The taking of AWR snapshots can be disabled.
• E. AWR data is stored in the SYSTEM tablespace.

Answer: ABD

NEW QUESTION 6
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. Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.
• B. Addonly the CREATE_FILE_DEST clause to the statement.
• C. Set only the PDB_FILE_NAME_CONVERT parameter.
• D. Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.
• E. Enable only OMF.
• F. Add the FILE_NAME_CONVERT clause to the statement and enable OracleManaged Files (OMF)

Answer: BDE

NEW QUESTION 7
Which three are true about upgrading Oracle Grid Infrastructure? (Choose three.)

• A. A direct upgrade can be performed only from the immediately preceding Oracle Grid Infrastructure version.
• B. The newer version is installed in a separate Oracle Grid Infrastructure home on the same server as the existing version.
• C. An existing Oracle base can be used.
• D. The upgrade process will automatically install all mandatory patches for the current version of Oracle Grid Infrastructure.
• E. Existing Oracle Database instances must be shut down before starting the upgrade.
• F. Only the grid user can perform the upgrade.

Answer: DEF

NEW QUESTION 8
Which two are true about flashback features in Oracle Database 19c and later releases? (Choose two.)

• A. Flashback logs areautomatically purged when DB_FLASHBACK_RETENTION_TARGET is set lower than the time they have already been retained.
• 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 retentionperiod defined inDB_FLASHBACK_RETENTION_TARGET and can be deleted by an administrator written event trigger.
• E. Flashback logs are automatically purged whenever the value of DB_FLASHBACK_RETENTION_TARGET is changed.

Answer: BE

NEW QUESTION 9
Examine this configuration:
CDB1is an Oracle Database 12c Release 2 database containing pluggable databasesPDB$SEED,PDB1, andPDB2.
PDB$SEEDis openREAD ONLY
PDB1is openREAD WRITE
PDB2isMOUNTED.
ORACLE_HOMEis/u01/app/oracle/product/18.1.0/dbhome_1.
You execute these commands before upgrading the database to the current release:

For which databases will fixup scripts be created?

• A. CDB1, PDB$SEED, PDB1, and PDB2
• B. PDB$SEED, PDB1, and PDB2 only
• C. CDB1 and PDB$SEED only
• D. CDB1, PDB1,and PDB2 only
• E. CDB1, PDB$SEED, and PDB1 only

Answer: E

NEW QUESTION 10
Which three are true In Oracle 19c and later releases?

• A. Tablespaces always remain In read/write mode during transportable tablespace operations.
• B. Simultaneous data pump jobs can be limited at thepluggable database (PDB) level.
• C. Tablespaces never remain In read/write mode during transportable tablespace operations.
• D. An ordinary data pump export of a table with encrypted columns will always encrypt the same columns when imported.
• E. A transportable data pump import can leave a plugged-in tablespace in read-only mode.
• F. A transportable data pump import can leave a plugged-in tablespace In read/write mode.

Answer: ADE

NEW QUESTION 11
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? (Choose two.)

• A. Backups must be doneincrementally.
• B. Backups must be contained in backup sets.
• C. Backups can be taken only if the database is in ARCHIVELOG mode.
• D. Backups can be done incrementally.
• E. The database must be registered in an RMAN catalog.
• F. Only consistent backups can becreated.

Answer: CE

NEW QUESTION 12
A container database called CDB1 is OMF-enabled.
PDB_FILE_NAME_CONVERT is not configured in CDB1. PDB1 was unplugged from CDB1 earlier in the week. Examine this command, which will be executed in CDB1:
CREATE PLUGGABLE DATABASE pdb1
USING ‘/u01/app/oracle/oradata/pdb1.xml’ SOURCE_FILE_NAME_CONVERT =
(‘/u01/app/oracle/oradata/’, ‘/u02/app/oracle/oradata/’); Which two are true? (Choose two.)

• A. PDB1 data files already exist in the correct location.
• B. DBMS_PDB.CHECK_PLUG_COMPATIBILITY must be run in CDB1 before executing the command.
• C. PDB_FILE_NAME_CONVERT must be set before executing the command.
• D. /u01/app/oracle/oradata/pdb1.xml does not contain the current locations of data filesfor PDB1.
• E. PDB1 must be dropped from CDB1.

Answer: AE

NEW QUESTION 13
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. Patches are appliedvia opatchauto.
• D. Users must always input patch plans to opatchauto.
• E. It requires the Oracle Grid Infrastructure and Oracle Database instances to be shut down before being invoked.
• F. It applies patches in nonrolling mode by default.
• G. It is used toapply interim patches to Oracle Grid Infrastructure and Oracle Database home combinations.

Answer: ABC

NEW QUESTION 14
Your container database, CDB1, has an application container, HR_ROOT, with an application PDB, HR_PDB1.
You have the required privilege to clone HR_PDB1 to container database CDB2, which does not contain HR_ROOT.
Which two are always true? (Choose two.)

• A. CDB1 and CDB2 must be in shared undo mode.
• B. A common user must exist in CDB2 with the CREATE PLUGGABLE DATABASE privilege.
• C. All transactions in HR_PDB1 of CDB1 must commit before the cloning process starts.
• D. Cloning HR_ROOT automatically clones HR_PDB1.
• E. The HR_PDB1 clone created in CDB2 will be in mount state when cloning ends.

Answer: BD

NEW QUESTION 15
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 16
Which two are true about Recovery Manager (RMAN) diagnostic message output? (Choose two.)

• A. Media Management messages for SBT devices are always written to sbtio.log.
• B. RMAN error stacks should be read from the bottom up as that is the order in which errors are generated.
• C. RMAN error stacks should be read from the top down as that is the order in which errors are generated.
• D. The RMAN LOG command line clause causes output issued during RMAN commandcompilation to bewritten to a log file and to standard output.
• E. The RMAN LOG command line clause causes output issued during RMAN command compilation to be written to a log file only.
• F. Media Management messages for SBT devices are written to an Oracletrace file.

Answer: EF

NEW QUESTION 17
Which two are trueabout changing the LOCAL_UNDO_ENABLED property to false in a CDB? (Choose two.)

• A. After the change, only a common user with the required privilege can create an undo tablespace in CDB&ROOT.
• B. Any new PDB and existing PDBs are automatically configured to use the default undo tablespace in CDB$ROOT.
• C. After the change, only one undo tablespace can exist in CDB$ROOT.
• D. After the change, any user with the required privilege can create an undo tablespace in the PDBs.
• E. Undo tablespaces existing in PDBs must be dropped before the change.
• F. After the change, each existing PDB has to be reopened for the new undo mode to take effect.

Answer: BC

Explanation:
You can set a CDB in local UNDO mode either at CDB creation or by altering the CDB property. When the database property LOCAL_UNDO_ENABLE is FALSE, which is the default, there is only one UNDO tablespace that is created in the CDB root, and that is shared by all containers. When LOCAL_UNDO_ENABLE is TRUE, every container in the CDB uses local undo and each PDB must have its own local UNDO tablespace. To maintain ease of management and provisioning, UNDO tablespace creation happens automatically and does not require any action from the user. When a PDB is opened and an UNDO tablespace is not available, its automatically created.

NEW QUESTION 18
Which three are true about Optimizer Statistics Advisor? (Choose three.)

• A. It can berun only manually.
• B. It is part of the DBMS_ADVISOR package.
• C. It can recommend changes to improve the statistics gathering process.
• D. It always analyzes all schemas in the database.
• E. It runs automatically every night by default.
• F. It is part of theDBMS_STATS package.

Answer: ACF

Explanation:
https://mikedietrichde.com/2021/08/22/oracle-optimizer-statistics-advisor-in-oracle-database-12-2-0-1/ https://www.oracle.com/technetwork/database/bi-datawarehousing/twp-bp-for-stats-gather-19c-5324205.pdf

NEW QUESTION 19
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 20
Your CDB has two regular PDBs as well as one application container with two applicationPDBs and an application seed
No changes have been made to the standard PDB$SEED.
How many default temporary tablespaces can be assigned in the CDB?

• A. three
• B. eight
• C. seven
• D. six
• E. five

Answer: C

NEW QUESTION 21
Examine this configuration:

WhileCDB1is open,‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’is accidentally deleted. To recover from this critical failure, you execute these commands:

What will be the outcome?

• A. It will create ‘$ORACLE_HOME/dbs/cdb1/CDB1/controlfile02.ctl’
• B. It will create ‘/u01/app/oralce/oradata/CDB1/controlfile/controlfile02.ctl’.
• C. It will re-create ‘/u02/app/oracle/fast_recover_area/cdb1/CDB1/controlfile02.ctl’
• D. It will create ‘/u01/app/oracle/product/12.2.0.1/db_1/dbs/snapcf_cdb1control02.ctl’.
• E. It will fail because there is no autobackup of the controlfiles.

Answer: C

NEW QUESTION 22
......