Oracle 1Z0-053 Free Practice Questions

NEW QUESTION 1

Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g? (Choose all that apply.)

• A. It does not allow you to change the moving window size.
• B. Adaptive threshold functionalities use it by default to compute statistics.
• C. It is created by default with the window size being equal to the AWR retention time.
• D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).

Answer: BC

Explanation:
A moving window baseline corresponds to all AWR data that exists within the AWR retention period. This is useful when using adaptive thresholds because the database can use AWR data in the entire AWR retention period to compute metric threshold values. Oracle Database automatically maintains a system-defined moving window baseline. The
default window size for the system-defined moving window baseline is the current AWR retention period, which by default is 8 days. If you are planning to use adaptive thresholds, consider using a larger moving window—such as 30 days—to accurately compute threshold values. You can resize the moving window baseline by changing the number of days in the moving window to a value that is equal to or less than the number of days in the AWR retention period. Therefore, to increase the size of a moving window, you must first increase the AWR retention period accordingly.

NEW QUESTION 2

You execute the following RMAN command to perform the backup operation:
RMAN> RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8; BACKUP DATABASE FILESPERSET 4;
}
What is the multiplexing level in the preceding backup process?

• A. 4
• B. 8
• C. 7

Answer: A

NEW QUESTION 3

You are performing incomplete recovery using RMAN. You execute the following RUN block:
RUN
{
SET UNTIL SCN 1107600; RESTORE DATABASE; RECOVER DATABASE;
}
Which statement is true about the result?

• A. RMAN restores all datafiles from the most recent backup available since the failure and applies the redo logs necessary to recover the database to SCN 1107600
• B. RMAN restores all datafiles needed to restore the database through SCN 1107599 and applies the redo logs necessary to recover the database through SCN 1107599.
• C. RMAN restores all datafiles and control files from the most recent backup
• D. The RUN block fails because you did not specify an UNTIL clause in your RECOVER DATABASE command

Answer: B

NEW QUESTION 4

Which statement describes the effect of table redefinition on the triggers attached to the table?

• A. All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table.
• B. All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.
• C. All triggers on the table remain valid.
• D. Only triggers that are affected by the changes to the structure of the table are invalidated and automatically revalidated with the next DML execution on the table.

Answer: A

NEW QUESTION 5

Using the LIST command in Recovery Manager (RMAN), which two pieces of information in the RMAN repository can be listed? (Choose two.)

• A. stored scripts in the recovery catalog
• B. backups that can be deleted from disk
• C. backup sets and image copies are obsolete
• D. backups that do not have the AVAILABLE status in the RMAN repository

Answer: AD

Explanation:
About the LIST command
The primary purpose of the LIST command is to list backup and copies. For example, you can list:
✑ Backups and proxy copies of a database, tablespace, data file, archived redo log, or control file
✑ Backups that have expired
✑ Backups restricted by time, path name, device type, tag, or recoverability
✑ Archived redo log files and disk copies
Besides backups and copies, RMAN can list other types of data. For example, you can list:
✑ Backup sets and proxy copies
✑ Image copies
✑ Archived redo log files
✑ Database incarnations
✑ Databases in a Data Guard environment
✑ Backups and copies for a primary or standby database in a Data Guard environment
✑ Restore points
✑ Names of stored scripts
✑ Failures for use with Data Recovery Advisor

NEW QUESTION 6

The INV_HISTORY table is created using the command:

The following data has been inserted into the INV_HISTORY table:

You would like to store the data belonging to the year 2006 in a single partition and issue the command:
SQL> ALTER TABLE inv_history MERGE PARTITIONS
FOR(TO_DATE('15-feb-2006','dd-mon-yyyy')), FOR(TO_DATE('15-apr-2006'))
INTO PARTITION sys_py;
What would be the outcome of this command?

• A. It executes successfully, and the transition point is set to '1-apr-2006'.
• B. It executes successfully, and the transition point is set to '15-apr-2006'.
• C. It produces an error because the partitions specified for merging are not adjacent.
• D. It produces an error because the date values specified in the merge do not match the date values stored in the table.

Answer: C

NEW QUESTION 7

Which of the following are valid program types for a lightweight job? (Choose all that apply.)

• A. PLSQL_BLOCK
• B. EXECUTABLE
• C. JAVA_STORED_PROCEDURE
• D. STORED_PROCEDURE
• E. EXTERNAL

Answer: AD

Explanation:
Job_type
Job action type ('PLSQL_BLOCK', 'STORED_PROCEDURE', 'EXECUTABLE', or 'CHAIN')

NEW QUESTION 8

Your database initialization parameter file has the following entry: SEC_MAX_FAILED_LOGIN_ATTEMPTS=3
Which statement is true regarding this setting?

• A. It drops the connection after the specified number of login attempts fail for any user.
• B. It is enforced only if the password profile is enabled for the user.
• C. It locks the user account after the specified number of attempts.
• D. It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.

Answer: A

NEW QUESTION 9

What methods of point-in-time recovery are available? (Choose all that apply.)

• A. Change-based
• B. Cancel-based
• C. Time-based
• D. Sequence number-based
• E. Transaction number-based

Answer: ABCD

NEW QUESTION 10

A database is running In ARCHIVELOG mode. It has two online redo log groups and each group has one member.
A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow.
1) Restore the corrupted redo log group.
2) Restore from a whole database backup.
3) Perform incomplete recovery.
4) Relocate by renaming the member of the damaged online redo log group to a new location.
5) Open the database with the RESETLOGS option.
6) Restart the database instance.
7) Issue a checkpoint and clear the log.
Identify the option with the correct sequential steps to accomplish the task efficiently.

• A. 1, 3, 4, and 5
• B. 7, 3, 4. and 5
• C. 2, 3, 4, and 5
• D. 7, 4, 3. and 5
• E. Only 6 is required

Answer: C

Explanation:
Recovering After Losing All Members of an Online Redo Log Group
If a media failure damages all members of an online redo log group, then different scenarios can occur depending on the type of online redo log group affected by the failure
and the archiving mode of the database.
If the damaged online redo log group is current and active, then it is needed for crash recovery; otherwise, it is not. Table 30-4 outlines the various recovery scenarios.

C:UsersalboDesktop1-1.jpg

NEW QUESTION 11

You discover that your Recycle Bin contains two tables with the same name, MY_TABLE.
You also have a table named MY_TABLE in your schema. You execute the following statement:
FLASHBACK TABLE my_table TO BEFORE DROP RENAME TO my_table2; What will be the result of executing this statement?

• A. One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
• B. One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
• C. Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
• D. None of the tables are recovered from the Recycle Bin, and the statement returns an error.

Answer: B

NEW QUESTION 12

During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information? (Choose all that apply.)

• A. V$LOGFILE
• B. V$RECOVER_LOG
• C. V$RECOVER_DATABASE
• D. V$LOG_RECOVER
• E. V$LOG

Answer: AE

NEW QUESTION 13

Which is the correct command to back up the database, back up the archived redo logs, and then remove the backed-up archived redo logs?

• A. backup database
• B. backup database and archivelogs
• C. backup database plus archivelogs
• D. backup database plus archivelog delete input
• E. backup database and archivelog delete input

Answer: D

NEW QUESTION 14

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

NEW QUESTION 15

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 16

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.
Identify the two events that can occur in the event of a log switch? (Choose two.)

• A. An entry is created in the alert log file and the database instance continues to function normally
• B. The log switch hangs occur for transactions until free space is available in the flash recovery area
• C. The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area
• D. The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

Answer: BC

NEW QUESTION 17

While deploying a new application module, the software vendor ships the application software along with appropriate SQL plan baselines for the new SQLs being introduced. Which two statements describe the consequences? (Choose two.)

• A. The plan baselines can be evolved over time to produce better performance.
• B. The newly generated plans are directly placed into the SQL plan baseline without being verified.
• C. The new SQL statements initially run with the plans that are known to produce good performance under standard test configuration.
• D. The optimizer does not generate new plans for the SQL statements for which the SQL plan baseline has been imported.

Answer: AC

Explanation:
Purpose of SQL Plan Baselines
Common scenarios where SQL plan management can improve or preserve SQL performance include:
A database upgrade that installs a new optimizer version usually results in plan changes for a small percentage of SQL statements. Most of these plan changes result in either no performance change or improvement. However, some plan changes may cause performance regressions. SQL plan baselines significantly minimize potential regressions resulting from an upgrade.
Ongoing system and data changes can impact plans for some SQL statements, potentially causing performance regressions. SQL plan baselines help minimize performance regressions and stabilize SQL performance.
Deployment of new application modules means introducing new SQL statements into the database. The application software may use appropriate SQL execution plans developed in a standard test configuration for the new statements. If the system configuration is significantly different from the test configuration, then the database can evolve SQL plan baselines over time to produce better performance.

NEW QUESTION 18

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 19

Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature?

• A. RSTLNE
• B. NLSRTL
• C. LISTENER
• D. NLSSORT
• E. Linguistic sorts

Answer: B

Explanation:
NLSRTL: NLS Runtime Type Library.

NEW QUESTION 20

Which of the following statements are true regarding the Recycle Bin? (Choose all that apply.)

• A. The Recycle Bin is a physical storage area for dropped objects.
• B. The Recycle Bin is a logical container for dropped objects.
• C. The Recycle Bin stores the results of a Flashback Drop operation.
• D. The objects in the Recycle Bin are stored in the tablespace in which they were created.

Answer: BD

NEW QUESTION 21

The following databases are registered in the base recovery catalog: PROD1, PROD2, and PROD3.The database user CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog.
The RVPC user can do which of the following? (Choose all that apply.)

• A. Register databases if granted the register database privilege
• B. See all databases in the recovery-catalog schema
• C. See all database-related metadata in the recovery catalog if they are granted access to that database
• D. Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with the grant command
• E. Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes

Answer: AC

NEW QUESTION 22

Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?

• A. Yes, if the database is in ARCHIVELOG mode.
• B. Yes, if the database is in NOARCHIVELOG mode.
• C. No, the backup is not usable in any way.
• D. Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE.

Answer: C

NEW QUESTION 23

Which command do you use to generate a report of database incarnations?

• A. list incarnation of database
• B. report incarnation of database
• C. list database incarnation
• D. database incarnation list
• E. report database incarnation

Answer: A

Explanation:
LIST INCARNATION OF DATABASE prod3;

NEW QUESTION 24

Which are the two prerequisites before setting up Flashback Data Archive? (Choose two.)

• A. Flash recovery area must be defined
• B. Undo retention guarantee must be enabled.
• C. Database must be running in archivelog mode.
• D. Automatic undo management must be enabled.
• E. The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

Answer: DE

NEW QUESTION 25

For Oracle 11g, Oracle strongly recommends that you configure your database to use which of the following memory management features?

• A. Automatic PGA Memory Management
• B. Automatic SGA Memory Management
• C. Automatic Shared Memory Management
• D. Automatic Memory Management
• E. Manual SGA Memory Management
• F. None of the above

Answer: D

NEW QUESTION 26

What is the correct order of steps to perform an online database backup?
a: alter database begin backup; b: alter database end backup;
c: Back up the database datafiles. d: Back up the archive log files.
e: alter system switch logfile;

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

Answer: E

Explanation:
(link)
To back up online read/write tablespaces in an open database:
1. Use the DBA_DATA_FILES data dictionary view to identify all of the data files in the tablespace.
2. ALTER TABLESPACE users BEGIN BACKUP;
3. Back up the online data files of the online tablespace with operating system commands.
4. ALTER TABLESPACE users END BACKUP;
5. ALTER SYSTEM ARCHIVE LOG CURRENT; Archive the unarchived redo logs so that the redo required to recover the tablespace backup is archived.

NEW QUESTION 27
......