CertsTopics Logo

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

Last Attempt 1z0-083 Questions

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

Oracle Database Administration II Questions and Answers

Question 9

In your Database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using information Lifecycle Management (ILM) to automate data movement?

Options:

A.

The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

B.

Settingthetargettablespacetoread-only

C.

The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED

D.

Setting the target tablespace offline

E.

The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds TBS PERCENT USED Correct

Question 10

Application PDBs, SALES_APP1 and SALES_APP2, must be created and they must access common tables of the SALES APP application. Examine these steps:

Install the SALES_APP application, induding the common tables, in the application root.

Install the SALES_APP application in the application root and the common tables in both the CDB root and the application root.

Create an application seed.

Install the SALES_APP application in the application seed.

Create the SALES_APP1 and SALES_APP2 application PDBs.

Sync the SALES_APP1 and SALES_APP2 application PDBs with the application root.

Sync the SALES_APP1 and SALES_APP2 application PDBs with the application seed.

Sync the application seed with the application root. Which are the minimum required steps in the correct sequence?

Options:

A.

1,3,5,7

B.

2,5,6

C.

1,5,6

D.

3,4,1.6,8

E.

1,3,5,6,7

Question 11

Choose three. Which three are true about configuring CONTROLFILE AUTOBACKUP by using RMAN?

Options:

A.

The control file is backed up whenever a new tablespace is created.

B.

The server parameter file (SPFILE) is automatically backed up each time the control file is backed up.

C.

The control file is backed up whenever a new table is created.

D.

The control file is backed up whenever an RMAN backup is successfully recorded in the catalog.

E.

It requires the use of fast recovery area (FRA).

F.

The control file is backed up automatically each time the SPFILE is backed up manually.

Question 12

Which three are true in Oracle 19c and later releases? (Choose three.)

Options:

A.

If the password file location changes, then the new location is used automatically by the Oracle Server.

B.

Schema Only accounts can be granted administrator privileges.

C.

All the Oracle-supplied accounts are Schema Only accounts.

D.

Privilege Analysisisincluded in Oracle Enterprise Edition and no longer requires Database Vault. E) Unified Auditing can be configured to audit only events that are issued indirectly by an audited user.

E.

Unified Auditing can be configured to audit only events that are issued directly by an audited user.

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