Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 591:

  When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?

  A. INCLUDING DEPENDENCIES
  B. INCLUDING DEPENDENCIES CASCADE
  C. COMPACT
  D. CASCADE
  E. None of the above
  D. CASCADE

• Question 592:

  Which of the following tasks does the tool Incident Packaging Service (IPS) perform?

  A. Cleans up the ADR by deleting files not associated with an incident uploaded to Oracle Support.
  B. Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle Support.
  C. Automatically opens a Service Request with Oracle Support for each critical error and sends all relevant files.
  D. Displays a high-level view of critical errors on the database home page.
  B. Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle Support.

• Question 593:

  What elements of globalization can be explicitly defined using the NLS_LANG environment variable? (Choose all that apply.)

  A. NLS_LANGUAGE
  B. NLS_SORT
  C. NLS_CALENDAR D. NLS_CHARACTERSET
  E. NLS_TERRITORY
  A. NLS_LANGUAGE
  E. NLS_TERRITORY

• Question 594:

  In a Database Replay workload capture, what client request information is gathered? (Choose all that apply.)

  A. SQL text
  B. Shared server requests (Oracle MTS)
  C. Bind variable values
  D. Information about transactions
  E. Remote DESCRIBE and COMMIT operations
  A. SQL text
  C. Bind variable values
  D. Information about transactions

• Question 595:

  When creating a SQL tuning set, which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values?

  A. Filter versions
  B. Filter loads
  C. Filter tasks
  D. Filter options
  D. Filter options

• Question 596:

  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 create the LOB.
  B. It forces SecureFiles to be created even if the BASICFILE option is specified to create 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 create the LOB.

• Question 597:

  Which two statements are true about encrypting RMAN backup? (Choose two.)

  A. The transparent encryption of backups uses the encryption wallet
  B. The database uses the same encryption key for every encrypted backup
  C. The password encryption of backups only uses the password while creating and restoring backup
  A. The transparent encryption of backups uses the encryption wallet
  C. The password encryption of backups only uses the password while creating and restoring backup

• Question 598:

  You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)

  A. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
  B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.
  C. The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.
  D. ASM compatibility controls which features for the ASM will be enabled.
  A. The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.
  B. RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.
  D. ASM compatibility controls which features for the ASM will be enabled.

• Question 599:

  When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?

  A. The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET.
  B. The V$PGA_TARGET_ADVICE view shows how the V$SQL_WORKAREA histogram will change if you change the value of PGA_AGGREGATE_TARGET.
  C. The V$PGA_TARGET_ADVICE_HISTOGRAM view shows how the V$SQL_WORKAREA_HISTOGRAM will change if you switch between Manual and Automatic PGA Memory Management.
  D. The V$PGA_TARGET_ADVICE view shows how performance will improve for the different work areas if you switch from Manual to Automatic PGA Memory Management.
  A. The V$PGA_TARGET_ADVICE view shows the predicted cache hit-ratio improvement if you increase PGA_AGGREGATE_TARGET.

• Question 600:

  When performing a database duplication, which duplicate database parameter would you set to ensure that the online redo logs are created in the correct location?

  A. log_file_name_convert
  B. convert_log_file_name
  C. file_name_convert_log
  D. redo_log_file_name_convert
  E. logfile_convert_directory
  A. log_file_name_convert