1z0-083 Exam Dumps - Oracle Database Administration II

Go to page:

<< First
Prev
1
2
3
4
5
6
7
8
9
10
Next
Last >>

Question # 41

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 Oracle database 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 run root privileged scripts.

Full Access

Question # 42

Choose two. In performance management, which two factors might reduce the ability of an application to scale to a larger number of users?

poorly trained users who do not commit transactions

the number of tablespaces containing tables updated by a transaction

issuing multiple savepoints during a transaction

the number of data files containing extents belonging to tables updated by a transaction

poorly written SQL

Full Access

Question # 43

Which two are true about RMAN backups when using a media manager to write backups to tape when there are only two tape drives? (Choose two.)

SBT tape compression can be used even if no RMAN compression is configured.

Any backup set written to the SBT device in this configuration can contain a maximum of two backup pieces.

Any backup written to the SBT device in this configuration can contain a maximum of two backup sets.

SBT tape compression and RMAN backup compression should be used in parallel.

The SBT device should be configured to use PARALLELISM 2 to allow both tape drive to be used simultaneously.

Full Access

Question # 44

Choose three. Your container database, CDB1, is in local undo mode. You successfully execute this command while connected to CDB1: CREATE PLUGGABLE DATABASE pdb1 ADMIN USER pdb1_admin IDENTIFIED BY pdb123 ROLES= (CONNECT) CREATE_FILE_DEST='/u01/app/oracle/oradata/cdb1/pdb1' ; Which three are true about PDB1?

It has the same common users defined as does CDB1.

It has only local roles.

It has the same number of roles as CDB1.

Service PDB1 is created for remote logins to PDB1.

It is in mount state after creation.

It has no local users.

Full Access

Question # 45

choose three Identify three reasons for using a recovery catalog with Recovery Manager (RMAN).

to allow database duplication without a connection to the target instance.

to store backup metadata that would cause the controlfile to become too large.

to store backups that would cause the controlfile to become too large.

to report on the database schema at an earlier point in time.

to allow database duplication without a connection to the auxiliary instance.

Full Access

Question # 46

Unified auditing is enabled in your database. The HR_ADMIN and OE_ADMIN roles exist and are granted system privileges. You execute the command: SQL>CREATE AUDIT POLICY table_aud PRIVILEGES CREATE ANY TABLE, DROP ANY TABLE ROLES hr_admin,oe_admin; Which statement is true?

It succeeds and needs to be enabled to capture all SQL statements that require either the specified privileges or any privilege granted to the HR_ADMIN or OE_ADMIN role.

It fails because the command does notspecify when the unified audit policy should be enforced.

It succeeds and starts capturing only successful SQL statements for all users who have either the specified privileges or roles granted to them.

It fails because system privileges cannot be granted with roles in the same audit policy.

Full Access

Question # 47

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 the upgrade.

It removes the AUDSYS schema and the AUDIT_ADMIN and AUDIT_VIEWER roles

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