Summer Certification Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = getmirror

Home
Oracle
Oracle Database 19c
1z0-083
Oracle Database Administration II Questions and Answers

Pass the Oracle Database 19c 1z0-083 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam 1z0-083 Premium Access

View all detail and faqs for the 1z0-083 exam

Go to Exam

838 Students Passed

93% Average Score

93% Same Questions

Viewing page 6 out of 9 pages

Viewing questions 51-60 out of questions

Questions # 51:

Choose two. When backing up to the Oracle Fast Recovery Area (FRA), you determine that the backup takes too long and suspect a performance bottleneck. Which two are true about diagnosing and tuning these problems?

Options:

Data files with a high value in V$BACKUP_ASYNC_IO.SHORT_WAITS are a potential performance bottleneck when asynchronous I/O is used.

If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then read I/O is a likely bottleneck.F

If an RMAN BACKUP VALIDATE command takes noticeably less time than an actual backup, then write I/O is a likely bottleneck.

If an RMAN BACKUP VALIDATE command takesroughly the same time as an actual backup, then both read and write I/O are likely bottlenecks.

Data files with a high value in V$BACKUP_SYNC_IO.DISCRETE_BYTES_PER_SECOND are a potential performance bottleneck when synchronous I/O is used.

Answer

A, C, E

Questions # 52:

Examine these actions: 1. Create a new database for a recovery catalog. 2. Create a tablespace with sufficient space in the catalog database for the recovery catalog. 3. Configure ARCHIVE LOG mode for the catalog database. 4. Create a user to own the recovery catalog schema with quota on the tablespace that will contain the catalog. 5. Grant the RECOVERY_CATALOG_OWNER role to the recovery catalog schema owner. 6. Grant the SYSBACKUP privilege to the recovery catalog schema owner. Which are the minimum actions that must be performed before executing the CREATE CATALOG command?

Options:

2,4,5,6

1,2,3,4,5,6

1,2,4,5

2,4,5

1,3,4,5

Answer

Questions # 53:

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?

Options:

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.

Answer

Questions # 54:

Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog. You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host. How would you achieve this?

Options:

by using the RMAN switch command to set the new location for the data files

by using the RMAN duplicate command with nofilenamecheck to recover the database to the new host

by using the RMAN duplicate command with dbid and set new name for tablespace to recover the database to the new host

by creating a new database in the new host, and then using the RMAN recover command

Answer

Questions # 55:

The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user. The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open. You execute the RMAN commands: RMAN> CONNECT CATALOG rcl2c/passl2c@catdbl2c RMAN> IMPORT CATALOG rcll/pwdcatll@ractll Which two tasks are performed as part of the import?

Options:

Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.

Recovery catalog is resynchronized with the control files of the registered databases.

Imported databases are unregistered from the RC11 catalog.

Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed.

All databases registered in the RC11 catalog are registered in the RC12C catalog.

Answer

D, E

Questions # 56:

Choose three. Which three are true about Recovery Manager (RMAN) active database duplication?

Options:

Pre-existing backups of the database to be duplicated are required for the "push" method of duplication.

Pre-existing backups of the database to be duplicated are required for the "pull" method of duplication.

Pre-existing backups of the database to be duplicated are always used if they exist.

Image copies can be used to duplicate the active database.

The active database must be duplicated while in OPEN state.

No connection to the recovery catalog is required for active database duplication.

Backup sets can be used to duplicate the active database.

Answer

D, F, G

Questions # 57:

Choose three. Which three are true about Data Pump in an Oracle multitenant environment?

Options:

It can be used to transport data from a non-CDB to a PDB.

It can be used to clone a CDB.

It can be used to transport data between PDBs.

It can be used to transport data from a PDB to a non-CDB.

It can be used to create a new PDB.

Answer

A, C, D

Questions # 58:

choose two Examine these RMAN commands: RMAN> CONNECT TARGET "sbu@prod AS SYSBACKUP"; RMAN> CONNECT AUXILIARY "sbu@dup_db AS SYSBACKUP"; RMAN> DUPLICATE TARGET DATABASE TO dup_db FROM ACTIVE DATABASE PASSWORD FILE SECTION SIZE 400M; Which two statements are true about the DUPLICATE command?

Options:

It succeeds.

It fails because no parallel channels are allocated for the auxiliary database.

It fails because connection to the AUXILIARY instance must be as SYSDBA.

Itsucceeds only if the target database is greater than 400M.

No catalogued backup of the TARGET is used to duplicate the database.

Answer

A, E

Questions # 59:

Which two are true about data movement between a non-CDB and a PDB using Data Pump? (Choose two.)

Options:

Tablespaces are automatically created as need while importing full exports in either a non-CDB or a PDB.

Oracle attempts to convert conventional database users to local users when moving schemas from a non-CDB to a PDB.

A new PDB is automatically created when importing a non-CDB into a CDB.

Oracle attempts to convert common users to conventional users when moving schemas from a PDB to a non-CDB.

Moving data from a PDB to a non-CDB is only possible by using transportable tablespace export and import.

Moving data from a non-CDB to a PDB is only possible by using conventional export and import.

Answer

B, D

Questions # 60:

Choose the best answer. Examine this configuration: 1. CDB1 is a container database. 2. APP_ROOT is an application root in CDB1. 3. APP_PDB1 is an application PDB in APP_ROOT. 4. FLASHBACK DATABASE is ON. You execute these commands: $ sqlplus sys/orac1e_4U@localhost:1521/cdb1 SQL> SELECT current_scn FROM v$database; CURRENT_SCN -----------------------2074756 SQL> CREATE TABLE cdb1_tab(c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_root; Session altered. SQL> CREATE TABLE app_root_tab (c1 NUMBER) ; Table created. SQL> ALTER SESSION SET CONTAINER=app_pdb1; Session altered. SQL> CREATE TABLE app_pdb1_tab (c1 NUMBER) ; Table created. SQL> conn / as sysdba Connected. SQL> ALTER PLUGGABLE DATABASE app_root CLOSE; Pluggable database altered. SQL> FLASHBACK PLUGGABLE DATABASE app_root TO SCN 2074756; Flashback complete. Which table or set of tables will exist after the Flashback operation has completed?