Oracle 1Z0-055 Online Practice Questions and Exam Preparation

Oracle 1Z0-055 Online Questions & Answers

• Question 11:

  The Database Resource Manager isautomatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?

  A. To prevent the creation of an excessive number of scheduler job classes
  B. To allow the Automated Maintenance Task to use system resources without any restriction
  C. To allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
  D. To prevent the Automated Maintenance Tasks from consuming excessive amount of system resources
  D. To prevent the Automated Maintenance Tasks from consuming excessive amount of system resources

• Question 12:

  Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines. (Choose two.)

  A. Cursor cache
  B. Stored outline
  C. SQL Tuning Set
  D. Automatic Workload Repository (AWR) snapshots
  A. Cursor cache
  C. SQL Tuning Set

• Question 13:

  The SQL Tuning Advisor has beenconfigured with default configurationsinyourdatabase instance. Which recommendation is automatically implemented without the DBA's intervention after the SQL Tuning Advisor is run as part of the AUTOTASK framework?

  A. Statistics recommendations
  B. SQL profile recommendations
  C. Index-related recommendations
  D. Restructuring of SQL recommendations
  B. SQL profile recommendations

• Question 14:

  Evaluate the following SQL statement used to create the PRODUCTS table:

  

  Which statement is true regarding this command?

  A. It executes successfully but partition pruning cannot happen for this partition key
  B. It produces an error because the TOTAL_VALUE column cannot be used as a partition key
  C. It produces an error because compression cannot be used for the TOTAL_VALUE partition key
  D. It executes successfully but the values in the TOTAL_VLAUE column would not be physically stored in the partitions
  D. It executes successfully but the values in the TOTAL_VLAUE column would not be physically stored in the partitions

• Question 15:

  ENCRYPT_TS is an encrypted tablespace that contains tables with data. Which statement is true regarding the effect of queries and data manipulation language (DML) statements on the encrypted data in the tables?

  A. The data is decrypted during SORT and JOIN operations
  B. The data remains encrypted when it is read into memory
  C. The data remains encrypted when it is stored in the redo logs
  D. The data remains encrypted in the UNDO tablespace provided that the UNDO tablespace was created with the encryption option enabled
  C. The data remains encrypted when it is stored in the redo logs

• Question 16:

  You have three production databases, HRDB, FINDB and ORGDB that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance.

  SQL> shutdown immediate;

  What is the result of executing this command?

  A. The ASM instance is shut down, but the other instances are still running
  B. It results in an error because other database instances are connected to it
  C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode
  D. HRDB, FINDB and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode
  B. It results in an error because other database instances are connected to it

• Question 17:

  Which statements describe the capabilities of theDMBS_NETWORK_ACL_ADMINpackage? (Choose all that apply.)

  A. It can be used to allow the access privilege settings for users but not roles
  B. It can be used to allow the access privilege settings for users as well as roles
  C. It can be used to control the time interval for which the access privilege is available to a user
  D. It can be used to selectively restrict the access for each user in a database to different host computers
  E. It can be used to selectively restrict a user's access to different applications in a specific host computer
  B. It can be used to allow the access privilege settings for users as well as roles
  C. It can be used to control the time interval for which the access privilege is available to a user
  D. It can be used to selectively restrict the access for each user in a database to different host computers

• Question 18:

  See the exhibit:

  

  Examine the Automatic Database Diagnostic Monitor (ADDM) tasks: You executed the following commands:

  

  Which statement describes the consequence?

  A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema
  B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only
  C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state
  D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT
  C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state

• Question 19:

  You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:

  ALTER TABLE employees SHRINK SPACE CASCADE;

  Which statement is correct in this scenario?

  A. The EMPLOYEES table will be changed to read-only mode during the shrink operation
  B. The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over
  C. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation
  D. Data manipulation language (DML) operations will not be possible on the EMPLOYYES table during the COMPACTION phase of the shrink operation
  C. The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation

• Question 20:

  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