web analytics

100% Pass Guarantee PassLeader 1Z0-052 Dumps with VCE and PDF for Free (Question 41 – Question 60)

PassLeader now are offering 100% pass ensure 1Z0-052 dumps! All 1Z0-052 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-052 VCE dumps and PDF dumps: http://www.passleader.com/1z0-052.html (261 Q&As)

BTW: Download PassLeader 1Z0-052 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpaXlIQVBWWmRoa1U

QUESTION 41
Which two operations can be performed on an external table? (Choose two.)

A.    Create a view on the table
B.    Create an index on the table
C.    Create a synonym on the table
D.    Add a virtual column to the table
E.    Update the table using the UPDATE statement
F.    Delete rows in the table using the DELETE command

Answer: AC

QUESTION 42
Which two statements are true regarding listeners? (Choose two.)

A.    Listeners use only the TCP/IP protocol.
B.    Multiple listener processes can run simultaneously on a host.
C.    Multiple database instances can be registered with a single listener.
D.    The listener-related errors can be traced only at the administrative level.
E.    Only one database instance can be registered with a single listener at any time.

Answer: BC

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

A.    Indexes and views can be created on temporary tables.
B.    Both the data and the structure of temporary tables can be exported.
C.    Temporary tables are always created in a user’s temporary tablespace.
D.    The data inserted into a temporary table in a session is available to other sessions.
E.    Data manipulation language (DML) locks are never acquired on the data of temporary tables.

Answer: ACE

QUESTION 44
You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=500M
PGA_AGGREGATE_TARGET=90M
SGA_TARGET=270M
Which two statements are true about these parameters after the database instance is restarted? (Choose two.)

A.    The MEMORY_MAX_TARGET parameter is automatically set to 500MB.
B.    The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
C.    The value of the MEMORY_MAX_TARGET parameter remains zero until it is changed manually.
D.    The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90MB and 270 MB, respectively.

Answer: AD

QUESTION 45
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 46
A user, who is authenticated externally, logs in to a remote machine and connects to the database instance. What action would you take to ensure that a user cannot connect to the database instance by merely logging in to a remote machine?

A.    Set REMOTE_OS_ROLES to FALSE
B.    Set OS_ROLES parameter to FALSE
C.    Set the REMOTE_OS_AUTHENT parameter to FALSE
D.    Set the REMOTE_LOGIN_PASSWORD_FILE parameter to NONE

Answer: C

QUESTION 47
Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to a nonzero value? (Choose two.)

A.    The MTTR advisor will be disabled
B.    Automatic checkpoint tuning will be enabled
C.    The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value for FAST_START_MTTR_TARGET
D.    The time taken to recover the instance after the crash is always exactly the same as the value given for the FAST_START_MTTR_TARGET initialization parameter

Answer: BC

QUESTION 48
You want to create a role to meet these requirements:
1. The role is to be protected from unauthorized usage.
2. The password of the role is not to be embedded in the application source code or stored in a table.
Which method would you use to restrict enabling of such roles?

A.    Create the role with external authentication.
B.    Create the role as a secure application role.
C.    Create the role as a password-protected role.
D.    Create a role and use Fine-Grained Access Control (FGAC) to secure the role.

Answer: B

QUESTION 49
View the Exhibit and identify the component marked with a question mark.
passleader-1Z0-052-dumps-491
A.    Checkpoint (CKPT)
B.    Process Monitor (PMON)
C.    Archiver Processes (ARcn)
D.    Recoverer Process (RECO)
E.    Memory Manager Process (MMAN)

Answer: A

QUESTION 50
Note the following points describing various utilities in Oracle Database 11g:
1. It enables the transfer of data from one database to another
2. It provides a complete solution for the backup, restoration and recovery needs of the entire database
3. It enables the loading of data from an external file into tables of an Oracle Database
4. It provides a tape backup management for the Oracle ecosystem
Which point describes the Oracle Data Pump utility?

A.    1
B.    2
C.    3
D.    4
E.    1 and 3
F.    1, 2, 3 and 4

Answer: A

QUESTION 51
Your database is configured in shared server mode. However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of the users. What could be the reason for this?

A.    To limit the User Global Area (UGA) memory allocated to a session from the SGA
B.    To limit the amount of memory to be used for the dispatcher queue of a session in SGA
C.    To limit the amount of memory to be used for the request pool in System Global Area (SGA)
D.    To control the amount of memory allocated in SGA for the local variables for each shared server process

Answer: A

QUESTION 52
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
B.    1, 5, 7, 2, 3, 6; step 4 is not required
C.    7, 1, 5, 2, 3, 6 step 4 is not required
D.    1, 2, 3, 5, 6, 4; step 7 is not required

Answer: C

QUESTION 53
Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true in this scenario?

A.    The minimum memory size for the database buffer cache is set to 100 MB.
B.    The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100 MB.
C.    The minimum memory size allocated for a server process in the database buffer cache in dedicated mode is set to 100 MB.
D.    The maximum memory size from the database buffer cache that can be released for dynamic distribution during ASMM is set to 100 MB.

Answer: A

QUESTION 54
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.)

A.    The SGA advisor will be disabled
B.    The MTTR advisor will be disabled
C.    Automatic checkpoint tuning will be disabled
D.    Checkpoint information will not be written to the alert log file

Answer: BC

QUESTION 55
View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is true about the output of the command?
passleader-1Z0-052-dumps-551

A.    The backup piece is expired as the new backup is available
B.    The backup piece is expired because the operating-system file was not found
C.    The backup piece is expired because the retention period for the backup has expired
D.    The backup piece is expired because the backup set to which it belongs is not complete

Answer: B

QUESTION 56
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:
SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;
What affect would this command have on the database?

A.    The extents in the undo tablespace retain data until the next full database backup
B.    The extents containing committed undo in the undo tablespace are not overwritten for at least 15 minutes
C.    The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down
D.    The extents containing committed undo in the undo tablepace are transferred to Flash Recovery Area before being overwritten

Answer: B

QUESTION 57
You configured the Flash Recovery Area for your database. The database instance has been started in ARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications on the archiving and the location of archive redo log files?

A.    Archiving will be disabled because the destination for the redo log files is missing
B.    The database instance will shut down and the error details will be logged in the alert log file
C.    Archiving will be enabled and the destination for the archived redo log file will be set to the Flash Recovery Area implicitly
D.    Archiving will be enabled and the location for the archive redo log file will be created in the default location $ORACLE_HOME/log

Answer: C

QUESTION 58
Which is the correct description of a pinned buffer in the database buffer cache?

A.    The buffer is currently being accessed
B.    The buffer is empty and has not been used
C.    The contents of the buffer have changed and must be flushed to the disk by the DBWn process
D.    The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk

Answer: A

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

A.    When multiple databases are to be registered with the listener
B.    When DBAs need to connect remotely to start up the database instance
C.    When users need to connect the database instance using the host naming method
D.    When the database instance that is to be registered with the listener is configured in shared server mode

Answer: B

QUESTION 60
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?

A.    Validate the index structure using the ANALYZE … INDEX command
B.    Rebuild the index using the ALTER INDEX … REBUILD ONLINE command
C.    Change the block space utilization parameters using the ALTER INDEX command
D.    Deallocate the unused space in the index using the ALTER INDEX … DEALLOCATE UNUSED command

Answer: B


PassLeader now are offering 100% pass ensure 1Z0-052 dumps! All 1Z0-052 exam questions have been updated with correct answers, welcome to download the newest PassLeader 1Z0-052 VCE dumps and PDF dumps: http://www.passleader.com/1z0-052.html (261 Q&As)

BTW: Download PassLeader 1Z0-052 dumps from Google Drive for free: https://drive.google.com/open?id=0B-ob6L_QjGLpaXlIQVBWWmRoa1U