[Free] 2018(Jan) EnsurePass Pass4sure Oracle 1z0-052 Dumps with VCE and PDF 101-110

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

Oracle Database 11g: Administration I

Question No: 101 – (Topic 2)

In which situation would you use static database registration for a listener?

  1. When multiple databases are to be registered with the listener

  2. When DBAs need to connect remotely to start up the database instance

  3. When users need to connect the database instance using the host naming method

  4. When the database instance that is to be registered with the listener is configured in shared server mode

Answer: B

Question No: 102 – (Topic 2)

A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLE command with the ENABLE VALIDATE option to enable the constraint that was disabled.

What are the two effects of this command? (Choose two.)

  1. It fails if any existing row violates the constraint.

  2. It does not validate the existing data in the table.

  3. It enables the constraint to be enforced at the end of each transaction.

  4. It prevents insert, update, and delete operations on the table while the constraint is in the process of being enabled.

Answer: A,D Explanation:

  • Specify ENABLE if you want the constraint to be applied to the data in the table.

  • ENABLE VALIDATE specifies that all old and new data also complies with the constraint. An enabled validated constraint guarantees that all data is and will continue to be valid (not B).

    If any row in the table violates the integrity constraint, the constraint remains disabled and Oracle returns an error (A). If all rows comply with the constraint, Oracle enables the constraint. Subsequently, if new data violates the constraint, Oracle does not execute the statement and returns an error indicating the integrity constraint violation.

    Note:

  • Specify INITIALLY IMMEDIATE to indicate that Oracle should check this constraint at the end of each subsequent SQL statement.

Incorrect:

Not C: Specify INITIALLY DEFERRED to indicate that Oracle should check this constraint at the end of subsequent transactions.

Question No: 103 – (Topic 2)

Your database instance is started using the server parameter file (SPFILE). You executed a command to change the value of the LOG_BUFFER initialization parameter:

ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH;

What would be the outcome of this command?

  1. The command succeeds only if Automatic Memory Management is not enabled.

  2. The command succeeds, but you need to restart the database for changes to take effect.

  3. The command returns an error because the size of the redo log buffer cannot be changed dynamically.

  4. The parameter value is changed and it comes into effect as soon as space becomes available in the System Global Area (SGA).

Answer: C

Question No: 104 – (Topic 2)

You are managing an Oracle Database 11g database. You want to ensure the recovery of the database to the point of failure. Which configuration will you do to accomplish the task?

  1. Multiplex all database files.

  2. Configure the Flash Recovery Area.

  3. Configure the database instance for ARCHIVELOG mode.

  4. Configure the FAST_START_MTTR_TARGET initialization parameter.

Answer: C

Question No: 105 – (Topic 2)

Which three statements are correct about temporary tables? (Choose three.)

  1. Indexes and views can be created on temporary tables.

  2. Both the data and the structure of temporary tables can be exported.

  3. Temporary tables are always created in a user#39;s temporary tablespace.

  4. The data inserted into a temporary table in a session is available to other sessions.

  5. Data manipulation language (DML) locks are never acquired on the data of temporary tables.

Answer: A,C,E

Question No: 106 – (Topic 2)

While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance. Which option would you use to reduce

fragmentation without affecting the users who are currently using the index?

  1. Validate the index structure using the ANALYZE …. INDEX command

  2. Rebuild the index using the ALTER INDEX ….. REBUILD ONLINE command

  3. Change the block space utilization parameters using the ALTER INDEX command

  4. Deallocate the unused space in the index using the ALTER INDEX … DEALLOCATE UNUSED command

    Answer: B

    Question No: 107 – (Topic 2)

    In your database instance, the user sessions are connected to the database server from the remote machines. You want to achieve the following for these users:

    1. The user account must be locked after four unsuccessful login attempts.

    2. The user must be prompted to change the password at regular intervals.

    3. The user may not have more than three simultaneous sessions.

    4. The user session must automatically be logged off if more than 10 minutes elapsed time used.

      How would you accomplish the above?

      1. By assigning profiles for the users

      2. By implementing Fine-Grained Auditing (FGA)

      3. By granting a secure application role to the users

      4. By implementing the Database Resource Manager plan

Answer: A

Question No: 108 – (Topic 2)

See the Exhibit to observe the roles assigned to the SL_REP user.

Ensurepass 2018 PDF and VCE

Which statement is true about the assignment of the SELECT_CATALOG_ROLE role to the SL_REP user?

  1. The user must enable the role explicitly

  2. The user can grant the role to other users

  3. The user cannot user the role until the DBA enables it explicitly

  4. The user can start using the role immediately without any changes

Answer: A

Question No: 109 – (Topic 2)

You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating system group name.

Which statement is true in this case?

  1. The ORACLE_BASE parameter is not set.

  2. The installation is being performed by the root user.

  3. The operating system group that will be specified should have root user as its member.

  4. The installation is being performed without the quot;Create Starter Databasequot; option selected.

  5. The operating system group that will be specified must have permission to write to the inventory directory.

    Answer: E

    Question No: 110 – (Topic 2)

    The database instance is currently using SPFILE. View the Exhibit and examine the error that you received while running the DB Structure Integrity check. Given below are the steps to recover from the error in random order:

    1. Shut down the instance, if not already done.

    2. Copy one of the remaining control files to a new location.

    3. Change the value of the CONTROL_FILES initialization parameter to correspond to the new location of the control files.

    4. Start up the database instance to the NOMOUNT stage.

    5. Recover the database to the point of failure of the control file.

    6. Open the database.

Identify the correct sequence of steps? Exhibit:

Ensurepass 2018 PDF and VCE

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

  1. 2, 4, 3, 5, 6; 1 not required

  2. 4, 5, 6, 2, 3; 1 not required

  3. 5, 2, 3, 4; 1 and 6 not required

Answer: A

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.