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

Latesttests 2018 Jan Oracle Official New Released 1z0-052
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-052.html

Oracle Database 11g: Administration I

Question No: 21 – (Topic 1)

Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance.

What would be your next step to improve performance?

  1. Run the SQL Access Advisor

  2. Run the memory Advisor for the SGA

  3. Run the memory Advisor for the PGA

  4. Run the memory advisor for the shared pool

  5. Run the memory advisor for the buffer cache

Answer: D Explanation:

Using the Memory Advisor through OEM

The Memory Advisor can be used only when the automatic memory management (AMM) feature is disabled. The Memory Advisor has three advisors that give recommendations on: the Shared Pool in the SGA, the Buffer Cache in the SGA, and the PGA.

Question No: 22 – (Topic 1)

You execute this command to drop the ITEM table, which has the primary key referred in the ORDERS table:

SQLgt; DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;

Which two statements are true about the effect of the command? (Choose two.)

  1. No flashback is possible to bring back the ITEM table

  2. The ORDERS table is dropped along with the ITEM table

  3. The dependent referential integrity constraints in the ORDERS table are disabled

  4. The dependent referential integrity constraints in the ORDERS table are removed

  5. The table definition of the ITEM table and associated indexes are placed in the recycle bin

    Answer: A,D

    Question No: 23 – (Topic 1)

    Note the following structures in your database server:

    1. Extents

    2. OS Blocks

    3. Tablespace

    4. Segments

    5. Oracle Data Block

      Which option has the correct arrangement of these structures from the smallest to the largest?

      A. 2, 5, 1, 4, 3

      B. 1, 2, 3, 4, 5

      C. 5, 2, 1, 3, 4

      D. 2, 1, 5, 4, 3

      Answer: A

      Question No: 24 – (Topic 1)

      In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?

      1. When the data file of the undo tablespace is autoextensible

      2. When there are more than one undo tablespace available in the database

      3. When the undo tablespace is of a fixed size and retention guarantee is not enabled

      4. When the undo tablespace is autoextensible and retention guarantee is not enabled

Answer: C

Question No: 25 – (Topic 1)

Which two statements are true regarding Oracle Data Pump? (Choose two.)

  1. EXPDP and IMPDP are the client components of Oracle Data Pump

  2. DBMS_DATAPUMP PL/SQL packages can be used indedendently of the DATA Pump clients

  3. Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege

  4. Oracle Data Pump imports can be done from the export files generated in the Original Export Release 9.x

  5. EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands

Answer: A,B

Question No: 26 – (Topic 1)

Which two statements are true about alerts? (Choose two.)

  1. Clearing an alert sends the alert to the alert history

  2. Response actions cannot be specified with server-generated alerts

  3. The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view

  4. Server-generated alerts notify the problems that cannot be resolved automatically and require administrators to be notified

Answer: A,D

Question No: 27 – (Topic 1)

You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sunday to tape:

Which two statements are true about differential incremental backups? (Choose two.)

  1. The backup performed on Sundays contains all the blocks that have ever been used in the database

  2. The backup performed on Sundays contains all the blocks that have changed since the last level 1 backup

  3. The backup performed on each working day contains all the blocks that have changed since the last level 0 backup

  4. The backup performed on Monday contains all the blocks that have changed since the level 0 backup and every other working day contains all the blocks that have changed since the level 1 backup

Answer: A,D

Question No: 28 – (Topic 1)

SQLgt; AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;

What is the effect of this command?

  1. One audit record is created for every successful DROP TABLE command executed in the session of SCOTT

  2. One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users

  3. One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session

  4. One audit record is created for every session of any other user in which a table owned by SCOTT is dropped successfully

  5. One audit record is created for every successful DROP TABLE command executed by any user to drop tables owned by SCOTT

Answer: C

Question No: 29 – (Topic 1)

View the Exhibit to examine the error that occurred during the database startup.

Latesttests 2018 PDF and VCE

You opened an RMAN session for the database. To repair the failure, you executed the following command as the first RMAN command:

RMANgt; REPAIR FAILURE;

Which statement describes the consequence of this command?

  1. The command performs the recovery and closes the failure

  2. The command only displays the advice and the RMAN script required for recovery

  3. The command executes the RMAN script to repair the failure and remove the entry from the Automatic

    Diagnostic Repository (ADR)

  4. The command produces an error because the ADVISE FAILURE command was not executed before the REPAIR FAILURE command

Answer: D

Question No: 30 – (Topic 1)

You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this.

Which data types would you use for the new column?

  1. CLOB

  2. BLOB

  3. BFILE

  4. LONG RAW

    Answer: C

    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