[Free] 2018(Jan) Dumps4cert Pass4sure Oracle 1z0-050 Dumps with VCE and PDF 121-130

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

Oracle Database 11g: New Features for Administrators

Question No: 121

You have applications that have frequently executed queries, and produce small and static result sets.

You configure the sqlnet.ora file in the client machine to set a nonzero value for the OCI_RESULT_CACHE_MAX_SIZE parameter.

What is the purpose of this configuration?

  1. to avoid round trips to the server by enabling caching of query results in client memory

  2. to improve performance by storing a copy of the data from the private SQL area of the PGA

  3. to enhance the query performance by creating a cache in the client memory for sorting operations

  4. to avoid the storing of query plans and results in the server by creating a cache in the client memory

Answer: A

Question No: 122

Which statements are true regarding SecureFile LOBs? (Choose all that apply.)

  1. The amount of undo retained is user controlled.

  2. SecureFile LOBs can be used only for nonpartitioned tables.

  3. Fragmentation is minimized by using variable-sized chunks dynamically.

  4. SecureFile encryption allows for random reads and writes of the encrypted data.

  5. It automatically detects duplicate LOB data and conserves space by storing only one copy.

Answer: C,D

Question No: 123

To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the EC_PROTOCOL_ERROR_FURTHER_ACTION

initialization parameter as follows:

SQLgt; ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop.10;

What is the significance of this setting?

  1. It terminates the client connection after 10 bad packets and the client cannot reconnect to the same instance.

  2. It terminates the client connection after 10 bad packets but the client can still reconnect, and attempt the same operation again.

  3. It terminates the client connection 10 seconds after receiving a bad packet and the client cannot reconnect to the same instance.

  4. It terminates the client connection after receiving a bad packet and the client can reconnect to the same instance after 10 minutes.

Answer: B

Question No: 124

Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)

  1. Segment Advisor

  2. SQL Access Advisor

  3. Optimizer statistics gathering

  4. Automatic SQL Tuning Advisor

  5. Automatic Database Diagnostics Monitor

Answer: A,C,D

Question No: 125

Observe the following PL/SQL block:

BEGIN

dbms_spm .configure(#39;SPACE_BUDGET_PERCENT#39;, 30);

END;

Which statement is correct regarding the above PL/SQL block?

  1. It reserves 30% of the space in the SYSTEM tablespace for SMB.

  2. It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB).

  3. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace.

  4. It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace.

Answer: C

Question No: 126

Which three statements are true regarding persistent lightweight jobs? (Choose three.)

  1. The user cannot set privileges on persistent lightweight jobs.

  2. The use of a template is mandatory to create persistent lightweight jobs.

  3. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.

  4. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.

  5. Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.

Answer: A,B,D

Question No: 127

The INVJHISTORY table is created using the command:

SQLgt;CREATE TABLE INV_HISTORY

(inv_no NUMBER(3), inv_date DATE,

inv_amtNUMBER(10,2)) partition by range (inv_date)

interval (numtoyminterval(1 ,#39;month#39;))

(partition pO values less than (to_date(l01-01-2005llldd-mm-yyyy1)), partition p1 values less than (to_date(#39;01-01-2006#39;,#39;dd-mm-yyyy#39;)));

The following data has been inserted into the INVJHISTORY table :

INV_NO INV_DATE INV_AMT 1 30-dec-2004 1000

2 30-dec-2005 2000

3 1-feb-2006 3000

4 1-mar-2006 4000

5 1-apr-2006 5000

You would like to store the data belonging to the year 2006 in a single partition and issue the command:

SQLgt; ALTER TABLE inv_history MERGE PARTITIONS

FOR(TO_DATE(l15-feb-2006l,ldd-mon-yyyy,)),FOR(TO_DATE(l15-apr-20061)) INTO PARTITION sys_py;

What would be the outcome of this command?

  1. It executes successfully, and the transition point is set to quot;l-apr-20061.

  2. It executes successfully, and the transition point is set to #39;15-apr-2006#39;.

  3. It produces an error because the partitions specified for merging are not adjacent.

  4. It produces an error because the date values specified in the merge do not match the date values stored in the table.

Answer: C

Question No: 128

Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)

  1. You can add SQL test cases to the incident package,

  2. You can add or remove the trace files to the package.

  3. You cannot create an incremental incident package when the physical files are purged from the ADR.

  4. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created.

Answer: A,B,D

Question No: 129

Which statements are true regarding table compression? (Choose all that apply.)

  1. It requires uncompress operation during I/O.

  2. It saves disk space and reduces memory usage.

  3. It saves disk space but has no effect on memory usage.

  4. It incurs extra CPU overhead during DML but not direct loading operations.

  5. It incurs extra CPU overhead during DML as well as direct loading operations.

Answer: B,E

Question No: 130

Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose al that apply.)

  1. generating the SQL profile

  2. testing and accepting the SQL profile

  3. generating a list of candidate SQLs fortuning

  4. adding tuned SQL plans into the SQL plan baseline

  5. tuning each SQL statement in the order of importance

F- generating baselines that include candidate SQLs fortuning

Answer: A,B,C,E

100% Dumps4cert Free Download!
Download Free Demo:1z0-050 Demo PDF
100% Dumps4cert Free Guaranteed!
1z0-050 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 *