Copy and Edit

Cert12c_067_31a60_passLeader

Description

Quiz on Cert12c_067_31a60_passLeader, created by A A on 28/08/2017.
A A
Quiz by A A, updated more than 1 year ago
A A
Created by A A over 7 years ago
24
0
0

Resource summary

Question 1

Question
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?
Answer
  • 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.

Question 2

Question
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?
Answer
  • 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.

Question 3

Question
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?
Answer
  • A. TYPE
  • B. LOCATION
  • C. PARALLEL
  • D. DEFAULT DIRECTORY
  • E. ORGANIZATION EXTERNAL

Question 4

Question
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?
Answer
  • 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

Question 5

Question
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?
Answer
  • 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.

Question 6

Question
Which four actions are possible during an Online Datafile Move operation?
Answer
  • 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

Question 7

Question
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?
Answer
  • 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.

Question 8

Question
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?
Answer
  • 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.

Question 9

Question
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?
Answer
  • 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.

Question 10

Question
QUESTION 40 What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
Answer
  • A. statistics recommendations
  • B. SQL profile recommendations
  • C. SQL statement restructure recommendations
  • D. creation of materialized views to improve query performance

Question 11

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

Question 12

Question
QUESTION 42 Which three statements are true about the startup and shutdown of multitenant container databases (CDBs) and pluggable databases (PDBs)?
Answer
  • 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.

Question 13

Question
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?
Answer
  • 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

Question 14

Question
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?
Answer
  • 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.

Question 15

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

Question 16

Question
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?
Answer
  • 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.

Question 17

Question
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?
Answer
  • 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.

Question 18

Question
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?
Answer
  • 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.

Question 19

Question
QUESTION 49 You execute the RMAN commands: RMAN> BACKUP VALIDATE DATABASE; RMAN> RECOVER CORRUPTION LIST; Which task is performed by these commands?
Answer
  • 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.

Question 20

Question
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?
Answer
  • 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.

Question 21

Question
Which three statements are true about the SQL*Loader utility?
Answer
  • 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.

Question 22

Question
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?
Answer
  • 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.

Question 23

Question
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?
Answer
  • 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.

Question 24

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

Question 25

Question
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?
Answer
  • 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

Question 26

Question
QUESTION 56 Identify three benefits of unified auditing.
Answer
  • 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.

Question 27

Question
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?
Answer
  • 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

Question 28

Question
QUESTION 58 What two are the prerequisites for enabling Flashback Database?
Answer
  • 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

Question 29

Question
QUESTION 59 Which statements are true regarding system-partitioned tables? (Choose all that apply.)
Answer
  • 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.

Question 30

Question
QUESTION 60 Tablespaces of certain types or in certain states can be renamed. Which four of these situations permit renaming a tablespace?
Answer
  • 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
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Mind Map 1
matt_daniells
Mechanics
james_hobson
AQA GCSE Physics Unit 2.2
Matthew T
The Wife of Bath Quotes
rlshindmarsh
Biological molecules
sadiaali363
GCSE AQA Chemistry Atomic Structure and Bonding
mustafizk
AS Sociology - Education Theories
HannahLB
NSI Test First day
brahim matrix
TOK mindmap “Without application in the world, the value of knowledge is greatly diminished.”
Gabriela Serpa
Maths: Formulas for Areas & Perimeters of Shapes
Annan S
Romeo and Juliet notes
Faizaan Mohmed
Browse Library