Oracle 1Z0-055 Online Practice Questions and Exam Preparation

Oracle 1Z0-055 Online Questions & Answers

• Question 101:

  Which client requests to the database can be captured as a part of the workload capture? (Choose all that apply.)

  A. Flashback query
  B. Distributed transactions
  C. Logging in and logging out of sessions
  D. All DDL statements having bind variables
  E. Direct path load of data from external files
  C. Logging in and logging out of sessions
  D. All DDL statements having bind variables

• Question 102:

  Execute the following statements:

  

  What are the two consequences of the above statements? (Choose two.)

  A. Partitions of PURCHASE_ORDER_ITEMS have system-generated names
  B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each
  C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespace as the partitions of the PURCHASE_ORDERS table
  D. The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automaticallyduplicating the key columns
  E. Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE-ORDERS table
  B. Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each
  C. Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespace as the partitions of the PURCHASE_ORDERS table

• Question 103:

  Examine the following RMAN command:

  BACKUP DATABASE

  TAG TESTDB

  KEEP UNTIL `SYSDATE+1'

  RESTORE POINT TESTDB06;

  Which two statements are true regarding the backup taken by using the above RMAN command? (Choose two.)

  A. Only data files and the control file are backed up
  B. Archived redo logs are backed up only if the database is open during the backup
  C. The backup is deleted after one day, regardless of the default retention policy settings
  D. The backup becomes obsolete after one day, regardless of the default retention policy settings
  B. Archived redo logs are backed up only if the database is open during the backup
  D. The backup becomes obsolete after one day, regardless of the default retention policy settings

• Question 104:

  Evaluate the following command:

  SQL>ALTER SYSTEM SET db_securefile='IGNORE';

  What is the impact of this setting on the usage of SecureFiles?

  A. It forces BasicFiles to be created even if the SECUREFILE option is specified to created the LOB
  B. It forces SecureFiles to be created even if the BASICFILE option is specified to created the LOB
  C. It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB
  D. It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile
  A. It forces BasicFiles to be created even if the SECUREFILE option is specified to created the LOB

• Question 105:

  See the Exhibit to examine a portion of the output from the VALDIATE DATABASE command.

  

  Which statement is true about the block corruption detected by the command?

  A. No action is taken except the output in the exhibit
  B. The corruption is repaired by the command implicitly
  C. The failure is logged into the Automatic Diagnostic Repository (ADR)
  D. The ADVISE FAILURE command is automatically called to display the repair script
  C. The failure is logged into the Automatic Diagnostic Repository (ADR)

• Question 106:

  Which three actions are requiredto configure the Flashback Database? (Choose three.)

  A. Set Flash Recovery Area
  B. Enable Flashback logging
  C. Create FLASHBACK tablespace
  D. Start the database in the ARCHIVELOG mode
  E. Start the database in the NONARCHIVELOG mode
  A. Set Flash Recovery Area
  B. Enable Flashback logging
  D. Start the database in the ARCHIVELOG mode

• Question 107:

  Which statement describes the significance of theCHANGE FAILURE command in RMAN? (Choose all that apply.)

  A. It is used to explicitly close the open failures
  B. It is used to execute the advised repair script
  C. It is used to change failure priority only for the CRITICAL priority
  D. It is used to change failure priority only for HIGH or LOW priorities
  E. It is used to inform the database about the repair after the repair script executes
  A. It is used to explicitly close the open failures
  D. It is used to change failure priority only for HIGH or LOW priorities

• Question 108:

  You set the following parameters in theparameter file and restarted the database:

  

  Which two statements are true regarding these parameters after the database instance in restarted? (Choose two.)

  A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB
  B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually
  C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero
  D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90MB and 270 MB respectively
  A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB
  D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90MB and 270 MB respectively

• Question 109:

  Evaluate the following code:

  SQL>VARIABLE task_name VARCHAR2(255)'

  SQL>VARIABLE sql_stmt VARCHAR2(4000);

  SQL>BEGIN

  : sql_stmt:= `SELECT COUNT (*) FROM customers WHERE cust_state_province ="CA";

  :task_name := `MY_QUICKTUNE_TASK';

  DBMS_ADVISOR.QUICK_TUNE(DBMS_ADVISOR.SQLACCESS_ADVISOR, :task_name,:sql_stmt);

  END;

  What is the outcome of this block of code?

  A. It creates a task and workload and executes the task
  B. It creates a task and workload but does not execute the task
  C. It produces an error because a template has not been created
  D. It produces an error because the SQL Tuning Set has not been created
  A. It creates a task and workload and executes the task

• Question 110:

  Which of the following information will begathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems? (Choose all that apply)

  A. ADR diagnostics files
  B. All the optimizer statistics
  C. Initialization parameter settings
  D. PL/SQL functions, procedures and packages
  E. The table and index definitions and actual data
  B. All the optimizer statistics
  C. Initialization parameter settings
  E. The table and index definitions and actual data