[Free] 2018(Jan) EnsurePass Passguide Oracle 1z0-062 Dumps with VCE and PDF 141-150

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: 141

Which two are prerequisites for performing a flashback transaction?

  1. Flashback Database must be enabled.

  2. Undo retention guarantee for the database must be configured.

  3. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.

  4. Supplemental logging must be enabled.

  5. Recycle bin must be enabled for the database.

  6. Block change tracking must be enabled tor the database.

Answer: A,C Explanation:

References:

Question No: 142

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?

  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

    TBSPERCENT USED

  2. Setting the target tablespace to read-only

  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 TBS PERCENT USED

  4. Setting the target tablespace offline

  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

Answer: B,C Explanation:

The value for TBS_PERCENT_USEDspecifies the percentage of the tablespace quota when a tablespace is considered full. The value for TBS_PERCENT_FREE specifies the targeted free percentage for the tablespace. When the percentage of the tablespace quota reaches the value of TBS_PERCENT_USED, ADO begins to move data so that percent free of the tablespace quota approaches the value of TBS_PERCENT_FREE. This action by ADO is a best effort and not a guarantee.

Question No: 143

Examine the current value for the following parameters in your database instance:

SGA_MAX_SIZE = 1024M SGA_TARGET = 700M DB_8K_CACHE_SIZE = 124M LOG_BUFFER = 200M

You issue the following command to increase the value of DB_8K_CACHE_SIZE: SQLgt; ALTER SYSTEM SET DB_8K_CACHE_SIZE=140M;

Which statement is true?

  1. It fails because the DB_8K_CACHE_SIZE parameter cannot be changed dynamically.

  2. It succeeds only if memory is available from the autotuned components if SGA.

  3. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_TARGET.

  4. It fails because an increase in DB_8K_CACHE_SIZE cannot be accommodated within SGA_MAX_SIZE.

Answer: D Explanation:

  • The SGA_TARGET parameter can be dynamically increased up to the value specified for the SGA_MAX_SIZE parameter, and it can also be reduced.

  • Example:

  • Forexample, suppose you have an environment with the following configuration:

    SGA_MAX_SIZE = 1024M SGA_TARGET = 512M DB_8K_CACHE_SIZE = 128M

    In this example, the value of SGA_TARGET can be resized up to 1024M and can also be reduced until one or more of theautomatically sized components reaches its minimum size. The exact value depends on environmental factors such as the number of CPUs on the system. However, the value of DB_8K_CACHE_SIZE remains fixed at all times at 128M

    • DB_8K_CACHE_SIZE

      Size of cachefor 8K buffers

    • For example, consider this configuration:

      SGA_TARGET = 512M DB_8K_CACHE_SIZE = 128M

      In this example, increasing DB_8K_CACHE_SIZE by 16 M to 144M means that the 16M is taken away from the automatically sized components. Likewise, reducingDB_8K_CACHE_SIZE by 16M to 112M means that the 16M is given to the automatically sized components.

      Question No: 144

      To enable the Database Smart Flash Cache, you configure the following parameters:

      DB_FLASH_CACHE_FILE = ‘/dev/flash_device_1’ , ‘/dev/flash_device_2’ DB_FLASH_CACHE_SIZE=64G

      What is the result when you start up the database instance?

      1. It results in an error because these parameter settings are invalid.

      2. One 64G flash cache file will be used.

      3. Two 64G flash cache files will be used.

      4. Two 32G flash cache files will be used.

      Answer: A

      Question No: 145

      You upgradedfrom a previous Oracle database version to Oracle Database version to Oracle Database 12c. Your database supports a mixed workload. During the day, lots of insert, update, and delete operations are performed. At night, Extract, Transform, Load (ETL) and batch reporting jobs are run. The ETL jobs perform certain database operations using two or more concurrent sessions.

      After the upgrade, you notice that the performance of ETL jobs has degraded. To ascertain the cause of performance degradation, you want tocollect basic statistics such as the level of parallelism, total database time, and the number of I/O requests for the ETL jobs.

      How do you accomplish this?

      1. Examine the Active Session History (ASH) reports for the time period of the ETL or batch reporting runs.

      2. Enable SQL tracing for the queries in the ETL and batch reporting queries and gather diagnostic data from the trace file.

      3. Enable real-time SQL monitoring for ETL jobs and gather diagnostic data from the V$SQL_MONITOR view.

      4. Enable real-time database operation monitoring using the DBMS_SQL_MONITOR.BEGIN_OPERATION function, and then use the DBMS_SQL_MONITOR.REPORT_SQL_MONITOR function to view the required

      information.

      Answer: D Explanation:

    • Monitoring database operations

    Real-Time Database Operations Monitoring enables you to monitor long running database tasks such as batch jobs, scheduler jobs, and Extraction, Transformation, and Loading (ETL) jobs as a composite business operation. This feature tracks the progress of SQL and PL/SQL queries associated with the business operation being monitored. As a DBA or developer, you can define business operations for monitoring by explicitly specifying the start and end of the operation or implicitly with tags that identify the operation.

    Question No: 146

    In which situations does the Database Writer process (DBWn) write to data files?

    1. when the RMAN recovery process starts

    2. when a user process commits a transaction

    3. when a tablespace is made read-only or taken offline

    4. when PMON cleans up dirty buffers in the database buffer cache

    5. when clean buffers for reading new blocks into the database buffer cache are not found easily

    Answer: D

    Question No: 147

    Which Oracle Database component is audited by default if the unified Auditing option is enabled?

    1. Oracle Data Pump

    2. Oracle Recovery Manager (RMAN)

    3. Oracle Label Security

    4. Oracle Database Vault

    5. Oracle Real Application Security

    Answer: B

    Question No: 148

    What should you do to ensure that a job stored minimal job metadata and runtime data on disk, and uses only existing PL/SQL programs?

    1. Create an event-based job.

    2. Create a lightweight job.

    3. Specify the job as amember of a job class.

    4. Use a job array.

    Answer: B Explanation: References:

    https://docs.oracle.com/cd/B28359_01/server.111/b28310/schedover004.htm#BGBJGHBH

    Question No: 149

    Which two statements are true about the logical storage structure of an Oracle database?

    1. An extent contains data blocks that are always physically contiguous on disk.

    2. An extent can span multiple segments.

    3. Each data block always corresponds to one operating system block.

    4. It is possible to have tablespaces of different block sizes.

    5. A data block is the smallest unit of I/O in data files.

    Answer: B,D Explanation: References:

    Question No: 150

    Examine the commands executed to monitor database operations:

    $gt; conn sys oracle/oracle@prod as sysdba SQL gt; VAR eid NUMBER

    SQL gt;EXEC: eid := DBMS_SQL_MONITOR.BEGIN_OPERATION (‘batch_job’ , FORCED_TRACKING =gt; ‘Y’);

    Which two statements are true?

    1. Database operations will be monitored only when they consume a significant amount of resource.

    2. Database operations for all sessions will be monitored.

    3. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC TUNING.

    4. Only DML and DDL statements will be monitored for the session.

    5. All subsequent statements in the session will be treated as one database operation and will be monitored.

    Answer: C,E Explanation:

    C: Setting the CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter to DIAGNOSTIC TUNING (default) enables monitoring of database operations. Real-Time SQL Monitoring is a feature of the Oracle Database Tuning Pack.

    Note:

    * The DBMS_SQL_MONITOR package provides information about Real-time SQL Monitoring and Real-time Database Operation Monitoring.

    *(not B) BEGIN_OPERATION Function

    starts a composite database operation in the current session.

    / (E) FORCE_TRACKING – forces the composite database operation to be tracked when the operation starts. You can also use the string variable #39;Y#39;.

    / (not A) NO_FORCE_TRACKING – the operation will be tracked only when it has consumed at least 5 seconds of CPU or I/O time. You can also use the string variable #39;N#39;.

    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 *