A A
Quiz by , created more than 1 year ago

Ordenadores/Informática Quiz on Cert12c_067_1a30_passLeader, created by A A on 28/08/2017.

32
0
0
A A
Created by A A over 7 years ago
Close

Cert12c_067_1a30_passLeader

Question 1 of 30

1

QUESTION 1
Examine the RMAN command:
RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which prerequisite must be met before accomplishing the backup?

Select one or more of the following:

  • A. The password for the encryption must be set up.

  • B. Oracle wallet for the encryption must be set up.

  • C. All the tablespacesin the database must be encrypted.

  • D. Oracle Database Vault must be enabled.

Explanation

Question 2 of 30

1

QUESTION 2
A database is running in archivelog mode.
The database contains locally managed tablespaces.
Examine the RMAN command:
RMAN> BACKUP
AS COMPRESSED BACKUPSET
SECTION SIZE 1024M
DATABASE;
Which statement is true about the execution of the command?

Select one or more of the following:

  • A. The backup succeeds only if all the tablespaces are locally managed.

  • B. The backup succeeds only if the RMAN default device for backup is set to disk.

  • C. The backup fails because you cannot specify section size for a compressed backup.

  • D. The backup succeeds and only the used blocks are backed up with a maximum backup piece size of 1024 MB.

Explanation

Question 3 of 30

1

QUESTION 3
In your database, the tbs percent used parameter is set to 60 and the tbs percent free parameter is set to 20.
Which two storage-tiering actions might be automated when using Information Lifecycle Management (ILM) to automate data movement?

Select one or more of the following:

  • A. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

  • B. Setting the target tablespace to read-only after the segments are moved

  • C. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used

  • D. Taking the target tablespace offline after the segments are moved

  • E. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used

Explanation

Question 4 of 30

1

QUESTION 4
You want to consolidate backup information and centrally manage backup and recovery scripts for multiple databases running in your organization.
Which two backup solutions can be used?

Select one or more of the following:

  • A. RMAN recovery catalog

  • B. RMAN Media Management Library

  • C. Enterprise Manager Cloud Control

  • D. Enterprise Manager Database Express

  • E. Oracle Secure Backup

Explanation

Question 5 of 30

1

QUESTION 5
You want to create a guaranteed restore point for your database by executing the command:
SQL> CREATE RESTORE POINT dbrsp1 GUARANTEE FLASHBACK DATABASE;
Identify two prerequisites for the successful execution of this command.

Select one or more of the following:

  • A. The database must be running in archivelog mode.

  • B. Flashback Database must be enabled.

  • C. Fast Recovery Area must be enabled.

  • D. The recyclebin must be enabled for the database.

  • E. Undo retention guarantee must be enabled.

  • F. A database backup must be taken.

Explanation

Question 6 of 30

1

QUESTION 6
Your database has a table customers that contains the columns cust_name, amt_due, and old_status.
Examine the commands executed and their output:
SQL>UPDATEcustomersSETamt_due=amt_due+amt_due*l. 1WHEREcust_name='JAMES';
1row updated.
SQL> ALTER TABLE customers DROP COLUMN old_status;
Table Altered
SQL> UPDATE customers SET amt_due=amt_due+amt_due*1.5 WHERE cust_r.ame='JAMES';
1 row updated.
SQL> COMMIT;
SQL> SELECT versions_xid AS XID, versior.s_startscr. AS START_SCN, versions_er.cscn AS END_SCN, versior.s_operatior. AS OPERATION', amt_due
FROM customers VERSIONS BETWEEN SCN MINVALULEAND MAXVALUE WHERE custname='JAMES';.
XIDSTART_SCNEND_SCNOPERATIONAMT_DUE
--------------- ------------------ ------------ --------- -------------
07002f00cl03000017063371706337 U3300
Why is it that only one update is listed by the Flashback Version Query?

Select one or more of the following:

  • A. Supplemental logging is not enabled for the database.

  • B. The undo data that existed for versions of rows before the change to the table structure is invalidated.

  • C. The db_flash3ACK_reteni:on_target parameter is set to a lower value and the undo data pertaining to the first transaction is flushed out.

  • D. Undo retention guarantee is not enabled.

  • E. Flashback Data Archive is full after the first update statement.

Explanation

Question 7 of 30

1

QUESTION 7
Which two methods can be used to add an Oracle 11g database to a multitenant container database (CDB) as a pluggable database (PDB)?

Select one or more of the following:

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

  • B. Use the create database ... enable pluggable database statement to create a PDB by copying data files from pd3Sseed and use data pump to load data from the Oracle 11g database into the newly created PDB.

  • C. 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.

  • D. 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.

  • E. 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.

Explanation

Question 8 of 30

1

QUESTION 8
In which three scenarios is media recovery required?

Select one or more of the following:

  • A. when a tablespace is accidentally dropped from a database

  • B. when archived redo log files are lost

  • C. when data files are lost

  • D. when one of the online redo log members is corrupted

  • E. when all control files are lost

Explanation

Question 9 of 30

1

QUESTION 9
In the SPFILE, UNDOJTABLESPACEis Set to UNDOTBS.
You rename the undotbs undo tablespace:
ALTER TABLESPACE undotbs RENAME TO undotbs_old;
Which statement is true?

Select one or more of the following:

  • A. The tablespace will be renamed but the data file headers will not be updated.

  • B. The statement will fail because you cannot rename an undo tablespace.

  • C. The tablespace will be renamed and all the changes will be logged in the alert log.

  • D. The tablespace will be renamed and a message written to the alert log indicating that you should change the corresponding initialization parameter.

  • E. You must set the undo_tablespace parameter to some other tablespace name before renaming undotbs.

Explanation

Question 10 of 30

1

QUESTION 10
Which two statements are true regarding an Automatic Storage Management (ASM) instance? (Choose two.)

Select one or more of the following:

  • A. An ASM instance mounts an ASM control file

  • B. An ASM instance uses the ASMB process for rebalancing of disks within a disk group

  • C. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly

  • D. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Explanation

Question 11 of 30

1

QUESTION 11
Before a Flashback Table operation, you execute the following command:
ALTER TABLE employees ENABLE ROW MOVEMENT;
Why would you need this to be executed?

Select one or more of the following:

  • A. Because row IDs may change during the flashback operation

  • B. Because the object number changes after the flashback operation

  • C. Because the rows are retrieved from the recycle bin during the flashback operation

  • D. Because the table is moved forward and back to a temporary during the flashback opertion

Explanation

Question 12 of 30

1

QUESTION 12
Examine the following set of RMAN commands:
RMAN> CONFIGURE CHANNELdelDEVICETYPEDISK FORMAT '/u02/backup/%U*;
RKAN>RUN
{
ALLOCATECHANNELchlDEVICETYPEDISK;
EXECUTESCRIPTfull_backup;
}
Which statement is true when the RMAN run block is executed?

Select one or more of the following:

  • A. The execution of the script fails because multiple channels cannot coexist.

  • B. The script is executed and both the channels are used for the script execution.

  • C. The new channel, CH1, is ignored because a channel has been configured already.

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

Explanation

Question 13 of 30

1

QUESTION 13
Your database is using a default temporary tablespace that contains the temp01.tmp temporary file. All the users on the database use the default temporary tablespace.
A user issues a query on the orders table and receives the following error:
ERROR at line I:
ORA-0I565: error in identifying file '/u01/app/oracle/oradata/TEST/temp01.tmp'
ORA-27037: unable to obtain file status
What would be the most efficient way to rectify this error?

Select one or more of the following:

  • A. Add a new tempfile to the user's temporary tablespace and drop the tempfile that produced the error.

  • B. Shut down the database instance, restore the temp01.tmp file from the backup, and then restart the database.

  • C. Allow the database to continue running, drop the temp01.tmp temporary file, and then re-create it with new tempfiles.

  • D. Take the temporary tablespace offline, recover the missing tempfile by applying redo logs, and then bring the temporary tablespace online.

Explanation

Question 14 of 30

1

QUESTION 14
Identify two scenarios in which the RMAN crosscheck command can be used.

Select one or more of the following:

  • A. when checking for backups that are not required as per the retention policy

  • B. when updating the RMAN repository if any of the archived redo log files have been deleted without using RMAN to do the deletes

  • C. when updating outdated information about backups that disappeared from disk or media or became corrupted and inaccessible

  • D. when synchronizing backups, which were not performed by using RMAN, with the RMAN repository

  • E. when listing backups that are required for recovery operations

Explanation

Question 15 of 30

1

QUESTION 15
A database is running in archivelog mode.
You want to back up a 10 TB data file belonging to the users tablespace.
The backup of the data file is too slow.
What type of backup do you recommend to improve the performance of the backup?

Select one or more of the following:

  • A. image copy backup by using RMAN

  • B. multi section image copy backup by using RMAN

  • C. multi section parallel backup by using RMAN

  • D. cold backup after taking the tablespace offline

  • E. cold backup after placing the tablespace in backup mode

Explanation

Question 16 of 30

1

QUESTION 16
Automatic Undo Management is enabled for your database.
You want a user to retrieve metadata and historical data for a given transaction or for transactions in a given time interval.
Which three are prerequisites to fulfill this requirement?

Select one or more of the following:

  • A. Minimal supplemental logging must be enabled.

  • B. The database must be running in archivelog mode.

  • C. Flashback Data Archive must be created and the flashback archive administer system privilege must be granted to the user.

  • D. The flashback any table privilege must be granted to the user.

  • E. The select any transaction privilege must be granted to the user.

  • F. Therecycle binparameter must be set to on.

Explanation

Question 17 of 30

1

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

Select one or more of the following:

  • A. expdp will fail because no path has been defined for the dump file.

  • B. expdp will succeed butimpdp will fail because the users do not exist.

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

  • D. 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.

Explanation

Question 18 of 30

1

QUESTION 18
Which two statements are true about a multitenant architecture?

Select one or more of the following:

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

  • B. A PDB can have a private undo tablespace.

  • C. Log switches occur only at the container database level.

  • D. A PDB can have a private temporary tablespace.

  • E. Each PDB has a private control file.

Explanation

Question 19 of 30

1

QUESTION 19
Examine the command to create a pluggable database (PDB):
SQL> CREATE PLUGGABLE DATABASE pdb2 FROM pdb1
FILE_NAME-_CONVERT = ('/disk1/oracle/pdb1/', '/disk2/oracle/pdb2/')
PATH_PREFIX = '/disk2/oracle/pdb2';
Which two statements are true?

Select one or more of the following:

  • A. The pluggable database pdb2 is created by cloning pdb1 and is in mount state.

  • B. Details about the metadata describing pdb2 are stored in an XML file in the'/disk2/oracle/pdb2/' directory.

  • C. The tablespace specifications of pdb2 are the same as pdb1.

  • D. All database objects belonging to common users in PD3I are cloned in PD32.

  • E. pdb2 is created with its own private undo and temp tablespaces.

Explanation

Question 20 of 30

1

QUESTION 20
Which three tasks can be automatically performed by the Automatic Data Optimization feature of Information Lifecycle Management (ILM)?

Select one or more of the following:

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

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

  • C. tracking insert time by row for table rows

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

  • E. tracking the most recent read time for a table segment in the sysauxtablespace

  • F. tracking the most recent write time for a table segment in the sysauxtablespace

Explanation

Question 21 of 30

1

QUESTION 21
Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled?

Select one or more of the following:

  • A. Reduced logical I/O

  • B. Reduced virtual memory utilization

  • C. Improved Serial Execution performance

  • D. Reduced physical I/O

  • E. Reduced CPU utilization

Explanation

Question 22 of 30

1

QUESTION 22
Examine the steps/operations performed during the RMAN backup operation by using Oracle Secure Backup (OSB):
1.Start the RMAN client by using the RMAN target / command.
2.Start the RMAN client by using the OSB user.
3.RMAN creates the backup pieces.
4.Run the RMAN backup command with the sbt channels.
5.OSB creates a backup job and assigns a unique identifier.
6.OSB creates a backup job request through the OSB sbt library.
7.OSB stores metadata about RMAN backup pieces in the OSB catalog.
8.OSB starts the backup operation.
9. OSB updates the RMAN catalog.
Identify the required steps/operations performed in correct order.

Select one or more of the following:

  • A. 1, 4, 6, 5, 8, 3, 9

  • B. 1, 6, 4, 5, 8, 3, 9

  • C. 2, 4, 6, 5, 8, 3, 7

  • D. 2, 4, 5, 8, 3, 7, 9

Explanation

Question 23 of 30

1

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

Select one or more of the following:

  • A. The backup must be performed in mount state.

  • B. The tablespace must be taken offline.

  • C. All files must be backed up as backup sets.

  • D. The database must be backed up as an image copy.

Explanation

Question 24 of 30

1

QUESTION 24
You wish to enable an audit policy for all database users, except sys, system, and scott.
You issue the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT;
For which database users is the audit policy now active?

Select one or more of the following:

  • A. all users except sys

  • B. all users except scott

  • C. all users except sys and scott

  • D. all users except sys, system, and scott

Explanation

Question 25 of 30

1

Your database instance is started using an SPFILE.
You are connected to cdb$root, as a DBA.
You issue:
SQL> ALTER SYSTEM SET STATISTICS_LEVEL=ALL SCOPE=BOTH;
Which two statements are true about the statistics level parameter?

Select one or more of the following:

  • A. It is immediately set to all in the SPFILE and the CDB instance.

  • B. It is immediately set to all in only those pluggable databases (PDBs) where the value is set to typical.

  • C. It is immediately set to all only for cd3Sroot.

  • D. It is immediately set to all in all PDBs where the statistics_level parameter is not set.

  • E. It is set to all for all PDBs only in the SPFILE.

Explanation

Question 26 of 30

1

You are administering a multitenant container database (CDB).
Identify two ways to access a pluggable database (PDB) that is open in read-only mode.

Select one or more of the following:

  • A. by using the connect statement as a local user having only the set container privilege

  • B. by using easy connect

  • C. by using external authentication

  • D. as a common user with the set container privilege

  • E. by executing the alter session set container command as a local user

Explanation

Question 27 of 30

1

QUESTION 27
In which situation can you use Flashback Database?

Select one or more of the following:

  • A. when undoing a shrink data file operation

  • B. when retrieving a dropped tablespace

  • C. when returning to a point in time before the restoration or re-creation of a control file

  • D. when returning to a point in time before the most recent open resetlogs operation

Explanation

Question 28 of 30

1

QUESTION 28
For your database, an incremental level 1 backup is taken every week day.
On Tuesday, before the backup is performed, you add a new tablespace.
You execute the command:
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG WEEKLY DATABASE;
Which statement is true about the execution of the command?

Select one or more of the following:

  • A. It returns an error because there is no level 0 backup available for new data files.

  • B. It performs an image copy backup of new data files, and a level 1 incremental backup of all other data files.

  • C. It performs a level-0 backup of all data files including those that belong to the new tablespace.

  • D. It performs an image copy backup of all data files including those that belong to the new tablespace.

  • E. It performs a backup as a backup set of all data files including those that belong to the new tablespace.

Explanation

Question 29 of 30

1

QUESTION 29
Which three conditions must be true for unused block compression to be used automatically while performing backups by using RMAN?

Select one or more of the following:

  • A. The compatible initialization parameter is set to 10.2 or higher.

  • B. There are no guaranteed restore points defined for the database.

  • C. The default device for the backup must be set to disk.

  • D. The tablespaces are locally managed

  • E. The fast recovery area is less than 50 percent free.

Explanation

Question 30 of 30

1

QUESTION 30
Your database supports a Decision Support System (DSS) workload that involves the execution of
complex queries. Currently, the database is running with peak workload.
You want to analyze some of the most resource-intensive statements cached in the library cache.
What must you run to receive recommendations on the efficient use of indexes and materialized views to improve query performance?

Select one or more of the following:

  • A. SQL Performance Analyzer

  • B. SQL Access Advisor

  • C. SQL Tuning Advisor

  • D. Automatic Workload Repository (AWR) report

  • E. Automatic Database Diagnostic Monitor (ADDM)

Explanation

Previous
Check answer
Next