Oracle 1Z0-053 Exam Dumps 2021

NEW QUESTION 1
Which of the following commands will fail?

• A. report schema;
• B. report need backup;
• C. report need backup days 3;
• D. report user;
• E. report obsolete;

Answer: D

NEW QUESTION 2
The NLS_SORT parameter sets the default sort method for which of the following operations? (Choose all that apply.)

• A. WHERE clause
• B. ORDER BY clause
• C. BETWEEN clause
• D. NLSSORT function
• E. NLS_SORT function

Answer: AD

NEW QUESTION 3
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

Answer: C

NEW QUESTION 4
You want to use RMAN to create compressed backups.
Which statement is true about the compression algorithms that RMAN can use?

• A. The BZIP2 compression algorithm consumes more CPU resources than the ZLIB compression algorithm.
• B. The ZLIB compression algorithm consumes more CPU resources than the BZIP2 compression algorithm.
• C. The ZLIB compression algorithm provides maximum compression and produces smaller backups than the BZIP2 compression algorithm.
• D. Only the BZIP2 compression algorithm can be used to make compressed backups to disk.

Answer: A

NEW QUESTION 5
Consider the following scenario for your database:
✑ Backup optimization is enabled in RMAN.
✑ The recovery window is set to 7 days in RMAN.
✑ The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
✑ The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?

• A. The RMAN backup fails because the TOOLS tablespace is read-only
• B. The RMAN skips the backup of the tablespace because backup optimization is enabled
• C. The RMAN makes backup because optimization can be enabled only for backups to disk
• D. The RMAN makes the backup because no backup of the tablespace exists within the seven day window

Answer: D

NEW QUESTION 6
Which three statements are true about persistent configuration? (Choose three.)

• A. A user cannot set privileges on the persistent lightweight jobs
• B. Persistent lightweight jobs generate a large amount of metadata
• C. It is possible to create fully self-contained persistent lightweight jobs
• D. The use of a template is mandatory to create persistent lightweight jobs
• E. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time

Answer: ADE

NEW QUESTION 7
Which command is used to configure RMAN to perform a compressed backup for every backup executed?

• A. BACKUP AS COMPRESSED BACKUPSET DATABASE
• B. BACKUP AS COMPRESSED COPY OF DATABASE
• C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
• D. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS
• E. BACKUP DATABASE COMPRESS

Answer: C

NEW QUESTION 8
NLS parameters can be set using the five methods listed. Put the methods in order from highest to lowest according to Oracles order of precedence:
a: Default setting
b: Client environment variable
c: Explicit ALTER SESSION statement d: Inside SQL function
e: Server initialization parameter

• A. b, d, e, a, c
• B. e, a, b, c, d
• C. d, c, b, e, a
• D. a, b, d, c, e
• E. d, c, b, a, e

Answer: C

Explanation:
C:UsersalboDesktop1-1.jpg

NEW QUESTION 9
Which of the following statements is true when the database is in ARCHIVELOG mode and tablespaces are in hot backup mode?

• A. Archive log generation is suspended until the tablespaces are taken out of hot backup mode.
• B. Datafiles are not written to during hot backups.
• C. Changes to the database are cached during the backup and not written to the datafiles to ensure that the datafiles are consistent when recovered.
• D. The datafile headers are not updated during the backup.
• E. The way data is written to the online redo logs is unchanged during the backup.

Answer: D

NEW QUESTION 10
Which of the following most closely represents an image copy?

• A. Unix cp command of a file
• B. Bit-by-bit copy of a file
• C. Windows COPY command of a file
• D. All of the above

Answer: D

Explanation: Topic 5, Using RMAN to Create Backups

NEW QUESTION 11
Which three statements are true about windows? (Choose three.)

• A. Only one window can be open at any given time
• B. Consumer groups are associated with windows
• C. Windows work with job classes to control resource allocation
• D. The database service name must be provided during windows creation
• E. Windows can automatically start job or change resource allocation among jobs for various time periods.

Answer: ACE

NEW QUESTION 12
In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this:
1) Mount the database
2) Take the data file offline
3) Bring the data file online
4) Use the RMAN SWITCH TO command to switch the image copy
5) Apply the archived redo logs
6) Open the database
7) Use the RMAN RESTORE TO command to switch to the image copy
Which two options illustrate the correct sequence of steps that you could follow? (Choose two.)

• A. 2, 6, 4, 5, 3
• B. 1, 2, 4, 5, 3, 6
• C. 1, 2, 4, 6, 3
• D. 1, 2, 7, 5, 3, 6

Answer: BD

NEW QUESTION 13
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
----- ---- JAMES 2310
View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.
What could be the possible cause for the query not displaying any row? Exhibit:

• A. Flashback logging is not enabled for the database.
• B. The changes made to the table are not committed.
• C. Supplemental logging is not enabled for the database.
• D. The database is not configured in ARCHIVELOG mode.

Answer: B

NEW QUESTION 14
You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.
Which statements are true regarding extent management and allocation units in the ASM disk group? (Choose all that apply.)

• A. The au_size disk group attribute determines the size of allocation units in the disk group.
• B. The allocation unit size may vary but the extent size is fixed.
• C. The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed.
• D. Extent management is completely automated.

Answer: AD

NEW QUESTION 15
Which of the following best describes a full backup?

• A. All datafiles of a database
• B. All datafiles, archive logs, and control files
• C. All datafiles and control files
• D. All the used blocks in a datafile

Answer: D

Explanation: From the training book:
“Full backup: Makes a copy of each data block that contains data and that is within the files being backed up.”
“A full backup contains all used data file blocks.”
“A full backup is different from a whole database backup.”
Conclusion – it means that not all data files are backed up when you do full backup.

NEW QUESTION 16
Which three statements about performance analysis by SQL Performance Analyzer are true? (Choose three.)

• A. It detects changes in SQL execution plans.
• B. It produces results that can be used to create the SQL plan baseline.
• C. The importance of SQL statements is based on the size of the objects accessed.
• D. It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
• E. It shows only the overall impact on workload and not the net SQL impact on workload.

Answer: ABD

Explanation: Introduction to SQL Performance Analyzer (link)
SQL Performance Analyzer compares the performance of SQL statements before and after
the change and produces a report identifying any changes in execution plans or performance of the SQL statements.
Fixing Regressed SQL Statements
If the performance analysis performed by SQL Performance Analyzer reveals regressed SQL statements, then you can make changes to remedy the problem. For example, you can fix regressed SQL by running SQL Tuning Advisor or using SQL plan baselines. You can then repeat the process of executing the SQL statements and comparing its performance to the first execution. Repeat these steps until you are satisfied with the outcome of the analysis

NEW QUESTION 17
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 to the PGA.
• C. The database instance starts, but Automatic Memory Management is disabled.
• D. The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter.

Answer: B