Free 1z0-063 Questions Attempt

Oracle Database 12c: Advanced Administration Questions and Answers

Question 33

A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.

Which table organization allows for generating the bills with minimum degree of row sorting?

Options:

a hash cluster

an index cluster

a partitioned table

a sorted hash cluster

a heap table with a rowid column

Question 34

Examine this command:

SQL> CREATE DATABASE cdb1

DEFAULT TABLESPACE users

DEFAULT TEMPORARY TABLESPACE temp

UNDO TABLESPACE undotbs1

ENABLE PLUGGABLE DATABASE

SEED

SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED

SYSAUX DATAFILES SIZE 100M;

Which two requirements must be met to ensure that CDB1 is created? (Choose two.)

Options:

The ENABLE_PLUGGABLE_DATABASE parameter must be set to TRUE.

The PDB_FILE_NAME_CONVERT parameter must be configured.

The FILE_NAME_CONVERT clause must be added to the command.

The USER_DATA TABLESPACE clause must be added to the command.

The DB_CREATE_FILE_DEST parameter must be configured.

Question 35

Which two are true about incremental backups? (Choose two.)

Options:

A backup set can be used as the baseline for an incremental backup.

Differential backups can be taken at level 0.

An image copy can be used as the baseline for an incremental backup.

A tablespace incremental level 1 backup always backs up all blocks in the backed up tablespace.

Incremental backups are not permitted when using block change tracking.

A database incremental level 0 backup always backs up all database blocks.

Question 36

You want to back up a database such that only formatted blocks are backed up. Which statement is true about this backup operation?

Options:

The backup must be performed in MOUNT state.

The tablespace must be taken offline.

All files must be backed up as backup sets.

The database must be backed up as an image copy.

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

Oracle Database 12c: Advanced Administration Questions and Answers

Options:

Answer:

Options:

Answer:

Options:

Answer:

Explanation:

Options:

Answer:

CompTIA

Fortinet

Microsoft

Salesforce