[Free] 2018(Jan) EnsurePass Testinsides Oracle 1z0-052 Dumps with VCE and PDF 11-20

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-052
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: Administration I

Question No: 11 – (Topic 1)

You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time. How would you achieve this?

  1. Lock statistics for the tables.

  2. Change STALE_PERCENT to zero for the tables.

  3. Set the TIMED_STATISTICS parameter to TRUE.

  4. Set the STATISTICS_LEVEL parameter to BASIC.

  5. Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

Answer: A Explanation:

Statistics are collections of data that provide more details about the database and the objects in it. Optimizer statistics are used by the query optimizer to choose the best execution plan for each SQL statement. Database statistics provide information for performance monitoring.

Question No: 12 – (Topic 1)

You executed the following command to perform a backup of the USERS tablespace:



ERROR at line 1:

ORA-01123: cannot start online backup; media recovery not enabled What could be the reason for this error?

  1. The MTTR Advisor is disabled.

  2. The database is in NOARCHIVELOG mode.

  3. The tablespace is already in backup mode.

  4. The Flash Recovery Area is not configured.

Answer: B

Question No: 13 – (Topic 1)

You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be inserted as part of the same transaction.

View the Exhibit to examine the commands used to create tables.

Which action would you take to delay the referential integrity checking until the end of the transaction?


Ensurepass 2018 PDF and VCE

  1. Set the constraint to deferred before starting the transaction

  2. Alter the constraint to NOVALIDATE state before starting the transaction

  3. Enable the resumable mode for the session before starting the transaction

  4. Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction

Answer: A Explanation:

Specifying Constraint State

As part of constraint definition, you can specify how and when Oracle should enforce the constraint.

constraint_state You can use the constraint_state with both inline and out-of-line specification. You can specify the clauses of constraint_state in any order, but you can specify each clause only once.

DEFERRABLE Clause The DEFERRABLE and NOT DEFERRABLE parameters indicate whether or not, in subsequent transactions, constraint checking can be deferred until the end of the transaction using the SET CONSTRAINT(S) statement. If you omit this clause, then the default is NOT DEFERRABLE.

Specify NOT DEFERRABLE to indicate that in subsequent transactions you cannot use the SET

CONSTRAINT[S] clause to defer checking of this constraint until the transaction is committed. The checking of a NOT DEFERRABLE constraint can never be deferred to the end of the transaction.

If you declare a new constraint NOT DEFERRABLE, then it must be valid at the time the CREATE TABLE or ALTER TABLE statement is committed or the statement will fail.

Specify DEFERRABLE to indicate that in subsequent transactions you can use the SET CONSTRAINT[S] clause to defer checking of this constraint until after the transaction is committed. This setting in effect lets you disable the constraint temporarily while making changes to the database that might violate the constraint until all the changes are complete.

You cannot alter the deferability of a constraint. That is, whether you specify either of these parameters, or make the constraint NOT DEFERRABLE implicitly by specifying neither of them, you cannot specify this clause in an ALTER TABLE statement. You must drop the constraint and re-create it.

Question No: 14 – (Topic 1)

Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

  1. Failure when no standby database is configured

  2. Failure because a data file is renamed accidentally

  3. Failure that requires no archive logs to be applied for recovery

  4. Failure due to loss of connectivity-for example, an unplugged disk cable

Answer: B,D Explanation:

Advising on Repair

On the quot;View and Manage Failuresquot; page, the Data Recovery Advisor generates a manual checklist after you click the Advise button. Two types of failures can appear.

  • Failures that require human intervention: An example is a connectivity failure when a disk cable is not plugged in.

  • Failures that are repaired faster if you can undo a previous erroneous action: For example, if you renamed a data file by error, it is faster to rename it back to its previous name than to initiate RMAN restoration from backup.

    You can initiate the following actions:

  • Click quot;Re-assess Failuresquot; after you perform a manual repair. Resolved failures are implicitly closed; any remaining failures are displayed on the quot;View and Manage Failuresquot; page.

  • Click quot;Continue with Advisequot; to initiate an automated repair. When the Data Recovery Advisor generates an automated repair option, it generates a script that shows how RMAN plans to repair the failure. Click Continue if you want to execute the automated repair. If you do not want the Data Recovery Advisor to automatically repair the failure, you can use this script as a starting point for your manual repair.

    Question No: 15 – (Topic 1)

    In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.

    What is the impact of this setting?

    1. Optimizer statistics are collected automatically.

    2. Only timed operating system (OS) statistics and plan execution statistics are collected.

    3. The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.

    4. Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.

    5. The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

    Answer: C

    Question No: 16 – (Topic 1)

    Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)

    1. An SPFILE is a binary file

    2. An SPFILE cannot reside on a client

    3. An SPFILE cannot contain static parameters

    4. An SPFILE can store changes persistently across instance restarts

    5. An SPFILE can be read by the database server, but it is not written to by the server

    6. An SPFILE must be created manually, before creating a database, even if you use the Database Configuration Assistant (DBCA) to create the database

    Answer: A,B,D

    Question No: 17 – (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

    Question No: 18 – (Topic 1)

    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: 19 – (Topic 1)

    Your database is open and the LISTENER listener is running. The new DBA of the system stops the listener by using the command: LSNRCTLgt; STOP

    What happens to the sessions that are presently connected to the database instance?

    1. The sessions are able to perform only queries

    2. The sessions are not affected and continue to function normally

    3. The sessions are terminated and the active transactions are rolled back

    4. The sessions are not allowed to perform any operations till the listener is started

    Answer: B

    Question No: 20 – (Topic 1)

    The HR user creates a stand-alone procedure as follows and grants the EXECUTE privilege on the procedure to many database users:

    CREATE OR REPLACE PROCEDURE create_dept ( v_deptno NUMBER, v_dname VARCHAR2, v_mgr NUMBER, v_loc NUMBER)


    INSERT INTO hr.departments VALUES (v_deptno, v_dname, v_mgr, v_loc); END;

    The users having permission to execute the procedure are able to insert records into the DEPARTMENTS table even though they do not have the INSERT privilege on the table. You want only those users who have privileges on the DEPARTMENTS table to be able to execute the procedure successfully.

    What would you suggest to the PL/SQL developers to achieve this?

    1. Create the procedure with definer#39;s right.

    2. Create the procedure with invoker#39;s right.

    3. Grant the EXECUTE privilege with GRANT OPTION on the procedure to selected users.

    4. Create the procedure as part of a PL/SQL package and grant the EXECUTE privilege on the package to selected users.

    Answer: B

    100% Ensurepass Free Download!
    Download Free Demo:1z0-052 Demo PDF
    100% Ensurepass Free Guaranteed!
    1z0-052 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.