Spring Sale Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Oracle Database Administration II

Last Update 1 day ago Total Questions : 286

The Oracle Database Administration II content is now fully updated, with all current exam questions added 1 day ago. Deciding to include 1z0-083 practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our 1z0-083 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these 1z0-083 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any Oracle Database Administration II practice test comfortably within the allotted time.

Question # 4

Choose two. Which two are true about a read-only Oracle home?

A.

It is enabled by performing a software-only Oracle Database installation and then running the roohctl ¬enable script.

B.

It requires the Rapid Home Provisioning service.

C.

Its configuration data and log files reside in subdirectories under the Oracle home.

D.

It is enabled by performing an Oracle Database installation with database creation and then running the roohctl -enable script.

E.

It contains an image that can be distributed across multiple servers.

Question # 5

Which three are true? (Choose three.)

A.

Virtual Private Database (VPD) policies on objects in an application root are automatically synchronized with all application PDBs contained in the application container.

B.

Application-common TSDP policies are always container specific.

C.

Application-common Transparent Security Data Protection (TSDP) policies can be created only within an application install/patch BEGIN-END block.

D.

Application-common Oracle Label Security (OLS) policies cannot be created in an application root outside an install/patch BEGIN-END block.

E.

Fine-grained auditing (FGA) policies in an application root are automatically synchronized to all application PDBs contained in the application container.

F.

Application-common OLS policies can be created in an application root inside an install/patch BEGIN¬END block.

G.

Unified auditing can be automatically synchronized to all application PDBs in an application container.

Question # 6

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 valuesthat have been modified. G)A DBA must specify either a redundancy retention policy or a recovery window retention policy.

Question # 7

Choose three. Which three are true about patchsets?

A.

They are installed via OPatch or OPatchAuto.

B.

A base release is not needed to install patchsets.

C.

They can be applied in a rolling fashion for Clusterware and the databases.

D.

Installing a patchset is considered an " upgrade. "

E.

They can introduce new features.

F.

They are only released quarterly.

Question # 8

Choose two. Which two are true about RMAN backups when using a media manager?

A.

A media manager always writes RMAN requested backups to tape.

B.

A media manager is required to create RMAN image copies.

C.

A media manager is required to create RMAN proxy copies.

D.

The media manager layer (MML) routines provided by Oracle support any vendors ' media management products.

E.

By default, a request for a proxy copy may result in a backup set being created.

Question # 9

Choose three. Which three are true about actions that can or cannot be performed by users with the SYSBACKUP privilege?

A.

They can view data from any data dictionary view or dynamic performance view.

B.

They can drop any tablespace.

C.

They can view data from any user-defined tables.

D.

They can create any table.

E.

They cannot create restore points.

F.

They cannot drop tablespaces.

Question # 10

Choose two. Which two are true about RMAN persistent configuration settings, administration, and their effects?

A.

A DBA must specify either a redundancy retention policy or a recovery window retention policy. B)A target database ' s persistent RMAN configuration settings are always synchronized automatically with the RMAN catalog.

B.

Backups 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 obsolete based on the redundancy retention policy can be deleted automatically to free space.

D.

A target database ' s persistent RMAN configuration settings are always stored in the target ' s control file.

Go to page: