CertsTopics Logo

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

1z0-062 Questions Bank

Page: 8 / 14
Total 379 questions
Get 1z0-062 Full Access Download 1z0-062 PDF

Oracle Database 12c: Installation and Administration Questions and Answers

Question 29

Which three statements are true about a job chain? (Choose three.)

Options:

A.

It can contain a nested chain of jobs.

B.

It can be used to implement dependency-based scheduling.

C.

It cannot invoke the same program or nested chain in multiple steps in the chain.

D.

It cannot have more than one dependency.

E.

It can be executed using event-based or time-based schedules.

Question 30

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.

You want to issue the following RMAN command:

RMAN > BACKUP TABLESPACE hr_pdb:userdata;

Which task should you perform before issuing the command?

Options:

A.

Place the root container in ARHCHIVELOG mode.

B.

Take the user data tablespace offline.

C.

Place the root container in the nomount stage.

D.

Ensure that HR_PDB is open.

Question 31

Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information lifecycle Management (ILM)? (Choose three.)

Options:

A.

Tracking the most recent read time for a table segment in a user tablespace

B.

Tracking the most recent write time for a table segment in a user tablespace

C.

Tracking insert time by row for table rows

D.

Tracking the most recent write time for a table block

E.

Tracking the most recent read time for a table segment in the SYSAUX tablespace

F.

Tracking the most recent write time for a table segment in the SYSAUX tablespace

Question 32

DAILY_ORDS_LST is created in locally managed tablespace ORDERS_TBS which uses automatic segment space management.

Which two are true? (Choose two.)

Options:

A.

80% of every data block in daily_ords_list is reserved for row inserts

B.

20% of each data block in the table is reserved for row updates

C.

PCTFREE can help to minimize row chaining during inserts

D.

PCTFREE can help reduce row migration during updates

E.

PCTFREE eliminates row chaining during inserts

Page: 8 / 14
Total 379 questions
Get 1z0-062 Full Access Download 1z0-062 PDF