Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Oracle 1z0-083 - Oracle Database Administration II

Oracle 1z0-083 Premium Access     Download Demo    
Page: 1 / 9
Total 286 questions

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

A.

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

B.

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

C.

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

D.

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

E.

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

You are working on an Oracle Database 19c database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? (Choose two.)

A.

Flashback logs are not archived.

B.

Flashback logs are maintained in redo log files.

C.

Flashback logs are maintained in the Flash Recovery Area.

D.

Flashback logs are used to maintain Flashback Database related errors.

E.

Flashback logs need to be cleared manually after you disable Flashback Database.

Which three are true about managing memory components in an Oracle database instance? (Choose three.)

A.

With Automatic Shared Memory Management, the database instance can increase the Large Pool size by reducing the Shared Pool size.

B.

With Automatic Memory Management, the database instance can increase the System Global Area size by reducing the Program Global Area size.

C.

Automatically tuned and resized System Global Area components will always revert to their initial sizes after an instance restart.

D.

Automatic Memory Management must be used together with locking the System Global Area into physical memory.

E.

With Automatic Shared Memory Management, the database instance can increase the Program Global Area size by reducing the System Global Area size.

F.

On Line Transaction Processing systems often use less Program Global Area than Decision Support Systems.

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 files for PDB1.

E.

PDB1 must be dropped from CDB1.

Which two are true about creating pluggable databases (PDBs) in Oracle 19c and later releases?

A.

A PDB snapshot depends on an existing storage snapshot of the source PDB.

B.

APDB snapshot can be a full copy of a source PDB.

C.

A PDB snapshot can be a sparse copy of a source PDB

D.

A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB.

E.

A snapshot copy PDB can be a full copy of a source PDB

Choose three. Which are the three steps in the SQL tuning process for Oracle Database environments?

A.

Tune individual SQL statements using the SQL Tuning Advisor.

B.

Identify poorly tuned SQL statements using Automatic Database Diagnostic Monitor.

C.

Test the application as a whole using tuned SQL statements.

D.

Test tuned SQL statements one at a time for all statements in the application.

E.

Identify poorly tuned SQL statements using the SQL Tuning Advisor.

F.

Tune SQL statements as a group using the SQL Tuning and SQL Access Advisors.

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 when evaluating 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.

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.

Add only 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 Oracle Managed Files (OMF)

Choose the best answer. 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, 6, 9

B.

1,3, 5, 7, 10

C.

1,2, 5, 7,4, 10

D.

1,3, 5, 6, 10

E.

1,3,5, 6, 10

F.

1,3,5,8, 6, 10

Which three are true about Oracle Grid Infrastructure for a Standalone Server?

A.

It requires Oracle ASMLib to manage Automatic Storage Managerment (ASMl) disks.

B.

It creates one disk group during installation.

C.

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

D.

Automatic Storage Management (ASM requires that ars groups OSASM and OSDBA be assigned assecondary groups for its installation owner.

E.

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

F.

It requires Oracle ASM Filter Drver (ASMFD) to manage Automatic Storage Managemernt (AsM) disks.