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

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: 121 – (Topic 2)

Which statement is true about loading data using the conventional path of SQL*Loader?

  1. Redo is not generated while performing conventional path loads

  2. Only PRIMARY KEY, UNIQUE KEY and NOT NULL constraints are checked

  3. No exclusive locks are acquired when the conventional path loads are performed

  4. Instead of performing transactions, SQL*Loader directly writes data blocks to the data files

  5. INSERT triggers are disabled before the conventional path load and reenabled at the end of the load

    Answer: C

    Question No: 122 – (Topic 2)

    You used the IMMEDIATE option to shutdown your database instance. Consider the steps that will be performed later when you open the database:

    1. SGA is allocated.

    2. Control file is read.

    3. Redo log files are read.

    4. Instance recovery is started.

    5. Background processes are started.

    6. Data files are checked for consistency.

    7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur? A. 7, 1, 5, 2, 3, 6, 4

  1. 1, 5, 7, 2, 3, 6; step 4 is not required

  2. 7, 1, 5, 2, 3, 6 step 4 is not required

  3. 1, 2, 3, 5, 6, 4; step 7 is not required

Answer: C

Question No: 123 – (Topic 2)

View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has experienced workloads of different capacities:

SQLgt; SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_components

WHERE current_size!=0;

What do you infer from this? Exhibit:

Latesttests 2018 PDF and VCE

  1. The database instance is running with manual PGA management.

  2. The database instance is running with manual shared memory management.

  3. The database instance has the MEMORY_TARGET value set to a nonzero value.

  4. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.

Answer: C

Explanation:

MEMORY_TARGET specifies the Oracle system-wide usable memory. The database tunes memory to the MEMORY_TARGET value, reducing or enlarging the SGA and PGA as needed.

In a text-based initialization parameter file, if you omit MEMORY_MAX_TARGET and include a value for MEMORY_TARGET, then the database automatically sets MEMORY_MAX_TARGET to the value of MEMORY_TARGET. If you omit the line for MEMORY_TARGET and include a value for MEMORY_MAX_TARGET, the MEMORY_TARGET parameter defaults to zero. After startup, you can then dynamically change MEMORY_TARGET to a nonzero value, provided that it does not exceed the value of MEMORY_MAX_TARGET.

Question No: 124 – (Topic 2)

You are in the middle of a transaction updating a very important table. The machine on which a database was running reboots because of power outage. This caused a database instance failure.

Which statement is true in this situation?

  1. The online redo log files and archived redo log files are required to accomplish the recovery

  2. The uncommitted transaction will be committed at the next startup of the database instance

  3. The uncommitted transaction is rolled back automatically at the next opening of the database

  4. The DBA has to perform the recovery on the database to recover the uncommitted transaction

Answer: C

Question No: 125 – (Topic 2)

Which statement is true about the UNDO_RETENTION parameter when retention guarantee is not enabled?

  1. It is the time period after which the undo data becomes obsolete.

  2. It is the time period after which the committed undo data would be transferred to a temporary tablespace.

  3. It is the minimum time period up to which the committed undo data would be retained if free undo space is available.

  4. It is the time period after which the undo data is transferred to the Flash Recovery Area to provide read consistency.

    Answer: C

    Question No: 126 – (Topic 2)

    You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the steps that will be performed later when you open the database:

    1. SGA is allocated.

    2. Control file is read.

    3. Redo log files are opened.

    4. Instance recovery is started.

    5. Background processes are started.

    6. Data file headers are checked for consistency.

    7. Server parameter file or the initialization parameter file is read. Which option has the correct order in which these steps occur?

      A. 7, 1, 5, 2, 3, 6, 4

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

      C. 7, 1, 4, 5, 2, 3, 6

      D. 1, 7, 5, 4, 2, 3, 6

      Answer: A

      Question No: 127 – (Topic 2)

      You are using Enterprise Manager to schedule backups for your database.

      Which type of script would be generated by the backup scheduler?

      1. XML script

      2. PL/SQL script

      3. Operating system script

      4. Recovery Manager (RMAN) script

Answer: D Explanation:

  • Recovery Manager (RMAN): Oracle tool that provides a complete solution for the backup, restoration, and recovery needs of the entire database or of specific database files.

  • Question No: 128 – (Topic 2)

    Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee:

    SQLgt; ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;

    What affect would this command have on the database?

    1. The extents in the undo tablespace retain data until the next full database backup

    2. The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes

    3. The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down

    4. The extents containing committed undo in the undo tablepace are transferred to Flash Recovery Area before being overwritten

    Answer: B

    Question No: 129 – (Topic 2)

    View the Exhibit and examine the user information.

    The user has been granted CONNECT and RESOURCE roles and no individual system privileges. The SL_REP user executes this command to create a table:

    SQLgt; CREATE TABLE orders (

    oid number(6), odate date, ccode number(4),

    oamt number(10,2)

    ) TABLESPACE purchase_space;

    The PURCHASE_SPACE tablespace already exists in the database. Which statement describes the effect of the command?

    Exhibit:

    Latesttests 2018 PDF and VCE

    1. The command executes successfully and creates the table in the USERS tablespace.

    2. The command executes successfully and creates the table in the PURCHASE_SPACE tablespace.

    3. The command produces an error because the user does not have the privilege to createthe table.

    4. The command produces an error because the user does not have quota in the PURCHASE_SPACE tablespace.

    Answer: B

    Question No: 130 – (Topic 2)

    You are installing Oracle Database 11g on a machine. When you run the installer, the Universal Installer (OUI) shows the message that says one of the product-specific prerequisite checks has failed:

    Checking available swap space requirements … Expected result: 1512MB

    Actual Result: 1018MB

    Check complete. The overall result of this check is: Failed lt;lt;lt;lt; Problem: The system does not have the required swap space.

    What happens to the installation in this situation?

    1. It can be continued.

    2. It resizes the swap space automatically when you proceed further.

    3. It can be continued, but the instance cannot be started without increasing the swap space.

    4. It shows a message saying one or more prerequisite checks have failed and the installation cannot proceed.

      Answer: A

      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