1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 491-500

By on April 21, 2015
Ensurepass    QUESTION 491 You set the following parameters in the parameter file and restarted the 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.)   A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB. B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 481-490

By on
Ensurepass  QUESTION 481 Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)   A. SORT_AREA_SIZE B. HASH_AREA_SIZE C. BITMAP_MERGE_AREA_SIZE D. CREATE_BITMAP_AREA_SIZE E. PGA_AGGREGATE_TARGET   Correct Answer: ABCD     QUESTION 482 When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?   A. The Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 471-480

By on
Ensurepass  QUESTION 471 You specify a nonzero value for the MEMORY_TARGET initialization parameter, but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance. Which statement about the result is true?   A. The database instance starts, and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE. B. The database instance starts, and Oracle automatically tunes memory and allocates 60 percent to the SGA and 40 percent Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 461-470

By on
Ensurepass="cursor: auto; margin: 0cm 0cm 0pt; line-height: normal; text-autospace: ; mso-layout-grid-align: none" align="left">  QUESTION 461 Which two statements are true about the Automatic Diagnostic Repository (ADR)? (Choose two.)   A. The ADR base keeps all diagnostic information in binary format B. SQL*Plus provides the ADRI script, which can be used to work with ADR C. The ADR can be used for problem diagnosis only when the database is open D. The ADR can be disabled Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 451-460

By on
Ensurepass="cursor: auto; margin: 0cm 0cm 0pt; line-height: normal; text-autospace: ; mso-layout-grid-align: none" align="left">  QUESTION 451 Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)   A. You can add or remove the trace files to the package. B. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created. Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 441-450

By on
Ensurepass  QUESTION 441 Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion?   A. The database must be in read-write mode. B. The database must have no external files. C. The database must open in read-only mode. D. The database must be mounted but not opened.   Correct Answer: C     QUESTION 442 Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 411-420

By on
Ensurepass  QUESTION 411 You want to track and store all transactional changes to a table over its lifetime.   To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years.   After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years.   To accomplish this, you issued the following command:   ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;   What is the implication of this command? Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 421-430

By on
Ensurepass="cursor: auto; margin: 0cm 0cm 0pt; line-height: normal; text-autospace: ; mso-layout-grid-align: none" align="left">  QUESTION 421 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 Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 391-400

By on
Ensurepass  QUESTION 391 User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions? (Choose four.)   A. ALTER DATABASE FLASHBACK ON; B. GRANT SELECT ANY TRANSACTION TO scott; C. GRANT EXECUTE ON dbms_flashback TO scott; D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA; E. ALTER TABLESPACE undots1 RETENTION GUARANTEE; F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA Read more [...]

Continue Reading