Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 141:

  In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL

  and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:

  $ SQLPLUS scott/tiger@DB01 AS SYSDBA

  where DB01 is the net service name.

  Which authentication method would be used first?

  A. authentication by password file
  B. authentication by using certificates over SSL
  C. authentication by using the Oracle Internet Directory
  D. authentication by using the local OS of the database server
  A. authentication by password file

• Question 142:

  View the Exhibit for some of the parameter settings.

  

  You start a session and issue the following command:

  SQL>CREATE INDEX emp_ename ON emp(ename)

  TABLESPACE users INVISIBLE;

  What is the outcome of the above command?

  A. The index is not used by the optimizer but is maintained during DML operations.
  B. The index is not used by the optimizer and is not maintained during DML operations.
  C. The index is used by the optimizer only if a hint is specified in the query statement and is maintained during DML operations.
  D. The index is used by the optimizer only if a hint is specified in the query statement but is not maintained during DML operations.
  A. The index is not used by the optimizer but is maintained during DML operations.

• Question 143:

  You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure. Which statements will be true in this scenario? (Choose all that apply.)

  A. The disk automatically goes offline.
  B. The disk is immediately dropped from the disk group.
  C. The ASM tracks the extents that are modified during the outage.
  D. The ASM migrates the extents from the unavailable disk to the remaining disks.
  A. The disk automatically goes offline.
  C. The ASM tracks the extents that are modified during the outage.

• Question 144:

  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 recover catalog owned by RC011. You also want to deregister them from the catalog after import.

  You executed the following commands to achieve this:

  RMAN> CONNECT CATALOG rco1 1/password@catdb

  RMAN> IMPORT CATALOG rcat1 0/oracle@inst1 DBID=1423241,1423242;

  What happens if the RC011 catalog has scripts with the same name as that of the scripts in RCAT10 catalog?

  A. The scripts in the RC011 catalog are overwritten.
  B. RMAN renames the local stored scripts in the RC011 catalog.
  C. The RMAN session in which the command is executed aborts.
  D. RMAN renames the global scripts that are imported from the RCAT10 catalog.
  D. RMAN renames the global scripts that are imported from the RCAT10 catalog.

• Question 145:

  You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script: SQL>@utlu111 i.sql

  Which statement about the execution of this script is true?

  A. It must be executed from the Oracle Database 11 g environment.
  B. It must be executed only after the SYSAUX tablespace has been created.
  C. It must be executed from the environment of the database that is being upgraded
  D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
  E. It must be executed from both the Oracle Database 11 g and Oracle Database 9i environments.
  C. It must be executed from the environment of the database that is being upgraded

• Question 146:

  The Database Resource Manager is automatically 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 Tasks 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 amounts of system resources
  D. to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources

• Question 147:

  Which two statements are true regarding Health Monitor checks in Oracle Database 11g? (Choose two.)

  A. Health Monitor checks are always initiated manually when there is some critical error.
  B. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption
  C. Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically.
  D. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.
  B. Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption
  D. Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible, corrupt or inconsistent.

• Question 148:

  Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g? (Choose all that apply.)

  A. Generate reports on data failure such as data file failures,
  B. You can package and upload diagnostic data to Oracle Support.
  C. You can track the Service Request (SR) and implement repairs.
  D. You can manually run health checks to gather diagnostic data for a problem.
  B. You can package and upload diagnostic data to Oracle Support.
  C. You can track the Service Request (SR) and implement repairs.
  D. You can manually run health checks to gather diagnostic data for a problem.

• Question 149:

  View the Exhibit to examine the Automatic SQL Tuning result details.

  

  Which action would you suggest for the selected SQL statement in the Exhibit?

  A. Accept the recommended SQL profile.
  B. Collect statistics for the related objects.
  C. Run the Access Advisor for the SQL statement.
  D. Run the Segment Advisor for recommendations.
  C. Run the Access Advisor for the SQL statement.

• Question 150:

  Which dependent object will get invalidated even if it is not affected by the table redefinition?

  A. views
  B. triggers
  C. packages
  D. synonyms
  B. triggers