[Jun-2022] 1Z1-083 Dumps are Available for Instant Access from ExamsLabs [Q48-Q63] : Exams Labs Braindumps : http://blog.examslabs.com

NEW QUESTION 48
Which three are true about SGA memory management in a multitenant database? (Choose three.)

Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer Cache memory for that PDB.

The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the SHARED_POOL_SIZE setting of the root container.

Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.

The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.

Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that PDB.

SGA_MIN_SIZE cannot be set for a PDB.

NEW QUESTION 49
Choose three. Which three are true about Oracle Grid Infrastructure for a Standalone Server?

It requires Oracle ASMLib to manage Automatic Storage Management (ASM) disks.

It creates one disk group during installation.

It includes both Oracle Restart and Oracle Automatic Storage Management (ASM) software.

Automatic Storage Management (ASM) requires that O/S groups OSASM and OSDBA be assigned as secondary groups for its installation owner.

It requires Oracle ASM Fitter Driver (ASMFD) to manage Automatic Storage Management (ASM) disks.

It requires the operating system ORACLE_BASE environment variable to be predefined before installation.

NEW QUESTION 50
Choose three. Which three are true about RMAN archival backups with the RESTORE POINT clause?

They are never considered obsolete by RMAN.

They can optionally be written to a fast recovery area (FRA).

All archive logs are retained after an archival backup is taken, until the next archival backup is taken of the same database.

Archive logs are retained if they are necessary to allow the database to be recovered to a consistent state when an archival backup is restored.

The SPFILE is included in the archival backup.

Use of a recovery catalog is always required to support the creation and use of archival backups. G)The ARCHIVAL attribute for a backup overrides the RMAN retention policy.

NEW QUESTION 51
Oracle Managed Files (OMF) is enabled in a CDB and this command is successfully executed:

Which three are true?

APP1 can never be unplugged.

Application PDBs that are subsequently created in the APP1 application container will be cloned from APP1$SEED.

An application seed PDB Is created for APP1.

Application PDBs that are subsequently created in the APP1 application container will be cloned from PDB$SEED.

An application root PDB is created for APP1.

A default service Is created for the application root APP1.

NEW QUESTION 52
Examine these queries and their output:

After a system crash, an instance restart and an attempted opening of the PDBs result in:

Which two are true? (Choose two.)

Data file 24 can be recovered while PDB2 is opened.

Data file 24 must be recovered while the CDB is opened.

Data file 24 can be recovered while CDB$ROOT and PDB$SEED are opened.

Data file 24 cannot be recovered while the CDB is opened.

Data file 24 must be recovered while PDB2 is closed.
19c: PDB SYSTEM or UNDO Tablespace Recovery: The CDB and all other PDBs can be left opened. 1. Connect to PDB 2. Shutdown abort the PDB, if its not automatically done. sqlplus sys@sales_pdb as sysdba sql> SHUTDOWN ABORT; OR ALTER PLUGGABLE DATABASE CLOSE ABORT; rman target sys@slaes_pdb rman> restore database; rman> recover database; rman> alter pluggable database sales_pdb open;

NEW QUESTION 53
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?

A container map exists for the revenue table, but Is not enabled.

The maptable table defines a logical partition key on a commonly used column for the revenue table.

The containers clause cannot be used in queries on the revenue table.

The revenue table partitions are not pruned across the PDBs automatically.

The maptable table is a metadata-linked table.

The revenue table must be a list-partitioned table.

NEW QUESTION 54
Which three are true about Automatic Workload Repository (AWR) snapshots?

They are generated if STATISTICS_LEVEL is set to TYPICAL.

They are always created manually.

They are always created automatically.

They are generated if STATISTICS_LEVEL is set to BASIC.

They are generated if STATISTICS_LEVEL is set to ALL.

They can be retained forever.

NEW QUESTION 55
Which three can be done using Oracle Database Configuration Assistant (DBCA) starting from Oracle Database 19c? (Choose three.)

cloning a remote container database in interactive mode

cloning a remote pluggable database in silent mode

relocating a remote pluggable database in interactive mode

relocating a remote container database in silent mode

cloning a remote container database in silent mode

relocating a remote pluggable database in silent mode

relocating a remote container database in interactive mode

NEW QUESTION 56
Which two are true about diagnosing Oracle Database failure situations using Data Recovery Advisor? (Choose two.)

Using the Data Recovery Advisor LIST FAILURE command always requires that the database for which failures are to be listed is in MOUNT state.

A failure can be closed only when it has been repaired.

Data Recovery Advisor can be used if a database is closed.

The Data Recovery Advisor CHANGE FAILURE command can be used only to change failure priorities.

Data Recovery Advisor can proactively check for failures.

NEW QUESTION 57
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?

All archive logs created after this backup are kept for two years.

The data file backups in the self-contained archive backup are not considered obsolete for two years regardless of the retention policy.

The restore point is a label for the system change number (SCN) that will be saved two years after the archival backup was taken.

The control file is included in the self-contained archival backup.

The spfile is included in the self-contained archival backup.

The restore point is a label for the system change number (SCN) before the archival backup was taken.

NEW QUESTION 58
Which two are true about gathering optimizer statistics? (Choose two.)

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open PDBs except PDB$SEED.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to a PDB opened in read/ write mode gathers object statistics for that PDB.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics only in CDB$ROOT.

System statistics can be gathered only while connected to CDB$ROOT.

Executing DBMS_STATS.GATHER_DATABASE_STATS while connected to CDB$ROOT gathers object statistics in all open pluggable databases (PDBs)

NEW QUESTION 59
Oracle Data Redaction is active on the SCOTT.EMP table. You queried the table twice. SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; Which is guaranteed to be true concerning the redaction policy?

FULL redaction is active on the SAL column

RANDOM redaction is active on the MGR column

RANDOM redaction is active on the HIREDATE column

PARTIAL redaction is active on the MGR column.

PARTIAL redaction is active of the HIREDATE column.

NEW QUESTION 60
Choose the best answer. How do you configure a CDB for local undo mode?

Open the CDB instance in restricted mode. In CDB$ROOT, drop the UNDO tablespace. Execute ALTER DATABASE LOCAL UNDO ON in each PDB, and then restart the CDB instance.

Open the CDB instance in upgrade mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then restart the CDB instance.

Open the CDB instance in upgrade mode. In each PDB, execute ALTER DATABASE LOCAL UNDO ON, create an UNDO tablespace, and then restart the CDB instance.

Open the CDB instance in restricted mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON. create an UNDO tablespace in each PDB, and then restart the CDB instance.

Open the CDB in read-only mode. In CDB$ROOT, execute ALTER DATABASE LOCAL UNDO ON, and then change the CDB to read/write mode.

NEW QUESTION 61
Which two are true about common objects? (Choose two.)

They can be created only in CDB$ROOT.

They can be only metadata-linked in an application container.

They can exist in user-defined schemas only in application containers.

They can exist in CDB$ROOTand an application root.

They can be extended data-linked in CDB$ROOT.

They can be created only in an application root.

NEW QUESTION 62
Choose two. Which two are true about creating RMAN backups for an Oracle container database?

Control file backups can be created while connected to the root container.

Archived Redo Log backups can be created while connected to an application root CDB.

Control file backups can be created while connected to a nonroot container.

Online Redo Log backups can be created while connected to the root container.

The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.

NEW QUESTION 63
Which two are true about Oracle Optimizer Statistics, their use, and their collection?

The number of table rows is considered when evaluating the cost of accessing a table using an index.

The Statistics Advisor can help recommend the best way to gather statistics.

Index balanced B*Tree height is considered when evaluating the cost of using an index,

The Statistics Advisor generates actions for all recommendations.

Statistics collected using DBMS_ATATS always yield the best optimizer result.

[Jun-2022] 1Z1-083 Dumps are Available for Instant Access from ExamsLabs [Q48-Q63]

Understanding functional and technical aspects of Oracle Database Administration II Exam Number: 1Z0-083

Difficulty in Attempting Oracle Database Administration II Exam Number: 1Z0-083

Understanding functional and technical aspects of Oracle Database Administration II Exam Number: 1Z0-083