Oracle 1Z0-053 Exam Dumps 2021

NEW QUESTION 1
If you use ALTER DISKGROUP ... ADD DISK and specify a wildcard for the discovery string, what happens to disks that are already a part of the same or another disk group?

• A. The command fails unless you specify the FORCE option.
• B. The command fails unless you specify the REUSE option.
• C. The command must be reissued with a more specific discovery string.
• D. The other disks, already part of the disk group, are ignored.

Answer: C

Explanation: Refer to an Oracle Example for adding disk to diskgroup (link) How A Disk is Discovered
While an ASM instance is initialized, ASM discovers and examines the contents of all of the disks that are in the paths that you designated with values in the ASM_DISKSTRING initialization parameter. Disk discovery also occurs when you:
✑ Run the ALTER DISKGROUP...ADD DISK and ALTER DISKGROUP...RESIZE
DISK commands
✑ Query the V$ASM_DISKGROUP and V$ASM_DISK views
Disk Discovery Rules(link)
The rules for discovering ASM disks are as follows:
Note:
✑ ASM can discover up to 10,000 disks. That is, if more than 10,000 disks match the ASM_DISKSTRING initialization parameter, then ASM discovers only the first 10,000.
✑ ASM only discovers disks that contain a partition table.
ASM does not discover a disk that contains an operating system partition table, even if the disk is in an ASM disk string search path and ASM has read and write permission for the disk.
✑ When adding a disk, the FORCE option must be used if ASM recognizes that the disk was managed by Oracle. Such a disk appears in the V$ASM_DISK view with a status of FOREIGN. In this case, you can only add the disk to a disk group by using the FORCE keyword.
In addition, ASM identifies the following configuration errors during discovery:
✑ Multiple paths to the same disk
In this case, if the disk is part of a disk group, then disk group mount fails. If the disk is being added to a disk group with the ADD DISK or CREATE DISKGROUP command, then the command fails. To correct the error, adjust the ASM_DISKSTRING value so that ASM will not discover multiple paths to the same disk. Or if you are using multipathing software, then ensure that you include only the pseudo-device name in the ASM_DISKSTRING value. See "ASM and Multipathing".
✑ Multiple ASM disks with the same disk header
This can be caused by having copied one disk onto another. In this case, the disk group mount operation fails.

NEW QUESTION 2
View the Exhibit for the object interdependency diagram.
✑ The PRODUCTS table is used to create the PRODCAT_VW view.
✑ PRODCAT_VW is used in the GET_DATA procedure.
✑ GET_DATA is called in the CHECK_DATA function.
✑ A new column PROD_QTY is added to the PRODUCTS table.
How does this impact the status of the dependent objects? Exhibit:

• A. All dependent objects remain valid.
• B. Only the procedure and function become invalid and must be recompiled.
• C. Only the view becomes invalid and gets automatically revalidated the next time it is used.
• D. Only the procedure and function become invalid and get automatically revalidated the next time they are called.

Answer: A

NEW QUESTION 3
You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:
SQL> @utlu111i.sql
Which statement about the execution of this script is true?

• A. It must be executed from the Oracle Database 11g environment.
• B. It must be executed only after the SYSAUX tablespace has been created.
• C. It must be executed from the environment of the database that is being upgraded.
• D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
• E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

Answer: C

Explanation: Script Name: utlu111i.SQL
Used to: Pre-Upgrade Information
Analyzes the database to be upgraded, detailing requirements and issues for the upgrade to Oracle Database 11g Release 1 (11.1)

NEW QUESTION 4
You want to enable resumable space allocation at the instance level.
Which two actions would enable resumable space allocation at the instance level? (Choose two.)

• A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statement
• B. issuing the ALTER SESSION ENABLE RESUMABLE; statement
• C. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero value
• D. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=<nonzero value>; statement

Answer: CD

NEW QUESTION 5
You issued the following command to mount the DATA disk group in restricted mode: ALTER DISKGROUP data MOUNT RESTRICT;
What is the implication of this command?

• A. The client RDBMS instance can access the file as a read-only file.
• B. A new disk cannot be added to a disk group.
• C. A disk in a disk group can be taken offline.
• D. The client RDBMS instance cannot access the files in the disk group.

Answer: D

Explanation: MOUNT (link)
Specify MOUNT to mount the disk groups in the local Oracle ASM instance. Specify ALL MOUNT to mount all disk groups specified in the ASM_DISKGROUPS initialization parameter. File operations can only be performed when a disk group is mounted. If Oracle ASM is running in a cluster or a standalone server managed by Oracle Restart, then the MOUNT clause automatically brings the corresponding resource online.
RESTRICTED | NORMAL Use these clauses to determine the manner in which the disk groups are mounted.
In the RESTRICTED mode, the disk group is mounted in single-instance exclusive mode. No other Oracle ASM instance in the same cluster can mount that disk group. In this mode the disk group is not usable by any Oracle ASM client.
In the NORMAL mode, the disk group is mounted in shared mode, so that other Oracle ASM instances and clients can access the disk group. This is the default.

NEW QUESTION 6
For which two situations would you use functionality provided by the Resource Manager? (Choose two.)

• A. setting idle timeout limits on resource plans
• B. saving storage space by using compressed backup sets
• C. creating jobs that will run automatically at a scheduled time
• D. assigning priorities to jobs to manage access to system resources
• E. creating alerts to perform notification when tablespaces are low on available space resources

Answer: AD

NEW QUESTION 7
To clean up old records that are in a Flashback Data Archive and are past the retention period, what must the DBA do?

• A. TRUNCATE the archive table.
• B. DROP the Flashback Data Archive.
• C. Nothing; expired rows are automatically removed.
• D. Nothing; expired rows are moved to an archive table.
• E. Delete entries from the archive where the metadata date retained is greater than the retention period.

Answer: C

NEW QUESTION 8
Which of these components correctly identify the unique value of the NAME column in the DBA_RESUMABLE view?

• A. Username, instance number, session ID
• B. Instance number, username, session ID
• C. Instance number, session ID, username
• D. Username, session ID, instance number
• E. None of the above

Answer: D

NEW QUESTION 9
What is an obsolete backup set?

• A. A backup set that is missing one or more backup set pieces
• B. A backup that has exceeded the retention criteria and is no longer needed
• C. A backup set that does not include archived redo logs
• D. A backup set that can not be recovered due to corruption
• E. A backup set superceded by a datafile copy

Answer: B

NEW QUESTION 10
Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?

• A. The database must be running in ARCHIVELOG mode.
• B. No special setup is required, and the feature is enabled by default.
• C. The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.
• D. The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.
• E. Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.

Answer: E

NEW QUESTION 11
You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don't want to have to rebuild the disks from scratch.
What do you do?

• A. Take the whole disk group offline and wait for the controller card to be installe
• B. Once it's installed, bring the disk group online again.
• C. Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed dis
• D. Once the disk controller is replaced, reset the parameter to its original value.
• E. You have no choice but to rebuild the dis
• F. Drop the disk from the disk group and wait for the controller to be replace
• G. Once the controller is replaced, add the disk back into the disk group and allow ASM to rebuild it.
• H. If you are using any setting other than REDUNDANCY EXTERNAL for your disk group, you will have to recover any data on that disk from a backu
• I. The database will be unavailable until you can correct the problem and perform recovery.
• J. Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.

Answer: E

NEW QUESTION 12
Consider the following code snippet:

If this code were executed, which of the following statements would be true?

• A. The priority of the lne_job1 job would be set to 1.
• B. The lne_job1 job would be executed synchronously.
• C. The lne_job1 job would run immediately in the users current session.
• D. The lne_job1 job would retain its current priority.
• E. The job will immediately take priority over all running jobs.

Answer: A

Explanation: job_priority
This attribute specifies the priority of this job relative to other jobs in the same class as this job. If multiple jobs within a class are scheduled to be executed at the same time, the job priority determines the order in which jobs from that class are picked up for execution by the job coordinator. It can be a value from 1 through 5, with 1 being the first to be picked up for job execution.
If no job priority is specified when creating a job, the default priority of 3 is assigned to it.

NEW QUESTION 13
Which of the following are not disabled by default?

• A. Jobs
• B. Chains
• C. Windows
• D. Window groups
• E. Schedule

Answer: E

NEW QUESTION 14
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 15
The ADMIN_EMP table has columns EMPNO, ENAME, DEPTNO, and SAL. It has a materialized view EMP_MV with a materialized log and an ENAME_IDX index on the ENAME column. You need to perform an online table redefinition on the ADMIN_EMP table to move it from the TBS1 tablespace to the TBS2 tablespace in the same schema.
What action is required for the dependent objects when you perform online redefinition on the table?

• A. The materialized view should have a complete refresh performed after the online table redefinition is completed.
• B. The materialized view should have a fast refresh performed after the online table redefinition is completed.
• C. The materialized view, materialized log, and the index should be dropped and re-created after the online table redefinition is complete.
• D. The materialized view and materialized log should be dropped and all constraints disabled and re-created after the online table redefinition is complete.

Answer: A

Explanation: Restrictions for Online Redefinition of Tables
✑ After redefining a table that has a materialized view log, the subsequent refresh of any dependent materialized view must be a complete refresh.

NEW QUESTION 16
You executed the following command to drop a user: DROP USER scott CASCADE;
Which two statements regarding the above command are correct? (Choose two.)

• A. All the objects of scott are moved to the Recycle Bin.
• B. Any objects in the Recycle Bin belonging to scott are purged.
• C. All the objects owned by scott are permanently dropped from the database.
• D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.
• E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

Answer: BC

NEW QUESTION 17
The following query will provide what information about transportable tablespaces for the current database? (Choose all that apply.)

• A. The list of target platforms having the same endian format as the source database
• B. The list of target platforms requiring endian conversion
• C. The list of target platforms that will not require endian conversion
• D. The list of all target platforms that can receive transportable tablespaces from the source database
• E. None of the above

Answer: AC