Oracle 1Z0-055 Online Practice Questions and Exam Preparation

Oracle 1Z0-055 Online Questions & Answers

• Question 41:

  Which two statements about Oracle DirectNetwork File System (NFS) are true? (Choose two.)

  A. It bypasses the OS file system cache
  B. A separate NFS interface is required for use across Linux, UNIX and Windows platform
  C. It uses the operating system kernel NFS layer for user tasks and network communication modules
  D. File systems need not be mounted by the Kernel NFS system when being served through Direct NFS
  E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver
  A. It bypasses the OS file system cache
  E. Oracle Disk Manager can manage NFS on its own, without using the operating system kernel NFS driver

• Question 42:

  A PL/SQL procedure queries only thosecolumns of a redefined table that were unchanged by the online table redefinition. What happens to the PL/SQL procedure after the online table redefinition?

  A. It remains valid
  B. It becomes invalid for all options of online table redefinition but automatically gets revalidated the next time it is used
  C. It becomes invalid for all options of online table redefinition and is automatically recompiled during online redefinition of the table
  D. It becomes invalid only if the storage parameters have been modified and it automatically gets revalidated the next time it is used
  A. It remains valid

• Question 43:

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

  You have a range-partitioned table in your database. Each partition in the table contains the sales data for a quarter. The partition related to the current quarter is modified frequently and other partitions undergo fewer data manipulations. The preferences for the table are set to their default values. You collect statistics for the table using the following command in regular intervals:

  SQL>EXECUTE DBMS_STATS.GATHER_TABLE_STATS(`SH','SALES',GRANULARITY=>'GLOBAL')

  You need statistics to be collected more quickly. What can you do to achieve this?

  A. Set DYNAMIC_SAMPLING to level 4
  B. Set the STATISTICS_LEVEL parameter to BASIC
  C. Set the INCREMENTAL value to TRUE for the partition table
  D. Increase the value of STALE_PERCENT for the partition table
  C. Set the INCREMENTAL value to TRUE for the partition table

• Question 45:

  See the Exhibit:

  

  You receive this error regularly and have to shut down the database instance to overcome the error. What can the solution be to reduce the change of this error in future, when implemented?

  A. Locking the SGA in memory
  B. Automatic memory management
  C. Increasing the value of SGA_MAX_SIZE
  D. Setting the PRE_PAGE_SGA parameter to TRUE
  B. Automatic memory management

• Question 46:

  You want the Automatic SQL Tuning processto stop accepting and implementing the recommended SQL profiles automatically. Which action would you perform to achieve this?

  A. Edit the automatic maintenance window group configuration
  B. Set the CURSOR_SHARING parameter to EXACT for the database instance
  C. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to FALSE
  D. Set the SQLTUNE_CATEGORY parameter to DEFAULT for the database instance
  C. Use the DBMS_SQLTUNE.SET_TUNING_TASK_PARAMETERS procedure to set ACCEPT_SQL_PROFILES to FALSE

• Question 47:

  You executed the following script:

  SQL>@utlrp.sql

  What is the significance ofexecuting 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

• Question 48:

  See the following PL/SQL block of statements:

  

  Which statement is correct regarding the above PL/SQL block?

  A. It reserves 30% of the space in the SYSTEM tablespace for SMB
  B. It reserves 30% of the space in the SYSAUX tablespace for SQL Management Base (SMB)
  C. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace
  D. It automatically purges the SQL management objects when SMB occupies more than 30% of the SYSAUX tablespace
  C. It generates a weekly warning in the alert log file when SMB occupies more than 30% of the SYSAUX tablespace

• Question 49:

  The Oracle Database 11g database is running in the ARCHIVELOG mode. The archived redo log files are stored on three locations. The Flash Recovery Area is one of the locations. The details are given below:

  LOG_ARCHIVE_DEST_1 = `LOCATION = /disk1/archive'

  LOG_ARCHIVE_DEST_2 = `SERVICE = stdb1'

  DB-RECOVERY_FILE_DEST = `/u01/oradata'

  Examine the following RMAN command is used to set the deletion policy for archived log files:

  RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED up 2 TIMES TO sbt;

  Which statement is true regarding what this command accomplishes?

  A. All archived redo log files backed up at least twice to tape are deleted
  B. All archived redo log files backed up at least once to tape are eligible for deletion
  C. All archived redo log files backed up at least twice to tape are deleted from the flash recovery area
  D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion
  D. All archived redo log files in local archiving destinations and the flash recovery area backed up at least twice to tape are eligible for deletion

• Question 50:

  Which two initialization parameterswould you set to enable Automatic Shared Memory Management? (Choose two.)

  A. SET SHARED_POOL_SIZE to zero
  B. Set STATISTICS_LEVEL to BASIC
  C. SET SGA_TARGET to a non-zero value
  D. Set DB_CACHE_SIZE to a non-zero value
  E. Set STATISTICS_LEVEL to TYPICAL or ALL
  C. SET SGA_TARGET to a non-zero value
  E. Set STATISTICS_LEVEL to TYPICAL or ALL