CertsTopics Logo

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Last Attempt 1z0-063 Questions

Page: 5 / 10
Total 276 questions
Get 1z0-063 Full Access Download 1z0-063 PDF

Oracle Database 12c: Advanced Administration Questions and Answers

Question 17

Examine the output:

SQL> ARCHIVE LOG LIST

Database log modeArchive Mode

Automatic archival Enabled

Archive DestinationUSE_DB_RECOVERY_FILE_DEST

Oldest online log sequence376

Next log sequence to archive378

Current log sequence378

Which three types of files are automatically placed in the fast recovery area? (Choose three.)

Options:

A.

Flashback data archives (FDA)

B.

Archived redo log files

C.

Control file autobackups

D.

Server parameter file (SPFILE)

E.

Recovery Manager (RMAN) backup pieces

Question 18

Your database has a table CUSTOMERS that contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.

Examine the commands executed and their output:

Why is it that only one update is listed by the Flashback Version Query?

Options:

A.

Supplemental logging is not enabled for the database.

B.

The undo data that existed for versions of rows before the change to the table structure is invalidated.

C.

The DB_FLASHBACK_RETENTION_TARGET parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.

D.

Undo retention guarantee is not enabled.

E.

Flashback Data Archive is full after the first update statement.

Question 19

You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter to YYYY-MM-DD. The default format of which two data types would be affected by this setting? (Choose two.)

Options:

A.

DATE

B.

TIMESTAMP

C.

INTERVAL YEAR TO MONTH

D.

INTERVAL DAY TO SECOND

E.

TIMESTAMP WITH LOCAL TIME ZONE

Question 20

Automatic Shared Memory Management (ASMm) is enabled for your database instance, but parameters for the managed components are not defined.

You execute this command:

SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true?

Options:

A.

The minimum size for the standard buffer cache is 100 MB.

B.

The maximum size for the standard buffer cache is 100 MB.

C.

The minimum space guaranteed in the buffer cache for any server process is 100 MB.

D.

The maximum space in the buffer cache that can be released for dynamic distribution is 100 MB.

E.

The minimum size for all buffer caches is 100 MB.

Page: 5 / 10
Total 276 questions
Get 1z0-063 Full Access Download 1z0-063 PDF