04 January, 2023

The Renewal Guide To 1z0-083 Free Exam Questions

Exam Code: 1z0-083 (Practice Exam Latest Test Questions VCE PDF)
Exam Name: Oracle Database Administration II
Certification Provider: Oracle
Free Today! Guaranteed Training- Pass 1z0-083 Exam.

Check 1z0-083 free dumps before getting the full version:

Page: 1 / 8

Total 96 questions Full Exam Access

Question 1

Which three are true about performing an Oracle Database install on Linux? (Choose three.)

The runfixup.sh script can install missing RPMs.

The Oracle Preinstallation RPM must be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

It allows you to select the languages supported by the Oracledatabase server.

It can be done before installing Grid Infrastructure for a Standalone Server.

The Oracle Preinstallation RPM can be used to configure the Oracle database installation owner, the Oracle Inventory group, and an Oracle administrative privileges group.

It can be done after installing Grid Infrastructure for a Standalone Server.

The Oracle database administrator must be granted access to the root operating system account to tun root privileged scripts.

Question 2

Which three actions are performed by Database Upgrade Assistant (DBUA)? (Choose three.)

It recompiles all stored PL/SQL code by using utlrp.sql.

It empties the RECYCLE BIN.

It performs prerequisite checks to verify if the Oracle database is ready for upgrade.

It sets all user tablespaces to “read-only” before starting theupgrade.

It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles

It increases tablespace size, if required, to meet upgrade requirements.

Question 3

Which three actions are performed by the Oracle Preinstallation RPM, oracle-database-server-xxxx- preinstall, for Oracle Grid Infrastructure, where xxxx is the Oracle version and release? (Choose three.)

performing checks to ensure minimum configuration requirements for Oracle Grid Infrastructure are met

creating the oracle OS user

creating the OSDBA (dba) group

creating thte oraInventory (oinstall) group

creating the grid OS user

configuring the OS for Oracle Automatic Storage Management shared storage access

Question 4

Automatic Shared Memory Management is disabled for one of your database instances.
SomeSQL statements perform poorly due to excessive hard parse activity, thereby degrading performance. What would be your next step?

Run the SQL Access Advisor.

Run the Memory Advisor for the shared pool.

Run the SQL Tunning Advisor.

Run theMemory Advisor for the Program Global Area.

Run the Memory Advisor for the System Global Area.

Question 5

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

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

Index balanced B*Tree height is considered whenevaluating the cost of using an index.

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

Statistics collected using DBMS_STATS always yield the best optimizer result.

The Statistics Advisor generates actions for all recommendations.

Question 6

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

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

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

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

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

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

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

Question 7

Examine this output:
1Z0-083 dumps exhibit

Which two are true? (Choose two.)

Any PDB not specified in the plan will be unable to execute statementsin parallel.

PDB3 can use all available parallel execution processes at times.

PDB1 is always limited to 40% of the available system resources regardless of demand.

Any PDB not specified in the plan will be able to use a maximum of 16.5% of the available system resources.

PDB3 is guaranteed to receive at least 20% of the available system resources if there is enough demand.

PDB2 is guaranteed at least 25% of the available parallel execution processes if there is enough demand.

Question 8

You must transport the UNIVERSITY tablespace from one database to another. The UNIVERSITY tablespace is currently open read/write.
The source and destination platforms have different endian formats. Examine this list of actions:
* 1.Make the UNIVERSITY tablespace read-only on the source system.
* 2. Export the UNIVERSITY tablespace metadata using EXPDP.
* 3. Convert the UNIVERSITY tablespace data fies to the destination platform format using RMAN on the source system.
* 4. Copy the UNIVERSITY tablespace data files to the destination system.
* 5.Copy the Data Pump dump set to the destination system.
* 6. Convert the UNIVERSITY tablespace data files to thedestination platform format using RMAN on the destination system.
* 7. Import the UNIVERSITY tablespace metadata using IMPDP.
* 8. Make the UNIVERSITY tablespace read/write on the destination system.
Which is the minimum number of actions required, in the correct order, to transport the UNIVERSITY tablespace?

1, 2, 4, 5, 7, 8

1, 2, 4, 6, 7, 8

1, 2, 3, 4, 5, 7, 8

1, 2, 3, 4, 5, 6, 7, 8

2, 4, 5, 6, 7

Question 9

Which three are true about monitoring waits for sessions and services? (Choose three.)

V$SESSION_EVENT displays all waits for all past and existing sessions if the wait has occurred at least once for a session.

V$SERVICE_EVENT displays all waits for all services if the wait has occurred at least once for a service.

V$SESSION_WAIT_CLASS displays waits broken down by wait class only for waiting sessions.

V$SESSION_WAIT and V$SESSION both contain details of the event on which a non-waiting session last waited.

V$SESSION_EVENT displays all waits for all past sessions if the wait has occurred at least once for a session.

V$SESSION_WAIT and V$SESSION both contain details of the event on which a session is currently waiting.

Question 10

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

A duplexed backup set uses the same number of SBT channels as a non-duplexed backup set for the same number of files.

A non-duplexed backup set written to disk can be duplexed to disk bybacking up the backup set that is already on disk.

A non-duplexed backup set written to SBT can be duplexed to tape by backing up the backup set that is already on tape.

A non-duplexed backup set written to disk can be duplexed to tape by backing upthe backup set that is already on disk.

A non-duplexed backup set written to SBT can be duplexed to disk by backing up the backup set that is already on tape.

A duplexed backup set always uses twice as many SBT channels as a non-duplexedbackup set for the same number of files.

Question 11

Which four are true about performing Tablespace Point -In-Time Recovery (TSPITR) using Recovery Manager (RMAN)?

It can be performed using anauxiliary instance managed by a DBA.

It can be used to recover a truncated table.

RMAN automatically adds any required tablespaces to the recovery set to make it self-contained.

RMAN always includes tablespaces containing undo segments in the recovery set.

It can be performed repeatedly until the correct time is found without using an RMAN catalog.

flashback database must be enabled for it to work.

It can be used to recover a dropped tablespace.

It can be performed using an auxiliary instance managed by RMAN.

Question 12

Examine this command:
$ rhpctl move database –sourcehome Oracle_home_path –destinationhome Oracle_home_path For which two purposes can you use this command? (Choose two.)

to switch an existing Oracle Database home to anewer release of Oracle software on the same server

to switch to a read-only Oracle home

to switch back to the previous Oracle home as part of a rollback operation

to switch the Oracle Database home when using a centralized Rapid Home Provisioningserver

to switch to a patched Oracle Database home

Question 13

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

It is automatically synchronized with its application root PDB when an application is upgraded.

It cannot be added to an application container after the application container has already been created.

A new application PDB created by cloning an application seed PDB can have an old version of the application installed after cloning completes.

It is automatically synchronized with its application root PDB when an application is installed.

It cannot be dropped from its application container.

A new application PDB created by cloning an application seed PDB canhave an up-to-date version of the application installed after cloning completes.

It is not required in an application container.

Question 14

Which two are true about the execution of operating system scripts starting from Oracle Database 19c? (Choose two.)

orainstRoot.sh can be executed automatically by the Database installer by using sudo or root credentials.

root.sh can be executed automatically by the Database Installer only if it is provided with root credentials.

The sudo password can be specified in a response file.

root.sh can be executed automatically by the Database installer only by using sudo credentials.

The sudo password must be specified in a response file.

The root password cannot be specified in a response file.

Question 15

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

It can berun only manually.

It is part of the DBMS_ADVISOR package.

It can recommend changes to improve the statistics gathering process.

It always analyzes all schemas in the database.

It runs automatically every night by default.

It is part of theDBMS_STATS package.

Question 16

Which four are true about a Recovery Manager (RMAN)duplication without a TARGET connection? (Choose four.)

The NOREDO clause must be used if the backups of the database being duplicated were taken when the database was in NOARCHIVELOG mode.

The UNDO TABLESPACE clause is always required when no connection exists to the TARGET instance.

RMAN “pushes” the backups of the database to be duplicated over the network to the auxiliary instance.

The NOREDO clause can be used if the backups of the database being duplicated were taken when the database wasin ARCHIVELOG mode.

RMAN SBT-based backups of the database to be duplicated can be used by the auxiliary instance.

The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is closed.

The UNDO TABLESPACE clause is always required when no connection exists to the recovery catalog and the TARGET database is opened.

RMAN disk-based backups of the database to be duplicated can be used by the auxiliary instance.

Question 17

Which three are true about transporting databases across platforms usingRecovery Manager (RMAN) image copies? (Choose three.)

By default, the transported database will use Oracle Managed Files (OMF)

Data files can be converted on the destination system.

Data files can be converted on the source system.

A new DBIDis automatically created for the transported database.

Databases can be transported between systems with different endian formats.

The password file is automatically converted by RMAN.

Question 18

Which two are true about the character sets used in an Oracle database? (Choose two.)

Single-byte character sets provide betterperformance than multibyte character sets.

Unicode enables information from any language to be stored using a single character set.

Unicode is the only supported character set for Oracle databases created using Database Configuration Assistant (DBCA).

Single-byte character sets always use 7-bit encoding schemes.

Multibyte character sets allow more efficient space utilization than single byte character sets.

Single-byte character sets always use 8-bit encoding schemes.

Question 19

Which two are true about Rapid Home Provisioning (RHP), which has been available since Orcale 18c? (Choose two.)

It is an Oracle Database service

It cannot be usedto upgrade Oracle Database homes.

It can be used to provision applications.

It can be used to patch Grid Infrastructure homes containing Oracle Restart.

It can be used to provision middleware.

Question 20

Examine the command for creating pluggable database PDB2 in container database CDB2.
1Z0-083 dumps exhibit

Select three options, any one of which is required for it to execute successfully. (Choose three.)

Add the FILE_NAME_CONVERT clause to the statement and set the PDB_FILE_NAME_CONVERT parameter.

Addonly the CREATE_FILE_DEST clause to the statement.

Set only the PDB_FILE_NAME_CONVERT parameter.

Set the PDB_FILE_NAME_CONVERT parameter and enable OMF.

Enable only OMF.

Add the FILE_NAME_CONVERT clause to the statement and enable OracleManaged Files (OMF)

Question 21

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

It is only possible for RMAN to connect to a pluggable database as a target if an RMAN Virtual Private Catalog is used.

It isalways possible for RMAN to connect to a pluggable database as a target if any RMAN Catalog is used.

A Virtual Private Catalog used to register a container database must be created in a pluggable database.

A Virtual Private Catalog used to registera container database can be created in a pluggable database.

It is always possible for RMAN to connect to a pluggable database as a target.

A Virtual Private Catalog used to register a container database can be created in a non-container database.

Question 22

Examine these queries and their output:
1Z0-083 dumps exhibit

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?

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMANwhile connected to PDB1.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQLwhile connected to PDB1.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using SQLwhile connected to CDB$ROOT.

Execute FLASHBACK PLUGGABLE DATABASE PDB1 TO RESTORE POINT R1 by using RMANwhile connected to CDB$ROOT.

This cannot be done due to the lack of aclean restore point.

Question 23

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

The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.

Oracle DBCA templates can store only logical structure and not database files.

New templates can only be created by modifying an existing user-created template.

The Data Warehouse template is most suitable when transaction response time is the key criterion.

Oracle DBCAtemplates can be used to create new databases and duplicate existing databases.

Question 24

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES_APP application.
Examine these steps:
* 1. Install the SALES_APP application, including the commontables, in the application root.
* 2. Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.
* 3. Create an application seed.
* 4. Install the SALES_APP application in the application seed.
* 5. Create the SALES_APP1 and SALES_APP2 application PDBs.
* 6. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.
* 7. Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.
* 8. Sync the application seed withthe application root.
Which are the minimum required steps in the correct sequence?

3,4,1,6,8

1,5,6

1,3,5,6,7

1,3,5,7

2,5,6

Question 25

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

Tablespaces are automatically created as neeed 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 anon-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.

Page: 1 / 8

Total 96 questions Full Exam Access