[Free] 2018(Jan) Latesttests Dumpsleader Oracle 1z0-052 Dumps with VCE and PDF Download 91-100

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

Oracle Database 11g: Administration I

Question No: 91 – (Topic 2)

Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.)

  1. The MTTR advisor will be disabled

  2. Automatic checkpoint tuning will be enabled

  3. The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET

  4. The time taken to recover the instance after the crash is always exactly the same as the value given for the

FAST_START_MTTR_TARGET initialization parameter

Answer: B,C

Question No: 92 – (Topic 2)

A user, who is authenticated externally, logs in to a remote machine and connects to the database instance. What action would you take to ensure that a user cannot connect to the database instance by merely logging in to a remote machine?


  2. Set OS_ROLES parameter to FALSE

  3. Set the REMOTE_OS_AUTHENT parameter to FALSE

  4. Set the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE

Answer: C

Question No: 93 – (Topic 2)

Which is the correct description of a pinned buffer in the database buffer cache?

  1. The buffer is currently being accessed

  2. The buffer is empty and has not been used

  3. The contents of the buffer have changed and must be flushed to the disk by the DBWn process

  4. The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk

Answer: A

Question No: 94 – (Topic 2)

In which of the scenario will the DBA perform recovery? (Choose all that apply.)

  1. The alert log file is corrupted

  2. A tablespace is accidentally dropped

  3. One of the redo log members is corrupted

  4. A database user terminates the session abnormally

  5. The hard disk on which the data files is stored is corrupted

Answer: B,E

Question No: 95 – (Topic 2)

Which two statements are true regarding a PL/SQL package body? (Choose two.)

  1. It cannot be created without a package specification.

  2. It cannot invoke subprograms defined in other packages.

  3. It can contain only the subprograms defined in the package specification.

  4. It can be changed and recompiled without making the package specification invalid.

Answer: A,D Explanation:

Package Specification and Body

Package bodies:

  • Are separate from package specifications. Because of this, the code of the body can be changed and recompiled, and other objects that are dependent on the specification are not marked invalid.

  • Contain the code for subprograms defined in the package specification. This is where the work is done. The specification shows how to call subprograms within the package: the

    body is the code section

  • Cannot be compiled unless the package specification has already been compiled. You can create a specification without a body- but you cannot create a body without a specification.

  • May be wrapped to hide details of the code. Wrap is a stand-alone program that obfuscates PL SQL source code so that you can deliver PL SQL applications without exposing your source code. For more information about the use of wrap, see the PL/SQL Packages and Types Reference.

    Question No: 96 – (Topic 2)

    Examine the following output:

    Latesttests 2018 PDF and VCE

    Which two statements about the above index are true? (Choose two.)

    1. It is ignored by the query optimizer.

    2. It is not used while the index is being rebuilt.

    3. The index cannot be rebuilt, and has to be re-created.

    4. The index is automatically rebuilt when used the next time.

    Answer: A,B

    Question No: 97 – (Topic 2)

    View the Exhibit.

    Latesttests 2018 PDF and VCE

    You want to create a tablespace to contain objects with block size 16 KB. But while configuring the storage you find that the block size that you can provide is only 8 KB.

    Which configuration could have enabled the block selection of 16 KB?

    1. Choosing the extent allocation type to uniform

    2. Choosing the Segment Space Management option to manual

    3. Setting autoextension on for the data file mentioned for the tablespace

    4. Setting the DB_16K_CACHE_SIZE parameter for the database instance to a nonzero value

    Answer: D Explanation:

    DB_16K_CACHE_SIZE parameter used to specify size of cache in 16K buffers i.e. other than default size specified by using DB_BLOCK_SIZE. This can be used only when DB_BLOCK_SIZE is not set 16384. Do not set this parameter value to zero if any

    tablespace has block size as 16KB. This parameter can be set only when operating system specific minimum block size not restricted greater than 4KB.

    Question No: 98 – (Topic 2)

    Which two statements are true regarding transactions in an Oracle database? (Choose two.)

    1. Multiple transactions can use the same undo segment.

    2. A transaction is assigned an undo segment when it is started.

    3. More than one transaction cannot share the same extent in the undo tablespace.

    4. The transactions use system undo segment to store undo data if all the segments in the undo tablespace are used.

    Answer: A,B Explanation:


    The level of logical database storage above an extent is called a segment. A segment is a set of extents that are allocated for a certain logical structure. Different types of segments include:

  • Data segments: Each nonclustered. non-index-organized table has a data segment, with the exception of external tables, global temporary tables, and partitioned tables in which each table has one or more segments. All of the table#39;s data is stored in the extents of its data segment. For a partitioned table, each partition has a data segment. Each cluster has a data segment. The data of every table in the cluster is stored in the cluster#39;s data segment.

  • Index segments: Each index has an index segment that stores all of its data. For a partitioned index, each partition has an index segment.

  • Undo segments: One UNDO tablespace is created for each database instance. This tablespace contains numerous undo segments to temporarily store undo information. The information in an undo segment is used to generate read-consistent database information and. dining database recovery, to roll back uncommitted transactions for users.

  • Temporary segments: Temporary segments are created by the Oracle database when a SQL statement needs a temporary work area to complete execution. When the statement finishes execution, the temporary segment#39;s extents are returned to the instance for future

    use. Specify either a default temporary tablespace for every user, or a default temporary tablespace that is used database-wide.

    Transactions and Undo Data

    When a transaction starts, it is assigned to an undo segment. Throughout the life of the transaction, when data is changed, the original (before the change) values are copied into the undo segment. You can see which transactions are assigned to which undo segments by checking the V$TRANSACTION dynamic performance view.

    Undo segments are specialized segments that are automatically created by the instance as needed to support transactions. Like all segments, undo segments are made up of extents, which, in turn, consist of data blocks. Undo segments automatically grow and shrink as needed, acting as a circular storage buffer for their assigned transactions.

    Transactions fill extents in their undo segments until a transaction is completed or all space is consumed. If an extent fills up and more space is needed, the transaction acquires that space from the next extent in the segment. After all extents have been consumed, the transaction either wraps around back into the first extent or requests a new extent to be allocated to the undo segment.

    Question No: 99 – (Topic 2)

    To make audit information more productive, the DBA executes the following command before starting an audit operations:


    Which statement is true regarding the audit record generated when auditing starts after restarting the database?

    1. It contains only the plan for the SQL statement executed by the user

    2. It contains the SQL text executed by the user and the bind variables used with it

    3. It contains the plan and statistics associated with the SQL statement executed by the user

    4. It contains the plan for the SQL statement executed by the user and the bind variables used with it

    Answer: B

    Question No: 100 – (Topic 2)

    View the Exhibit to examine the output for the CROSSCHECK BACKUP command.

    Latesttests 2018 PDF and VCE

    Which statement is true about the output of the command?

    1. The backup piece is expired as the new backup is available

    2. The backup piece is expired because the operating-system file was not found

    3. The backup piece is expired because the retention period for the backup has expired

    4. The backup piece is expired because the backup set to which it belongs is not complete

    Answer: B

    Explanation: EXPIRED and AVAILABLE Status

    You can view the status of backup sets and copies recorded in the RMAN repository through LIST, vs views, or recovery catalog views (if you use RMAN with a catalog). Table 2-4 describes the meaning of each status.

    The crosscheck command only processes files created on the same device type as the channels used for the crosscheck. The crosscheck command checks only objects marked available or expired in the repository by examining the files on disk for disk channels or by querying the media manager for sbc channels.

    The CROSSCHECK command only processes files created on the same device type as the channels used for the crosscheck. The CROSSCHECK command checks only objects marked AVAILABLE or EXPIRED in the repository by examining the files on disk for DISK channels or by querying the media manager for sbt channels.

    Latesttests 2018 PDF and VCE



    Use the CROSSCHECK command to synchronize the physical reality of backups and copies with their logical records in the RMAN repository.

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

    Latesttests 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

    2018 Latesttests IT Certification PDF and VCE