Oracle Oracle Certifications 1Z0-053 Questions & Answers

• Question 291:

  You want to take the backup of the USERS tablespace. It has a single data file of 900 MB. You have tape drives of 300 MB each. The SBT channel is configured for the RMAN. To accomplish the backup, you issued the following RMAN

  command:

  RMAN> BACKUP SECTION SIZE 300M TABLESPACE users;

  Which two statements are true regarding the execution of the above command? (Choose two.)

  A. The RMAN parallelizes the backup although the parallelism is not set for a channel.

  B. The backup piece size will be limited to 300 MB.

  C. The operation is accomplished using the default channel available.

  D. Three channels for the tape drive must be configured by setting the parallelism to three.

  Correct Answer: BC

  SECTION SIZE sizeSpec Specifies the size of each backup section produced during a data file backup.

  By setting this parameter, RMAN can create a multisection backup. In a multisection backup, RMAN creates a backup piece that contains one file section, which is a contiguous range of blocks in a file. All sections of a multisection backup are the same size. You can create a multisection backup for a data file, but not a data file copy. File sections enable RMAN to create multiple steps for the backup of a single large data file. RMAN channels can process each step independently and in parallel, with each channel producing one section of a multisection backup set.

  If you specify a section size that is larger than the size of the file, then RMAN does not use multisection backup for the file. If you specify a small section size that would produce more than 256 sections, then RMAN increases the section size to a value that results in exactly 256 sections.

  Depending on where you specify this parameter in the RMAN syntax, you can specify different section sizes for different files in the same backup job. Note: You cannot use SECTION SIZE with MAXPIECESIZE or with INCREMENTAL LEVEL 1.

• Question 292:

  You perform a backup using the following BACKUP command: RMAN> BACKUP AS COMPRESSED BACKUPSET DATABASE; Which statement is true of this command?

  A. A different procedure is required to restore a database from compressed backups

  B. The AS COMPRESSED clause of the BACKUP command provided by RMAN is used to create compressed backup sets and image copies.

  C. Using this command to create backups minimizes the bandwidth consumed

  D. Using this command to create backups improves the performance of the backup process

  Correct Answer: C

• Question 293:

  Examine the output of the query that you executed to list the objects in the recycle bin:

  

  You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:

  SQL> PURGE TABLE sales_tab;

  What would be the outcome of this command?

  A. All three tables in the recycle bin are purged

  B. Only the table with the oldest DROPSCN is purged

  C. The command returns an error because multiple entries with the same name exist in the recycle bin

  D. Only the table with the latest DROPSCN is purged

  Correct Answer: B

• Question 294:

  User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions? (Choose four.)

  A. ALTER DATABASE FLASHBACK ON;

  B. GRANT SELECT ANY TRANSACTION TO scott;

  C. GRANT EXECUTE ON dbms_flashback TO scott;

  D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;

  E. ALTER TABLESPACE undots1 RETENTION GUARANTEE;

  F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

  Correct Answer: BCDF

• Question 295:

  What are the prerequisites for performing flashback transactions? (Choose all that apply)

  A. Supplemental log must be enabled

  B. Supplemental log must be enabled for the primary key

  C. Undo retention guarantee for the database must be configured

  D. "EXECUTE " permission on the DBMS_FLASHBACK package must be granted to the user

  Correct Answer: ABD

• Question 296:

  View the Exhibit and examine the data manipulation language (DML) operations that you performed on the NEWEMP table. Note that the first two updated are not listed by the Flashback Versions Query.

  What could be the reason?

  Exhibit:

  

  A. The first two updated were not explicitly committed.

  B. ALTER TABLE caused the recycle bin to release the space.

  C. The data definition language (DDL) operation caused a log switch.

  D. Flashback Versions Query stops producing versions of rows that existed before a change in the table structure.

  Correct Answer: C

• Question 297:

  You executed the following query:

  SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; Considering that all the redo logs are available, what information can you derive from the output of the preceding query?

  A. The time when the last flashback operation in your database was performed

  B. The time when the first flashback operation in your database was performed

  C. The approximate time and the lowest system change number (SCN) to which you can flash back your database

  D. The system change number (SCN) and the time when the Flashback Database was enabled in the database instance

  Correct Answer: C

  V$FLASHBACK_DATABASE_LOG displays information about the flashback data. Use this view to help estimate the amount of flashback space required for the current workload.

  

• Question 298:

  You performed the RMAN database backup having a backupset key number 231 with the KEEP FOREVER option.

  After some days, you want to change the status of the database backup and you issued the following command:

  RMAN>CHANGE BACKUPSET 231 NOKEEP;

  What is the implication of this command?

  A. The backup is deleted.

  B. The backup is marked unavailable.

  C. The backup overrides the backup retention policy.

  D. the backup becomes eligible for deletion according to the existing retention policy

  Correct Answer: D

• Question 299:

  You executed the following commands in a database session:

  

  What could have caused the recycle bin to clean up?

  A. There is demand for space from the new table

  B. The undo tablespace does not have sufficient free space

  C. The new table name is the same as the table name in the recycle bin

  D. The temporary tablespace that is assigned to you does not have sufficient free space

  Correct Answer: A

• Question 300:

  You executed the following command to drop a user: DROP USER scott CASCADE;

  Which two statements regarding the above command are correct? (Choose two.)

  A. All the objects of scott are moved to the Recycle Bin.

  B. Any objects in the Recycle Bin belonging to scott are purged.

  C. All the objects owned by scott are permanently dropped from the database.

  D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command.

  E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

  Correct Answer: BC