[Free] 2018(Jan) EnsurePass Testking Oracle 1z0-062 Dumps with VCE and PDF 21-30

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-062
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/1z0-062.html

Oracle Database 12c: Installation and Administration

Question No: 21

Which two statements are true about extents?

  1. Blocks belonging to an extent can be spread across multiple data files.

  2. Data blocks inan extent are logically contiguous but can be non-contiguous on disk.

  3. The blocks of a newly allocated extent, although free, may have been used before.

  4. Data blocks in an extent are automatically reclaimed for use by other objects in a tablespace when all the rows in a table are deleted.

Answer: B,C

Question No: 22

Automatic Shared Memory Management (ASMM) is enabled for your database instance. You execute the following command:

SQLgt; ALTER SYSTEM SET DB_CACHE_SIZE = 100M;

Which statement is true?

  1. It succeeds and the minimum size for the DEFAULT buffer pool is set to 100M.

  2. It fails because DB_CACHE_SIZE is a static initialization parameter.

  3. It fails because ASMM is enabled and individual SGA components cannot be sized.

  4. It succeeds and the value is changed in the SPFILE immediately, but the change takes effect only at the next instance startup.

Answer: A

Question No: 23

Whatcan be automatically implemented after the SQL Tuning Advisor is run as part of the Automated Maintenance Task?

  1. statistics recommendations

  2. SQL profile recommendations

  3. SQL statement restructure recommendations

  4. creation of materialized views toimprove query performance

Answer: B Explanation:

References: http://docs.oracle.com/cd/B28359_01/server.111/b28274/sql_tune.htm#i36217

Question No: 24

You want execution of large database operations to suspend, and then resume, in the eventof space allocation failures.

You set the value of the initialization parameter RESUMABLE_TIMEOUT to 3600. Which two statements are true?

  1. Before a statement executes in resumable mode, the ALTER SESSION ENABLE RESUMABLE statement must be issued in its session.

  2. Data Manipulation Language (DML) operations are resumable, provided that they are not embedded in a PL/SQL block.

  3. A resumable statement can be suspended and resumed only once during execution.

  4. A suspended statement will report an errorif no corrective action has taken place during a timeout period.

  5. Suspending a statement automatically results in suspending a transaction and releasing all the resources held by the transaction.

Answer: D,E

Question No: 25

In your multitenant container database (CDB) containing pluggable database (PDBs), you granted the CREATE TABLE privilege to the commonuser C # # A_ADMIN in root and all PDBs. You execute the following command from the root container:

SQL gt; REVOKE create table FROM C # # A_ADMIN; What is the result?

  1. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.

  2. It fails and reports an error because the CONTAINER=ALL clause is not used.

  3. It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.

  4. It fails and reports an error because the CONTAINER=CURRENT clause is not used.

  5. It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.

    Answer: A Explanation:

    REVOKE ..FROM

    If the current container is the root:

    / Specify CONTAINER = CURRENT to revoke alocally granted system privilege, object privilege, or role from a common user or common role. The privilege or role is revoked from the user or role only in the root. This clause does not revoke privileges granted with

    CONTAINER = ALL.

    / Specify CONTAINER = ALL to revoke a commonly granted system privilege, object privilege on a common object, or role from a common user or common role. The privilege or role is revoked from the user or role across the entire CDB. This clause can revoke only a privilege orrole granted with CONTAINER = ALL from the specified common user or common role. This clause does not revoke privileges granted locally with CONTAINER = CURRENT. However, any locally granted privileges that depend on the commonly granted privilege being revoked are also revoked.

    If you omit this clause, then CONTAINER = CURRENT is the default. References:

    Question No: 26

    You want to create a database and you have the following:

    • Oracle Grid Infrastructure is installed and configured.

    • Oracle Database Vault is installed in ORACLE_HOME to be used for this database.

    • Oracle Enterprise Manager Cloud Control isavailable and an agent is deployed on the database server.

    Examine the requirements:

    1. configuring the database instance to support shared server mode

    2. using Automatic Storage Management (ASM) for storing database files.

    3. configuring a naming methodto help a remote user connect to a database instance

    4. configuring the Fast Recovery Area

    5. configuring Database Vault

    6. configuring Enterprise Manager (EM) Database Express

    7. registering with EM Cloud Control

    8. configuring remote log archive destinations

    9. enabling daily incremental backups

    10. configuring a nondefault block size for nondefault block size tablespaces

Which of these requirements can be met while creating a database by using the Database Configuration Assistant (DBCA)?

A. 1, 2, 4, 5,7, 8, 9 and 10

B. 1, 2, 4, 5, 6 and 7

C. 1, 2, 3, 8, 9 and 10

D. 1, 2, 3, 4, 6, 8, 9 and 10

E. 1, 2, 4, 5, 6, 7 and 8

Answer: D

Question No: 27

Which three statements are true about the purpose of checkpoints?

  1. They ensure that uncommitted transactions are rolled back in case of an instance failure.

  2. They ensure that all the dirty buffers are written to disk during a normal shutdown.

  3. They ensure that instance recovery starts in the event of an instance failure.

  4. They ensure that dirty buffers in the buffer cache are written to disk regularly.

  5. They reduce the time required for recovery in case of an instance failure.

Answer: C,D,E Explanation: References:

http://docs.oracle.com/cd/E36909_01/server.1111/e25789/startup.htm#BABGDACG

Question No: 28

Your database instance is started by using a server parameter file (SPFILE). You execute

the following command to change thevalue of the LOG_BUFFER initialization parameter: ALTER SYSTEM SET LOG_BUFFER=32 M;

What is the outcome of this command?

  1. The parameter value is changed and it comes into effect as soon as space becomes available in the SGA.

  2. It returns an error because the value of this parameter cannot be changed dynamically.

  3. The parameter value is changed and it comes into effect at the next instance startup.

  4. It returns an error because SCOPE should be set to MEMORY.

Answer: B

Question No: 29

You execute this command:

Ensurepass 2018 PDF and VCE

Which two statements are true about segment space management for segments in thistablespace?

  1. Space utilization inside segments is mapped by bitmaps.

  2. Segments are automatically shrunk and compressed when rows are deleted.

  3. The PCTFREE storage parameter has no effect on segments created in this tablespace.

  4. The PCTUSED storageparameter has no effect on segments created in this tablespace.

Answer: A

Question No: 30

Which two options can be configured for an existing database by using the Database Configuration Assistant (DBCA)?

  1. Configure Label Security

  2. Database Vault in ORACLE_HOME

  3. Oracle Suggested BackupStrategy

  4. Database Resident Connection Pooling

  5. Nondefault blocksize tablespaces

Answer: B,D

100% Ensurepass Free Download!
Download Free Demo:1z0-062 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-062 Dumps

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

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.