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

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: 41

Which two are the uses of theASM metadata backup and restore (AMBR) feature? (Choose two.)

  1. It can be used to backup all data on ASM disks

  2. It can be used to re-create the ASM disk group with its attributes

  3. It can be used to recover the damaged ASM disk group along with the data

  4. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates and alias directory structure

Answer: B,D

Question No: 42

Which statements is true regardingthe VALIDATE DATABASE command executed in RMAN session?

  1. It checks the database for intrablock corruptions only

  2. It checks for block corruption in the valid backups of the database

  3. It checks the database for both intrablock and interblock corruputions

  4. It checks for only those corrupted blocks that are associated with data files

Answer: A

Question No: 43

You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?

  1. Data Pump Export and Import

  2. Conventional export and import

  3. The CONVERT command of RMAN

  4. The BACKUP AS COPY….. command of RMAN

Answer: D

Question No: 44

You want the Automatic SQL Tuning processto stop accepting and implementing the recommended SQL profiles automatically. Which action would you perform to achieve this?

  1. Edit the automatic maintenance window group configuration

  2. Set the CURSOR_SHARING parameter to EXACT for the database instance

  3. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to FALSE

  4. Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance

Answer: C

Question No: 45

While deploying a newapplication module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)

  1. The plan baselines can be evolved over time to produce better performance

  2. The newly generated plans are directly placed into the SQL plan baseline without being verified

  3. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration

  4. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported

Answer: A,C

Question No: 46

You have three production databases, HRDB, FINDB and ORGDB that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance.

SQLgt; shutdown immediate;

What is the result of executing this command?

  1. The ASM instance is shut down, but the other instances are still running

  2. It results in an error because other database instances are connected to it

  3. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode

  4. HRDB, FINDB and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode

Answer: B

Question No: 47

See the Exhibit to examine a portion of the output from the VALDIATE DATABASE command.

Latesttests 2018 PDF and VCE

Which statement is true about the block corruption detected by the command?

  1. No action is taken except the output in the exhibit

  2. The corruption is repaired by the command implicitly

  3. The failure is logged into the Automatic Diagnostic Repository (ADR)

  4. The ADVISE FAILURE command is automatically called to display the repair script

Answer: C

Question No: 48

You set to the following parameters in the parameter file and restarted the test database:

MEMORY_MAX_TARGET=0 MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M

Which two statements are true regarding these parameters after the database instance is 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_TRAGET parameters are set to 90MB and 270 MB respectively

Answer: A,D

Question No: 49

Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)

  1. Flashback query

  2. Distributed transactions

  3. Logging in and logging out of sessions

  4. All DDL statements having bind variables

  5. Direct path load of data from external files

Answer: C,D

Question No: 50

Which two initialization parameterswould you set to enable Automatic Shared Memory Management? (Choose two.)

  1. SET SHARED_POOL_SIZE to zero

  2. Set STATISTICS_LEVEL to BASIC

  3. SET SGA_TARGET to a non-zero value

  4. Set DB_CACHE_SIZE to a non-zero value

  5. Set STATISTICS_LEVEL to TYPICAL or ALL

Answer: C,E

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