A A
Quiz by , created more than 1 year ago

Quiz on Cert12c_067_31a60_passLeader, created by A A on 28/08/2017.

24
0
0
No tags specified
A A
Created by A A over 7 years ago
Close

Cert12c_067_31a60_passLeader

Question 1 of 30

1

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

Select one or more of the following:

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

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

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

  • D. The crsct1 start has command must be used to start software services for Oracle AutomaticStorage Management (ASM) after the "Oracle Grid Infrastructure for a standalone server" installation is complete.

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

Explanation

Question 2 of 30

1

QUESTION 32
In your multitenant container database (CDB) that contains pluggable databases (PDBs), the hr user executes the following commands to create and grant privileges on a procedure:
CREATEORREPLACEPROCEDUREcreate_test_v(v_emp_idNUMBER,v_enameVARCHAR2,v_S ALARYNUMBER,v_dept_idNUMBER)
BEGIN
INSERT INTO hr.test VALUES (v_emp_id, v_ename, v salary, v_dept_id);
END;
/
GRANT EXECUTE ON CREATE_TEST TO John, jim, smith, king;
How can you prevent users having the execute privilege on the create_test_v procedure from inserting values into tables on which they do not have any privileges?

Select one or more of the following:

  • A. Create the create_test procedure with definer's rights.

  • B. Grant the execute privilege to users with grant option on the create_test procedure.

  • C. Create the create_test procedure with invoker's rights.

  • D. Create the create_test procedure as part of a package and grant users the execute privilege on the package.

Explanation

Question 3 of 30

1

QUESTION 33
You must unload data from the orders, order_items, and products database tables to four files using the External Tables.
CREATE TABLE orders_ext
(order_id, order_date, product_id, product_name,quantity)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY ext.dir
LOCATION (`ordersl.dmp','orders2.dmp','orders3.dmp','lorders4.dmp')
)
PARALLEL
AS
SELECT o.order_id,o.order_date,p.product_id,p.product_name,i.quantity
FROM orders o,productsp,order_itemsi
WHERE o.orderjd = i.order_id and i.product_id = p.product_id;
You execute the command shown in the Exhibit, but only two files are created.
Which parameter must be changed so that four files are created?

Select one or more of the following:

  • A. TYPE

  • B. LOCATION

  • C. PARALLEL

  • D. DEFAULT DIRECTORY

  • E. ORGANIZATION EXTERNAL

Explanation

Question 4 of 30

1

QUESTION 34
Users report this error message when inserting rows into the orders table:
ERROR atline1:
ORA-01654f:unable to extend index USERS.ORDERS_IND by 8in tablespace INDEXES
You determine that the indexes tablespace is out of space and there is no free space on the filesystem used by the Oracle database.
Which two must you do to fix this problem without affecting currently executing queries?

Select one or more of the following:

  • A. drop and re-create the index

  • B. coalesce the orders,,ind index

  • C. coalesce the indexes tablespace

  • D. perform an on line table rebuild using dbns_redefir.ition.

  • E. rebuild the index online moving it to another tablespace that has enough free space for the index

Explanation

Question 5 of 30

1

QUESTION 35
Evaluate these statements:
CREATE TABLE purchase_orders
(po_idNUMBER(4),
po_dateTIMESTAMP,
supplier_idNUM8ER(6),
po_totalNUMBER(8,2), CONSTRAINT order_pk PRIMARY KEY(po_id))
PARTITIONBYRANGE(po_date)
(PARTITIONQ1 VALUESLESSTHAN (TO_DATE('01-apr-2007','dd-mon-yyyy')), PARTITIONQ2VALUESLESSTHAN(TO_DATE('01-jul-2007','dd-mon-yyyy')), PARTITIONQ3VALUESLESSTHAN (TO~DATE('01-oct-2007','dd-non-yyyy')), PARTITIONQ4VALUESLESSTHAN (TO_DATE('Ol-jan-2008','dd-non-yyyy' )));
CREATETABLEpurchase_order_items
(po_idNUM3ER(4)NOTNULL,
product_idNUMBER(6)NOTNULL,
unit_prlceNUMBER(8,2),
quantity NUMBER(8),
CONSTRAINTpo_items_f k
FOREIGNKEY(po_id)REFERENCESpurchase_orders(po_id) )
PARTITIONBYREFERENCE(po_items_fk);
Which two statements are true?

Select one or more of the following:

  • A. Partitions of purchase_order_items are assigned unique names based on a sequence.

  • B. The purchase_orders and purchase_order_items tables are created with four partition each.

  • C. purchase_order_items table partitions exist in the same tablespaces as the purchase_orders table partitions.

  • D. The purchase_order_:teks table inherits the partitioning key by duplicating the key columns from the parent table.

  • E. Partition maintenance operations on the purchase_order_items table require disabling the foreign key constraint.

Explanation

Question 6 of 30

1

Which four actions are possible during an Online Datafile Move operation?

Select one or more of the following:

  • A. Creating and dropping tables in the datafile being moved

  • B. Performing file shrink of the data file being moved

  • C. Querying tables in the datafile being moved

  • D. Performing Block Media Recovery for a data block in the datafile being moved

  • E. Flashing back the database

  • F. Executing DML statements on objects stored in the datafile being moved

Explanation

Question 7 of 30

1

QUESTION 37
Examine the command used to perform an incremental level-0 backup:
RMAN>BACKUPINCREMENTALLEVEL0DATABASE;
To enable block change tracking, after the incremental level 0 backup, you issue the command:
SQL>ALTERDATABASEENABLEBLOCKCHANGETRACKINGUSING
FILE'/mydir/rman_change_track.f';
To perform an incremental level-1 cumulative backup, you issue the command:
RMAN>BACKUPINCREMENTALLEVEL1CUMULATIVEDATABASE;
Which two statements are true in the preceding situation?

Select one or more of the following:

  • A. The block change tracking data is used only from the next incremental backup.

  • B. The incremental level 1 backup fails because a block change tracking file Is created after the level 0 backup.

  • C. The incremental level 1 backup does not use change tracking data for accomplishing the backup.

  • D. The block change tracking file scans all blocks and creates a bitmap for the blocks backed up in the level 0 backup.

  • E. The block change tracking data is used for the next incremental level 1 backup only after the next level 0 backup.

Explanation

Question 8 of 30

1

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

Select one or more of the following:

  • A. The event parameter was not set.

  • B. The sql_trace parameter is set to false.

  • C. Enterprise Manager was not used.

  • D. The statistics_level parameter is set tobasic.

  • E. The t:kid_statistics parameter is set to false.

Explanation

Question 9 of 30

1

QUESTION 39
You are administering a multitenant container database (CDB) cdb1 that is running in archivelog mode and contains pluggable databases (PDBs), pdb_i and pdb_2.
While opening pdb_1, you get an error:
SQL> alter pluggable database pdb_1 open;
ORA-011S7:cannotidentify/lockdatafile11-seeDBWRtracefile
ORA-01110:data file 11:'/u01/app/oracle/oradata/cdb1/pcb_1/example01.dbf'
To repair the failure, you open an RMAN session for the target database CDBSROOT.
You execute the following as the first command:
RMAN>REPAIRFAILURE;
Which statement describes the consequence of the command?

Select one or more of the following:

  • A. The command performs the recovery and closes the failure.

  • B. The command produces an error because RMAN is not connected to the target database pdb_1.

  • C. The command produces an error because the advise failure command was not executed before the REPAIRFAILUER command.

  • D. The command executes successfully, performs recovery, and opens PDB_1.

Explanation

Question 10 of 30

1

QUESTION 40
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

Select one or more of the following:

  • A. statistics recommendations

  • B. SQL profile recommendations

  • C. SQL statement restructure recommendations

  • D. creation of materialized views to improve query performance

Explanation

Question 11 of 30

1

QUESTION 41
You use RMAN with a recovery catalog to back up your database. The backups and the archived redo log files are backed up to media daily. Because of a media failure, the entire database along with the recovery catalog database is lost.
Examine the steps required to recover the database:
1.Restore an autobackup of the server parameter file.
2.Restore the control file.
3.Start up the database instance in nomount state.
4.Mount the database.
5.Restore the data files.
6.Open the database with the resetlogs option.
7.Recover the data files.
8.Set D3ID for the database.
Identify the required steps in the correct order.

Select one or more of the following:

  • A. 1, 8, 3, 2, 4, 5, 7, 6

  • B. 8, 1, 3, 2, 4, 5, 7, 6

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

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

  • E. 8, 1, 3, 2, 4, 5, 6

Explanation

Question 12 of 30

1

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

Select one or more of the following:

  • A. A PDB opened in restricted mode allows only local users to connect.

  • B. When a CDB is open in restricted mode, PDBs must also be opened in restricted mode.

  • C. When a CDB is in mount state, PDBs are automatically placed in mount state.

  • D. All PDBs must be shut down before shutting down a CDB instance.

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

Explanation

Question 13 of 30

1

QUESTION 43
A telecom company wishes to generate monthly bills to include details of customer calls, listed in order of time of call.
Which table organization allows for generating the bills with minimum degree of row sorting?

Select one or more of the following:

  • A. a hash cluster

  • B. an index cluster

  • C. a partitioned table

  • D. a sorted hash cluster

  • E. a heap table with a rowid column

Explanation

Question 14 of 30

1

QUESTION 44
You have installed two 64G flash devices to support the Database Smart Flash Cache feature on your database server that is running on Oracle Linux.
You have set the db_smart_flash_file parameter:
DB_FLASH_CACHE_FILE= ` /dev/f lash_device_1`,` /dev/f lash_device_2`
How should the D3_flash_cache_size be configured to use both devices?

Select one or more of the following:

  • A. Set DB_FLASH_CACHE_SIZE=64G.

  • B. Set D3_FLASH_CACHE_SIZE=64G, 64G.

  • C. Set D3_FLASK_CACKE_SI2E=i28G.

  • D. db_flash_cache_SI2E is automatically configured by the instance at startup.

Explanation

Question 15 of 30

1

QUESTION 45
You are required to migrate your 11.2.0.3 database to an Oracle 12c database.
Examine the list of steps that might be used to accomplish this task:
1.Place all user-defined tablespaces in read-only mode on the source database.
2.Use the RMAN convert command to convert data files to the target platform's endian format, if required.
3.Perform a full transportable export on the source database with the parameters
VERSI0N=I2, TRANSPORTABLE=ALWAYS, and FULL=Y.
4. Transport the data files for all the user-defined tablespaces.
5. Transport the export dump file to the target database.
6.Perform an import on the target database by using the full, network_link, and transportable_datafiles parameters.
7.Perform an import on the target database by using the full and transportable_datafiles parameters.
Identify the required steps in the correct order.

Select one or more of the following:

  • A. 1, 3, 5, 4, 2, and 6

  • B. 1, 2, 4, 6, 5, 3, and 7

  • C. 1, 2,4, and 7

  • D. 2, 4, 5, 6, and 7

Explanation

Question 16 of 30

1

QUESTION 46
Your multitenant container database (CDB) cdb1 that is running in archivelog mode contains two pluggable databases (PDBs), pdb2_1 and pdb2_2.
RMAN is connected to the target database pdb2_1.
Examine the command executed to back up pdb2_1:
RMAN> BACKUP DATABASE PLUS ARCHIVELOG;
Which statement is true about the execution of this command?

Select one or more of the following:

  • A. It fails because archive log files cannot be backed up using a connection to a PDB.

  • B. It succeeds but only the data files belonging to the pdb2_i pluggable database are backed

  • C. It succeeds and all data files belonging to PD32_i are backed up along with the archive log files.

  • D. It fails because the pluggable clause is missing.

Explanation

Question 17 of 30

1

QUESTION 47
View the Exhibit showing steps to create a database resource manager plan.
SQL>executedbms_resource_manager.create_pendingarea();
PL/SQLproceduresuccessfully completed.
3QL>execdbms_resource_manager,create_consumergroup
(consumer_group=>'OLTP,,comment=>,onlineuser')
PL/SQLproceduresuccessfullycompleted.
SQL>execdbras_resource_raanager.create_plan(plan=>'PRIU3ER3',comment=>'dssprio');
SQL>exec
Dbms_resource_manager.create_plan_directive(plan=>'PRIU3ER3',group_or_subplan=>'OLTP',comraent=>'onlinegrp'CPU_Pl=>60);
PL/3QLproceduresuccessfullycompleted.
After execting the steps in the exhibit you execute this procedure, which results in an error:
SQL> EXECUTEdbms_resource_manager. validate_pending_area ();
What is the reason for the error?

Select one or more of the following:

  • A. The pending area is automatically submitted when creating plan directives.

  • B. The procedure must be executed before creating any plan directive.

  • C. The sys_group group is not included in the resource plan.

  • D. The other_groups group is not included in the resource plan.

  • E. Pending areas can not be validated until submitted.

Explanation

Question 18 of 30

1

Your database is running in noarchivelog mode.
One of the data files belonging to the system tablespace is corrupted.
You notice that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file?

Select one or more of the following:

  • A. Shut down the instance if not already shut down, restore all data files belonging to the system tablespace from the last backup, and restart the instance.

  • B. Shut down the instance if not already shut down, restore the corrupted data file belonging to the system tablespace from the last backup, and restart the instance.

  • C. Shut down the instance if not already shut down, restore all data files for the entire database from the last backup, and restart the instance.

  • D. Mount the database, restore all data files belonging to the system tablespace from the last backup, and open the database.

Explanation

Question 19 of 30

1

QUESTION 49
You execute the RMAN commands:
RMAN> BACKUP VALIDATE DATABASE;
RMAN> RECOVER CORRUPTION LIST;
Which task is performed by these commands?

Select one or more of the following:

  • A. Corrupted blocks, if any, are repaired in the backup created.

  • B. Only those data files that have corrupted blocks are backed up.

  • C. Corrupted blocks in the data files are checked and repaired before performing the database backup.

  • D. The database is checked for physically corrupt blocks and any corrupted blocks are repaired.

Explanation

Question 20 of 30

1

QUESTION 50
You are connected to a pluggable database (PDB) as a common user with the sysdba privilege. The PDB is open and you issue the shutdown immediate command.
What is the outcome?

Select one or more of the following:

  • A. The PDB is closed.

  • B. The PDB is placed in mount state.

  • C. The command executes only if the common user is granted the set container privilege for the PDB.

  • D. The command results in an error because the PDB can be shut down only by a local user.

Explanation

Question 21 of 30

1

Which three statements are true about the SQL*Loader utility?

Select one or more of the following:

  • A. It can be used toload data from multiple external files into multiple tables.

  • B. It can be used to extract and reorganize data from external files, and then load it into a table.

  • C. It can be used to load data from external files using direct path only.

  • D. It can be used to create tables using data that is stored in external files.

  • E. It can be used to generate unique sequential values in specified columns while loading data.

Explanation

Question 22 of 30

1

QUESTION 52
While performing database backup to tape via the media manager interface, you notice that tape streaming is not happening because RMAN is not sending data blocks fast enough to the tape drive.
Which two actions would you take for tape streaming to happen during the backup?

Select one or more of the following:

  • A. Configure backup optimization.

  • B. Configure the channel to increase maxopenfiles.

  • C. Configure a backup policy by using incremental backups.

  • D. Configure the channel to increase capacity with the rate parameter.

  • E. Configure the channel to adjust the tape buffer size by using the 3LKSIZE option.

  • F. Configure large_pool, if not done already. Alternatively, you can increase the size of LARGE_POOL.

Explanation

Question 23 of 30

1

QUESTION 53
You are administering a multitenant container database (CDB) cdb1.
Examine the command and its output:
SQL>show parameterfile
NAMETYPEVALUE
-----------------------------------------------------------------------
db_create_file_deststring
db_file_name_convertstring
db_filesinteger200
You verify that sufficient disk space is available and that no file currently exists in the `/u0l/app/oracle/oradata/cdb1/salesdb' location.
You plan to create a new pluggable database (PDB) by using the command:
SQL>CREATEPLUGGABLEDATABASESALESPDB
ADMINUSERsalesadmIDENTIFIED 3Y password
ROLES=(dba)
DEFAULTTABLESPACEsales
DATAFILE' /u01/app/oracle/oradata/cdb1/salesdb/sales01 .dbf'SIZE 250M AUTOEXTEND ON
FILE_NAME_CONVERT=(`/u01/app/oracle/oradata/cdb1/pdbseed/',
'/u01/app/oracle/oradata/cdb1/salesdb/')
STORAGE(MAXSIZE2G)
PATK_PREFIX='/u01/app/oracle/oradata/cdb1/SALESPDB';
Which statement is true?

Select one or more of the following:

  • A. SALESPDB is created and is in mount state.

  • B. PDB creation fails because the D3_file_name_convert parameter is not set in the CDB.

  • C. SALESPDB is created and is in read/write mode.

  • D. PDB creation fails because a default temporary tablespace is not defined for SALESPDB.

Explanation

Question 24 of 30

1

QUESTION 54
You want to migrate your Oracle 11g database as a pluggable database (PDB) in a multitenant container database (CDB).
The following are the possible steps to accomplish this task:
1. Place all the user-defined tablespace in read-only mode on the source database.
2. Upgrade the source database to a 12c version.
3. Create a new PDB in the target container database.
4. Perform a full transportable export on the source database with the VERSION parameter set to
12 using the expdp utility.
5. Copy the associated data files and export the dump file to the desired location in the target database.
6. Invoke the Data Pump import utility on the new PDB database as a user with the DATAPUMP_IMP_FULL_DATABASE role and specify the full transportable import options.
7. Synchronize the PDB on the target container database by using the DBMS_PDS.SYNC_ODB function.
Identify the correct order of the required steps.

Select one or more of the following:

  • A. 2, 1, 3, 4, 5, 6

  • B. 1, 3, 4, 5, 6, 7

  • C. 1, 4, 3, 5, 6, 7

  • D. 2, 1, 3, 4, 5, 6, 7

  • E. 1, 5, 6, 4, 3, 2

Explanation

Question 25 of 30

1

QUESTION 55
You want to consolidate databases for the CRM, ERP, and SCM applications by migrating them to pluggable databases (PDBs).
You have already created a test system to support the consolidation of databases in a multitenant container database (CDB) that has multiple PDBs.
What is the easiest way to perform capacity planning for consolidation?

Select one or more of the following:

  • A. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system

  • B. capturing the workload on the production system and replaying the workload for one PDB at a time on the test system

  • C. capturing the workload on the production system and using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs

  • D. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on the test system

Explanation

Question 26 of 30

1

QUESTION 56
Identify three benefits of unified auditing.

Select one or more of the following:

  • A. It helps to reduce disk space used to store an audit trail in a database.

  • B. It guarantees zero-loss auditing

  • C. It reduces overhead on a database caused by auditing, by having a single audit trail.

  • D. An audit trail cannot be modified because it is read-only.

  • E. It automatically audits Recovery Manager (RMAN) events.

Explanation

Question 27 of 30

1

QUESTION 57
Examine the backup requirement for your company:
1) Every Sunday, a backup of all used data file blocks is performed.
2) Every Wednesday and Friday, a backup of all the changed blocks since last Sunday's backup is performed.
3) On all the other days, a backup of only the changed blocks since the last day's backup is performed.
Which backup strategy satisfies the requirements?

Select one or more of the following:

  • A. level 0 backup on Sunday, cumulative incremental backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days

  • B. level 0 backup on Sunday, differential incremental backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days

  • C. full database backup on Sunday, level 0 backup on Wednesday and Friday, and cumulative incremental level 1 backup on all the other days

  • D. full database backup on Sunday, level 0 backup on Wednesday and Friday, and differential incremental level 1 backup on all the other days

Explanation

Question 28 of 30

1

QUESTION 58
What two are the prerequisites for enabling Flashback Database?

Select one or more of the following:

  • A. The database must be in ARCHIVELOG mode

  • B. The database must be in MOUNT EXCLUSIVE mode

  • C. The database must be opened in RESTRICTED mode

  • D. The database instance must be started in the NOMOUNT state

  • E. The database instance must have the keep buffer pool defined

Explanation

Question 29 of 30

1

QUESTION 59
Which statements are true regarding system-partitioned tables? (Choose all that apply.)

Select one or more of the following:

  • A. Only a single partitioning key column can be specified.

  • B. All DML statements must use partition-extended syntax.

  • C. The same physical attributes must be specified for each partition.

  • D. Unique local indexes cannot be created on a system-partitioned table.

  • E. Traditional partition pruning and partitionwise joins are not supported on these tables.

Explanation

Question 30 of 30

1

QUESTION 60
Tablespaces of certain types or in certain states can be renamed.
Which four of these situations permit renaming a tablespace?

Select one or more of the following:

  • A. the SYSTEM tablespace

  • B. the default permanent tablespace for the non-SYSTEM users

  • C. an offline tablespace

  • D. a temporary tablespace

  • E. a read-only tablespace

  • F. an undo tablespace

Explanation

Previous
Check answer
Next