[Free] 2018(Jan) EnsurePass Dumpsleader Oracle 1z0-055 Dumps with VCE and PDF 51-60

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan Oracle Official New Released 1z0-055
100% Free Download! 100% Pass Guaranteed!

Oracle Database 11g: New Features for 9i OCPs

Question No: 51

The application tables ownedby the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this?

  1. owner

  2. touser

  3. attach

  4. remap_schema

Answer: D

Question No: 52

Identify two situations in whichyou can use Data Recovery Advisor for recovery. (Choose two.)

  1. The database files are corrupted when the database is open

  2. The archived log files are missing for which backup is not available

  3. The user has dropped an important table that needs to be recovered

  4. You are not able to start up the database instance because the required database files are missing

Answer: A,D

Question No: 53

To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SET_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows:


Whist 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: 54

Examine the following PL/SQL block:

Ensurepass 2018 PDF and VCE

Which statement describes the effect of the execution of the above PL/SQL block?

  1. The plan baseline are verified with the SQL profiles

  2. All fixed plan baselines are converted into nonfixed plan baselines

  3. All the nonaccepted SQL profiles are accepted into the plan baseline

  4. The nonacccepted plans in the SQL Management Base are verified with the existing plan baselines

Answer: D

Question No: 55

You set the following parameters in theparameter file and restarted the database:

Ensurepass 2018 PDF and VCE

Which two statements are true regarding these parameters after the database instance in restarted? (Choose two.)

  1. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB

  2. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually

  3. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero

  4. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90MB and 270 MB respectively

Answer: A,D

Question No: 56

The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario? (Choose two.)

  1. The optimizer adds the new plan to the plan history

  2. The optimizer selects the new plan for the execution of the SQL statement

  3. The optimizer adds the new plan to the SQL plan baseline as an accepted plan

  4. The optimizer adds the new plan to the SQL baseline but not in the ENABLED state

  5. The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost

Answer: A,E

Question No: 57

See the Exhibit:

Ensurepass 2018 PDF and VCE

You receive this error regularly and have to shut down the database instance to overcome the error. What can the solution be to reduce the change of this error in future, when implemented?

  1. Locking the SGA in memory

  2. Automatic memory management

  3. Increasing the value of SGA_MAX_SIZE

  4. Setting the PRE_PAGE_SGA parameter to TRUE

Answer: B

Question No: 58

Which statements are true regardingsystem-partitioned tables? (Choose all that apply.)

  1. Only a single partitioning key column can be specified

  2. All DML statements must use partition-extended syntax

  3. The same physical attributes must be specified for each partition

  4. Unique local indexes cannot be created on a system-partitioned table

  5. Traditional partition pruning and partitionwise joins are not supported on these tables

Answer: D,E

Question No: 59

You need to create a partitioned table to store historical data and you issued the following command:

Ensurepass 2018 PDF and VCE

What is the outcome of the above command?

  1. It returns an error because the range partitions P1 and P2 should be of the same range

  2. It creates two range partitions (P1,P2), within each range partition, it creates month wise subpartitions

  3. It creates two range partitions of varying range. For data beyond ‘1-1-2007’, it creates partitions with a width of one month each

  4. It returns an error because the number of tablespace (TBS1,TBS2,TBS3) specified does not match the number of range partitions (P1,P2) specified

Answer: C

Question No: 60

You plan to collect theAutomatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?

  1. Create a repeating baseline template

  2. Insert a finding directive for future ADDM tasks

  3. Create and populate a SQL Tuning Set from the AWR on every Monday

  4. Change the RETENTION setting for the AWR snapshots to 7 days on Monday

Answer: A

100% Ensurepass Free Download!
Download Free Demo:1z0-055 Demo PDF
100% Ensurepass Free Guaranteed!
1z0-055 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
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.