Oracle 1Z0-055 Online Practice Questions and Exam Preparation

Oracle 1Z0-055 Online Questions & Answers

• Question 51:

  See the Exhibit:

  

  Which statement is true regarding the status of the incident?

  A. The DBA is working on the incident and prefers that the incident be kept in the ADR
  B. The incident is now in the does state and the ADR can select the incident to be purged
  C. The incident has been newly created and is in the process of collecting diagnostic information
  D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support
  D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support

• Question 52:

  You plan to have a larger movingwindow size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?

  A. The collection level for the AWR should be set to BASIC
  B. The moving window size must be less than Undo Retention
  C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
  D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
  D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

• Question 53:

  You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to `ora_%t_%s_%r.log'. Which statement regarding the archived redo log files, created in an earlier incarnation of the database is true?

  A. The archived redo log files will be overwritten
  B. The archived redo log files are deleted automatically
  C. The archived redo log files should be moved to some other location
  D. The archived redo log files are still maintained because the file names are unique
  D. The archived redo log files are still maintained because the file names are unique

• Question 54:

  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 tablespace having Flashback archive is dropped
  B. The Flashback Data Archive FLA1 is dropped only if it is empty
  C. The Flashback Data Archive FLA1 and historical data are dropped
  D. The Flashback Data Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive
  C. The Flashback Data Archive FLA1 and historical data are dropped

• Question 55:

  See the following command:

  

  Which statement is true regarding the above command?

  A. The LOB values are automatically compressed
  B. The LOB values are cached by default in the buffer cache
  C. The LOB values are automatically stored in encrypted mode
  D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks
  D. All LOB data that is identical in two or more rows in a LOB column share the same data blocks

• Question 56:

  Which two statements regardinga SQL profile are true? (Choose two.)

  A. It is built by Automatic Tuning Optimizer
  B. It cannot be stored persistently in the data dictionary
  C. It can be used by the query optimizer automatically
  D. It can be created manually by using the CREATE PROFILE command
  A. It is built by Automatic Tuning Optimizer
  C. It can be used by the query optimizer automatically

• Question 57:

  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 58:

  You have the following requirements in relation to the detection of block corruption for your database instance:

  Check for logical self-consistency of data blocks when modified in memory Checksums are calculated before and after the block change Checks are performed for the lost writes to the physical standby database

  Which method would help you perform the above checks automatically?

  A. Set the DB_SECUREFILE parameter to PERMITTED
  B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY
  C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL
  D. Set the DB_LOST _WRITE_PROTECT parameter to TYPICAL
  B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY

• Question 59:

  You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?

  A. Data Pump Export and Import
  B. Conventional export and import
  C. The CONVERT command of RMAN
  D. The BACKUP AS COPY..... command of RMAN
  D. The BACKUP AS COPY..... command of RMAN

• Question 60:

  What recommendations does the SQLAccess 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