Real Oracle Database Certification 1Z0-067 Exam Dumps Online

Not only get real 1Z0-067 exam dumps to prepare for Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP exam, but also need to know all exam details of 1Z0-067 exam:

Associated Certificaiton: Oracle Database 12c Administrator Certified Professional(upgrade)
Format: Multiple Choice
Duration: 150 Minutes
Number of Questions: 102
Passing Score: 60%

In order to complete all real Q&As and get the aim of passing, please choose Real Oracle Database Certification 1Z0-067 Exam Dumps Online for passing Oracle 1Z0-067 exam. Here there are some free questions of 1Z0-067 dumps, after you check all these, you will find 1Z0-067 exam questions are great for passing 1Z0-067 Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP exam.

1. Which two statements are true about scheduling operations in a pluggable database (PDB)?

 
 
 
 
 

2. A complete database backup to media is taken for your database every day.

Which three actions would you take to improve backup performance?

 
 
 
 
 
 

3. For which three pieces of information can you use the RMAN list command?

 
 
 
 
 

4. You notice performance degradation in your production Oracle 12c database. You want to know what caused this performance difference.

Which method or feature should you use?

 
 
 
 

5. Which three statements are true about a job chain?

 
 
 
 
 

6. Create a Data Pump export dump file that contains the recovered table on a target database.

Identify the required steps in the correct order.

 
 
 
 

7. Examine the command:

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;

In which two scenarios is this command required?

 
 
 
 
 

8. Which two are prerequisites for setting up Flashback Data Archive?

 
 
 
 
 
 

9. The environmental variable oracle_Base is set to /u01/app/oracle and oracle_home is set to /u01/app/ oracle/product/12.1.0/db 1.

You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). Examine the initialization parameters set in your database.

NAME TYPE VALUE

———————————————————————————-

audit_file_deststring/u01/app/oracle/admin/eml2rep/adump

background_dump_deststring

core_dump_deststring

db_create_file_deststring

db_recovery_file_deststring/u01/app/oracle/fast_recovery_area

diagnostic_deststring

What is the location of the ADR base?

 
 
 
 

10. Create the same tablespaces in emp_pdb1 as in hr_pdb1 for new local user objects.

Identify the required steps in the correct order.

 
 
 
 

11. Rebuild indexes on the SALES table after completion of the bulk load.

How would you create these jobs?

 
 
 
 

12. Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs). In the PDB hr_pdb, the common user c##admin and the local user b_admin have only the connect privilege.

You create a common role c##role1 with the create table and select any table privileges.

You then execute the commands:

SQL> GRANTc##role1 TOcMadmin CONTAINER=ALL;

SQL>CONNsys/[email protected]_PDB assysdba

SQL> GRANTc##role1TO b_admin CONTAINER=CURRENT;

Which two statements are true?

 
 
 
 
 

13. Examine the commands executed in the root container of your multitenant container database (CDB) that has multiple pluggable databases (PDBs):

SQL> CREATE USER c##a_admin IDENTIFIED BY orcl123;

SQL> CREATE ROLE c##role1 CONTAINER=ALL;

SQL> GRANT CREATE VIEW TO C##roleI CONTAINER=ALL;

SQL> GRANT c##role1 TO c##a_admin CONTAINER=ALL;

SQL> REVOKE c##role1 FROM c##a_admin;

What is the result of the revoke command?

 
 
 
 

14. Examine the RMAN command:

RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON;

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which prerequisite must be met before accomplishing the backup?

 
 
 
 

15. A database is running in archive log 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?

 
 
 
 

16. 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?

 
 
 
 
 

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

 
 
 
 
 

18. You want RMAN to make duplicate copies of data files when using the backup command.

What must you set using the RMAN configure command to achieve this?

 
 
 
 

19. You create a table with the period for clause to enable the use of the Temporal Validity feature of Oracle Database 12c.

Examine the table definition:

create table employees (empno number, salary number, deptid number, name varchar2(100), period for employee_time);

Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

 
 
 
 
 
 

20. Which two statements are true when row-archival management is enabled?

 
 
 
 
 

21. Which two resources might be prioritized between competing pluggable databases (PDBs) when creating a multitenant container database (COB) plan using Oracle Database Resource Manager?

 
 
 
 
 

22. Which three types of failures are detected by the Data Recovery Advisor (DRA)?

 
 
 
 
 

23. Issue the select dbms_stats.reportwcol_usage(‘SH’, ‘customers’) from dual statement.

Identify the correct sequence of steps.

 
 
 
 

24. Examine the initialization parameter that is set in the PFILE:

DB_CREATE_FILE_DEST =’/u01/app/oracle/oradata/’

You execute the following command to create theCDB1. container database (CDB):

SQL>CREATE DATABASE CDB1

DEFAULT TABLESPACE users

DEFAULT TEMPORARY TABLESPACE temp

UNDO TABLESPACE undotbsl

ENABLE PLUGGABLE DATABASE

SEED

SYSTEM DATAFILES SIZE125M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED SYS AUX DATAFILES SIZE 100M;

Which three statements are true?

 
 
 
 
 
 

25. Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0.

Identify the steps in the correct order.

 
 
 
 

26. Examine the RMAN command:

RMAN> SET ENCRYPTION IDENTIFIED BY <password> ON FOR ALL TABLESPACES; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which type of encryption is used for the backup performed by using this command?

 
 
 
 

27. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function.

Identify the correct sequence of steps.

 
 
 
 

28. You created a database with DBCA by using one of the Oracle supplied templates.

Which is the default permanent tablespace for all users except DBSNMP and OUTLN?

 
 
 
 

29. Your database is running in archivelog mode. Examine the parameters for your database instance:

LOG_ARCHIVE_DEST_l =’LOCATION=/disk1/arch MANDATORY’

LOG_ARCHIVE_DEST_2 =’LOCATION=/disk2/arch’

LOG_ARCHIVE_DEST_3 =’LOCATIO=/disk3/arch’

LOG_ARCHIVE_DEST _4 =’LOCATIONs/disk4/arch’

LOG_ARCHIVE _MIN_SUCCEED_DEST = 2

While the database is open, you notice that the destination set by the log_archive_dest_1 parameter is not available. All redo log groups have been used.

What happens at the next log switch?

 
 
 
 

30. Identify three scenarios in which RMAN will use backup sets to perform active database duplication.

 
 
 
 
 

31. Which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?

 
 
 
 
 

32. Restart the instance in NOMOUNT state.

Identify the required steps in the correct order.

 
 
 
 

33. After implementing full Oracle Data Redaction, you change the default value for the number data type as follows:

SQL> SELECT NUMBER_VALUE FROM REDACTION_VALUES_FOR_TYPE_FULL; NUMBER_VALUE

———————-

0

SQL> EXEC DBMS_REDACT.UPDATE_FULL_REDACTI0N_VALUES(-1)

PL/SQL procedure successfully completed.

SQL> select number_value from redaction_values_for_type_full;

NUMBER VALUE

——————–

-1

After changing the value, you notice that FULL redaction continues to redact numeric data with a zero.

What must you do to activate the new default value for numeric full redaction?

 
 
 
 
 

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

 
 
 
 
 
 

35. Your database has a table CUSTOMERS that contains the columns CUST_NAME, AMT_DUE, and OLD_STATUS.

Examine the commands executed and their output:

Why is it that only one update is listed by the Flashback Version Query?

 
 
 
 
 

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

 
 
 
 
 

37. In which three scenarios is media recovery required?

 
 
 
 
 

38. In the SPFILE, UNDO TABLESPACE is Set to UNDO TBS.

You rename the undotbs undo tablespace:

ALTER TABLESPACE undotbs RENAME TO undotbs_old;

Which statement is true?

 
 
 
 
 

39. Which two statements are true about dropping a pluggable database (PDB)?

 
 
 
 
 
 

40. On your Oracle 12c database, you invoke SQL*Loader to load data into the employees table in the hr schema by issuing the command:

S>sqlldrhr/[email protected] table=employees

Which two statements are true about the command?

 
 
 
 
 

41. Which three RMAN persistent settings can be set for a database?

 
 
 
 
 

42. Your production database is running in archivelog mode. You use RMAN with a recovery catalog to back up your database to media and the database is uniquely identified in the recovery catalog.

You want to create a test database from the production database and allow the production database to remain open during the duplicate process. You restore the database backups to a new host with the same directory structure as the production database and want to use the recovery catalog for future backups after the database is successfully restored to the new host.

How would you achieve this?

 
 
 
 

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

 
 
 
 
 

44. 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?

 
 
 
 
 

45. 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?

 
 
 
 
 
 

46. 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?

 
 
 
 

47. Which two statements are true about a multitenant architecture?

 
 
 
 
 

48. 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?

 
 
 
 
 

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

 
 
 
 
 
 

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

 
 
 
 
 

51. OSB updates the RMAN catalog.

Identify the required steps/operations performed in correct order.

 
 
 
 

52. You want to back up a database such that only formatted blocks are backed up.

Which statement is true about this backup operation?

 
 
 
 

53. 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?

 
 
 
 

54. 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?

 
 
 
 
 

55. You are administering a multitenant container database (CDB).

Identify two ways to access a pluggable database (PDB) that is open in read-only mode.

 
 
 
 
 

56. In which situation can you use Flashback Database?

 
 
 
 

57. 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?

 
 
 
 
 

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

 
 
 
 
 

59. 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?

 
 
 
 
 

60. 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?

 
 
 
 
 

61. 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_SALARYNUMBER,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?

 
 
 
 

62. 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?

 
 
 
 
 

63. 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?

 
 
 
 
 

64. 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?

 
 
 
 
 

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

 
 
 
 
 
 

 

 

Oracle Cloud Infrastructure Classic 2018 1Z0-337 Dumps with 106 Q&As
Oracle Database Cloud Service 1Z0-160 Real Exam Questions

Add a Comment

Your email address will not be published. Required fields are marked *