1z1-063 by Oracle Valid Free Exam Practice Test

Question 1

Which two are prerequisites for setting up Flashback Data Archive? (Choose two.)

A. Automatic Undo Management should be enabled. B. All users using Flashback Data Archive should have unlimited quota on the Flashback Data Archive tablespace. C. Fast Recovery Area should be defined. D. Undo retention guarantee should be enabled. E. Supplemental logging should be enabled. F. The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.

Correct Answer: A,F

Question 2

One of your databases is in ARCHIVELOG mode and take nightly RMAN backups.
The USERS and IDX tablespaces are missing due to storage array errors.
Which four actions would recover the tablespaces and their contents while the database remains open?
(Choose four.)

A. Bring both tablespaces ONLINE. B. Restore both tablespaces from the most recent backup. C. Take both tablespaces OFFLINE IMMEDIATE. D. Recover both tablespaces. E. Bring both tablespaces ONLINE and rebuild all the instances in the IDX tablespace. F. Take both tablespaces OFFLINE NORMAL.

Correct Answer: A,B,C,D

Question 3

The CATDB12c database contains an Oracle Database version 12c catalog schema owned by the RC12C user.
The RCAT11 database contains an Oracle Database version 11g catalog schema owned by the RC11 user in which several databases are registered. Both the databases are open.
You execute the RMAN commands:

Which two tasks are performed as part of the import? (Choose two.)

A. All databases registered in the RC11 catalog are registered in the RC12C catalog. B. Recovery catalog is resynchronized with the control files of the registered databases. C. Local and global stored scripts that have the same name as existing scripts in the RC12C catalog are automatically renamed. D. Imported databases are unregistered from the RC11 catalog. E. Databases from the RC12C catalog are implicitly unregistered if the RC11 catalog has registered databases with same name.

Correct Answer: A,D

Question 4

Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)? (Choose three.)

A. All PDBs must be shut down before shutting down a CDB instance. B. When a CDB is in MOUNT state, PDBs are automatically placed in MOUNT state. C. When a CDB instance is started, PDBs can be placed in OPEN state by using database triggers or by executing the ALTER PLUGGABLE DATABASE command. D. A PDB opened in restricted mode allows only local users to connect. E. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.

Correct Answer: B,C,E

Question 5

Which statement is true about the ALTER SESSION SET CONTAINER command to switch between containers?

A. It rolls back any pending transactions in the container from which it is executed. B. It will not fire login triggers for the specified container. C. It can be executed only from CDB$ROOT. D. It cannot be used to connect to CDB$ROOT from a pluggable database (PDB). E. It cannot be used to connect to PDB$SEED.

Correct Answer: E

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 6

You want to create a duplicate database DUP_DB from your production database PROD on the same host.
The PROD database uses Automatic Storage Management (ASM) for storage. Regular backups are taken using RMAN connected to a recovery catalog.
You create an auxiliary instance and want to execute the command:

What is a prerequisite for the successful execution of this command?

A. A most recent backup set of the PROD database must exist. B. RMAN must be connected to the target database instance and the auxiliary instance. C. The target database must be in MOUNT state. D. Flashback must be enabled for the PROD database.

Correct Answer: B

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 7

You created a tablespace with this statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/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.)

A. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON; B. ALTER TABLESPACE adtbs ADD DATAFILE; C. ALTER TABLESPACE adtbs AUTOEXTEND ON; D. ALTER TABLESPACE adtbs RESI2E 20G; E. ALTER TABLESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;

Correct Answer: C,D

Explanation: Only visible for ExamsLabs members. You can sign-up / login (it's free).

Question 8

Which two statements are true regarding SecureFile lobs? (Choose two.)

A. Fragmentation is minimized by using variable-sized chunks. B. The amount of undo retained is user controlled. C. They can be used only for nonpartitioned tables. D. They support random reads and writes of encrypted LOB data.

Correct Answer: A,D

Question 9

You specified the warning and critical thresholds for a locally managed tablespace to be 60% and 70%, respectively.
From the tablespace space usage metrics, you find that the space usage has reached the specified warning threshold value, but no alerts have been generated.
What could be the reason for this?

A. The sql_trace parameter is set to false. B. The timed_statistics parameter is set to false. C. The statistics_level parameter is set to basic. D. The event parameter was not set. E. Enterprise Manager was not used.

Correct Answer: C

Question 10

Which two statements are true about a common user? (Choose two.)

A. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace. B. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs. C. A common user with the CREATE USER privilege can create other common users, as well as local users. D. A common user can be granted only a common role. E. A common user can have a local schema in a PDB.

Correct Answer: C,E

Question 11

In your database, the user SCOTT wants to retrieve the dropped HR.EMPLOYEES table by using the command:
SQL> FLASHBACK TABLE HR.EMPLOYEES TO BEFORE DROP;
What are three prerequisites for this command to succeed? (Choose three.)

A. No duplicates of the HR.EMPLOYEES table should exist in the recycle bin of the HR schema. B. SCOTT should have the SELECT privilege on the HR schema and its recycle bin. C. No other table with the same name should exist in the HR schema. D. SCOTT should have the FLASHBACK ANY TABLE privilege. E. Undo retention guarantee must be enabled. F. The recycle bin should be enabled.

Correct Answer: C,D,F

Question 12

You set the following parameters in the parameter file and restart the database instance:
NEMORY_MAX_TARGET=0
MEMORY__TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true? (Choose two.)

A. The pga_aggregate_target and sga_target parameters are automatically set to zero. B. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values. C. The memory_max_target parameter is automatically set to 500 MB. D. The value of the memory_max_target parameter remains zero for the database instance. E. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.

Correct Answer: C,E

Question 13

You want to create a database with a block size other than the default 8 KB by using the Database Configuration Assistant (DBCA).
Which option should you use?

A. A file system for storage of data files B. Automatic Storage Management (ASM) for storage of data files C. A custom database template D. A Data Warehouse database template

Correct Answer: C

Oracle Database 12c: Advanced Administration - 1z1-063 Exam Practice Test