Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 91:

  Which two statements are true with respect to the maintenance window? (Choose two.)

  A. A DBA can enable or disable an individual task in all maintenance windows
  B. A DBA cannot change the duration of the maintenance window after it is created.
  C. In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.
  D. A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.
  A. A DBA can enable or disable an individual task in all maintenance windows
  D. A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.

• Question 92:

  Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:

  ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;

  What would be the outcome of this command?

  A. It produces an error because data already exists in the table.
  B. It produces an error because compression can be enabled at table creation only.
  C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
  D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.
  C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.

• Question 93:

  Which statements are true regarding the Query Result Cache? (Choose all that apply.)

  A. It can be set at the system, session, or table level.
  B. It is used only across statements in the same session.
  C. It can store the results from normal as well as flashback queries.
  D. It can store the results of queries based on normal, temporary, and dictionary tables.
  A. It can be set at the system, session, or table level.
  C. It can store the results from normal as well as flashback queries.

• Question 94:

  You decided to use Direct NFS configuration in a non-RAC Oracle installation and created the oranfstab file in /etc. Which two statements are true regarding this oranfstab file? (Choose two.)

  A. Its entries are specific to a single database.
  B. It contains file systems that have been mounted by Direct NFS.
  C. It is globally available to all Oracle 11 g databases on the machine.
  D. It contains file systems that have been mounted by the kernel NFS system.
  C. It is globally available to all Oracle 11 g databases on the machine.
  D. It contains file systems that have been mounted by the kernel NFS system.

• Question 95:

  Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?

  A. AWR baselines are always created as repeating baselines.
  B. AWR baselines can be created on the basis of two time values.
  C. AWR baselines are always created with infinite expiration duration.
  D. AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expiration duration.
  B. AWR baselines can be created on the basis of two time values.

• Question 96:

  You are managing an Oracle 11 g database with ASM storage, for which the COMPATIBLE initialization parameter is set to 11.1.0. In the ASM instance, the COMPATIBLE.RDBMS attribute for the disk group is set to 10.2 and the COMPATIBLE .ASM attribute is set to 11.1.

  Which two statements are true in this scenario for the features enabled for ASM? (Choose two.)

  A. The ASM-preferred mirror read feature is enabled.
  B. The ASM supports variable sizes for extents of 1. 8. and 64 allocation units.
  C. The ASM disk is dropped immediately from a disk group when it becomes unavailable.
  D. The RDBMS always reads the primary copy of a mirrored extent of the ASM disk group.
  A. The ASM-preferred mirror read feature is enabled.
  B. The ASM supports variable sizes for extents of 1. 8. and 64 allocation units.

• Question 97:

  Which two are the uses of the ASM metadata backup and restore (AMBR) feature? (Choose two.)

  A. It can be used to backup all data on ASM disks.
  B. It can be used to re-create the ASM disk group with its attributes.
  C. It can be used to recover the damaged ASM disk group along with the data.
  D. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.
  B. It can be used to re-create the ASM disk group with its attributes.
  D. It can be used to gather information about a preexisting ASM disk group with disk paths, disk name, failure groups, attributes, templates, and alias directory structure.

• Question 98:

  You are working on a CATDB database that contains an Oracle Database version 11.1 catalog schema owned by the userRC011. The INST1 database contains an Oracle Database version 10.1 catalog schema owned by the user RCAT10.

  You want the RMAN to import metadata for database IDs 1423241 and 1423242, registered in RCAT10, into the recovery catalog owned by RC011. You executed the following commands:

  RMAN> CONNECT CATALOG rco11/password@catdb

  RMAN> IMPORT CATALOG rcat1 0/oracle@inst1 NO UNREGISTER;

  Which two statements are true regarding the tasks accomplished with these commands? (Choose two.)

  A. They import all metadata from the RCAT10 catalog.
  B. They unregister the database from the RCAT10 catalog.
  C. They do not register the databases registered in the RCAT10 catalog.
  D. They register all databases registered in the RCAT10 catalog.
  A. They import all metadata from the RCAT10 catalog.
  D. They register all databases registered in the RCAT10 catalog.

• Question 99:

  View the Exhibit to examine the error during the database startup.

  

  You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:

  RMAN> REPAIR FAILURE;

  Which statement describes the consequence of the command?

  A. The command performs the recovery and closes the failures.
  B. The command only displays the advice and the RMAN script required for repair.
  C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command
  D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).
  C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command

• Question 100:

  Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?

  A. The database must be running in ARCHIVELOG mode.
  B. No special setup is required, and the feature is enabled by default.
  C. The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.
  D. The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.
  E. Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11 g software, provide valid MetaLink credentials and select license agreement.
  E. Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11 g software, provide valid MetaLink credentials and select license agreement.