Download Oracle Database 12c: Advanced Administration.1z0-063.Pass4Sure.2019-07-21.152q.vcex

Vendor: Oracle
Exam Code: 1z0-063
Exam Name: Oracle Database 12c: Advanced Administration
Date: Jul 21, 2019
File Size: 969 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAM_HUB

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
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.)
  1. The movement of all segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
  2. Setting the target tablespace to read-only after the segments are moved
  3. The movement of some segments to a target tablespace with a higher degree of compression, on a different storage tier, when the source tablespace exceeds T3S percent used
  4. Taking the target tablespace offline after the segments are moved
  5. The movement of some blocks to a target tablespace with a lower degree of compression, on a different storage tier, when the source tablespace exceeds tbs percent used
Correct answer: BC
Question 2
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.)
  1. RMAN recovery catalog
  2. RMAN Media Management Library
  3. Enterprise Manager Cloud Control
  4. Enterprise Manager Database Express 
  5. Oracle Secure Backup
Correct answer: AC
Question 3
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?
  1. MAXSETSIZE TO 2;
  2. DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
  3. CHANNEL DEVICE TYPE DISK FORMAT '/disk1/%U' , '/disk2/%U';
  4. DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
Correct answer: D
Explanation:
Reference:http://docs.oracle.com/cd/B14117_01/server.101/b10734/rcmconfg.htmhttp://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmconfa.htm#BRADV137
Reference:
http://docs.oracle.com/cd/B14117_01/server.101/b10734/rcmconfg.htm
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmconfa.htm#BRADV137
Question 4
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.) 
  1. The valid time columns employee_time_start and employee_time_end are automatically created.
  2. The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
  3. The valid time columns are not populated by the Oracle Server automatically.
  4. The valid time columns are visible by default when the table is described.
  5. 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.
Correct answer: ABC
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.
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.
Question 5
Which two statements are true when row-archival management is enabled? (Choose two.)
  1. Visibility of the ORA_ARCHIVE_STATE column is controlled by the row archival visibility session parameter.
  2. The ORA_ARCHIVE_STATE column is updated manually or by a program that can reference activity tracking columns, to indicate that a row is no longer considered active.
  3. The row archival visibility session parameter defaults to all rows.
  4. The ORA_ARCHIVE_STATE column is visible if it is referenced in the select list of a query.
  5. The ORA_ARCHIVE_STATE column is updated automatically by the database based on activity tracking columns, to indicate that a row is no longer considered active.
Correct answer: BD
Question 6
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.) 
  1. maximum undo per consumer group
  2. maximum idle time for a session in a PDB
  3. parallel server limit
  4. CPU
  5. maximum number of sessions for a PDB
Correct answer: CD
Question 7
Examine the steps to configure Oracle Secure Backup (OSB) for use with RMAN:
  1. Create media families for data files and archived redo log files. 
  2. Configure database backup storage selectors or RMAN media management parameters. 
  3. Create an OSB user preauthorized for RMAN operations. 
  4. Configure RMAN Access to the OSB SBT. 
  5. Disable Non-Uniform Memory Access (NUMA) awareness by setting the ob_ignore_numa parameter to 0. 
Identify the steps in the correct order.
  1. 1, 4, 3, 2, 5
  2. 1, 3, 4, 5, 2
  3. 4, 3, 1, 2, 5
  4. 4, 3, 5, 1, 2
Correct answer: C
Question 8
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?
  1. password-mode encryption
  2. dual-mode encryption
  3. transparent encryption
  4. default encryption
Correct answer: A
Explanation:
Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGEJABH (to make password –encrypted backups)
Reference:
http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmbckad.htm#CEGEJABH (to make password –encrypted backups)
Question 9
The following parameters are set for your Oracle 12c database instance:
OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE 
You want to manage the SQL plan evolution task manually. Examine the following steps:
  1. Set the evolve task parameters. 
  2. Create the evolve task by using the DBMS_SPM.CREATE_EVOVLE_TASK function. 
  3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 
  4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function. 
  5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. 
Identify the correct sequence of steps.
  1. 2, 4, 5
  2. 2, 1, 4, 3, 5
  3. 1, 2, 3, 4, 5
  4. 1, 2, 4, 5
Correct answer: B
Question 10
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?
  1. USERS
  2. SYSTEM
  3. SYSAUX
  4. EXAMPLE
Correct answer: B
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!