1z0-063 sample questions

Question 1

Which two statements are true when row-archival management is enabled? (Choose two.)

Accepted Answer

The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.

Accepted Answer

The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.

Answer

Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.

Answer

The row archival visibility session parameter defaults to all rows.

Answer

The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.

Question 2

One ofyour multitenant container databases (CDB) contains multiple pluggable databases (PDBs). You connect to CDB$ROOT as SYS and execute these commands successfully:
SQL) CREATE USER C##ADMIN IDENTIFIED BY orcl123;
SQL) CREATE ROLE C##CONNECT;
SQL) GRANT CREATE SESSION, CREATE TABLE, SELECT ANY TABLE TO C##CONNECT;
SQL) GRANT C##CONNECT to C##ADMIN CONTAINER=ALL;Which three are true? (Choose three.)

Accepted Answer

The C##CONNECT role can be granted different roles and privileges in each PD

Accepted Answer

The C##CONNECT role is granted to the C##ADMIN user in all PDBs.

Accepted Answer

The C##CONNECT role is a local role defined only in CDB$ROOT.

Answer

B. C##ADMIN has the orcl123 password in all PDBs.

Answer

CREATE SESSION is granted to the C##ADMIN user in all PDBs.

Question 3

Which two statements are true about a multitenant architecture? (Choose two.)

Accepted Answer

Log switches occur only at the container database level.

Accepted Answer

A PDB can have a private temporary tablespace.

Answer

Each pluggable database (PDB) has its own initialization parameter file.

Answer

A PDB can have a private undo tablespace.

Answer

Each PDB has a private control file.

Question 4

In your database, there are tablespaces that were read-only when the last backup was taken. These tablespaces have not been made read/write since then. You want to perform an incomplete recovery on the database by using a backup control file.
What precaution must you take for the read-only tablespaces before performing an incomplete recovery?

Accepted Answer

All the read-only tablespaces should be taken offline.

Answer

All the read-only tablespaces should be restored separately.

Answer

All the read-only tablespaces should be renamed to have the MISSINGnnnn format.

Answer

All the read-only tablespaces should be made online with logging disabled.

Question 5

user_data is a non-encrypted tablespace containing tables with data. You must encrypt all data in this tablespace. Which three methods can do this? (Choose three.)

Accepted Answer

Use Data Pump.

Accepted Answer

Use ALTERTABL

Accepted Answer

. .MOVE

Answer

Use CREATE TABLE AS SELECT

Answer

Use alter tablespace to encrypt the tablespace after enabling row movement on all its disk space E. Use altertablespace to encrypt the tablespace.

Question 6

You plan to duplicate the multitenant container database (CDB) cdb1 that contains the pluggable database (PDB) SALES: Which two statements are true? (Choose two.)

Accepted Answer

The root and seed databases are included in the duplication.

Accepted Answer

An auxiliary instance must have been started with the initialization parameter ENABLE_PLUGGABLE_DATABASE setto TRU

Answer

Only the SALES PDB is duplicated as the non-CDB CDBDUP.

Answer

A backup of the SALES PDB must exist before the execution of the command.

Answer

E. RMAN must be connected to a recovery catalog for the execution of the command.

Question 7

You created a tablespace with this statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE Vproddb/data/adtbs.dbf SIZE 10G;

The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this? (Choose two.)

Accepted Answer

ALTER TABLESPACE adtbs RESI2E 20G;

Accepted Answer

ALTER TABLESPACE adtbs AUTOEXTEND ON;

Answer

ALTER TABLESPACE adtbs ADD DATAFILE;

Answer

ALTER TABLESPACE adtbs ADD DATAFILE Vproddb/data/adtbsl.dbf SIZE 1QG;

Answer

ALTER TABLESPACE adtbs MODIFY DATAFILE Vproddb/data/adtbs.dbfAUTOEXTEND ON;

Question 8

Which three statements are true about compression of backup sets? (Choose three.)

Accepted Answer

Binary compression creates performance overhead during a backup operation.

Accepted Answer

Unused blocks below the high-water mark are not backed up.

Accepted Answer

It works only for locally managed tablespaces.

Answer

Compressed backups can only be written to media.

Answer

Compressed backups cannot have section size defined during a backup operation.

Question 9

Your multitenant container database (CDB) CDB1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:SQL)STARTUPWhich two statements are true about the successful execution of the command? (Choose two.)

Accepted Answer

All redo log files are opened.

Accepted Answer

Only the root database is opened in read-write mode.

Answer

The root, the seed, and all the PDBs are opened in read-write mode.

Answer

All the PDBs are opened in read-write mode.

Answer

All the PDBs are in closed state.

Question 10

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?

Accepted Answer

The minimum size for the standard buffer cache is 100 M

Answer

B. The maximum sizeforthe standard buffer cache is 100 MB.

Answer

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

Answer

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

Answer

The minimum size for all buffer caches is 100 MB.

1z0-063 Oracle Database 12c: Advanced Administration Practice Questions

Create an account to continue.

Create an account to continue.

Related exams