Cert12c_067_31a60_passLeader

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?

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?

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?

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?

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?

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

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?

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?

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?

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

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.

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

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?

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?

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.

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?

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?

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?

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

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?

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

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?

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?

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.

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?

QUESTION 56 Identify three benefits of unified auditing.

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?

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

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

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