Oracle Database 12c: Advanced Administration 1Z0-063 PDF

Great 1Z0-063 pdf has been updated for Oracle Database 12c: Advanced Administration exam. Newly updated 1Z0-063 dumps contain 235 real exam questions and answers, which are enough for testing your knowledge of SQL and PL/SQL, knowledge of Oracle Database 12c, and basic knowledge of the Linux operating system. New 1Z0-063 questions are all based on the 1Z0-063 exam knowledge points to ensure you pass Oracle Database 12c: Advanced Administration exam.

1Z0-063 PDF Demo Questions Online, Test and Check

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

 
 
 
 
 

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

Which three actions would you take to improve backup performance? (Choose three.)

 
 
 
 
 
 

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

 
 
 
 
 

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? (Choose three.)

 
 
 
 
 

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? (Choose two.)

 
 
 
 
 

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

 
 
 
 
 
 

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_dest string /u01/app/oracle/admin/eml2rep/adump

background_dump_dest string

core_dump_dest string

db_create_file_dest string

db_recovery_file_dest string /u01/app/oracle/fast_recovery_area

diagnostic_dest string

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 ANY TABLE and SELECT ANY TABLE privileges.

You then execute the commands:

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

SQL> CONN sys/[email protected]_PDB as sysdba

SQL> GRANT c##role1 TO b_admin CONTAINER=CURRENT;

Which two statements are true? (Choose two.)

 
 
 
 
 

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

 
 
 
 

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? (Choose two.)

 
 
 
 
 

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? (Choose two.)

 
 
 
 
 

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? (Choose three.)

 
 
 
 
 
 

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

 
 
 
 
 

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

 
 
 
 
 

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

 
 
 
 
 

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 CDB1 container database (CDB):

SQL>CREATE DATABASE CDB1

DEFAULT TABLESPACE users

DEFAULT TEMPORARY TABLESPACE

temp

UNDO TABLESPACE

Undotbsl ENABLE

PLUGGABLE DATABASE SEED

SYSTEM DATAFILES SIZE 125M AUTOEXTEND ON NEXT 10M MAXSIZE

UNLIMITED SYSAUX DATAFILES SIZE 100M;

Which three statements are true? (Choose three.)

 
 
 
 
 
 

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_1 =’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. (Choose three.)

 
 
 
 
 

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

 
 
 
 
 

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. (Choose two.)

 
 
 
 
 
 

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)? (Choose two.)

 
 
 
 
 
 
 

37. In which three scenarios is media recovery required? (Choose three.)

 
 
 
 
 

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

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)? (Choose two.)

 
 
 
 
 
 

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? (Choose two.)

 
 
 
 
 

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

 
 
 
 
 

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. (Choose two.)

 
 
 
 
 

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? (Choose three.)

 
 
 
 
 
 

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? (Choose two.)

 
 
 
 
 

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? (Choose two.)

 
 
 
 
 

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

 
 
 
 
 
 

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

 
 
 
 
 

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? (Choose two.)

 
 
 
 
 

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. (Choose two.)

 
 
 
 
 

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? (Choose three.)

 
 
 
 
 

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? (Choose two.)

 
 
 
 
 

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:

CREATE OR REPLACE PROCEDURE create_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_items

WHERE o.orderid = 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 at line1:

ORA-01654f:unable to extend index USERS.ORDERS_IND by 8 in 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? (Choose two.)

 
 
 
 
 

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))

PARTITION BY RANGE(po_date)

(PARTITIONQ1 VALUES LESS THAN (TO_DATE(’01-apr-2007′,’dd-mm-yyyy’)), PARTITIONQ2VALUESLESSTHAN(TO_DATE(’01-jul-2007′,’dd-mm-yyyy’)), PARTITIONQ3VALUESLESSTHAN (TO~DATE(’01-oct-2007′,’dd-mm-yyyy’)), PARTITIONQ4VALUESLESSTHAN (TO_DATE(‘Ol-jan-2008′,’dd-mm-yyyy’)));

CREATE TABLE purchase_order_items

(po_idNUM3ER(4)NOT NULL,

product_idNUMBER(6)NOT NULL,

unit_price NUMBER(8,2),

quantity NUMBER(8),

CONSTRAINT po_items_f k

FOREIGN KEY(po_id)REFERENCES purchase_orders(po_id))

PARTITION BY REFERENCE(po_items_fk);

Which two statements are true? (Choose two.)

 
 
 
 
 

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

 
 
 
 
 
 

66. Examine the command used to perform an incremental level-0 backup:

RMAN> BACKUP INCREMENTAL LEVEL0 DATABASE;

To enable block change tracking, after the incremental level 0 backup, you issue the command:

SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING

FILE’/mydir/rman_change_track.f’;

To perform an incremental level-1 cumulative backup, you issue the command:

RMAN> BACKUP INCREMENTAL LEVEL1 CUMULATIVE DATABASE;

Which two statements are true in the preceding situation? (Choose two.)

 
 
 
 
 

Online Oracle Certification 1Z0-934 Free Dumps
Oracle ZFS Storage Appliance 2017 Implementation Essentials 1Z0-499 Dumps

Add a Comment

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