The Secret Of Oracle 1Z0-053 Exam Question

NEW QUESTION 1

View the Exhibit for some of the parameter settings. You start a session and issue the following command:
SQL>CREATE INDEX emp_ename ON emp(ename) TABLESPACE users INVISIBLE;
What is the outcome of the above command? Exhibit:

• A. The index is not used by the optimizer but is maintained during DML operations.
• B. The index is not used by the optimizer and is not maintained during DML operations.
• C. The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.
• D. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.

Answer: A

NEW QUESTION 2

Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?

• A. Perform Export before TSPITR and Import after TSPITR
• B. Move objects to another schema that has the same tablespace assigned
• C. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
• D. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

Answer: A

NEW QUESTION 3

View the Exhibit and examine the steps that you executed to create a database resource
plan.
Subsequently, you execute the following procedure which results in an error: SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );
What could be the reason?

• A. The pending area is automatically submitted after the plan creation
• B. The procedure must be executed before creating the resources plan directive
• C. The SYS_GROUP resource consumer group is not included in the resource plan directive
• D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

Answer: D

NEW QUESTION 4

View the Exhibit to examine the output produced by the following query at three different times since the database instance started and has undergone workloads of different capacities:
SQL> SELECT substr(component, 0, 10) COMP, current_size CS, user_specified_size US FROM v$memory_dynamic_components
WHERE current_size!=0; What do you infer from this? Exhibit:

• A. All sessions are connected to the database instance in dedicated mode, and no RMAN or parallel query operations have been performed.
• B. The database instance is running with manual shared memory management.
• C. The database instance is running with manual PGA management.
• D. The database instance has the MEMORY_TARGET value set to a nonzero value.

Answer: D

NEW QUESTION 5

You have just performed a FLASHBACK TABLE operation using the following command: flashback table employees to scn 123456;
The employees table has triggers associated with it. Which of the following statements is true regarding the state of the triggers during the Flashback Table operation?

• A. All the triggers are disabled.
• B. All the triggers are enabled by default.
• C. Enabled triggers remain enabled and disabled triggers remain disabled.
• D. Triggers are deleted when a Flashback Table operation is performed.

Answer: A

NEW QUESTION 6

Which of the following cannot be used as input to the SQL Tuning Advisor? (Choose all
that apply.)

• A. A single SQL statement provided by a user
• B. An existing SQL Tuning Set (STS)
• C. A preprocessed Database Replay workload
• D. A schema name
• E. SQL statement identified in EM as using excessive resources

Answer: CD

NEW QUESTION 7

You have configured flash recovery area in your database and you set the following Initialization parameters for your database instance:
LOG_ARCHIVE_DEST 1 = 'LOCATION=/disk1/arch MANDATORY' LOG _ARCHIEVE_DEST 2 = 'LOCATION=/disk2/arch' LOG_ARCHIVK_DEST_3 = 'LOCATION=/diSk3/arch LOG_ARCH1VK_DEST_4 = 'LOCATION=/disk4/arch' LOG_ARCHIVE_MIN-SUCCEED_DEST = 2
While the database instance is functional, you realized that the destination set by the LOG_ARCHIVE_DEST_I parameter Is not available for the archived redo log file to be created in. All redo log groups have been used.
What happens in an event of log switch?

• A. The online redo log file is not allowed to be overwritten.
• B. The archived redo log files are written to the flash recovery area until the MANDATORY destination is made available.
• C. The database instance will crash because the archived redo log file cannot be created in a destination set as MANDATORY.
• D. The destination set by the LOG_ARCHIVE_DEST_1 parameter is ignored and the archived redo log files are created in the next two available locations to guarantee archive log success.

Answer: D

NEW QUESTION 8

If you lost your entire database, including the database spfile, control files, online redo logs, and database datafiles, what kind of recovery would be required with RMAN?

• A. Complete database recovery.
• B. Incomplete database recovery.
• C. Approximate database recovery.
• D. Archived database recovery.
• E. The database could not be recovered with RMAN.

Answer: B

NEW QUESTION 9

You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?

• A. Restore and recover the datafile.
• B. Restore and recover the tablespace.
• C. Restore and recover the database.
• D. Restore and recover the control file.
• E. Restore and recover the parameter file.

Answer: A

NEW QUESTION 10

David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day.
They are using a recovery catalog for this database.
What steps did Bill perform to recover the database and in what order?

• A. Restored the control file with the RMAN restore controlfile command.
• B. Mounted the DSL instance with the alter database mount command.
• C. Restored the datafiles for the DSL database with the RMAN restore command.
• D. Opened the DSL database with the alter database open resetlogs command.
• E. Recovered the datafiles for the DSL database with the RMAN recover command.
• F. Started the DSL instance.
• G. Connected to the recovery catalog with RMAN.
• H. a, b, c, d, e, f, g
• I. b, c, d, g, f, e, a
• J. g, f, a, b, c, e, d
• K. c, a, d, b, f, e, g
• L. g, f, a, b, e, c, d

Answer: C

Explanation:
About Recovery with a Backup Control File
If all copies of the current control file are lost or damaged, then you must restore and mount a backup control file. You must then run the RECOVER command, even if no data files have been restored, and open the database with the RESETLOGS option. If some copies of the current control file are usable, however, then you can follow the procedure in "Responding to the Loss of a Subset of the Current Control Files" and avoid the recovery and RESETLOGS operation.
When RMAN is connected to a recovery catalog, the recovery procedure with a backup control file is identical to recovery with a current control file. The RMAN metadata missing from the backup control file is available from the recovery catalog. The only exception is if the database name is not unique in the catalog, in which case you must use SET DBID command before restoring the control file.
1. Start RMAN and connect to a target database.
2. Start the target instance without mounting the database. RMAN>STARTUP NOMOUNT;
3. Restore the control file
RMAN> SET DBID 320066378; # (Optional) If the database name is not unique, you need to specify the DBID
RMAN> RUN
{
SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO
'autobackup_format';
RESTORE CONTROLFILE FROM AUTOBACKUP;
}
4. Start the target instance with mounting the database. RMAN>STARTUP MOUNT;
5. Restore the data files; RMAN>RESTORE DATABASE;
6. Recover the database; RMAN>RECOVER DATABASE;
7. Open the database with RESETLOGS option; RMAN> ALTER DATABASE OPEN RESETLOGS;

NEW QUESTION 11

You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command:
ASMCMD> lsdsk -I -d DATA
Which statement is true regarding the outcome of this command?

• A. The command succeeds but it retrieves only the disk names.
• B. The command produces an error because the ASM instance is down.
• C. The command succeeds but it shows only the status of the ASM instance.
• D. The command succeeds and retrieves information by scanning the disk headers based on anASM_DISKSTRING value.

Answer: D

Explanation:
See details at Options for the lsdsk command.
-I Scans disk headers for information rather than extracting the information from an Oracle ASM instance. This option forces non-connected mode.

NEW QUESTION 12

What two are the prerequisites for enabling Flashback Database? (Choose two)

• A. The database must be in ARCHIVELOG mode
• B. The database must be in MOUNT EXCLUSIVE mode
• C. The database must be opened in RESTRICTED mode
• D. The database instance must be started in the NOMOUNT state
• E. The database instance must have the keep buffer pool defined

Answer: AB

NEW QUESTION 13

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.
• C. You can add SQL test cases to the incident package.
• D. You cannot create an incremental incident package when the physical files are purged from the ADR.

Answer: ABC

Explanation:
Refer to here
About Quick Packaging and Custom Packaging
The Enterprise Manager Support Workbench provides two methods for creating and uploading an incident package: the quick packaging method and the custom packaging method.
Quick Packaging—This is the more automated method with a minimum of steps, organized in a guided workflow (a wizard). You select a single problem, provide a package name and description, and then schedule upload of the package contents, either immediately or at a specified date and time. The Support Workbench automatically places diagnostic data related to the problem into the package, finalizes the package, creates the zip file, and then uploads the file. With this method, you do not have the opportunity to add, edit, or remove package files or add other diagnostic data such as SQL test cases. However, it is the simplest and quickest way to get first-failure diagnostic data to Oracle Support. Quick packaging is the method used in the workflow described in "Investigating, Reporting, and Resolving a Problem".
Note that when quick packaging is complete, the package that was created by the wizard remains. You can then modify the package with custom packaging operations at a later time and manually reupload.
Custom Packaging—This is the more manual method, with more steps. It is intended for expert Support Workbench users who want more control over the packaging process. With custom packaging, you can create a new package with one or more problems, or you can add one or more problems to an existing package. You can then perform a variety of operations on the new or updated package, including:
✑ Adding or removing problems or incidents
✑ Adding, editing, or removing trace files in the package
✑ Adding or removing external files of any type
✑ Adding other diagnostic data such as SQL test cases
✑ Manually finalizing the package and then viewing package contents to determine if you must edit or remove sensitive data or remove files to reduce package size.
You might conduct these operations over a number of days, before deciding that you have enough diagnostic information to send to Oracle Support.
With custom packaging, you create the zip file and request upload to Oracle Support as two separate steps. Each of these steps can be performed immediately or scheduled for a future date and time.
Select the Full or Incremental option to generate a full package zip file or an incremental package zip file.
For a full package zip file, all the contents of the package (original contents and all correlated data) are always added to the zip file.
For an incremental package zip file, only the diagnostic information that is new or modified since the last time that you created a zip file for the same package is added to the zip file. For example, if trace information was appended to a trace file since that file was last included in the generated physical file for a package, the trace file is added to the
incremental package zip file. Conversely, if no changes were made to a trace file since it was last uploaded for a package, that trace file is not included in the incremental package zip file.

NEW QUESTION 14

You execute the following command to set the redundancy retention policy in Recovery Manager (RMAN):
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
Identify the statement that correctly describes the implications of this command.

• A. when there are already three backups, for the fourth backup RMAN removes the oldest backup.
• B. When there are already three backups, for the fourth backup RMAN marks the oldest backup as obsolete.
• C. the number of backups that are retained is equal to three and it includes full, incremental, and cumulative backups.
• D. when there are already three backup, one of the existing backups must be removed manually before taking the fourth backup.

Answer: B

Explanation:
Configuring a Redundancy-Based Retention Policy
The REDUNDANCY parameter of the CONFIGURE RETENTION POLICY command specifies how many full or level 0 backups of each data file and control file that RMAN should keep. If the number of full or level 0 backups for a specific data file or control file exceeds the REDUNDANCY setting, then RMAN considers the extra backups as obsolete. The default retention policy is REDUNDANCY 1.
As you produce more backups, RMAN keeps track of which ones to retain and which are obsolete. RMAN retains all archived logs and incremental backups that are needed to recover the nonobsolete backups.
Assume that you make a full backup of data file 7 on Monday, Tuesday, Wednesday, and Thursday. You now have four full backups of this data file.If REDUNDANCY is 2, then the Monday and Tuesday backups are obsolete. If you make another backup on Friday, then the Wednesday backup of data file 7 becomes obsolete. Assume a different case in which REDUNDANCY is 1. You run a level 0 database backup at noon on Monday, a level 1 cumulative backup at noon on Tuesday and Wednesday, and a level 0 backup at noon on Thursday. Immediately after each daily backup you run the command DELETE OBSOLETE. The Wednesday DELETE command does not remove the Tuesday level 1 backup because this backup is not redundant: the Tuesday level 1 backup could be used to recover the Monday level 0 backup to a time between noon on Tuesday and noon on Wednesday. However, the DELETE command on Thursday removes the previous level 0 and level 1 backups.
Run the CONFIGURE RETENTION POLICY command at the RMAN prompt, as in the following example: CONFIGURE RETENTION POLICY TO REDUNDANCY 3;

NEW QUESTION 15

You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog?

• A. synch catalog
• B. resync catalog
• C. replicate catalog
• D. update catalog
• E. restore catalog

Answer: B

Explanation:
Manually Resynchronizing the Recovery Catalog
Use RESYNC CATALOG to force a full resynchronization of the recovery catalog with a target database control file. You can specify a database unique name with RESYNC FROM DB_UNIQUE_NAME or ALL, depending on whether you want to resynchronize a specific database or all databases in the Data Guard environment.
Typically, you would perform this operation after you have run the CONFIGURE command for a standby database, but have not yet connected to this standby database.
1. Start RMAN and connect to a target database and recovery catalog.
2. Mount or open the target database: RMAN> STARTUP MOUNT;
3. Resynchronize the recovery catalog. RMAN> RESYNC CATALOG;

NEW QUESTION 16

You issue the following command on the RMAN prompt.
REPORT NEED BACKUP DAYS 5;
Which statement is true about executing this command?

• A. It will display a list of files that need incremental backup
• B. It will display a list of files that need backup after five days
• C. It will display a list of files that were backed up in the last five days
• D. It will display a list of files that have not been backed up in the last five days
• E. It will apply the current retention policy to determine the files that need to be backed up

Answer: D

NEW QUESTION 17

In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command:
SQL>SELECT /*+ RESULT_CACHE */ sale_category, sum(sale_amt) FROM sales GROUP BY sale_category;
Where would the result of this query be stored?

• A. database buffer cache
• B. shared pool
• C. PGA
• D. large pool

Answer: B

NEW QUESTION 18

How long will this backup be allowed to run?
Backup as compressed backupset duration 2:00 minimize load database;

• A. 2 minutes
• B. 2 hours
• C. 2 days
• D. The command will generate an error.
• E. This backup is not constrained by any time limitation.

Answer: B

NEW QUESTION 19

View the Exhibits exhibit1 and exhibit2.
Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit1 takes less time than the process in exhibit2.
What is the reason for this? lightweight-job-1 (exhibit):

lightweight-job-2 (exhibit):

• A. It updates several tables in the SYSTEM tablespace instead of creating new tables.
• B. It creates jobs temporarily in memory only.
• C. It creates less metadata for the jobs.
• D. It writes the job metadata to disk in compressed format.

Answer: C

Explanation:
The difference between two blocks of code is the "JOB_STYLE". The lightweight job creates less metadata for the jobs.

NEW QUESTION 20

View the exhibit and examine the TRANS table's storage information. After a massive delete operation, you executed the following statement to shrink the TRANS table:
SQL> ALTER TABLE trans SHRINK SPACE CASCADE;
Which statement describes the outcome of the command? Exhibit:

• A. An error is produced.
• B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted
• C. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged
• D. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process

Answer: B

NEW QUESTION 21

You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?

• A. Set MEMORY_TARGET to zero
• B. Set the STATISTICS_LEVEL parameter to BASIC
• C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL
• D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value

Answer: D

NEW QUESTION 22

Which are the prerequisites for performing flashback transactions on your database? (Choose all that apply.)

• A. Undo retention guarantee for the database must be configured.
• B. Supplemental log must be enabled for the primary key.
• C. Supplemental log must be enabled.
• D. Execute permission on the DBMS_FLASHBACK package must be granted to the user.

Answer: BCD

NEW QUESTION 23

Evaluate the following command:
SQL>ALTER SYSTEM SET db_securefile = 'IGNORE';
What is the impact of this setting on the usage of SecureFiles?

• A. It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB.
• B. It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB.
• C. It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB.
• D. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile.

Answer: A

Explanation:
Parameter type String
Syntax DB_SECUREFILE = { NEVER | PERMITTED | ALWAYS | IGNORE }
Default value PERMITTED
Modifiable ALTER SESSION, ALTER SYSTEM
Basic No
DB_SECUREFILE specifies whether or not to treat LOB files as SecureFiles. Values:
NEVER
Any LOBs that are specified as SecureFiles are created as BasicFile LOBs. All SecureFile- specific storage options and features (for example, compress, encrypt, deduplicate) will cause an exception. The BasicFile LOB defaults will be used for storage options not specified.
PERMITTED
LOBs are allowed to be created as SecureFiles. ALWAYS
Attempts to create all LOBs as SecureFile LOBs but creates any LOBs not in an Automatic Segment Space Managed tablespace as BasicFile LOBs, unless SECUREFILE is explicitly specified. Any BasicFile LOB storage options that are specified will be ignored and the SecureFile defaults will be used for all storage options not specified.
IGNORE
The SECUREFILE keyword and all SecureFile options are ignored.
If the COMPATIBLE initialization parameter is not set to 11.1.0 or higher, then LOBs are not treated as SecureFiles.

NEW QUESTION 24
......