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

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

Oracle Database 11g: Administration I

Question No: 71 – (Topic 2)

Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine?

  1. Host naming method

  2. Local naming method

  3. External naming method

  4. Directory naming method

Answer: B Explanation:

Database Configuration Options Your installation process continues:

  1. Navigate through the OUI pages and specify your database configuration options. OUI displays a summary of your installation choices.

  2. Click Install to begin your installation of the Oracle software.

If you chose to create a starter database as part of the installation, OUI invokes all of these configuration assistants:

  • Oracle Net Configuration Assistant: This configures basic network components during installation including:

    • Listener names and protocol addresses

    • Naming methods that the client will use to resolve connect identifiers to connect descriptors

    • Net service names in a tnsnames.ora file

    • Directory server usage

  • Oracle Database Configuration Assistant (DBCA): This creates the starter database that you selected. When this configuration assistant finishes, you can unlock accounts and change passwords.

    Question No: 72 – (Topic 2)

    You are working on a new Oracle Database 11g server, where only the software is installed and no database is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA).

    Some of the requirements set for your database creation task are:

    1. Configure the database to operate in shared server mode.

    2. Disable automatic maintenance tasks such as optimizer statistics collection.

    3. Configure a naming method to help the remote user connect to the database instance.

    4. Use Automatic Storage Management (ASM) for storing the database files.

    5. Configure daily database backup to flash recovery area.

    6. Configure Enterprise Manager Database Control to manage the database. Which of these requirements can be met while creating the database?

      1. 4 and 6

    B. 2, 3, 4, and 6

    C. 1, 2, 4, 5, and 6

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

    Answer: C

    Question No: 73 – (Topic 2)

    View the Exhibit1, which shows the options that are selected to create the user SL_REP. View the Exhibit2 and examine the contents of DATABASE_PROPERTIES.

    Latesttests 2018 PDF and VCE

    Which two statements are true regarding this user? (Choose two.) Exhibit1 (exhibit):

    Exhibit2 (exhibit):

    Latesttests 2018 PDF and VCE

    1. The user is authenticated by the operating system.

    2. The objects created by the user are placed in the USERS tablespace.

    3. The user does not require quota on the TEMP tablespace to perform sort operations.

    4. The user is forced to change the password at the first login to the database instance.

    5. The objects created by the user in future are unlocked to be accessed by all the users in the database by default.

    Answer: B,C

    Question No: 74 – (Topic 2)

    You have executed this command to change the size of the database buffer cache:


    System altered.

    To verify the change in size, you executed this command:

    Latesttests 2018 PDF and VCE

    Why is the value set to 4194304 and not to 2516582?

    1. Because 4194304 is the granule size

    2. Because 4194304 is the standard block size

    3. Because 4194304 is the largest nonstandard block size defined in the database

    4. Because 4194304 is the total size of data already available in the database buffer cache

    Answer: A Explanation:

    Regardless of whether you are using automatic or manual memory management, you#39;ll find that memory is allocated to the various pools in the SGA in units called granules. A single granule is an area of memory of 4MB, 8MB, or 16MB in size. The granule is the smallest unit of allocation, so if you ask for a lava pool of 5MB and your granule size is 4MB. Oracle will actually allocate 8MB to the lava pool (8 being the smallest number greater than or equal to 5 that is a multiple of the granule size of 4). The size of a granule is determined by the size of your SGA (this sounds recursive to a degree, as the size of the SGA is dependent on the granule size). Vim can view the granule sizes used for each pool by querying V$SGA_DYNAMIC_COMPONENTS. In fact, we can use this view to see how the total SGA size might affect the size of the granules:

    Question No: 75 – (Topic 2)

    The TRANS_SUMMARY table contains product-wise transaction details that get updated with every transaction in the system. Each row has cumulative transaction details of a single product and every product is identified by a product code, which is the primary key.

    As part of the archival process, the company wants to transfer the rows in the TRANS_SUMMARY table to the TRANS_SUMMARY_DUP table at the end of every quarter of the year. Along with existing products, the company deals with many new products during every quarter.

    Which method is best suited for this quarterly data transfer?

    1. Using the MERGE command

    2. Using the SQL*Loader utility

    3. Using the correlated UPDATE command

    4. Using the INSERT command to perform bulk operation

    Answer: A

    Question No: 76 – (Topic 2)

    Which statement is true about a whole consistent database backup on a database running in

    ARCHIVELOG mode?


    Latesttests 2018 PDF and VCE

    1. The backup will consist of used data blocks only.

    2. The database must be shut down to accomplish the backup.

    3. The backup can be accomplished without shutting down the database.

    4. The backup will contain all database files that have never been backed up.

    Answer: B

    Question No: 77 – (Topic 2)

    You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance, you plan to move the data from the flat files to clustered tables in an Oracle database. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into the Oracle database?

    1. Use the external table population.

    2. Use the Oracle Data Pump export and import utility.

    3. Use the conventional path data load of the SQL*Loader utility.

    4. Use the INSERT INTO…SELECT command to load the data.

    Answer: C

    Question No: 78 – (Topic 2)

    Which three operations require undo data? (Choose three.)

    1. Committing a transaction

    2. Flashing back a transaction

    3. Recovering a failed transaction

    4. Running a read-consistent query

    5. Changing a tablespace status from READ ONLY to READ WRITE

    Answer: B,C,D Explanation:

    Module 10 – Managing Undo Data Objectives

    These notes teach you about managing undo data including the method used to implement automatic undo data management. You will also learn to create and modify undo segments and how to query the data dictionary to retrieve undo segment information.

  • Beginning with Release 11 g, for a default installation, Oracle Database automatically manages undo.

    There is typically no need for DBA intervention.

  • If your installation uses Oracle Flashback operations, you may need to perform some undo management tasks to ensure the success of these operations.

    Undo Purpose

    Undo records are used to:

  • Roll back transactions when a ROLLBACK statement is issued

  • Recover the database

  • Provide read consistency

  • Analyze data as of an earlier point in time by using Oracle Flashback Query

  • Recover from logical corruptions using Oracle Flashback features

    Question No: 79 – (Topic 2)

    Which two statements are true regarding undo tablespaces? (Choose two.)

    1. The database can have more than one undo tablespace

    2. The UNDO_TABLESPACE parameter is valid in both automatic and manual undo management

    3. Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions

    4. An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up

    Answer: A,C

    Question No: 80 – (Topic 2)

    Observe the information in the columns:

    Latesttests 2018 PDF and VCE

    Which option has the correct match between the memory areas and their contents?

    A. 1-c, 2-b, 3-d, 4-a

    B. 1-b, 2-c, 3-d, 4-a

    C. 1-a, 2-b, 3-c, 4-d

    D. 1-a, 2-b, 3-d, 4-c

    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