Cert12c_067_61a90_passLeader

Question 1

QUESTION 61
ENCRYPT_TS is an encrypted tablespace that contains tables with data.
Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

Accepted Answer

C. The data remains encrypted when it is stored in the redo logs.

Answer

A. The data is decrypted during SORT and JOIN operations.

Answer

B. The data remains encrypted when it is read into memory.

Answer

D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled.

Question 2

QUESTION 62
Which three statements are true about Oracle Secure Backup (OSB)?

Accepted Answer

A. It can encrypt client data written to tape.

Accepted Answer

C. It can be used to manage tape backup and restore operations for multiple databases.

Accepted Answer

E. It can be used to perform file system backups at the file, directory, file system, or raw partition level.

Answer

B. It can be used to take image copy backups to tape.

Answer

D. It can be used along with an RMAN recovery catalog for maintaining records of backups in a tape library.

Question 3

QUESTION 63
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 configure for the database and OLD 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?

Accepted Answer

A. authentication by password file

Answer

B. authentication by using certificates overSSL

Answer

C. authentication by using the Oracle Internet Directory

Answer

D. authentication by using the local OS of the database server

Question 4

QUESTION 64
Your database is running in archivelog mode and regular nightly backups are taken. Due to a media failure, the current online redo log group, which has one member, is lost and the instance is aborted.
Examine the steps to recover the online redo log group and move it to a new location.
1.Restore the corrupted redo log group.
2.Restore the database from the most recent database backup.
3.Perform an incomplete recovery.
4.Relocate the member of the damaged online redo log group to a new location.
5.Open the database with the resetlogs option.
6. Issue a checkpoint and clear the log.
Identify the required steps in the correct order.

Accepted Answer

C. 2, 3, 4, 5

Answer

A. 1, 3, 4, 5

Answer

B. 6, 3, 4, 5

Answer

D. 6, 4, 3, 5

Question 5

QUESTION 65
You are administering a multitenant container database (COB) that contains two pluggable databases (PDBs), pdb1 and pdb2. You are connected to pdb2 as a common user with DBA privileges.
The statistics_level parameter is PDB modifiable.
As the user sys, execute the following command on pdb2:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SID='*' SCOPE=SPFILE;
Which statement is true about the result of this command?

Accepted Answer

B. The statistics_level parameter is set to all only for PDB2 when it is reopened.

Answer

A. The statistics_level parameter is set to all when any of the PDBs is reopened

Answer

C. The statistics_level parameter is set to all when the root database is restarted.

Answer

D. The statement is ignored because there is no SPFILE for a PDB.

Question 6

QUESTION 66
Examine the command to back up the ASM metadata:
ASMCMD>md_backup /backup/ASM_backup
In which three situations can you use the backup?

Accepted Answer

A. when one or more disks in anASMdisk group are lost

Accepted Answer

D. when one or more file directory paths are accidentally deleted from anASMdisk group

Accepted Answer

E. when all theASMdisk groups for theASMinstance are lost

Answer

B. when the data file on anASMdisk group gets corrupted

Answer

C. when one of the disks in a disk group is accidentally unplugged

Question 7

QUESTION 67
You are administering a database that supports data warehousing workload and Is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 Incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
You want to recover the data file.
Examine the steps involved in the recovery process:
1.Shut down the database instance.
2.Start up the database instance in nomount state.
3.Mount the database.
4.Take the data file offline.
5.Put the data file online.
6.Restore the control file.
7.Restore the database.
8.Restore the data file.
9.Open the database with the resetlog option.
10.Recover the database with the noredo option.
11.Recover the data file with the noredo option.
Identify the required steps in the correct order.

Accepted Answer

C. 1, 2, 6, 3, 7, 10, 9

Answer

A. 4, 8, 11, 5

Answer

B. 1, 3, 8, 11, 9

Answer

D. 1, 3, 7, 10, 9

Answer

E. 1, 2, 6, 3, 8, 11, 9

Question 8

QUESTION 68
Examine the commands:
SQL> ALTER SESSION SET RECYCLBIN = ON;
Session altered.
SQL> DROP TABLE emp; --(First EMP table)
Total dropped.
SQL> CREATE TABLE emp (id NUMBER CONSTRAINT emp_id_idx PRIMARY KEY, name VARCHAR2 (15), salary NUMBER(7,2) );
Table created.
You then execute multiple INSERT statements to insert rows into EMP table and drop the table again:
SQL> DROP TABLE emp; -- (Second EMP table)
Table dropped.
SQL> FLASHBACK TABLE emp TO BEFORE DROP;
Which statement is true about the FLASHBACK command?

Accepted Answer

D. It recovers the structure, data, and indexes of the second emp table.

Answer

A. It recovers the structure, data, and indexes of the first emp table.

Answer

B. It recovers only the structure of the second emp table.

Answer

C. It returns an error because two tables with the same name exist in the recycle bin.

Question 9

QUESTION 69
Which three statements are true about the keystore storage framework for transparent data encryption?

Accepted Answer

A. It facilitates and helps to enforce keystore backup requirements

Accepted Answer

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

Accepted Answer

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

Answer

B. It handles encrypted data without modifying applications.

Answer

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

Answer

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

Question 10

QUESTION 70
You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects. During this operation, you want to ensure the following:
i.Long-running queries are not affected.
ii.No extra space is used.
iii.Data manipulation language (DML) operations on the table succeed at all times throughout theprocess.
iv.Unused space is reclaimed both above and below the high water mark.
Which alter TABLE option would you recommend?

Accepted Answer

C. SHRINK SPACE COMPACT

Answer

A. DEALLOCATE UNUSED

Answer

B. SHRINK SPACE CASCADE

Answer

D. ROW STORE COMPRESSBASIC

Question 11

QUESTION 71
You have a production Oracle 12c database running on a host.
You want to install and create databases across multiple new machines that do not have any Oracle database software installed.
You also want the new databases to have the same directory structure and components as your existing 12c database.
The steps in random order:
1.Create directory structures similar to the production database on all new machines.
2.Create a response file for Oracle Universal Installer (OUI) with the same configurations as the production database.
3.Create a database clone template for the database.
4.Run the Database Configuration Assistant (DBCA) to create the database.
5.Run OUI in graphical mode on each machine.
6.Run OUI in silent mode using the OUI response file.
Identify the required steps in the correct sequence to achieve the requirement with minimal human intervention.

Accepted Answer

D. 2, 3, 1, and 6

Answer

A. 2, 1, 6, and 4

Answer

B. 2, 3, and 6

Answer

C. 3, 1, 5, and 6

Answer

E. 1, 5, and 4

Question 12

QUESTION 72
For which two requirements would you use the Database Resource Manager?

Accepted Answer

D. limiting the degree of parallelism of operations performed by a user or group of users

Accepted Answer

E. specifying an idle time limit that applies to sessions that are idle and blocking other sessions

Answer

A. limiting the CPU used per database call

Answer

B. specifying the maximum number of concurrent sessions allowed for a user

Answer

C. specifying the amount of private space a session can allocate in the shared pool of the SGA

Question 13

QUESTION 73
Your multitenant container database (CDB) contains multiple pluggable databases (PDBs).
You execute the command to create a common user:
SQL> CREATE USER c##a_admin
IDENTIFIED BY password
DEFAULT TABLESPACE users
QUOTA I00M ON users
TEMPORARY TABLESPACE temp;
Which statement is true about the execution of the command?

Accepted Answer

B. The command succeeds only if all the PDBs have the users and temp tablespaces.

Answer

A. The common user is created in the CDB and all the PDBs, and uses the users and temp tablespaces of the CDB to store schema objects.

Answer

C. The command gives an error because the container=all clause is missing.

Answer

D. The command succeeds and sets the default permanent tablespace of a PDB as the default tablespace for the c##a_admin user if the users tabiespace does not exist in that PDB.

Question 14

QUESTION 74
Which two statements are true about the Automatic Diagnostic Repository (ADR)?

Accepted Answer

A. The ADR base is shared across multiple instances.

Accepted Answer

D. The ADR can be used for problem diagnosis even when the database instance is down

Answer

B. The ADR base keeps all diagnostic information in binary format.

Answer

C. The ADR can be used to store statspack snapshots to diagnose database performance issues.

Answer

E. The ADR is used to store Automatic Workload Repository (AWR) snapshots.

Question 15

QUESTION 75
user_data is a nonencryptedtablespace containing tables with data.
You must encrypt ail data in this tablespace.
Which three methods can do this?

Accepted Answer

A. Use Data Pump.

Accepted Answer

B. Use ALTERTABLE. . .MOVE

Accepted Answer

C. Use CREATE TABLE AS SELECT

Answer

D. Use alter tablespace to encrypt the tablespace after enabling row movement on all its

Answer

E. Use altertablespace to encrypt the tablespace.

Question 16

QUESTION 76
Which two statements are true about a common user?

Accepted Answer

B. A common user with the create user privilege can create other common users, as well as local users.

Accepted Answer

D. A common user can have a local schema in a PDB.

Answer

A. A common user connected to a pluggable database (PDB) can exercise privileges across other PDBs.

Answer

C. A common user can be granted only a common role.

Answer

E. A common user always uses the global temporary tablespace that is defined at the CDB level as the default temporary tablespace.

Question 17

QUESTION 77
You are administering a database that supports a data warehousing workload and is running in noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1 incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
Which action must you take for recovery?

Accepted Answer

B. Restore the control file and all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

Answer

A. Restore the data file, recover it by using the recover datafilenoredo command, and use the resetlogs option to open the database.

Answer

C. Restore all the data files, recover them by using the recover database command, and open the database.

Answer

D. Restore all the data files, recover them by using the recover database noredo command, and use the resetlogs option to open the database.

Question 18

QUESTION 78
Which three statements are true about Oracle Restart?

Accepted Answer

A. It can be configured to automatically attempt to restart various components after a hardware or software failure.

Accepted Answer

B. While starting any components, it automatically attempts to start all dependencies first and in proper order.

Accepted Answer

E. It runs periodic check operations to monitor the health of Oracle components.

Answer

C. It can be configured to automatically restart a database in case of normal shutdown of the database instance.

Answer

D. It can be used to only start Oracle components

Question 19

QUESTION 79
Examine the parameters for your database instance:
NAMETYPEVALUE
-----------------------------------------------------------------------
optimizer_adaptive_reporting_onlybooleanFALSE
optimizer_capture_sql_plan_baselinesbooleanFALSE
optimizer_dynamic_samplinginteger2
optimizer_features_enablestring12.1.0.1
Which three statements are true about the process of automatic optimization by using statistics feedback?

Accepted Answer

A. The optimizer automatically changes a plan during subsequent execution of a SQL statement if there is a huge difference in optimizer estimates and execution statistics.

Accepted Answer

C. The optimizer enables monitoring for cardinality feedback after the first execution of a query.

Accepted Answer

D. The optimizer does not monitor cardinality feedback if dynamic sampling and multicolumn statistics are enabled.

Answer

B. The optimizer can re optimize a query only once using cardinality feedback.

Answer

E. After the optimizer identifies a query as a re-optimization candidate, statistics collected by the collectors are submitted to the optimizer.

Question 20

QUESTION 80
RMAN is connected to the target database prod1 and an auxiliary instance in nomount state.
Examine the command to create a duplicate database:
RMAN> DUPLICATE TARGET DATABASE TO dup1
FROM ACTIVE DATABASE
NOFILENAMECHECK
PASSWORD FILE
SPFILE;
Which two statements are true about the execution of the duplicate command?

Accepted Answer

B. The duplicate database has the same directory structure as the source database.

Accepted Answer

The duplicate database is created without using RMAN backups and prod: is allowed to remain open during duplication.

Answer

A. All archive redo log files are automatically copied to the duplicate database

Answer

C. The duplicate database is created by using the backups created during the execution of D. the duplicate command.

Answer

The password file and SPFILE for the duplicate database dup1 are created in their respective default locations.

Question 21

QUESTION 81
A user issues a query on the sales table and receives the following error:
ERROR at line 1:
ORA-01565: error in identifying file '/u0l/app/oracle/oradata/ORCL/temp01.dbf'
ORA-27037: unable to obtain file status
Which two actions would you take to recover the temporary tablespace?

Accepted Answer

B. Add a new temp file to the temporary tablespace and drop the tempOi.dbf file.

Accepted Answer

E. Create a new temporary tablespace and assign it as the default to the user.

Answer

A. Drop the tenpOi.dbf file, and then re-create the temp file.

Answer

C. Shut down the database instance, start up the database instance in mount state, create a new temporary tablespace, and then open the database.

Answer

D. Take the temporary tablespace offline, recover the missing temp file, and then bring the temporary tablespace online.

Question 22

QUESTION 82
Your database supports an online transaction processing (OLTP) workload in which one of the applications creates a temporary table for a session and performs transactions on it.
This consumes a lot of undo tablespace and is affecting undo retention.
Which two actions would you take to solve this problem?

Accepted Answer

A. Enable temporary undo for the database

Accepted Answer

E. Increase the size of the temporary tablespace.

Answer

B. Enable undo retention guarantee.

Answer

C. Increase the size of the redo log buffer.

Answer

D. Enable Automatic Memory Management (AMM).

Question 23

QUESTION 83
Which two statements are true about service creation for pluggable databases (PDBs)?

Accepted Answer

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

Accepted Answer

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

Answer

B. 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.

Answer

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

Answer

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

Question 24

QUESTION 84
You want to move your existing recovery catalog to another database.
Examine the steps:
1) Export the catalog data by using the Data Pump Export utility in the source database.
2) Create a recovery catalog user and grant the necessary privileges in the target database.
3) Create a recovery catalog by using the create catalog command.
4) Import the catalog data into the new recovery catalog by using the Data Pump Import utility in the target database.
5) Import the source recovery catalog schema by using the import catalog command.
6) Connect to the destination database.
7) Connect as catalog to the destination recovery catalog schema.
Identify the option with the correct sequence for moving the recovery catalog.

Accepted Answer

B. 2, 3, 7, 5

Answer

A. 1, 6, 4

Answer

C. 1, 2, 6, 4

Answer

D. 1, 2, 3, 6, 5

Question 25

QUESTION 85
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?

Accepted Answer

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

Accepted Answer

C. It automatically flashes back any triggers defined on the table.

Answer

B. It automatically flashes back all the indexes on the employes table.

Answer

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

Answer

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

Question 26

QUESTION 86
Which parameter must be set to which value to implement automatic PGA memory management?

Accepted Answer

C. Set pga_aggregate_target to a nonzero value.

Answer

A. Set memory_target to zero.

Answer

B. Set STATISTICS_LEVEL to BASIC.

Answer

D. Set pga_aggregate_target and sga_target to the same value.

Answer

E. Set sgajtarget to zero.

Question 27

QUESTION 87
Examine the following set of RMAN commands:
RKAN> CONFIGURE CHANNEL del DEVICE TYPE DISK FORMAT ' /u02/backup/%U' ;
RKAN> RUN
{
ALLOCATE CHANNEL chl DEVICE TYPE DISK;
EXECUTE SCRIPT arc_backup;
}
Which statement is true about the RMAN run block execution?

Accepted Answer

C. The persistent configuration parameter,DC1, is overridden because a new channel is allocated in the RMAN run block.

Answer

A. The script is executed and bothDC1and chi channels are used for script execution.

Answer

B. The execution of the script fails because multiple channels cannot exist simultaneously.

Answer

D. The new channel, chi, is ignored because a channel has been configured already.

Question 28

QUESTION 88
You create two Resource Manager plans, one for night time workloads, the other for day time.
How would you make the plans switch automatically?

Accepted Answer

B. Use scheduler windows.

Answer

A. Use job classes.

Answer

C. Use the mapping rule for the consumer groups.

Answer

D. Set the switch_time plan directive for both plans.

Question 29

QUESTION 89
Which three statements are true about Consolidated Database Replay?

Accepted Answer

B. Multiple workload captures from multiple databases can be replayed simultaneously on all pluggable databases (PDBs) in a multitenant container database (CDB).

Accepted Answer

C. A subset of the captured workload can be replayed.

Accepted Answer

E. Multiple replay schedules can be defined for a consolidated replay and during replay initialization, you can select from any of the existing replay schedules.

Answer

A. The workload capture and replay systems must have the same operating system (OS).

Answer

D. The number of captured workloads must be the same as the number of PDBs in a multitenant CDB.

Question 30

QUESTION 90
Which two statements are true about Flashback Version Query?

Accepted Answer

D. It retrieves all versions of rows that exist in a time interval, including the start time and end time.

Accepted Answer

E. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

Answer

A. The result of a query can be used as part of a DML statement.

Answer

B. It can be used to create views.

Answer

C. It can be used only if Flashback Data Archive is enabled for a table.

Cert12c_067_61a90_passLeader

Questions in this quiz (30)

Information

Feedback

What do you think of the new look?