Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 81:

  The following databases are registered in the base recovery catalog: PROD1 ,, PROD2, and PROD3. The database user CAT OWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1

  database and create a virtual private catalog.

  Given below are some of the commands required to achieve this:

  1 .SQL> GRANT recovery_catalog_owner TO vpc1;

  2.

  RMAN> CONNECT CATALOG vpc1/password@catdb;

  3.

  RMAN> GRANT CATALOG FOR DATABASE prod1 TO vpc1;

  4.

  RMAN> CONNECT CATALOG catowner/password@catdb;

  5.

  RMAN> CREATE VIRTUAL CATALOG;

  What is the correct sequence in which the commands have to be executed?

  A. 1,4,5,2,3
  B. 1,4,3,2,5
  C. 4,5,2,3, 1
  D. 2,3,4,5, 1
  E. 1,4,2,3,5
  B. 1,4,3,2,5

• Question 82:

  Evaluate the following block of code

  BEGIN

  DBMS_NETWORK_ACL_ADMIN.CREATE_ACL(

  acl => lmycompany-com-permissions.xmll1

  principal => 'ACCTJvlGR1,

  is_grant => TRUE,

  privilege => 'connect');

  DBMS_NETWORK_ACL_ADMIN.ASSIGN_ACL(

  acl => 'mycompany-com-permissions.xml',

  host => ".mycompany.com');

  END;

  What is the outcome of the above code?

  A. It produces an error because a fully qualified host name needs to be specified.
  B. It produces an error because the range of ports associated with the hosts has not been specified.
  C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges
  D. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT privilege but not the RESOLVE privilege.
  C. It creates an access control list (ACL) with the user ACCT_MGR who gets the CONNECT and RESOLVE privileges

• Question 83:

  Which two activities are NOT supported by the Data Recovery Advisor? (Choose two.)

  A. Diagnose and repair a data file corruption offline.
  B. Diagnose and repair a data file corruption online.
  C. Diagnose and repair failures on a standby database.
  D. Recover from failures in the Real Application Cluster (RAC) environment.
  C. Diagnose and repair failures on a standby database.
  D. Recover from failures in the Real Application Cluster (RAC) environment.

• Question 84:

  You executed the following commands:

  SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false; SQL> EXECUTE DBMS_STATS.SET_TABLE_PREFS('SHI, 'CUSTOMERS', 'PUBLISH'.'false'); SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS

  ('SH', 'CUSTOMERS');

  Which statement is correct regarding the above statistics collection on the SH.CUSTOMERS table in the above session?

  A. The statistics are stored in the pending statistics table in the data dictionary.
  B. The statistics are treated as the current statistics by the optimizer for all sessions.
  C. The statistics are treated as the current statistics by the optimizer for the current sessions only.
  D. The statistics are temporary and used by the optimizer for all sessions until this session terminates.
  A. The statistics are stored in the pending statistics table in the data dictionary.

• Question 85:

  Which two statements are true regarding the functionality of the remap command in ASMCMD? (Choose two.)

  A. It repairs blocks that have read disk I/O errors
  B. It checks whether the alias metadata directory and the file directory are linked correctly.
  C. It repairs blocks by always reading them from the mirror copy and writing them to the original location.
  D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.
  A. It repairs blocks that have read disk I/O errors
  D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.

• Question 86:

  Which three statements correctly describe the features of the I/O calibration process? (Choose three.)

  A. Only one I/O calibration process can run at a time
  B. It automates the resource allocation for the Automated Maintenance Tasks.
  C. It improves the performance of the performance-critical sessions while running.
  D. It can be used to estimate the maximum number of l/Os and maximum latency time for the system.
  E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.
  A. Only one I/O calibration process can run at a time
  D. It can be used to estimate the maximum number of l/Os and maximum latency time for the system.
  E. The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.

• Question 87:

  You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive?

  A. Drop the table.
  B. Partition the table
  C. Truncate the table.
  D. Add a column to the table.
  E. Rename a column in the table.
  D. Add a column to the table.

• Question 88:

  Examine the following command:

  ALTER DISKGROUP data MOUNT FORCE;

  In which scenario can you use the above command to mount the disk group?

  A. when ASM disk goes offline
  B. when one or more ASM files are dropped
  C. when some disks in a disk group are offline
  D. when some disks in a failure group for a disk group are rebalancing
  C. when some disks in a disk group are offline

• Question 89:

  Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.)

  A. It translates tasks into jobs for execution by the scheduler
  B. It creates jobs without considering the priorities associated with them.
  C. It determines the list of jobs that must be created for each maintenance window.
  D. It is spawned by the MMON background process at the start of the maintenance window.
  E. It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.
  A. It translates tasks into jobs for execution by the scheduler
  C. It determines the list of jobs that must be created for each maintenance window.
  D. It is spawned by the MMON background process at the start of the maintenance window.

• Question 90:

  Which two statements are true regarding the starting of the database instance using the following command? (Choose two.) SQL>STARTUP UPGRADE

  A. It enables all system triggers.
  B. It allows only SYSDBA connections.
  C. It ensures that all job queues remain active during the upgrade process.
  D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.
  B. It allows only SYSDBA connections.
  D. It sets system initialization parameters to specific values that are required to enable database upgrade scripts to be run.