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

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

You upgraded Oracle Database 10g to Oracle Database 11 g. How would this affect the existing users#39; passwords?

  1. All passwords automatically become case-sensitive.

  2. All passwords remain non-case-sensitive till they are changed.

  3. All passwords remain non-case-sensitive and cannot be changed.

  4. All passwords remain non-case-sensitive until their password attribute in the profile is altered.

    Answer: B

    Question No: 72

    Which steps are mandatory to enable Direct NFS?

    1. Mount all required file systems using the kernel NFS driver.

    2. Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.

    3. Replace the ODM library libodm11 .so_stub with libodm11 .so.

      1. 2 and 3

      2. 1 and 3

      3. 1 and 2

      4. 1, 2 and 3

Answer: B

Question No: 73

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 Archive FLA1 is dropped only if it is empty.

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

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

Answer: D

Question No: 74

You are managing an Oracle Database 11 g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statements regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)

  1. ASM compatibility controls which features for the ASM will be enabled.

  2. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group

  3. The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.

  4. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.

Answer: A,B,D

Question No: 75

SQLgt; EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(START_TIME=gt;

TO_TIMESTAMP(SYSDATE 2), END_TIME=gt;TO_TIMESTAMP(SYSDATE 10), BASELINE_NAME=gt;#39;Mybase4#39;, TEMPLATE_NAME=gt;#39;Mytemp4l, EXPIRATION=gt;NULL);

Which statement is true about the effect of the above command?

  1. It creates a baseline template that never expires.

  2. It produces an error because no snapshot information is provided to create the baseline.

  3. It creates a baseline template that expires after the Automatic Workload Repository (AWR) retention period.

  4. It creates a repeating baseline template that repeats after the Automatic Workload Repository (AWR) retention period.

Answer: A

Question No: 76

What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?

  1. It improves resync operations.

  2. This feature enables much faster file opens.

  3. It improves performance as fewer extent pointers are needed in the shared pool.

  4. It improves performance by reading from a copy of an extent closest to the node.

Answer: D

Question No: 77

You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option. After some days, you want to change the status of the database backup and you issued the following command:

RMANgt;CHANGE BACKUPSET 231 NOKEEP;

What is the implication of this command?

  1. The backup is deleted.

  2. The backup is marked unavailable.

  3. The backup overrides the backup retention policy.

  4. the backup becomes eligible for deletion according to the existing retention policy

Answer: D

Question No: 78

You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals:

SQLgt; EXECUTE DBMS_STATS .GATHER_TABLE_STATS(#39;SHI ,#39;SALES1

,GRANUU\RITY=gt;#39;GLOBALl);

You need statistics to be collected more quickly. What can you do to achieve this?

  1. Set DYNAMIC_SAMPLING to level 4.

  2. Set the STATISTICS_LEVEL parameter to BASIC.

  3. Set the INCREMENTAL value to TRUE for the partition table.

  4. Increase the value of STALE_PERCENT for the partition table.

Answer: C

Question No: 79

In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file.

You issued the following command:

SQLgt;SELECT /* RESULT_CACHE 7 sale_categoiy, sum(sale_amt) FROM sales

GROUP BY sale_categoiy;

Where would the result of this query be stored?

  1. PGA

  2. large pool

  3. shared pool

  4. database buffer cache

Answer: C

Question No: 80

Which two statements about workload capture and replay operations are true? (Choose two.)

  1. The clients must be created manually on the test machines to perform more realistic testing.

  2. Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.

  3. Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.

  4. The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

    Answer: C,D

    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 *