What Vivid 1Z0-053 Free Practice Questions Is

NEW QUESTION 1

Examine the following RMAN command:
BACKUP DATABASE TAG TESTDB
KEEP UNTIL 'SYSDATE+1' RESTORE POINT TESTDB06;
Which two statements are true regarding the backup taken by using the above RMAN command? (Choose
two.)

• A. Only data files and the control file are backed up.
• B. Archived redo logs are backed up only if the database is open during the backup.
• C. The backup is deleted after one day, regardless of the default retention policy settings.
• D. The backup becomes obsolete after one day, regardless of the default retention policy settings.

Answer: BD

Explanation:
Refer to here. KeepOption
Overrides any configured retention policy for this backup so that the backup is not considered obsolete, as shown in Example 2-26.
You can use the KEEP syntax to generate archival database backups that satisfy business or legal requirements. The KEEP setting is an attribute of the backup set (not individual backup piece) or image copy.
Note: You cannot use KEEP with BACKUP BACKUPSET.
With the KEEP syntax, you can keep the backups so that they are considered obsolete after a specified time (KEEP UNTIL), or make them never obsolete (KEEP FOREVER). As shown in Example 2-27, you must be connected to a recovery catalog when you specify KEEP FOREVER.
Note: You can use CHANGE to alter the status of a backup generated with KEEP.
See Also: keepOption for more information about backups made with the KEEP option. Creating a Consistent Database Backup for Archival Purposes:
This example uses a keepOption to create an archival backup set that cannot be considered obsolete for one year. The example backs up the database, archives the redo in the current online logs to ensure that this new backup is consistent, and backs up only
those archived redo log files needed to restore the data file backup to a consistent state. The BACKUP command also creates a restore point to match the SCN at which this backup is consistent.
The FORMAT parameter must be capable of creating multiple backup pieces in multiple backup sets.
BACKUP DATABASE
FORMAT '/disk1/archival_backups/db_%U.bck' TAG quarterly
KEEP UNTIL TIME 'SYSDATE + 365' RESTORE POINT Q1FY06;

NEW QUESTION 2

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.
You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table:
SQL> SELECT object_name, original_name, droptime FROM recyclebin;

What would be the outcome of the precedent statement?

• A. It retrieves the latest version of the table from the recycle bin
• B. It retrieves the oldest version of the table from the recycle bin
• C. It retrieves the version of the table for which undo information is available
• D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

Answer: A

NEW QUESTION 3

Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?

• A. All objects in the database
• B. Tables owned by SYS and SYSTEM
• C. Data dictionary tables
• D. NCHAR columns
• E. CHAR columns

Answer: E

NEW QUESTION 4

Which command is used to begin a tablespace point-in-time recovery?

• A. Restore tablespace
• B. Recover tablespace
• C. Tablespace recover
• D. Recover to time
• E. recover datafile

Answer: B

NEW QUESTION 5

A database is running in ARCHIVELOG mode and regular backups are performed. A user receives the following
Error message:

Which is the recommended sequence of operations you need to perform for the query successfully?

• A. Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the tablespace.
• B. Take the affected datafile offline (if not already offline), restore the damaged image ofthe datafile, and then bring it online.
• C. Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile and then open the database with resetlogs.
• D. Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile and recover the tablespace, and then put the database in normal operational mode.

Answer: B

NEW QUESTION 6

The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:
LOG_ARCHIVE_DEST_1 = 'LOCATION = /disk1/archive' LOG_ARCHIVE_DEST_2 = 'SERVICE = stdb1'
DB_RECOVERY_FILE_DEST = '/u01/oradata'
Examine the following RMAN command issued to set the deletion policy for archived log files:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO
sbt;
Which statement is true regarding what this command accomplishes?

• A. All archived redo log files backed up at least twice to tape are deleted.
• B. All archived redo log files backed up at least once to tape are eligible for deletion.
• C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area.
• D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion.

Answer: D

NEW QUESTION 7

Observe the following PL/SQL block: BEGIN
dbms_spm.configure('SPACE_BUDGET_PERCENT', 30); END;
Which statement is correct regarding the above PL/SQL block?

• A. It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace.
• B. It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB).
• C. It reserves 30% of the space in the SYSTEM tablespace for SMB.
• D. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace.

Answer: D

NEW QUESTION 8

The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?

• A. The tape I/O performed is asynchronous
• B. The tape buffer is allocated from the System Global Area (SGA)
• C. The tape buffer is allocated from the Program Global Area (PGA)
• D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes

Answer: C

Explanation:
Tape I/O Slaves
RMAN allocates the tape buffers in the System Global Area (SGA) or the Program Global Area (PGA), depending on whether I/O slaves are used. If you set the initialization parameter
BACKUP_TAPE_IO_SLAVES=true, then RMAN allocates tape buffers from the SGA. Tape devices can only be accessed by one process at a time, so RMAN starts as many slaves as necessary for the number of tape devices. If the LARGE_POOL_SIZE initialization parameter is also set, then RMAN allocates buffers from the large pool. If you set BACKUP_TAPE_IO_SLAVES=false, then RMAN allocates the buffers from the PGA.
If you use I/O slaves, then set the LARGE_POOL_SIZE initialization parameter to dedicate SGA memory to holding these large memory allocations. This parameter prevents RMAN I/O buffers from competing with the library cache for SGA memory. If I/O slaves for tape I/O were requested but there is not enough space in the SGA for them, slaves are not used, and a message appears in the alert log.
The parameter BACKUP_TAPE_IO_SLAVES specifies whether RMAN uses slave processes rather than the number of slave processes. Tape devices can only be accessed by one process at a time, and RMAN uses the number of slaves necessary for the number of tape devices.

NEW QUESTION 9

As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query? (Choose two.)
SQL> select group_number, name, state from v$ASM_DISKGROUP; GROUP_NUMBER NAME STATE
============ ======= ========== 0 DGROUP1 DISMOUNTED
2 DGROUP2 MOUNTED
3 DGROUP3 MOUNTED

• A. The DGROUP1 disk group was unmounted by another DBA.
• B. A datafile has been lost, causing the ASM disk group DGROUP1 to go into the DISMOUNTED state
• C. One of the redundant disks (DGROUP1) has been lost in a disk group.
• D. This query has no meaning in an ASM instance.
• E. A disk associated with a disk group was discovered after the ASM instance initially opened.

Answer: AE

NEW QUESTION 10

What command would you issue to enable automated backups of control files?

• A. alter database controlfile autobackup on
• B. alter system controlfile autobackup on
• C. configure controlfile autobackup on
• D. enable controlfile autobackup

Answer: C

NEW QUESTION 11

You plan to collect the Automatic Workload Repository (AWR) data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this?

• A. Create and populate a SQL Tuning Set from the AWR on every Monday.
• B. Change the RETENTION setting for the AWR snapshots to 7 days on Monday.
• C. Create a repeating baseline template.
• D. Insert a finding directive for future ADDM tasks.

Answer: C

NEW QUESTION 12

Which two statements are true about the compressed backups in RMAN? (Choose two.)

• A. Compressed backups can only be taken on the tape drives.
• B. The binary compression creates some performance overhead during backup operation.
• C. The ZLIB compression algorithm can be used only if the COMPATIBLE initialization parameter is set to 11.1.0.
• D. The media manager compression for the tape drive should be enabled for taking compressed backups on the tape.

Answer: BD

NEW QUESTION 13

View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions:
RMAN> BACKUP DATABASE FILESPERSET 2;
The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?
Exhibit:

• A. Because the progress is reported for each data file
• B. Because the progress is reported for each backup set
• C. Because other RMAN sessions have issued the same BACKUP command
• D. Because new data files have been added to the database while the RMAN backup is in progress

Answer: B

NEW QUESTION 14

In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?

• A. VARCHAR2
• B. CHAR
• C. NVARCHAR2
• D. CLOB
• E. LONG

Answer: C

NEW QUESTION 15

On the development database rac0, there are six raw devices: /dev/raw/raw1 through
/dev/raw/raw6. /dev/raw/raw1 and /dev/raw/raw2 are 8GB each, and the rest are 6GB each.
An existing disk group +DATA1, of NORMAL REDUNDANCY, uses /dev/raw/raw1 and
/dev/raw/raw2.
Which series of the following commands will drop one of the failure groups for +DATA1, create a new disk group +DATA2 using two of the remaining four raw devices, and then cancel the drop operation from +DATA1?

• A. Option A
• B. Option B
• C. Option C
• D. Option D

Answer: A

NEW QUESTION 16

Examine the exhibit to view the parameters set in your parameter file. You restart the instance.
To what value will the MEMORY_MAX_TARGET parameter be set by default? Exhibit:

• A. 120M
• B. 320M
• C. 440M
• D. 600M

Answer: D

NEW QUESTION 17

You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline.
Which action would you take before performing this task?

• A. Compute the baseline statistics.
• B. Take an immediate AWR snapshot.
• C. Decrease the window size for the baseline.
• D. Decrease the expiration time for the baseline.

Answer: A

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.

NEW QUESTION 18

Which two statements are true about encrypting RMAN backup? (Choose two.)

• A. The transparent encryption of backups uses the encryption wallet
• B. The database uses the same encryption key for every encrypted backup
• C. The password encryption of backups only uses the password while creating and restoring backup

Answer: AC

NEW QUESTION 19

Another DBA issues a shutdown abort command on a database on which you were running an online backup.
What will happen when you try to restart the database?

• A. Oracle will automatically take the datafile out of hot backup mode, generate a warning message, and then open the database.
• B. Oracle will automatically take the datafile out of hot backup mode and then open the database.
• C. Oracle will generate an error when trying to open the database, indicating that a datafile is in hot backup mod
• D. You will need to correct this error before you can open the database.
• E. The database will open with the file in hot backup mod
• F. You can restart the backup at any time.
• G. The datafile in hot backup mode will be corrupted and you will have to recover it.

Answer: C

NEW QUESTION 20

Which of the following are not disabled by default?

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

Answer: E

NEW QUESTION 21

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 22

Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)

• A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero
• B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
• C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
• D. MEMORY_TARGET is static and cannot be modified without shutting down the instance

Answer: ABC

NEW QUESTION 23

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP;
While you are performing the backup, an error occurs that causes the instance to terminate abnormally.
Which statement about the DATA1 tablespace is true?

• A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
• B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
• C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
• D. If you restart the database, the database will not be opened.

Answer: D

Explanation:
After database instance failure, the BEGIN BACKUP option would not obtain the tablespace online, it will be OFFLINE mode. so that the instance cannot load the database file online.

NEW QUESTION 24
......