Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 611:

  Which operation requires that you create an auxiliary instance manually before executing the operation? (Choose all that apply.)

  A. Backup-based database duplication.
  B. Active database duplication.
  C. Tablespace point-in-time recovery.
  D. No operation requires the creation of an auxiliary instance.
  A. Backup-based database duplication.
  B. Active database duplication.

• Question 612:

  You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to _____.

  A. identify the segments that you should shrink
  B. modify the storage parameters for the tablespace
  C. automatically shrink the segments with unused space
  D. check the alerts generated for the tablespace that is running low on space
  A. identify the segments that you should shrink

• Question 613:

  You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it.

  You issued the following command to drop the Flashback Archive FLA1:

  DROP FLASHBACK ARCHIVE fla1;

  What is the effect of this command?

  A. The Flashback Archive FLA1 is dropped only if it is empty.
  B. The tablespace having Flashback Archive is dropped.
  C. The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
  D. The Flashback Data Archive and historical data are dropped.
  D. The Flashback Data Archive and historical data are dropped.

• Question 614:

  What recommendations does the SQL Access Advisor provide for optimizing SQL queries? (Choose all that apply.)

  A. selection of SQL plan baselines
  B. partitioning of tables and indexes
  C. creation of index-organized tables
  D. creation of bitmap, function-based, and B-tree indexes
  E. optimization of materialized views for maximum query usage and fast refresh
  B. partitioning of tables and indexes
  D. creation of bitmap, function-based, and B-tree indexes
  E. optimization of materialized views for maximum query usage and fast refresh

• Question 615:

  The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task, you issued the following command:

  SQL> ALTER TABLESPACE hr_data BEGIN BACKUP;

  Which two statements are true in this scenario? (Choose two.)

  A. No transaction on the tablespace is allowed but you can perform queries.
  B. The tablespace will automatically come out of backup mode when the file copy is complete.
  C. The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
  D. The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.
  C. The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
  D. The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.

• Question 616:

  What does the SCN represent?

  A. The system change number, which is a point in time relative to transactions within a given database.
  B. A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases.
  C. The security change number, which represents the security code that is needed to access any database structure.
  D. A conversion factor that converts internal database time to external clock time.
  E. UTC time in the database, providing a standardized way of tracking time in Oracle.
  A. The system change number, which is a point in time relative to transactions within a given database.

• Question 617:

  An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?

  A. TEST_TBS is a small file tablespace.
  B. TEST_TBS is a bigfile tablespace (BFT).
  C. TEST_TBS is the default temporary tablespace.
  D. TEST_TBS is a dictionary-managed tablespace.
  D. TEST_TBS is a dictionary-managed tablespace.

• Question 618:

  Which two statements are true regarding the SQL Repair Advisor? (Choose two.)

  A. The SQL Repair Advisor can be invoked to tune the performance of the regressed SQL statements.
  B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
  C. The SQL Repair Advisor is invoked by the Health Monitor when it encounters the problematic SQL statement.
  D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.
  B. The SQL Repair Advisor can be invoked even when the incident is not active for a SQL statement crash.
  D. The DBA can invoke the SQL Repair Advisor when he or she receives an alert generated when a SQL statement crashes and an incident is created in the ADR.

• Question 619:

  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.
  C. There is no difference in the resource-plan definition.

• Question 620:

  You want to enable automatic PGA memory management in your database. Which setting is required to achieve this?

  A. Set MEMORY_TARGET to zero
  B. Set the STATISTICS_LEVEL parameter to BASIC
  C. Set the WORKAREA_SIZE_POLICY parameter to MANUAL
  D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value
  D. Set the PGA_AGGREGATE_TARGET parameter to nonzero value