04 February, 2022

All About Printable 1Z0-063 Study Guides

It is more faster and easier to pass the Oracle 1Z0-063 exam by using Guaranteed Oracle Oracle Database 12c: Advanced Administration questuins and answers. Immediate access to the Leading 1Z0-063 Exam and find the same core area 1Z0-063 questions with professionally verified answers, then PASS your exam with a high score now.

Also have 1Z0-063 free dumps questions for you:

Page: 1 / 19

Total 235 questions Full Exam Access

Question 1

- (Exam Topic 1)
LDAP_DIRECTORY_SYSAUTH is set to YES.
Users requiring DBAs access have been granted the sysdba enterprise role in Oracle Internet Directory (OID). SSL has been configured for the database and OID and the password file has been configured for the database. User scott with sysdba privilege tries to connect remotely using this command:
$sqlplusscott/tiger@DB0l As sysdba where DB01 is the net service name. Which authentication method will be attempted first?

authentication by password file

authentication by using certificates over SSL

authentication by using the Oracle Internet Directory

authentication by using the local OS of the database server

Question 2

- (Exam Topic 1)
Which two statements are true regarding the Oracle Data Pump export and import operations? (Choose two.)

You cannot export data from a remote database.

You can rename tables during import.

You can overwrite existing dump files during export.

You can compress data but not metadata during export.

Question 3

- (Exam Topic 1)
You install "Oracle Grid Infrastructure for a standalone server" on a host on which the orcl1 and orcl2 databases both have their instances running.
Which two statements are true? (Choose two.)

Both orcl1 and orcl2 are automatically added to the Oracle Restart configuration.

All database listeners running from the database home are automatically added to the Oracle Restart configuration.

The srvct1 add database command must be used to add orcl1 and orcl2 to the Oracle Restart configuration.

The crsct1 start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation iscomplete.

All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.

Question 4

- (Exam Topic 1)
Examine these Data Pump commands to export and import objects from and to the same database. The dba has not yet created users hr1 and oe1.
$expdp system/manager schemas = hr.oe directory = EXP_DIR dumpfile = export.dat include = table
$ impdpsysten/manager schemas = hr1,oe1 directory = EXP_DIR dumpfile = export.dat
remap_schena=hr:hrl, oe:oe1
What will happen when running these commands?

expdp will fail because no path has been defined for the dumpfile.

expdp will succeed but impdp will fail because the users do not exist.

inpdp will create two users called hr1 and oe1 and import all objects to the new schemas.

impdp will create two users called hr1 and oe1 and import only the tables owned by hr and oe schemas to ht1 and oe1 schemas, respectively.

Question 5

- (Exam Topic 1)
Examine the following steps of privilege analysis for checking and revoking excessive, unused privileges
granted to users:
1. Create a policy to capture the privileges used by a user for privilege analysis.
2. Generate a report with the data captured for a specified privilege capture.
3. Start analyzing the data captured by the policy.
4. Revoke the unused privileges.
5. Compare the used and unused privileges' lists.
6. Stop analyzing the data.
Identify the correct sequence of steps.

1, 3, 5, 6, 2, 4

1, 3, 6, 2, 5, 4

1, 3, 2, 5, 6, 4

1, 3, 5, 2, 6, 4

Question 6

- (Exam Topic 1)
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)? (Choose three.)

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

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

tracking insert time by row for table rows

tracking the most recent write time for each block in a table segment

tracking the most recent read time for a table segment in the sysaux tablespace

tracking the most recent write time for a table segment in the sysaux tablespace

Question 7

- (Exam Topic 1)
In which three scenarios is media recovery required? (Choose three.)

when a tablespace is accidentally dropped from a database

when archived redo log files are lost

when data files are lost

when one of the online redo log members is corrupted

when all control files are lost

Question 8

- (Exam Topic 2)
Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

The PDB must be open in read only mode.

The PDB must be dosed.

The unplugged PDB becomes a non-CDB.

The unplugged PDB can be plugged into the same multitenant container database (CDB)

The unplugged PDB can be plugged into another CDB.

The PDB data files are automatically removed from disk.

Question 9

- (Exam Topic 1)
Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)? (Choose two.)

Use the DBMS_PDB package to plug the Oracle 11g database into the existing CDB as a PDB.

Use the CREATE DATABASE ... ENABLE PLUGGABLE DATABASE statement to create a PDB by copying data files from PDB$SEED and use data pump to load data from the Oracle 11g database into the newly created PDB.

Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.

Pre-create a PDB in CDB and use the NETWORK_LINK and PARALLEL parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.

Upgrade the Oracle 11g database to a 12c non-CDB and use the DBMS_PDB.DESCRIBE procedure to plug the database as a new PDB into the CDB.

Question 10

- (Exam Topic 2)
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:
1Z0-063 dumps exhibit

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

The target database must be in MOUNT state.

RMAN must be connected to the target database instance and the auxiliary instance.

A most recent backup set of the PROD database must exist.

Flashback must be enabled for the PROD database.

Question 11

- (Exam Topic 2)
Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):
1Z0-063 dumps exhibit

Which statement is true about granting the SELECT privilege on the DBA_USERS view to the c##ROLE1 role?

The command fails and gives an error because object privileges cannot be granted to a common user.

The command fails because CONTAINER is not set to CURRENT.

The command succeeds and the common user C##ADMIN can create a session and query the DBA_USERS view in CDB$ROOT and all the PDBs.

The command succeeds and the common user C##ADMIN can create a session in CDB$ROOT and all the PDBs, but can only query the DBA_USERS view in CDB$ROOT.

The command succeeds and the common user C##ADMIN can create a session and query the DBA_USERS view only in CDB$ROOT.

Question 12

- (Exam Topic 2)
Which activity is audited by default and recorded in the operating system audit trail irrespective of whether or not database auditing is enabled?

configuration of unified auditing mode

execution of SQL statements by users connected with the SYSDBA privilege

usage of the AUDIT statement

creation of a fine grained audit policy

Question 13

- (Exam Topic 1)
Which three statements are true about the keystore storage framework for transparent data encryption? (Choose three.)

It facilitates and helps to enforce keystore backup requirements.

It handles encrypted data without modifying applications.

It enables a keystore to be stored only in a file on a file system.

It enables separation of duties between the database administrator and the security administrator.

It transparently decrypts data for the database users and applications that access this data.

It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

Question 14

- (Exam Topic 2)
Your database supports an OLTP workload. Examine the output of the query:
1Z0-063 dumps exhibit

To ensure faster instance recovery, you set the FAST_START_MTTR_TARGET initialization parameter to 30.
What is the effect of this setting on the database?

Automatic checkpoint tuning is disabled.

The frequency of log switches is increased.

The overhead on database performance is increased because of frequent writes to disk.

The MTTR advisor is disabled.

Question 15

- (Exam Topic 1)
Which two are prerequisites for setting up Flashback Data Archive? (Choose two.)

Fast Recovery Area should be defined.

Undo retention guarantee should be enabled.

Supplemental logging should be enabled.

Automatic Undo Management should be enabled.

All users using Flashback Data Archive should have unlimited quota on the Flashback Data Archive tablespace.

The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.

Question 16

- (Exam Topic 2) Examine the command and its output: SQL> DROP TABLE EMPLOYEE;
SQL> SELECT object_name AS recycle_name, original_name, type
FROM recyclebin; RECYCLE_NAMEORIGINAL_NAMETYPE
binsgk31sj/3akk5hg3j21kl5j3d==$0EMPLOYEE TABLE You then successfully execute the command:
SQL> FLASHBACK TABLE "BINSgk31sj/3akk5hg3j21kl5j3d==$0" TO BEFORE DROP;
Which two statements are true? (Choose two.)

It flashes back the employee table and all the constraints associated with the table.

It automatically flashes back all the indexes on the employees table.

It automatically flashes back any triggers defined on the table.

It flashes back only the structure of the table and not the data.

It flashes back the data from the recycle bin and the existing data in the original table is permanently lost.

Question 17

- (Exam Topic 2)
Examine the RMAN command:
1Z0-063 dumps exhibit

Which statement is true about the command?

It creates compressed backup sets.

It uses asynchronous I/O for the backup.

It uses parallelization for the backup set.

It uses multisection backup.

Question 18

- (Exam Topic 1)
Your production database is running in ARCHIVELOG mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.
You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.
How would you achieve this?

by using the RMAN SWITCH command to set the new location for the data files

by using the RMAN DUPLICATE command with NOFILENAMECHECK to recover the database to the new host

by using the RMAN DUPLICATE command with DBID and SET NEWNAME FOR TABLESPACE to recover the database to the new host

by creating a new database in the new host, and then using the RMAN RECOVER command

Question 19

- (Exam Topic 2)
Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start?

from the last complete checkpoint position

from the beginning of the current redo log file until the instance failure

from the last committed transaction

from the beginning of the current redo log file to the checkpoint position

from the most recent incremental checkpoint

Question 20

- (Exam Topic 1)
Which three types of failures are detected by the Data Recovery Advisor (DRA)? (Choose three.)

loss of a non-critical data file

loss of a control file

physical data block corruption

logical data block corruption

loss of an archived redo log file

Question 21

- (Exam Topic 1)
A complete database backup to media is taken for your database every day. Which three actions would you take to improve backup performance? (Choose three.)

Set the backup_tape_io_slaves parameter to true.

Set the dbwr_io_slaves parameter to a nonzero value if synchronous I/O is in use.

Configure large pool if not already done.

Remove the rate parameter, if specified, in the allocate channel command.

Always use RMAN compression for tape backups rather than the compression provided by media manager.

Always use synchronous I/O for the database.

Question 22

- (Exam Topic 1)
Which two statements are true about a multitenant architecture? (Choose two.)

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

A PDB can have a private undo tablespace.

Log switches occur only at the container database level.

A PDB can have a private temporary tablespace.

Each PDB has a private control file.

Question 23

- (Exam Topic 2)
Which two statements are true about service creation for pluggable databases (PDBs)? (Choose two.)

When a PDB is created, a service is automatically started in the instance with the same name as the PDB.

The default service that is automatically created by a database at the time of PDB creation can be dropped, provided a new additional service is created.

A database managed by Oracle Restart can have additional services created or existing services modified by using the SRVCTL utility for each PDB.

Only a common user can create additional services for a PDB.

When a PDB is created, a service with the same name as the PDB is created in the PDB.

Page: 1 / 19

Total 235 questions Full Exam Access