A A
Quiz von , erstellt am more than 1 year ago

Ordenadores/Informática Quiz am Cert12c_067_1a30_passLeader, erstellt von A A am 28/08/2017.

32
0
0
A A
Erstellt von A A vor mehr als 7 Jahre
Schließen

Cert12c_067_1a30_passLeader

Frage 1 von 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?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 2 von 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?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 3 von 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?

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 4 von 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?

Wähle eine oder mehr der folgenden:

  • A. RMAN recovery catalog

  • B. RMAN Media Management Library

  • C. Enterprise Manager Cloud Control

  • D. Enterprise Manager Database Express

  • E. Oracle Secure Backup

Erklärung

Frage 5 von 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.

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 6 von 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?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 7 von 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)?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 8 von 30

1

QUESTION 8
In which three scenarios is media recovery required?

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 9 von 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?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 10 von 30

1

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

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 11 von 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?

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 12 von 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?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 13 von 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?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 14 von 30

1

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

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 15 von 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?

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 16 von 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?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 17 von 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?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 18 von 30

1

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

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 19 von 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?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 20 von 30

1

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

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 21 von 30

1

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

Wähle eine oder mehr der folgenden:

  • A. Reduced logical I/O

  • B. Reduced virtual memory utilization

  • C. Improved Serial Execution performance

  • D. Reduced physical I/O

  • E. Reduced CPU utilization

Erklärung

Frage 22 von 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.

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 23 von 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?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 24 von 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?

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 25 von 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?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 26 von 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.

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 27 von 30

1

QUESTION 27
In which situation can you use Flashback Database?

Wähle eine oder mehr der folgenden:

  • 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

Erklärung

Frage 28 von 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?

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 29 von 30

1

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

Wähle eine oder mehr der folgenden:

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

Erklärung

Frage 30 von 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?

Wähle eine oder mehr der folgenden:

  • A. SQL Performance Analyzer

  • B. SQL Access Advisor

  • C. SQL Tuning Advisor

  • D. Automatic Workload Repository (AWR) report

  • E. Automatic Database Diagnostic Monitor (ADDM)

Erklärung

Vorherige
Antwort prüfen
Nächste