web analytics

100% Pass Ensure 1Z0-052 Dumps with Free VCE and PDF (Question 161 – Question 180)

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 161
Note the following points describing various utilities in Oracle Database 11g:
1. It enables the high-speed 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 table of an Oracle Database
4. It provides a tape backup management for the Oracle ecosystem
Which point describes Oracle Secure Backup?

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

Answer: D

QUESTION 162
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 163
You have an ORDERS table with the following structure:
passleader-1Z0-052-dumps-1631
The table has data in the ODATE column for all rows. Many orders are placed in a single day. You need to ensure that the ODATE column must contain data for every order in future. Which method would serve the purpose?

A.    Modify the column using the ALTER TABLE … MODIFY command.
B.    Add a UNIQUE constraint to the column using the ALTER TABLE … ADD CONSTRAINT command.
C.    Add a NOT NULL constraint to the column using the ALTER TABLE … ADD CONSTRAINT command.
D.    Add a PRIMARY KEY constraint to the column using the ALTER TABLE … ADD CONSTRAINT command.

Answer: A

QUESTION 164
Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

A.    The database files are corrupted when the database is open
B.    The user has dropped an important table that needs to be recovered
C.    The archived redo log files are missing for which the backup is not available
D.    The database is not opening because the required database files are missing

Answer: AD

QUESTION 165
You have two tables with referential integrity enforced between them. You need to insert data to the child table first because it is going to be a long transaction and data for the parent table will be available in a later stage, which can be inserted as part of the same transaction. View the Exhibit to examine the commands used to create tables. Which action would you take to delay the referential integrity checking until the end of the transaction?
passleader-1Z0-052-dumps-1651

A.    Set the constraint to deferred before starting the transaction
B.    Alter the constraint to NOVALIDATE state before starting the transaction
C.    Enable the resumable mode for the session before starting the transaction
D.    Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction

Answer: A

QUESTION 166
You have statistics collected for some selected tables. Your requirement is that the statistics for the tables and all dependent indexes must not be overwritten by further statistics collection until a certain point of time. How would you achieve this?

A.    Lock statistics for the tables.
B.    Change STALE_PERCENT to zero for the tables.
C.    Set the TIMED_STATISTICS parameter to TRUE.
D.    Set the STATISTICS_LEVEL parameter to BASIC.
E.    Set the OPTIMIZER_USE_PENDING parameter statistics to TRUE.

Answer: A

QUESTION 167
Automatic Shared Memory Management is disabled for your database instance. You realize that there are cases of SQL statements performing poorly because of repeated parsing activity, resulting in degradation of performance. What would be your next step to improve performance?

A.    Run the SQL Access Advisor
B.    Run the memory Advisor for the SGA
C.    Run the memory Advisor for the PGA
D.    Run the memory advisor for the shared pool
E.    Run the memory advisor for the buffer cache

Answer: D

QUESTION 168
View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table:
SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005′;
Before user A issues a COMMIT or ROLLBACK command, user B executes the following command on the TRANS table:
SQL> ALTER TABLE trans MODIFY (tr_type VARCHAR2(3));
What would happen in this scenario?
passleader-1Z0-052-dumps-1681

A.    The ALTER TABLE command modifies the column successfully
B.    The DDL operation gets higher priority and transaction for user A is rolled back
C.    The ALETER TABLE command waits indefinitely until user A ends the transaction
D.    The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy

Answer: D

QUESTION 169
Which two files in the database can be configured for automatic backups by using the autobackup feature in Recovery Manager (RMAN)? (Choose two.)

A.    Data Files
B.    Control Files
C.    Parameter Files
D.    Online Redo Log Files
E.    Server Parameter File

Answer: BE

QUESTION 170
Which two statements are true regarding the usage of the SQL*LOADER utility? (Choose two.)

A.    You can load data into multiple tables during the same load session
B.    You can load data from multiple files to a table during the same load session
C.    You cannot perform selective data loading based on the values available in the records
D.    You can use an export file generated by the EXPDP utility as an input data file to load the data
E.    You can load data only if the input file is available on the disk and tape but not a named pipes

Answer: AB

QUESTION 171
In which situation may the UNDO_RETENTION parameter be ignored, even if it is set to a value?

A.    When the data file of the undo tablespace is autoextensible
B.    When there are more than one undo tablespace available in the database
C.    When the undo tablespace is of a fixed size and retention guarantee is not enabled
D.    When the undo tablespace is autoextensible and retention guarantee is not enabled

Answer: C

QUESTION 172
Note the following structures in your database server:
1. Extents
2. OS Blocks
3. Tablespace
4. Segments
5. Oracle Data Block
Which option has the correct arrangement of these structures from the smallest to the largest?

A.    2, 5, 1, 4, 3
B.    1, 2, 3, 4, 5
C.    5, 2, 1, 3, 4
D.    2, 1, 5, 4, 3

Answer: A

QUESTION 173
You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add a new column to the EMPLOYEE table to achieve this. Which data types would you use for the new column?

A.    CLOB
B.    BLOB
C.    BFILE
D.    LONG RAW

Answer: C

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

A.    Host naming method
B.    Local naming method
C.    External naming method
D.    Directory naming method

Answer: B

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

A.    Committing a transaction
B.    Flashing back a transaction
C.    Recovering a failed transaction
D.    Running a read-consistent query
E.    Changing a tablespace status from READ ONLY to READ WRITE

Answer: BCD

QUESTION 176
Which two activities are NOT supported by the Data Recovery Advisor (DRA)? (Choose two.)

A.    Recover from failures in the RAC environment.
B.    Diagnose and repair a data file corruption online.
C.    Diagnose and repair a data file corruption offline.
D.    Diagnose and repair failures on a standby database.

Answer: AD

QUESTION 177
Which two statements are true regarding the SGA_TARGET initialization parameter? (Choose two.)

A.    It can be increased up to the value of the SGA_MAX_SIZE parameter.
B.    Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the autotuned components.
C.    Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and manually sized components.
D.    Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared memory management feature.

Answer: AB

QUESTION 178
Which statement is true about the Manageability Monitor (MMON) background process?

A.    It transfers statistics from memory to disk at regular intervals.
B.    It coordinates the rebalance activity for disk groups when ASM is used.
C.    It communicates with the Automatic Storage Management (ASM) instance on behalf of the database instance.
D.    It performs dynamic memory management when Automatic Shared Memory Management is enabled for the database instance.

Answer: A

QUESTION 179
Which two statements are true regarding transactions in an Oracle database? (Choose two.)

A.    Multiple transactions can use the same undo segment.
B.    A transaction is assigned an undo segment when it is started.
C.    More than one transaction cannot share the same extent in the undo tablespace.
D.    The transactions use system undo segment to store undo data if all the segments in the undo tablespace are used.

Answer: AB

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

A.    Use the external table population.
B.    Use the Oracle Data Pump export and import utility.
C.    Use the conventional path data load of the SQL*Loader utility.
D.    Use the INSERT INTO…SELECT command to load the data.

Answer: C


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