Oracle 1z0-063 Dumps - The Sure Way To Pass Exam
1z0-063 Exam Questions (Updated 2021) 100% Real Question Answers
Besides, if you feel that these courses are not enough for you and/or you need more tools to generalize your existing knowledge, you can take a look at the study guides available on the Amazon website:
- ‘Study Guide for 1Z0-063: Oracle Database 12c: Advanced Administration: Oracle Certification Prep’ by Matthew Morris, who’s an Oracle expert with years of experience with Oracle Support Services. In all, this guide is intended for IT specialists who aim to upgrade their certification in Oracle Database 12c administration to a professional level and strengthen their position in the eyes of the employer. In spite of the fact that this book is quite compact, it contains only the most necessary information for you to be well-equipped on the day of the Oracle 1Z0-063 exam, and later it can be used as a reference guide for everyday tasks related to Oracle Database technology. This study guide is available in both the Kindle version and in print format for everyone interested.
- ‘OCP Oracle Database 12c Advanced Administration Exam Guide (Exam 1Z0-063) (Oracle Press) 3rd Edition’, which is written by a real Oracle certified professional with tremendous experience in Oracle database development and administration. Only an expert like Bob Bryla can clearly describe how to work with the Oracle RMAN recovery catalog, identify database failures, and use Oracle Data Pump, SQL*Loader, as well as audit features in the meantime. This guide is worth your attention since, in addition to the material fully covering the exam objectives, it contains realistic practice questions and quizzes at the end of each chapter so that you are 100% prepared for the official test. Just order this book from Amazon, in the Kindle version or paperback format, and start conquering the heights of professional-level Oracle database administration.
On this basis, there are enough ways for high-quality and productive training, and each candidate can find the necessary preparation tools that will help him/her in the primary target of obtaining the Oracle Database 12c Administrator Certified Professional certification.
The Oracle 1Z0-063 exam is a globally recognized qualifying test for the Oracle Database 12c Administrator Certified Professional certificate for the most highly skilled and experienced database specialists who already have the Oracle Database 12c Administrator Certified Associate certification.
NEW QUESTION 143
Your Oracle 12c multitenant container database (CDB) contains multiple pluggable databases (PDBs).
In PDB HR_PDB, common user C##ADMIN and 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/oracle@HR_PDB as sysdba
SQL> GRANT c##role1 TO b_admin CONTAINER=CURRENT;
Which three statements are true? (Choose three.)
- A. C##ADMIN can create and select any table in HR_PDB.
- B. B_ADMIN can create and select any table only in HR_PDB.
- C. B_ADMIN can create and select any table in both the root container and HR_PDB.
- D. A local role can be granted to c##role1 in a PDB
- E. Role c##role1 will always have the same privileges in each PDB.
- F. C##ADMIN can create and select any table, and grant the C##ROLE1 role to users only in the root container.
Answer: A,D,E
NEW QUESTION 144
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.)
- A. The valid time columns are not populated by the Oracle Server automatically.
- B. Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulation language (DML), data definition language (DDL), and queries performed by the session.
- C. The valid time columns employee_time_start and employee_time_end are automatically created.
- D. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
- E. The valid time columns are visible by default when the table is described.
Answer: A,C,D
Explanation:
Explanation
A: To implement Temporal Validity(TV), 12c offers the option to have two date columns in that table which is having TV enabled using the new clause Period For in the Create Table for the newly created tables or in the Alter Table for the existing ones. The columns that are used can be defined while creating the table itself and will be used in the Period For clause or you can skip having them in the table's definition in the case of which, the Period For clause would be creating them internally.
NEW QUESTION 145
What can be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?
- A. SQL profile recommendations
- B. SQL statement restructure recommendations
- C. creation of materialized views to improve query performance
- D. statistics recommendations
Answer: A
NEW QUESTION 146
Examine this command:
Which two statements are true after successful execution? (Choose two.)
- A. A metadata description of PDB2 is stored in the system tablespace of PDB1.
- B. PDB2 will use shared UNDO.
- C. PDB2 will be in MOUNT state.
- D. PDB2 will be open read-only.
- E. A metadata description of PDB2 is stored in an XML file in '/disk2/oracle/pdb2/'.
Answer: A,C
NEW QUESTION 147
For which three pieces of information can you use the RMAN list command?
- A. available archived redo log files
- B. stored scripts in the recovery catalog
- C. backup sets and image copies that are obsolete
- D. backups of tablespaces
- E. backups that are marked obsolete according to the current retention policy
Answer: A,B,D
Explanation:
Explanation/Reference:
Explanation:
Reference:
http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkup007.htm
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm#BRADV89585 The primary purpose of the LIST command is to list backup and copies. For example, you can list:
- Backups and proxy copies of a database, tablespace, datafile, archived redo log, or control file
- Backups that have expired
- Backups restricted by time, path name, device type, tag, or recoverability
- Archived redo log files and disk copies
NEW QUESTION 148
Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)
- A. A PDB must have been opened at least once after creation.
- B. PDB data file are automatically removed from disk.
- C. A PDB must be in closed state before it can be unplugged.
- D. A PDB must be in MOUNT state before it can be unplugged.
- E. An unplugged PDB can be plugged into the same or another container database (CDB).
Answer: A,C,E
Explanation:
Explanation/Reference:
Explanation:
A: To unplug a PDB, you first close it.
E: You can disassociate or unplug a PDB from a CDB and reassociate or plug the PDB into the same CDB or into another CDB.
Incorrect Answers:
C: The PDB must be in a closed stated, not in a mounted state when unplugging it.
D: The unplugging operation makes changes in the PDB data files to record that the PDB was properly and successfully unplugged. Because the PDB is still part of the CDB, you can back it up in Oracle Recovery Manager (Oracle RMAN).
References: http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/12c/r1/pdb/pdb_unplug_plug/ pdb_unplug_plug.html
NEW QUESTION 149
Which two statements are true about roles in multitenant container databases (CDBs)?
- A. A common role can be granted only to a common user.
- B. A local role can be assigned to a common role in a PDB.
- C. Local roles can be granted to local and common users.
- D. A common role can be granted only system privileges.
- E. The root container can have both local and common roles.
- F. A common user can create a local role by default in any pluggable database (PDB) that is plugged in to a CDB.
Answer: C,F
Explanation:
Explanation/Reference:
Reference https://oracle-base.com/articles/12c/multitenant-manage-users-and-privileges-for-cdb-and-pdb-
12cr1
NEW QUESTION 150
You are administering a multitenant container database (CDB) cdb1.
Examine the command and its output:
SQL>show parameterfile
NAME TYPE VALUE
----------------------------------------------------------------------- db_create_file_dest string db_file_name_convert string db_files integer 200 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
ADMINUSER salesadm IDENTIFIED BY password;
ROLES=(dba)
DEFAULTTABLESPACE sales
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?
- A. SALESPDB is created and is in mount state.
- B. PDB creation fails because the db_file_name_convert parameter is not set in the CDB.
- C. PDB creation fails because a default temporary tablespace is not defined for SALESPDB.
- D. SALESPDB is created and is in read/write mode.
Answer: A
NEW QUESTION 151
The HR user updates the salary of one of the employees in the EMPLOYEES table, but does not commit the transaction.
Which type of lock would this scenario lead to?
- A. Exclusive table-level lock on the EMPLOYEES table
- B. Null lock on the EMPLOYEES table
- C. Null lock on the row being updated
- D. Row-exclusive lock on the row being updated
Answer: D
Explanation:
Explanation/Reference:
NEW QUESTION 152
You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able toconnect to the database instance because it hangs.
How can you detect the cause of the degraded performance?
- A. by using Active Session History (ASH) data and performing hang analysis
- B. by running ADDM in diagnostic mode
- C. by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots
- D. by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis
Answer: C
NEW QUESTION 153
You need to perform a block media recovery on the tools01.dbfdata file in your database by using Recovery Manager (RMAN).
Which two are prerequisites for performing this operation?
- A. You must have full or level-0 backups to restore blocks.
- B. You must take the tools01.dbfdata file offline.
- C. You must use an incremental level-1 backup to restore blocks.
- D. You must configure a block change tracking file.
- E. You must ensure that the database is mounted or open.
Answer: A,E
Explanation:
Explanation/Reference:
Explanation:
The target database must run in ARCHIVELOG mode and be open or mounted with a current control file.
The backups of the data files containing the corrupt blocks must be full or level 0 backups. They cannot be proxy copies or incremental backups.
References: Oracle Database, Backup and Recovery User's Guide, 12 Release 2 (January 2017), page
19-4
NEW QUESTION 154
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?
- A. EXAMPLE
- B. SYSTEM
- C. SYSAUX
- D. USERS
Answer: B
Explanation:
Explanation/Reference:
Explanation:
NEW QUESTION 155
Which two are prerequisites for setting up Flashback Data Archive? (Choose two.)
- A. Automatic Undo Management should be enabled.
- B. Undo retention guarantee should be enabled.
- C. All users using Flashback Data Archive should have unlimited quota on the Flashback Data Archive tablespace.
- D. Supplemental logging should be enabled.
- E. The tablespace in which the Flashback Data Archive is created should have Automatic Segment Space Management (ASSM) enabled.
- F. Fast Recovery Area should be defined.
Answer: A,E
Explanation:
Reference:
http://www.oracle.com/technetwork/database/focus-areas/storage/total-recall-whitepaper-171749.pdf (page 8)
NEW QUESTION 156
Examine the commands executed to monitor database operations:
$> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid := DBMS_SQL_MONITOR.BEGlN_OPERATION
('batch_job',FORCED_TRACKING=>'Y');
Which two statements are true? (Choose two.)
- A. Only DML and DDL statements will be monitored for the session.
- B. Database operations will be monitored only when they consume a significant amount of resource.
- C. All subsequent statements in the session will be treated as one database operation and will be monitored.
- D. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.
- E. Database operations for all sessions will be monitored.
Answer: C,D
Explanation:
Explanation/Reference:
Explanation:
C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC
+TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.
Note:
* The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real- time Database Operation Monitoring.
*(not B) BEGIN_OPERATION Function starts a composite database operation in the current session.
/ (E) FORCE_TRACKING - forces the composite database operation to be tracked when the operation starts. You can also use the string variable 'Y'.
/ (not A) NO_FORCE_TRACKING - the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable 'N'.
NEW QUESTION 157
Which three requirements should be successfully met by an Oracle Secure Backup (OSB) user so that OSB performs RMAN backup or restore requests? (Choose three.)
- A. matching the OS user identity of the Oracle instance associated with the database username
- B. assigned to a class with rights to browse all directories and catalogs
- C. scheduling of the RMAN backup to occur automatically at user-defined intervals
- D. OSB encryption for data in transport and on tape
- E. RMAN preauthorization on the host
- F. assigned to a class with rights to back up or restore Oracle database
Answer: B,E,F
Explanation:
Explanation
A: Performing Oracle database backups using RMAN requires RMAN user preauthorization within OSB D: The preauthorized Oracle Secure Backup user must also be assigned to an Oracle Secure Backup class possessing the following rights:
access Oracle backups (set to owner, class, or all)
perform Oracle backups and restores
F: The preauthorized Oracle Secure Backup user must be mapped to operating system privileges to access the files to be backed up or restored. the preauthorized Oracle Secure Backup user can perform RMAN operations only on the host where it has access to files.
References: https://docs.oracle.com/cd/E16926_01/doc.121/e16564/osb_rman_backup.htm#OBADM199
NEW QUESTION 158
Which two statements are true about Resource Manager plans for individual pluggable databases (PDB plans) in a multitenant container database (CDB)? (Choose two.)
- A. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the CDB.
- B. If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
- C. If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
- D. If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
- E. In a PDB plan, subplans may be used with up to eight consumer groups.
Answer: B,C
Explanation:
Explanation/Reference:
Explanation:
A: A CDB resource plan determines the amount of resources allocated to each PDB. A PDB resource plan determines how the resources allocated to a specific PDB are allocated to consumer groups within that PDB.
Resource Manager allocates the resources in two steps:
1. It allocates a portion of the system's resources to each PDB.
2. In a specific PDB, it allocates a portion of system resources obtained in Step 1 to each session connected to the PDB.
E: A PDB resource plan allocates resource among the consumer groups within a PDB.
References: https://docs.oracle.com/database/121/ADMIN/cdb_dbrm.htm
NEW QUESTION 159
You created a tablespace with this statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/proddb/data/adtbs.dbf' SIZE 10G;
The tablespace is nearly full and you need to avoid any out of space errors for the load of a 5 gig table.
Which two alter statements will achieve this? (Choose two.)
- A. ALTER TABLESPACE adtbs RESI2E 20G;
- B. ALTER TABLESPACE adtbs ADD DATAFILE;
- C. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf AUTOEXTEND ON;
- D. ALTER TABLESPACE adtbs ADD DATAFILE '/proddb/data/adtbsl.dbf' SIZE 1QG;
- E. ALTER TABLESPACE adtbs AUTOEXTEND ON;
Answer: A,E
Explanation:
Explanation
http://www.techonthenet.com/oracle/tablespaces/alter_tablespace.php
NEW QUESTION 160
One of your container databases (CDBs) has five pluggable databases (PDBs).
COMMON_USER_PREFIXis C##.
These commands executed successfully while connected as SYSto CDB$ROOT:
SQL> CREATE c##dba_admin IDENTIFIED BY orcl23;
SQL> CREATE ROLE c##role1 CONTAINER=ALL;
SQL> GRANT CREATE VIEW TO c##role1 CONTAINER=ALL;
SQL> GRANT c##role1 TO c##dba_admin CONTAINER=ALL;
SQL> GRANT c##role1 to system CONTAINER=ALL;
Which three are true? (Choose three.)
- A. The C##DBA_ADMINuser is a local user in CDB$ROOT.
- B. SYSTEMis able to create views in any PDB as a result of being granted the C##ROLE1role.
- C. SYSTEMis able to create views in any PDB as a result of being a DBA user.
- D. The c##role1role will always have the same privileges in all current and future PDBs.
- E. The C##DBA_ADMIN user is able to create views in any PDB as a result of being granted the C##ROLE1 role.
- F. The C##DBA_ADMINuser is a local user in CDB$ROOTand PDB$SEED.
Answer: B,D,E
NEW QUESTION 161
Which two statements are true about RMAN duplexed backups? (Choose two.)
- A. It is not supported for image copies.
- B. Duplex backups can contain only data files and control files.
- C. It is only supported for backups to tape via media management interface.
- D. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.
- E. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.
Answer: A,D
NEW QUESTION 162
You wish to create jobs to satisfy these requirements:
1. Automatically bulk load data from a flat file.
2. Rebuild indexes on the SALES table after completion of the bulk load.
How would you create these jobs?
- A. Create both jobs by using Scheduler raised events.
- B. Create both jobs using application raised events.
- C. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.
- D. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.
Answer: A
NEW QUESTION 163
......
Pass Oracle 1z0-063 Exam Quickly With Actual4Dumps: https://www.actual4dumps.com/1z0-063-study-material.html