Top Tips Of Far Out 1Z0-053 Free Practice Exam

NEW QUESTION 1

Within a resource-plan definition, what differentiates a top-level plan from a subplan?

• A. A subplan has the PLAN_SUB parameter value set to SUB.
• B. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definition.
• C. There is no difference in the resource-plan definition.
• D. A subplan always has the CPU_MTH parameter value set to RATIO.
• E. The string TOP_LEVEL is appended to the name of top-level resource plans.

Answer: C

NEW QUESTION 2

Which method could be utilized to identify both DML operations and the SQL statements needed to undo those operations for a specific schema owner? (Choose all that apply.)

• A. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, andUNDO_SQ
• B. Limit rows by START_SCN and TABLE_OWNER.
• C. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, andUNDO_SQ
• D. Limit rows by START_SCN and TABLE_OWNER.
• E. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, andUNDO_SQ
• F. Limit rows by START_TIMESTAMP and TABLE_OWNER.
• G. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, andUNDO_SQ
• H. Limit rows by START_TIMESTAMP and TABLE_OWNER.

Answer: BC

NEW QUESTION 3

Following is the list of locations in random order where oranfstab can be placed.
1./etc/mtab 2.$ORACLE_HOME/dbs/oranfstab 3./etc/oranfstab
What is the sequence in which Direct NFS will search the locations?

• A. 1, 2, 3
• B. 3, 2, 1
• C. 2, 3, 1
• D. 1, 3, 2

Answer: C

NEW QUESTION 4

When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?

• A. log_file_name_convert
• B. convert_log_file_name
• C. file_name_convert_log
• D. redo_log_file_name_convert
• E. logfile_convert_directory

Answer: A

NEW QUESTION 5

When you create a backup control file, where is the resulting file written to?

• A. The database user dump destination directory
• B. The database diagnostic destination directory
• C. To $ORACLE_HOME/rdbms
• D. To $ORACLE_HOME/admin
• E. To the directory and filename you specify in the command

Answer: E

NEW QUESTION 6

Identify three key features of ASM. (Choose three.)

• A. file striping
• B. allocation unit mirroring
• C. automatic disk rebalancing
• D. automatic file size increment
• E. automatic undo management

Answer: ABC

NEW QUESTION 7

Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode? (Choose all that apply.)

• A. Database datafiles
• B. Control files
• C. Archived redo logs
• D. Online redo logs
• E. Flashback logs

Answer: ABD

Explanation:
Recovering a Database in NOARCHIVELOG Mode
1. Restore all the data files and control files
2. (optional) if the media failure is not fixed, you need to modify the control file to the new location of data files and redo log files.
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE RENAME FILE '<damaged file, datafile, redo log>' TO '<new location>';
3. SQL> RECOVER DATABASE UNTIL CANCEL Because online redo logs are never backed up, you cannot restore them with the data files and control files. To enable the
database to reset the online redo logs, you must first mimic incomplete recovery:
4. SQL> ALTER DATABASE OPEN RESETLOGS;

NEW QUESTION 8

What is the correct order of the following commands if you wanted to restore datafile 4, which was accidentally removed from the file system?
a: sql 'alter database datafile 4 online'; b: restore datafile 4;
c: recover datafile 4;
d: sql 'alter database datafile 4 offline';
e: startup
f: shutdown

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

Answer: B

NEW QUESTION 9

When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?

• A. INCLUDING DEPENDENCIES
• B. INCLUDING DEPENDENCIES CASCADE
• C. COMPACT
• D. CASCADE
• E. None of the above

Answer: D

NEW QUESTION 10

Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)

• A. Database must be running in archivelog mode.
• B. Automatic undo management must be enabled.
• C. Undo retention guarantee must be enabled.
• D. The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

Answer: BD

NEW QUESTION 11

Which two statements are true about the duplexing of the backups taken by RMAN? (Choose two.)

• A. It's only supported for the backups performed on the tape
• B. It is not supported for backup operations that produce image copies
• C. Duplex backups need a parallelism for the device to be equal to number of copies
• D. Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

Answer: BD

NEW QUESTION 12

Archived redo logs can be copied to more than one destination by Oracle.

• A. True
• B. False

Answer: A

NEW QUESTION 13

View the Exhibit and examine the output.
You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE; What is the outcome of this command?
Exhibit:

• A. The Flashback Archive is created on the same tablespace where the tables are stored.
• B. The Flashback Archive is created on the SYSAUX tablespace.
• C. The command generates an error because no Flashback Archive name is specified and there is no default Flashback Archive.
• D. The table uses the default Flashback Archive.

Answer: C

NEW QUESTION 14

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 15

View the Exhibit-1 to observe the maintenance window property. View the Exhibit-2 to examine the output of the query.
Which two statements describe the conclusions? (Choose two.) EM-window (exhibit):

sql-dba_autotask_client (exhibit):

• A. RESOURCE_PERCENTAGE should be increased.
• B. The repeat time for the window should be decreased.
• C. RESOURCE_PERCENTAGE should be decreased.
• D. The window duration should be increased.

Answer: AD

NEW QUESTION 16

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 17

The writes the Flashback Database logs in the flash recovery area.

• A. FLSH
• B. FLDB
• C. RVWR
• D. RVRW
• E. FBDA

Answer: C

Explanation:
RVWR (Recovery Writer Process), Writes flashback data to the flashback logs in the fast recovery area RVWR writes flashback data from the flashback buffer in the SGA to the flashback logs. RVWR also creates flashback logs and performs some tasks for flashback log automatic management. Existed in Database instance, Flashback Database
FBDA (Flashback Data Archiver Process), Archives historical rows for tracked tables into flashback data archives and manages archive space, organization, and retention
When a transaction that modifies a tracked table commits, FBDA stores the pre-image of the rows in the archive. FDBA maintains metadata on the current rows and tracks how much data has been archived.
FBDA is also responsible for automatically managing the flashback data archive for space, organization (partitioning tablespaces), and retention. FBDA also keeps track of how far the archiving of tracked transactions has progressed.
See Also: Oracle Database Advanced Application Developer's Guide Existed in Database and ASM instances

NEW QUESTION 18

Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?

• A. AWR baselines are always created as repeating baselines.
• B. AWR baselines can be created on the basis of two time values.
• C. AWR baselines are always created with infinite expiration duration.
• D. AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.

Answer: B

NEW QUESTION 19

How can you reverse the effects of an ALTER DISKGROUP ... DROP DISK command if it has NOT yet completed?

• A. Issue the ALTER DISKGROUP ... ADD DISK command.
• B. Issue the ALTER DISKGROUP ... UNDROP DISKS command.
• C. Issue the ALTER DISKGROUP ... DROP DISK CANCEL command.
• D. Retrieve the disk from the Recycle Bin after the operation completes.

Answer: B

NEW QUESTION 20

Observe the structure of the table employees: The table contains 8475 records.

One of the employees wants to know the names of all employees of the company. For this, he fires the following query:
SELECT * FROM EMPLOYEES ORDER BY emp_fname;
Since the operation performed on executing the query cannot fit into memory, it requires disk space to complete the operation.
Which of the following types of segments will Oracle allocate to complete the operation and to provide the required result?

• A. Rollback segment
• B. Temporary segment
• C. Data segment
• D. Index segment

Answer: B

NEW QUESTION 21

Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSET parameters?

• A. V$VALID_NLS_VALUES
• B. NLS_VALID_VALUES
• C. NLS_VALUE_OPTIONS
• D. V$NLS_VALUE_OPTIONS
• E. V$NLS_VALID_VALUES

Answer: E

NEW QUESTION 22

The environmental variable ORACLE_BASE is set. You want to check the diagnostic files created as part of the Automatic Diagnostic Repository (ADR). View the Exhibit and note the various parameters set in your database.
What will be the location of the ADR base? Exhibit:

• A. It is set to ORACLE_BASE.
• B. It is set to ORACLE_HOME/log.
• C. It is set to /u01/app/oracle/admin/orcl/adump.
• D. It is set to /u01/app/oracle/flash_recovery_area.

Answer: A

Explanation:
The ADR root directory is known as ADR base. Its location is set by the DIAGNOSTIC_DEST initialization parameter. If this parameter is omitted or left null, the database sets DIAGNOSTIC_DEST upon startup as follows:
✑ If environment variable ORACLE_BASE is set, DIAGNOSTIC_DEST is set to the directory designated by ORACLE_BASE.
✑ If environment variable ORACLE_BASE is not set, DIAGNOSTIC_DEST is set to ORACLE_HOME/log.

NEW QUESTION 23

Identify the channel settings that can be performed using the CONFIGURE CHANNEL or ALLOCATE CHANNEL commands in RMAN. (choose all that apply)

• A. Limiting the input/output (I/O) bandwidth consumption
• B. Specifying the size of backup sets and backup pieces
• C. Specifying vendor-specific information for a media manager
• D. Specifying the parallelism for backup and restore operations

Answer: AC

Explanation:
✑ For Limiting the I/O bandwith: CONFIGURE [| ALLOCATE] CHANNEL....RATE
✑ For limiting backup pieces: CONFIGURE [| ALLOCATE] CHANNEL....MAXPIECESIZE
✑ For backup sets, you need to use BACKUP..MAXSETSIZE command to limit!
✑ For parallelism, either to use CONFIGURE DEVICE TYPE..PARALLELISM or to allocate multiple channels during job. NOT to be done with CONFIGURE CHANNEL.
Link to here: Configuring Advanced Channel Options

C:\Users\albo\Desktop\1-1.jpg

NEW QUESTION 24
......