[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-063 Dumps with VCE and PDF 91-100

2018 Jan Oracle Official New Released 1z0-063
100% Free Download! 100% Pass Guaranteed!

Oracle Database 12c: Advanced Administration

Question No: 91

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?

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

Answer: A,B,E

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 CreateTable 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 thecase of which, the Period For clause would be creating them internally.


This procedure enables session level valid time flashback.

Question No: 92

You set the following parameters in the parameter file and restart the database instance: NEMORY_MAX_TARGET=0


Which two statements are true?

  1. The memory_max_target parameter is automatically set to 500 MB.

  2. The pga_aggregate_target and sga_target parameters are automatically set to zero.

  3. The value of the memory_max_target parameter remains zero for the database instance.

  4. The lower limits of the pga_aggregate_target and sga_target parameters are set to 90 MB and 270 MB respectively.

  5. The instance does not start up because Automatic Memory Management (AMM) is enabled but pga_aggregate_target and sga_target parameters are set to nonzero values.

Answer: C,E

Question No: 93

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

  1. Use the d3MS_pdb package to plug the Oracle 11g database into the existing CDB as a PDB.

  2. Use the create database … enable pluggable database statement to create a PDB by copying data files from pd3Sseed and use data pump to load data from the Oracle 11g database into the newly created PDB.

  3. Pre-create a PDB in CDB and use data pump to load data from the complete database export of the Oracle 11g database into the newly created PDB.

  4. Pre-create a PDB in CDB and use the network_link and parallel parameters with data pump import to import data from the Oracle 11g database to the newly created PDB.

  5. Upgrade the Oracle 11g database to a 12c non-CDB and use the dbms_pdb.describe procedure to plug the database as a new PDB into the CDB.

Answer: B,E

Question No: 94

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?

  1. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Performance Analyzer on the test system

  2. capturing the workload on the production system and replaying the workload for one PDB at a time on the test system

  3. capturing the workload on the production systemand using Consolidated Database Replay to replay the workload of all production systems simultaneously for all PDBs

  4. capturing the most resource-intensive SQL statements in a SQL Tuning Set on the production system and using the SQL Tuning Advisor on thetest system

Answer: D

Question No: 95

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?

  1. a hash cluster

  2. an index cluster

  3. a partitioned table

  4. a sorted hash cluster

  5. a heap table with a rowid column

Answer: B

Question No: 96

You wish to enable an audit policy for all database users, except sys, system, and scott. You issue the following statements:


For which database users is the audit policy now active?

  1. all users exceptsys

  2. all users except scott

  3. all users except sys and scott

  4. all users except sys, system, and scott

Answer: B

Question No: 97

In a database supporting an OLTP workload, tables are frequently updated on both key and non-keycolumns.

Reports are also generated by joining multiple tables.

Which table organization or type would provide the best performance for this hybrid workload?

  1. heap table with a primary key index

  2. external table

  3. hash clustered table

  4. global temporary table

  5. index clustered table

Answer: E

Question No: 98

Which two statements are true about the Automatic Diagnostic Repository (ADR)?

  1. The ADR base is shared across multiple instances.

  2. The ADR base keeps all diagnostic information in binary format.

  3. The ADR can be used to store statspack snapshots to diagnose database performance issues.

  4. The ADR can be used for problem diagnosis even when the database instance is down.

  5. The ADR is used to store Automatic Workload Repository (AWR) snapshots.

Answer: C,D

Question No: 99

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

  1. loss of a non-critical data file

  2. loss of a control file

  3. physical data block corruption

  4. logical data block corruption

  5. loss of an archived redo log file

Answer: A,B,C Reference:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmrepai.htm#BRAD V89728

Question No: 100

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




Answer: A Explanation:

This table space is used to store permanent user objects and data. Like the TEMP table space, every database should have a table space for permanent user data that is assigned to users. Otherwise, user objects will be created in the SYSTEM table space, which is not good practice. In the preconfigured database, USERS is assigned the default table space, and space for all objects created by non-system users comes from this table space. For system users, the default permanent table space remains SYSTEM.

100% Free Download!
Download Free Demo:1z0-063 Demo PDF
100% Pass Guaranteed!
Download 2018 EnsurePass 1z0-063 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2018 EnsurePass IT Certification PDF and VCE

Leave a Comment


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