CertsTopics Logo

Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Changed 1z0-083 Exam Questions

Page: 9 / 21
Total 286 questions
Get 1z0-083 Full Access Download 1z0-083 PDF

Oracle Database Administration II Questions and Answers

Question 33

Choose three. In which three situations can you use threshold server-generated alerts to help diagnose and fix problems?

Options:

A.

when free space in a dictionary managed tablespace falls below a specified percentage

B.

when free space in a locally managed tablespace falls below a specified percentage

C.

when the total number of locked user account exceeds a specific value

D.

when the number of logons per second exceeds a specific value

E.

when a resumable statement is suspended

F.

when the total number of logons exceeds a specific value

Question 34

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

Options:

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.

Question 35

A user complains about poor database performance. You want to verify if the user’s session has waited for certain types of I/O activity. Which view displays all waits waited on by a session at least once?

Options:

A.

V$SESSION_EVENT

B.

V$SESSTAT

C.

V$SESSION_WAIT

D.

V$SESSION_WAIT_CLASS

E.

V$SESSION

Question 36

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

Options:

A.

poorly trained users who do not commit transactions

B.

the number of tablespaces containing tables updated by a transaction

C.

issuing multiple savepoints during a transaction

D.

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

E.

poorly written SQL

Page: 9 / 21
Total 286 questions
Get 1z0-083 Full Access Download 1z0-083 PDF