[Free] 2018(Jan) Dumps4cert Braindumps Oracle 1z0-052 Dumps with VCE and PDF 51-60

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan Oracle Official New Released 1z0-052
100% Free Download! 100% Pass Guaranteed!
http://www.Dumps4cert.com/1z0-052.html

Oracle Database 11g: Administration I

Question No: 51 – (Topic 1)

Your database instance is running with full workload after database creation. You have decided to use a fixedsize undo tablespace. You want to use the undo Advisor to estimate the capacity of the undo tablespace.

Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undo tablespace? (Choose two.)

  1. The retention period to support flashback

  2. The expected length of the longest-running query

  3. The number of undo tablespaces in the database

  4. The size of the Flash Recovery Area for the database instance

Answer: A,B

Question No: 52 – (Topic 1)

Examine the command:

SQLgt;ALTER USR skd ACCOUNT LOCK;

Which two statements are true after the command is executed? (Choose two.)

  1. The SKD user cannot log in to the database instance

  2. The objects owned by the SKD user are not accessible to any user

  3. The other users can access the objects owned by the SKD user, on which they have access

  4. The password for the SKD user expires and the user is forced to change the password at the next log in

Answer: A,C

Question No: 53 – (Topic 1)

The instance abnormally terminates because of a power outage.

Which statement is true about redo log files during instance recovery?

  1. Inactive and current redo log files are required to accomplish recovery

  2. Online and archived redo files are required to accomplish instance recovery

  3. All redo log entries after the last checkpoint are applied from redo log files to data files

  4. All redo log entries recorded in the current log file until the checkpoint position are applied to data files

Answer: C

Question No: 54 – (Topic 1)

Which two statements are true about Shared SQL Area and Private SQL Area? (Choose two.)

  1. Shared SQL Area will be allocated in the shared pool

  2. Shared SQL Area will be allocated when a session starts

  3. Shared SQL Area will be allocated in the large pool always

  4. The whole of Private SQL Area will be allocated in the Program Global Area (PGA) always

  5. Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool

  6. The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter

Answer: A,F

Question No: 55 – (Topic 1)

SQLgt; CREATE BIGFILE TABLESPACE MRKT

  1. DATAFILE #39;/u01/app/oracle/oradata/orcl/mrkt.dbf#39; size 10M LOGGING

  2. EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

Tablespace created.

SQLgt; ALTER DATABASE DEFAULT TABLESPACE MRKT;

Database altered.

Which two statements are true regarding the MRKT tablespace? (Choose two.)

  1. No more data files can be added to the tablespace.

  2. Segment space is managed by free lists in the tablespace.

  3. A user created without being assigned a default tablespace uses this tablespace.

  4. The tablespace can be dropped with the current setting with segments present in it.

Answer: A,C

Question No: 56 – (Topic 1)

Examine the values for the following initialization parameters:

FAST_START_MTTR_TARGET=0 LOG_CHECKPOINT_INTERVAL=0

Which two will be the implications of these values in your database? (Choose two.)

  1. The SGA advisor will be disabled

  2. The MTTR advisor will be disabled

  3. Automatic checkpoint tuning will be disabled

  4. Checkpoint information will not be written to the alert log file

Answer: B,C

Question No: 57 – (Topic 1)

View the Exhibit and examine the privileges granted to the SL_REP user.

Dumps4Cert 2018 PDF and VCE

The EMP table is owned by the SCOTT user. The SL_REP user executes the following command: SQLgt; GRANT SELECT ON scott.emp TO hr;

Which statement describes the outcome of the command?

  1. The command executes successfully

  2. The command produces an error because the EMP table is owned by SCOTT

  3. The command produces an error because SL_REP has the GRANT ANY OBJECT PRIVILEGE without ADMIN_OPTION

  4. The command produces an error because SL_REP does not have the SELECT privilege with

GRANT_OPTION on the EMP table

Answer: A

Question No: 58 – (Topic 1)

You want to move all objects of the APPS user in the test database to the DB_USR schema of the production database. Which option of IMPDP would you use to accomplish this task?

  1. FULL

  2. SCHEMAS

  3. TRANSFORM

  4. REMAP_SCHEMA

  5. REMAP_TABLESPACE

    Answer: D

    Question No: 59 – (Topic 1)

    You want to enable archiving on your database. Presently, the database is running in NOARCHIVELOG mode.

    Given below are the steps to accomplish the task in random order:

    1. Shut down the instance.

    2. Execute the ALTER DATABASE ARCHIVELOG command.

    3. Start up the instance and mount the database.

    4. Set the DB_RECOVERY_FILE_DEST initialization parameter to

      $ORACLE_HOME/dest_1.

    5. Open the database.

Which is the correct sequence of steps for accomplishing the task?

A. 4, 1, 3, 2, 5

B. 1, 3, 4, 5, 2

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

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

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

Answer: C

Question No: 60 – (Topic 1)

You have recently collected statistics on certain objects of a schema in your database. But you observe suboptimal execution plans for the queries on these objects after two days of statistics collection. The optimizer statistics retention period is set to its default value.

Which action would help to use the previous set of statistics on the objects?

  1. Restore statistics from statistics history.

  2. Reduce the optimizer statistics retention period by 2 days.

  3. Set the OPTIMIZER_PENDING_STATISTICS parameter to TRUE.

  4. Reduce the Automatic Workload Repository (AWR) retention period by 2 days.

Answer: A

100% Dumps4cert Free Download!
Download Free Demo:1z0-052 Demo PDF
100% Dumps4cert Free Guaranteed!
1z0-052 Dumps

Dumps4cert 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.