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

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 401-410

By on
Ensurepass  QUESTION 401 Which of these are valid Flashback Database recovery point parameters? (Choose all that apply.)   A. SCN B. Timestamp C. Named recovery point D. Transaction ID E. Session ID   Correct Answer: ABC     QUESTION 402 When setting up the Flashback Data Archive, which of these key parameters are required? (Choose all that apply.)   A. Tablespace name B. Storage quota C. Retention D. Table name E. Create a default archive Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 371-380

By on
Ensurepass  QUESTION 371 Which of the following statements best describes Flashback Versions Query?   A. Flashback Versions Query is used to make changes to multiple versions of data that existed between two points in time. B. Flashback Versions Query is used to view all version changes on rows that existed between the time the query was executed and a point in time in the past. C. Flashback Versions Query is used to view version changes and the SQL to undo those changes on rows Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 381-390

By on
Ensurepass="cursor: auto; margin: 0cm 0cm 0pt; line-height: normal; text-autospace: ; mso-layout-grid-align: none" align="left">  QUESTION 381 Examine the following commands and their output:   SQL> SELECT ename, sal FROM emp WHERE ename='JAMES';   ENAME SAL  ---- ----   JAMES 1050   SQL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename='JAMES';   1 row updated.   SQL> SELECT ename, sal FROM emp WHERE ename='JAMES';   ENAME SAL  ---- ----   Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 361-370

By on
Ensurepass="cursor: auto; margin: 0cm 0cm 0pt; line-height: normal; text-autospace: ; mso-layout-grid-align: none" align="left">  QUESTION 361 Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?   A. Point-in-time recovery B. Execute the ROLLBACK command with transaction number C. Flashback the database to before the transaction was committed D. Determine all the necessary undo SQL statements Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 351-360

By on
Ensurepass  QUESTION 351 You are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?   A. parallel image copy backup B. backup with MAXPIECESIZE configured for the channel C. parallel backup with MAXPIECESIZE configured for the channel D. intrafile parallel backup   Correct Answer: Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 341-350

By on
Ensurepass  QUESTION 341 You are tuning RMAN to optimize performance. You want tape I/O to be asynchronous when you perform tape backups. Which action should you take?   A. Set the BACKUP_TAPE_IO_SLAVES parameter to FALSE. B. Set the BACKUP_TAPE_IO_SLAVES parameter to TRUE. C. Use compression when performing tape backups. D. Configure multiple SBT channels.   Correct Answer: B     QUESTION 342 What does the minimize load database parameter mean when backing Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 331-340

By on
Ensurepass  QUESTION 331 What RMAN command is used to execute a tablespace point-in-time recovery?   A. recover B. duplicate C. restore D. copy E. None of the above   Correct Answer: A     QUESTION 332 Which options must you configure while performing an automated Tablespace Point-in- Time Recovery (TSPITR) by using Recovery Manager (RMAN)?   A. New channels for restore and recovery tasks B. New name for the data files of the tablespace C. Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 311-320

By on
Ensurepass  QUESTION 311 You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB. You issued the following RMAN commands to create a duplicate database:     Which three are the prerequisites for the successful execution of the above command? (Choose three.)   A. The source database should be open. B. The target database should be in ARCHIVELOG mode if it is open. C. RMAN should be connected to both Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 321-330

By on
Ensurepass  QUESTION 321 If you are going to run a TSPITR recovery, which view will help you to determine which objects will be lost during the TSPITR?   A. TS_OBJECTS_TO_BE_DROPPED B. TS_PTTR_OBJECT_DROPPED C. TS_PITR_OBJECTS_TO_BE_DROPPED D. TS_OBJECTS_DROPPED E. TS_DROPPED_OBJECTS   Correct Answer: C     QUESTION 322 Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 301-310

By on
Ensurepass="cursor: auto; margin: 0cm 0cm 0pt; line-height: normal; text-autospace: ; mso-layout-grid-align: none" align="left">  QUESTION 301 You are managing the APPPROD database as a DBA which is not using the Oracle- managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.   You executed the following RMAN commands:   RMAN> CONNECT TARGET sys/sys@APPPROD Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 281-290

By on
Ensurepass    QUESTION 281 What is the end result of these commands if they are successful?   RMAN> show retention policy;   RMAN configuration parameters for database with db_unique_name ORCL are:   CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default   RMAN> backup database tag=gold_copy plus archivelog tag=gold_copy delete input;   RMAN> backup database tag=silver_copy plus archivelog tag=silver_copy delete input;   A. Attempting to restore Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 291-300

By on
Ensurepass  QUESTION 291 While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?   A. The backup fails because one of the archived redo log files is missing. B. The backup succeeds but it would be without the missing archived log. C. During backup, you are prompted for the alternative Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 271-280

By on
Ensurepass  QUESTION 271 When running the tablespace point-in-time command   recover tablespace users   until time '10/06/2008:22:42:00'   auxiliary destination 'c:\oracle\auxiliary';   You receive the following error:     What is the likely cause of the error?   A. The database is in ARCHIVELOG mode. B. There is not a current backup of the database available. C. The USERS tablespace has dependent objects in other tablespaces and can not be a part Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 261-270

By on
Ensurepass  QUESTION 261 Which is NOT a valid way of backing up a control file?   A. Backing up the control file to trace B. Copying the existing control file of the database to the backup location during a hot backup C. Copying the existing control file of the database to the backup location during a cold backup D. Creating a backup control file E. Using the create controlfile command   Correct Answer: B     QUESTION 262 Another DBA issues a shutdown abort Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 251-260

By on
Ensurepass  QUESTION 251 You want to migrate your database to ASM, so you have done a clean shutdown, made a closed backup of the entire database. You noted the location of your control files and online redo log files, and changed your spfile to use OMF. The last step is to run an RMAN script to do the conversion. Using the following steps, what is the correct order in which the following RMAN commands should be executed?   1. STARTUP NOMOUNT 2. ALTER DATABASE OPEN RESETLOGS 3. SQL "ALTER Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 231-240

By on
Ensurepass  QUESTION 231 The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task, you issued the following command:   SQL> ALTER TABLESPACE hr_data BEGIN BACKUP;   Which two statements are true in this scenario? (Choose two.)   A. No transaction on the tablespace is allowed but you can perform queries. B. The tablespace will automatically Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 241-250

By on
Ensurepass="cursor: auto; margin: 0cm 0cm 0pt; line-height: normal; text-autospace: ; mso-layout-grid-align: none" align="left">  QUESTION 241 You have lost all your online redo logs. As a result, your database has crashed. You have tried to restart the database and clear the online redo log files, but when you try to open the database you get the following error.   SQL> startup   ORACLE instance started.   Total System Global Area 167395328 bytes   Fixed Size 1298612 Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 211-220

By on
Ensurepass  QUESTION 211 Examine the following RMAN script:   RMAN> run {   debug on;   allocate channel c1 type disk;   backup datafile 5;   }   Which statement describes the purpose of the script?   A. The data file is checked for physical corruption and backed up if found clean. B. The backup of data file 5 is performed and the interactive messages during the backup are suppressed. C. The existing backup for the data file is checked and the Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 221-230

By on
Ensurepass  QUESTION 221 While working on a data problem, Curt, Bill, Ben, Mike, and Matt introduced a vast amount of corrupted data into the database. Pablo has discovered this problem and he needs you to recover the database to the point in time prior to the introduction of the corruption. The logical corruption was introduced at 6:30 p.m. on September 6, 2008. Which of the following would be the correct commands to use to restore the database to a point in time before the corruption?   Read more [...]

Continue Reading

1Z0-053 Real Tests (Spring 2015)

Download New Updated (Spring 2015) Oracle 1Z0-053 Actual Tests 201-210

By on
Ensurepass  QUESTION 201 Given the following steps, which would be the correct order to create a backup of an Oracle database in NOARCHIVELOG mode?   7.   shutdown immediate from RMAN 8.   Log into RMAN 9.   startup mount from RMAN 10.  backup database 11.  alter database open 12.  backup database plus archivelog delete input   A. 2,3,1,4,5 B. 2,1,3,6,5 C. 1,3,5,4 D. 2,1,3,5,6 E. 2,1,3,4,5   Correct Answer: E Explanation: Read more [...]

Continue Reading