[Free] 2018(Jan) Latesttests Testking Oracle 1z0-055 Dumps with VCE and PDF Download 31-40

Latesttests 2018 Jan Oracle Official New Released 1z0-055
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/1z0-055.html

Oracle Database 11g: New Features for 9i OCPs

Question No: 31

See the Exhibit:

Latesttests 2018 PDF and VCE

As shown in the program, in-memory statistics are transferred to the disk at regular intervals. Which background process performs this activity?

  1. CKPT

  2. SMON

  3. MMON

  4. DBWR

Answer: C

Question No: 32

ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;

What is the implication of this command?

  1. The command produces an error because the retention time cannot be reduced

  2. All historical data older than three years is purged from the flashback archive FLA1

  3. All historical data is purged and the new flashback data archives are maintained for three years

  4. All historical data is retained but the subsequent flashback data archives are maintained for only three years

Answer: B

Question No: 33

See the Exhibit:

Latesttests 2018 PDF and VCE

In the CUSTOMERS_OBE table, when the value of COST_STATE_PROVINCE is “CA”, the value of COUNTRY_ID is “US”. See the exhibit to examine the commands and query plans.

The optimizer can sense 8 rows instead of 29 rows, which is the actual number of rows in the table. What can you do to make the optimizer detect the actual selectivity?

  1. Set the STATISTICS_LEVEL parameter to TYPICAL

  2. Change the STALE_PERCENT value for the CUSTOMERS_OBE table

  3. Set the OPTIMIZER_USE_PENDiNG_STATISTICS parameter to FALSE

  4. Create extended statistics for the CUST_STATE_PROVINCE and COUNTRY_ID columns

Answer: D

Question No: 34

See the Exhibit:

Latesttests 2018 PDF and VCE

You are planning to set the value for the MEMORY_TARGET parameter of your database instance. What value would you assign?

  1. 90 MB

  2. 272 MB

  3. 362 MB

  4. 1440 MB

Answer: C

Question No: 35

Which two statements aboutthe SQL Management Base (SMB) are true? (Choose two.)

  1. It contains only SQL profiles generated by SQL Tuning Advisor

  2. It stores plans generated by the optimizer using a stored outline

  3. It is part of the data dictionary and stored in the SYSAUX tablespace

  4. It is part of the data dictionary and stored in the SYSTEM tablespace

  5. It contains the statement log, the plan history, plan baselines and SQL profiles

Answer: C,E

Question No: 36

You executed the followingcommands:

Latesttests 2018 PDF and VCE

Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

  1. The statistics are stored in the pending statistics table in the data dictionary

  2. The statistics are treated as the current statistics by the optimizer for all sessions

  3. The statistics are treated as the current statistics by the optimizer for the current sessions only

  4. The statistics are temporary and used by the optimizer for all sessions until this sessions terminates

Answer: A

Question No: 37

You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup? (Choose two.)

  1. The KEEP option overrides the configured retention policy

  2. The KEEP option is an attribute of an individual backup piece

  3. The backup contains only data files and archived redo log files

  4. The backup contains data files, the server parameter file and control file even if the control file autobackup is disabled

Answer: A,D

Question No: 38

See the Exhibit:

Latesttests 2018 PDF and VCE

You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:

RMANgt; REPAIR FAILURE;

Which statement describes the consequence of the command?

  1. The command performs the recovery and closes the failures

  2. The command only displays the advice and the RMAN script required for repair

  3. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command

  4. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository(ADR)

Answer: C

Question No: 39

You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it.

You issued the following command to drop the Flashback Archive FLA1. DROP FLASHBACK ARCHIVE fla1;

What is the effect of this command?

  1. The tablespace having Flashback archive is dropped

  2. The Flashback Data Archive FLA1 is dropped only if it is empty

  3. The Flashback Data Archive FLA1 and historical data are dropped

  4. The Flashback Data Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive

Answer: C

Question No: 40

Which two statements regardinga SQL profile are true? (Choose two.)

  1. It is built by Automatic Tuning Optimizer

  2. It cannot be stored persistently in the data dictionary

  3. It can be used by the query optimizer automatically

  4. It can be created manually by using the CREATE PROFILE command

Answer: A,C

100% Free Download!
Download Free Demo:1z0-055 Demo PDF
100% Pass Guaranteed!
Download 2018 Latesttests 1z0-055 Full Exam PDF and VCE

Latesttests 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

2018 Latesttests IT Certification PDF and VCE