web analytics

PassLeader Valid 1Z0-060 Dumps with VCE and PDF (Question 91 – Question 100)

PassLeader now are offering 100% pass ensure 1Z0-060 dumps! All 1Z0-060 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-060 VCE dumps and PDF dumps: http://www.passleader.com/1z0-060.html (161 Q&As)

BTW: Download PassLeader 1Z0-060 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpNjQta2dQSmFJLWs

QUESTION 91
Which three operations can be performed as multipartition operations in Oracle?

A.    Merge partitions of a list partitioned table
B.    Drop partitions of a list partitioned table
C.    Coalesce partitions of a hash-partitioned global index
D.    Move partitions of a range-partitioned table
E.    Rename partitions of a range partitioned table
F.    Merge partitions of a reference partitioned index

Answer: ABF

QUESTION 92
You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:
passleader-1Z0-060-dumps-921
What is the result of the last SET CONTAINER statement and why is it so?

A.    It succeeds because the PDB_ADMIN user has the required privileges.
B.    It fails because common users are unable to use the SET CONTAINER statement.
C.    It fails because local users are unable to use the SET CONTAINER statement.
D.    If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

Answer: C
Explanation:
http://docs.oracle.com/cd/E16655_01/server.121/e17636/cdb_admin.htm

QUESTION 93
Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR) report:
passleader-1Z0-060-dumps-931
What are three possible causes for the latch-related wait events?

A.    The size of the shared pool is too small.
B.    Cursors are not being shared.
C.    A large number COMMITS are being performed.
D.    There are frequent logons and logoffs.
E.    The buffers are being read into the buffer cache, but some other session is changing the buffers.

Answer: ABE

QUESTION 94
You enabled an audit policy by issuing the following statements:
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT;
SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM;
For which database users and for which executions is the audit policy now active? Select two.

A.    SYS, SYSTEM
B.    SCOTT
C.    Only for successful executions
D.    Only for failed executions
E.    Both successful and failed executions

Answer: AE
Explanation:
* The ORA_DATABASE_PARAMETER policy audits commonly used Oracle Database parameter settings. By default, this policy is not enabled.

QUESTION 95
A redaction policy was added to the SAL column of the SCOTT.EMP table:
passleader-1Z0-060-dumps-951
All users have their default set of system privileges. For which three situations will data not be redacted?

A.    SYS sessions, regardless of the roles that are set in the session
B.    SYSTEM sessions, regardless of the roles that are set in the session
C.    SCOTT sessions, only if the MGR role is set in the session
D.    SCOTT sessions, only if the MGR role is granted to SCOTT
E.    SCOTT sessions, because he is the owner of the table
F.    SYSTEM session, only if the MGR role is set in the session

Answer: ABD
Explanation:
http://docs.oracle.com/cd/E16655_01/network.121/e17729/redaction.htm#ASOAG594

QUESTION 96
What is the result of executing a TRUNCATE TABLE command on a table that has Flashback Archiving enabled?

A.    It fails with the ORA-665610 Invalid DDL statement on history-tracked message.
B.    The rows in the table are truncated without being archived.
C.    The rows in the table are archived, and then truncated.
D.    The rows in both the table and the archive are truncated.

Answer: C

QUESTION 97
Which three activities are supported by the Data Recovery Advisor?

A.    Advising on block checksum failures
B.    Advising on inaccessible control files
C.    Advising on inaccessible block change tracking files
D.    Advising on empty password files
E.    Advising on invalid block header field values

Answer: ABE
Explanation:
*Data Recovery Advisor can diagnose failures such as the following:
/ (B) Components such as datafiles and control files that are not accessible because they do not exist, do not have the correct access permissions, have been taken offline, and so on.
/ (A, E) Physical corruptions such as block checksum failures and invalid block header field values.
/ Inconsistencies such as a datafile that is older than other database files.
/ I/O failures such as hardware errors, operating system driver failures, and exceeding operating system resource limits (for example, the number of open files).
* The Data Recovery Advisor automatically diagnoses corruption or loss of persistent data on disk, determines the appropriate repair options, and executes repairs at the user’s request. This reduces the complexity of recovery process, thereby reducing the Mean Time To Recover (MTTR).

QUESTION 98
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:
passleader-1Z0-060-dumps-981
Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?

A.    The valid time columns employee_time_start and employee_time_end are automatically created.
B.    The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
C.    The validtimecolumns are not populated by the Oracle Server automatically.
D.    The validtimecolumns arevisible by default when the table is described.
E.    Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for datamanipulation language (DML), data definition language (DDL), and queries performed by the session.

Answer: ABC

QUESTION 99
Which three statements are true regarding the use of the Database Migration Assistant for Unicode (DMU)?

A.    A DBAcancheck specific tables with the DMU.
B.    The database to be migrated must be opened read-only.
C.    The release of the database to be converted can be any release since 9.2.0.8.
D.    The DMU can report columns that are too long in the converted characterset.
E.    The DMU can report columns that are not represented in the converted characterset.

Answer: ADE
Explanation:
A: In certain situations, you may want to exclude selected columns or tables from scanning or conversion steps of the migration process.
D: Exceed column limit
The cell data will not fit into a column after conversion.
E: Need conversion
The cell data needs to be converted, because its binary representation in the target character set is different than the representation in the current character set, but neither length limit issues nor invalid representation issues have been found.
* Oracle Database Migration Assistant for Unicode (DMU) is a unique next-generation migration tool providing an end-to-end solution for migrating your databases from legacy encodings to Unicode.
Incorrect:
Not C: The release of Oracle Database must be 10.2.0.4, 10.2.0.5, 11.1.0.7, 11.2.0.1, or later.

QUESTION 100
Oracle Grid Infrastructure for a stand-alone server is installed on your production host before installing the Oracle Database server. The database and listener are configured by using Oracle Restart. Examine the following command and its output:
$ crsctl config has
CRS-4622: Oracle High Availability Services auto start is enabled.
What does this imply?

A.    When you start an instance on a high with SQL *Plus dependent listeners and ASM disk groups are automatically started.
B.    When a database instance is started by using the SRVCTL utility and listener startup fails, the instance is still started.
C.    When a database is created by using SQL* Plus, it is automatically added to the Oracle Restart configuration.
D.    When you create a database service by modifying the SERVICE_NAMES initialization parameter, it is automatically added to the Oracle Restart configuration.

Answer: B
Explanation:
About Startup Dependencies
Oracle Restart ensures that Oracle components are started in the proper order, in accordance with component dependencies. For example, if database files are stored in Oracle ASM disk groups, then before starting the database instance, Oracle Restart ensures that the Oracle ASM instance is started and the required disk groups are mounted. Likewise, if a component must be shut down, Oracle Restart ensures that dependent components are cleanly shut down first. Oracle Restart also manages the weak dependency between database instances and the Oracle Net listener (the listener): When a database instance is started, Oracle Restart attempts to start the listener. If the listener startup fails, then the database is still started. If the listener later fails, Oracle Restart does not shut down and restart any database instances.
http://docs.oracle.com/cd/E16655_01/server.121/e17636/restart.htm#ADMIN12710


PassLeader now are offering 100% pass ensure 1Z0-060 dumps! All 1Z0-060 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-060 VCE dumps and PDF dumps: http://www.passleader.com/1z0-060.html (161 Q&As)

BTW: Download PassLeader 1Z0-060 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpNjQta2dQSmFJLWs