08 September, 2021

All About Certified 1Z0-053 Exam Engine

Examcollection 1Z0-053 Questions are updated and all 1Z0-053 answers are verified by experts. Once you have completely prepared with our 1Z0-053 exam prep kits you will be ready for the real 1Z0-053 exam without a problem. We have Replace Oracle 1Z0-053 dumps study guide. PASSED 1Z0-053 First attempt! Here What I Did.

Online Oracle 1Z0-053 free dumps demo Below:

Page: 1 / 58

Total 698 questions Full Exam Access

Question 1

- (Topic 7)
Your production database is functional on the SHOST1 host. You are backing up the production database by using Recovery Manager (RMAN) with the recovery catalog. You want to replicate the production database to anther host, SHOST2, for testing new applications.
After you ensured that the backups of the target database are accessible on the new host, what must you do to restore and recover the backup for the test environment?

Restoring the control file from the backup by using the NOCATALOG option to restore, and recovering the data files

Restoring the data files by using the NOCATALOG option and using the SET NEWNAME command to change the location

Restoring the server parameter file from the backup by using the recovery catalog to restore,

Restoring the data files from the backup by using the recovery catalog to recover the files, and using the SWITCH command to change the location.

My answer: -

Reference answer: A

Reference analysis:

Refer to here:
To restore the database on a new host:
1. Ensure that the backups of the target database are accessible on the new host.
2. Configure the ORACLE_SID on hostb.
3. Start RMAN on hostb and connect to the target database without connecting to the recovery catalog.
For example, enter the following command:
% rman NOCATALOG RMAN> CONNECT TARGET
/
4. Set the DBID and start the database instance without mounting the database. For example, run SET DBID to set the DBID, then run STARTUP NOMOUNT: SET DBID 1340752057;
STARTUP NOMOUNT
RMAN fails to find the server parameter file, which has not yet been restored, but starts the instance with a "dummy" file. Sample output follows:
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/net/hostb/oracle/dbs/inittrgta.ora' trying to start the Oracle instance without parameter files ...
Oracle instance started
5. Restore and edit the server parameter file.
Allocate a channel to the media manager, then restore the server parameter file as a client- side parameter file and use the SET command to indicate the location of the autobackup (in this example, the autobackup is in /tmp):
RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS '...';
SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/tmp/%F'; RESTORE SPFILE
TO PFILE '?/oradata/test/inittrgta.ora' FROM AUTOBACKUP; SHUTDOWN ABORT;
}
6. Edit the restored initialization parameter file.
Change any location-specific parameters, for example, those ending in _DEST, to reflect the new directory structure. For example, edit the following parameters:
- IFILE
- LOG_ARCHIVE_DEST_1
- CONTROL_FILES
7. Restart the instance with the edited initialization parameter file. For example, enter the following command:
STARTUP FORCE NOMOUNT PFILE='?/oradata/test/inittrgta.ora';
8. Restore the control file from an autobackup and then mount the database. For example, enter the following command:
RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS '...'; RESTORE CONTROLFILE FROM AUTOBACKUP; ALTER DATABASE MOUNT;
}
RMAN restores the control file to whatever locations you specified in the CONTROL_FILES initialization parameter.
9. Catalog the data file copies that you copied in "Restoring Disk Backups to a New Host", using their new file names or CATALOG START WITH (if you know all the files are in directories with a common prefix easily addressed with a CATALOG START WITH command). For example, run:
CATALOG START WITH '/oracle/oradata/trgt/';
If you want to specify files individually, then you can execute a CATALOG command as follows:
CATALOG DATAFILECOPY
'/oracle/oradata/trgt/system01.dbf', '/oracle/oradata/trgt/undotbs01.dbf', '/oracle/oradata/trgt/cwmlite01.dbf', '/oracle/oradata/trgt/drsys01.dbf', '/oracle/oradata/trgt/example01.dbf', '/oracle/oradata/trgt/indx01.dbf', '/oracle/oradata/trgt/tools01.dbf', '/oracle/oradata/trgt/users01.dbf';
10. Start a SQL*Plus session on the new database and query the database file names recorded in the control file.
Because the control file is from the trgta database, the recorded file names use the original hosta file names. You can query V$ views to obtain this information. Run the following
query in SQL*Plus:
COLUMN NAME FORMAT a60
SPOOL LOG '/tmp/db_filenames.out' SELECT FILE# AS "File/Grp#", NAME FROM V$DATAFILE
UNION
SELECT GROUP#,MEMBER FROM V$LOGFILE;
SPOOL OFF EXIT
11. Write the RMAN restore and recovery script. The script must include the following steps:
a. For each data file on the destination host that is restored to a different path than it had on the source host, use a SET NEWNAME command to specify the new path on the destination host. If the file systems on the destination system are set up to have the same paths as the source host, then do not use SET NEWNAME for those files restored to the same path as on the source host.
b. For each online redo log that is to be created at a different location than it had on the source host, use SQL ALTER DATABASE RENAME FILE commands to specify the path name on the destination host. If the file systems on the destination system are set up to have the same paths as the source host, then do not use ALTER DATABASE RENAME FILE for those files restored to the same path as on the source host.
c. Perform a SET UNTIL operation to limit recovery to the end of the archived redo logs. The recovery stops with an error if no SET UNTIL command is specified.
d. Restore and recover the database.
e. Run the SWITCH DATAFILE ALL command so that the control file recognizes the new path names as the official new names of the data files.
Example 20-3 shows the RMAN script reco_test.rman that can perform the restore and recovery operation.
Example 20-3 Restoring a Database on a New Host:
RUN
{
# allocate a channel to the tape device
ALLOCATE CHANNEL c1 DEVICE TYPE sbt PARMS '...';
# rename the data files and online redo logs
SET NEWNAME FOR DATAFILE 1 TO '?/oradata/test/system01.dbf'; SET NEWNAME FOR DATAFILE 2 TO '?/oradata/test/undotbs01.dbf';
SET NEWNAME FOR DATAFILE 3 TO '?/oradata/test/cwmlite01.dbf'; SET NEWNAME FOR DATAFILE 4 TO '?/oradata/test/drsys01.dbf'; SET NEWNAME FOR DATAFILE 5 TO '?/oradata/test/example01.dbf'; SET NEWNAME FOR DATAFILE 6 TO '?/oradata/test/indx01.dbf'; SET NEWNAME FOR DATAFILE 7 TO '?/oradata/test/tools01.dbf'; SET NEWNAME FOR DATAFILE 8 TO '?/oradata/test/users01.dbf';
SQL "ALTER DATABASE RENAME FILE ''/dev3/oracle/dbs/redo01.log'' TO ''?/oradata/test/redo01.log'' ";
SQL "ALTER DATABASE RENAME FILE ''/dev3/oracle/dbs/redo02.log'' TO ''?/oradata/test/redo02.log'' ";
# Do a SET UNTIL to prevent recovery of the online logs SET UNTIL SCN 123456;
# restore the database and switch the data file names RESTORE DATABASE;
SWITCH DATAFILE ALL;
# recover the database RECOVER DATABASE;
} EXIT
12. Execute the script created in the previous step.
For example, start RMAN to connect to the target database and run the @ command:
% rman TARGET / NOCATALOG
RMAN> @reco_test.rman
13. Open the restored database with the RESETLOGS option.
From the RMAN prompt, open the database with the RESETLOGS option: ALTER DATABASE OPEN RESETLOGS;
Caution:
When you re-open your database in the next step, do not connect to the recovery catalog. Otherwise, the new database incarnation created is registered automatically in the recovery catalog, and the file names of the production database are replaced by the new file names specified in the script.
14. Optionally, delete the test database with all of its files. Note:
If you used an ASM disk group, then the DROP DATABASE command is the only way to safely remove the files of the test database. If you restored to non-ASM storage then you can also use operating system commands to remove the database.
Use the DROP DATABASE command to delete all files associated with the database automatically. The following example deletes the database files:
STARTUP FORCE NOMOUNT PFILE='?/oradata/test/inittrgta.ora'; DROP DATABASE;
Because you did not perform the restore and recovery operation when connected to the recovery catalog, the recovery catalog contains no records for any of the restored files or the procedures performed during the test. Likewise, the control file of the trgta database is completely unaffected by the test.

Question 2

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

It's only supported for the backups performed on the tape

It is not supported for backup operations that produce image copies

Duplex backups need a parallelism for the device to be equal to number of copies

Duplex backups can be performed to either disk or tape, but cannot be performed on tape and disk simultaneously

Question 3

- (Topic 8)
Which of the following are included in a transportable tablespace set? (Choose all that apply.)

The datafiles that make up a self-contained group of tablespaces required for copy

The system tablespace

An export of the tablespace metadata

The spfile

All of the above

Question 4

- (Topic 17)
Which of these represent the main components of Database Resource Manager? (Choose all that apply.)

Resource consumer groups

Resource plans

Resource-plan groups

Resource-plan directives

All of the above

Question 5

- (Topic 18)
When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?

SET_JOB_ARGUMENT_VALUE

SET_JOB_VALUE_ANYDATA

SET_JOB_ANYDATA_VALUE

SET_SPECIAL_JOB_VALUE

SET_JOB_ANYTYPE_VALUE

Question 6

- (Topic 4)
You issue the following command: RMAN>CONFIGURE BACKUP OPTIMIZATION ON;
What is the result of this command on your backups?

An incremental backup strategy will be used automatically.

Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria.

RMAN will configure itself for maximum performance at the cost of CPU.

RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.

RMAN will automatically compress backups.

Question 7

- (Topic 10)
You want to back up your 100-GB database on a remote tape device. You are required to ensure that minimum network bandwidth is consumed while transferring the backups to the tape device. The current consumption of your CPU is approximately 40 percent.
Which type of backup should you perform?

standard backup set

image copy

compressed backup

user-managed backup

Question 8

- (Topic 16)
Which statement describes the effect of table redefinition on the triggers attached to the table?

All triggers on the table are invalidated and are automatically revalidated with the next DML execution on the table.

All triggers on the table are invalidated and must be manually recompiled before the next DML execution on the table.

All triggers on the table remain valid.

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.

Question 9

- (Topic 13)
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?

Create and populate a SQL Tuning Set from the AWR on every Monday.

Change the RETENTION setting for the AWR snapshots to 7 days on Monday.

Create a repeating baseline template.

Insert a finding directive for future ADDM tasks.

Question 10

- (Topic 11)
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am.
Which option must you use to check whether a flashback operation can recover the database to the specified time?

Check the alert log file

Query the V$FLASHBACK_DATABASE_LOG view

Query the V$RECOVERY_FILE_DEST_SIZE view

Query the V$FLASHBACK_DATABASE_STAT view

Check the value assigned for the UNDO_RETENTION parameter

Question 11

- (Topic 1)
What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)

ORACLE_BASE should be set explicitly.

An Oracle base should have only one Oracle home created in it.

Flash recovery area and data file location should be on separate disks.

Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.

Question 13

- (Topic 20)
What is the name of the file that identifies the set of available locale definitions?

locale.def

lxdef.ora

lx1boot.nlb

lx1boot.ora

lang.def

Question 14

- (Topic 6)
You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.
Which of the following is true regarding your recovery?

You will need to open the database with the resetlogs command.

All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.

You will use the resetlogs version of the create controlfile command.

You will use the noresetlogs version of the create controlfile command.

You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command

Question 15

- (Topic 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?

One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.

One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.

Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.

None of the tables are recovered from the Recycle Bin, and the statement returns an error.

Question 17

- (Topic 2)
Which statement is true regarding the VALIDATE DATABASE command?

It checks the database for intrablock corruptions only.

It checks for block corruption in the valid backups of the database.

It checks the database for both intrablock and interblock corruptions.

It checks for only those corrupted blocks that are associated with data files.

Question 18

- (Topic 6)
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.

1, 3, 4, and 5

7, 3, 4. and 5

2, 3, 4, and 5

7, 4, 3. and 5

Only 6 is required

Question 19

- (Topic 11)
Users notify you that their application is failing every time they try to add new records. Because of poor application design, the actual ORA error message is unavailable.
What might be the problem? (Choose the best answers.)

The application user has exceeded their undo quota.

The FLASHBACK GUARANTEE option is set on the undo tablespace.

The table is currently being queried by a Flashback Transaction Query operation.

The table is currently being queried by a Flashback Versions Query operation.

The RETENTION GUARANTEE option is set on the undo tablespace.

Question 20

- (Topic 15)
Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK framework?

SQL statements that are part of the AWR baseline only

SQL statements based on the AWR top SQL identification

SQL statements that are part of the available SQL Tuning Set (STS) only

SQL statements that are available in the cursor cache and executed by a user other than SYS

Question 21

- (Topic 11)
In order to perform Flashback Transaction Query operations, which of these steps are required? (Choose all that apply.)

Ensure that database is running with version 10.1 compatibility.

Enable Flashback Logging.

Enable Supplemental Logging.

Ensure that the database is running with version 10.0 compatibility.

Ensure that the database is in ARCHIVELOG mode

Question 22

- (Topic 16)
Which statements are true regarding system-partitioned tables? (Choose all that apply.)

Only a single partitioning key column can be specified.

All DML statements must use partition-extended syntax.

The same physical attributes must be specified for each partition.

Unique local indexes cannot be created on a system-partitioned table.

Traditional partition pruning and partitionwise joins are not supported on these tables.

Question 23

- (Topic 1)
The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance.
SQL> STARTUP;
Which two activities are performed during a successful start up operation? (Choose two.)

The databases configured to use the ASM instance are mounted

The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter

ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started

ASM discovers and examines the contents of all files that are in the paths specified in theASM_DISKGROUPS initialization parameters

Question 24

- (Topic 6)
Examine the following scenario:
✑ Database is running in ARCHIVELOG mode.
✑ Complete consistent backup is taken every Sunday.
✑ On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted
✑ The disk having active online redo log files is also corrupted.
✑ The hardware is repaired and the paths for online redo log files and control files are still valid.
Which option would you use to perform the recovery of database till the point of failure?

Restore the latest whole backup, perform complete recovery, and open the database normally

Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option.

Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.

Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.

Question 25

- (Topic 5)
Which backup option defines a user-defined name for a backup?

FORMAT

NAME

TAG

FORMAT U%

Page: 1 / 58

Total 698 questions Full Exam Access