Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 541:

  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;
  B. GRANT SELECT ANY TRANSACTION TO scott;
  C. GRANT EXECUTE ON dbms_flashback TO scott;
  D. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
  F. ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

• Question 542:

  Which of the following are valid until command options when attempting point-in-time recovery in RMAN? (Choose all that apply.)

  A. until time
  B. until change
  C. until sequence
  D. until SCN
  E. until commit
  A. until time
  C. until sequence
  D. until SCN

• Question 543:

  Which of the following are NOT fundamental tasks of the Support Workbench? (Choose all that apply.)

  A. View long-running SQL workloads
  B. View problem details
  C. Gather additional diagnostic information
  D. Create a Service Request
  E. Clean up incident data after upload to Oracle Support
  A. View long-running SQL workloads
  E. Clean up incident data after upload to Oracle Support

• Question 544:

  Which package provides API's for the SQL Tuning Advisor?

  A. DBMS_MONITOR
  B. DBMS_STATS
  C. DBMS_SQLTUNE
  D. DBMS_ADVISOR
  C. DBMS_SQLTUNE

• Question 545:

  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
  D. All of the above

• Question 546:

  Examine the following command for RMAN backup:

  RMAN> RUN {

  ALLOCATE CHANNEL c1 DEVICE TYPE sbt;

  ALLOCATE CHANNEL c2 DEVICE TYPE sbt;

  ALLOCATE CHANNEL c3 DEVICE TYPE sbt;

  BACKUP

  INCREMENTAL LEVEL = 0

  (DATAFILE 1,4,5 CHANNEL c1)

  (DATAFILE 2,3,9 CHANNEL c2)

  (DATAFILE 6,7,8 CHANNEL c3);

  SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';

  }

  Which statement Is true regarding the approach in the command?

  A. The RMAN multiplexing level is 4.
  B. It is the use of asynchronous I/O by RMAN.
  C. It is a case of parallelization of the backup set.
  D. It is an implementation of a multisection backup.
  C. It is a case of parallelization of the backup set.

• Question 547:

  Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropriately? (Choose all that apply.)

  A. DB_CACHE_SIZE
  B. SHARED_POOL_SIZE
  C. LARGE_POOL_SIZE
  D. JAVA_POOL_SIZE
  E. SGA_MAX_SIZE
  F. SORT_AREA_SIZE
  A. DB_CACHE_SIZE
  B. SHARED_POOL_SIZE

• Question 548:

  In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?

  A. The datafiles have an ONLINE status.
  B. The datafiles have an OFFLINE status.
  C. The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.
  D. The datafiles have an OFFLINE status and are in hot backup mode for an online backup.
  E. The datafiles are in STANDBY mode.
  A. The datafiles have an ONLINE status.

• Question 549:

  You are working in an online transaction processing (OLTP) environment. You use the FLASHBACK TABLE command to flash back the CUSTOMERS table. Before executing the FLASHBACK TABLE command, the system change number (SCN) was 663571. After flashing back the CUSTOMERS table, you realize that the table is not in the correct state. Now, you need to reverse the effects of the FLASHBACK TABLE command.

  Which is the fastest and the most efficient option to reverse the effects of the FLASHBACK TABLE command?

  A. Restore the backup control file and open the database with RESETLOGS option.
  B. Perform point-in-time recovery because flashback cannot be performed again on this table
  C. Execute the FLASHBACK DATABASE statement to retrieve the CUSTOMERS table as it was at SCN 663571
  D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571
  D. Execute another FLASHBACK TABLE statement to retrieve the CUSTOMERS table as it was at SCN 663571

• Question 550:

  Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment.

  At the end of the upgrade, you observe that the DBA executes the following script:

  SQL> @utlrp.sql

  What is the significance of executing this script?

  A. It performs parallel recompilation of only the stored PL/SQL code.
  B. It performs sequential recompilation of only the stored PL/SQL code.
  C. It performs parallel recompilation of any stored PL/SQL as well as Java code.
  D. It performs sequential recompilation of any stored PL/SQL as well as Java code.
  C. It performs parallel recompilation of any stored PL/SQL as well as Java code.