Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 61:

  You want the Automatic SQL Tuning process to 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 62:

  While tuning a SQL statement, the SQL Tuning Advisor finds an existing SQL profile for the statement that has stale statistics available. What would the optimizer do in this situation?

  A. It updates the existing SQL profiles with current statistics.
  B. It makes the statistics information available to GATHER_STATS_JOB.
  C. It initiates the statistics collection process by running GATHER_STATS_JOB.
  D. It logs a warning message in the alert log so that the DBA can perform statistics collection manually.
  B. It makes the statistics information available to GATHER_STATS_JOB.

• Question 63:

  Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)

  A. Segment Advisor
  B. SQL Access Advisor
  C. Optimizer statistics gathering
  D. Automatic SQL Tuning Advisor
  E. Automatic Database Diagnostics Monitor
  A. Segment Advisor
  C. Optimizer statistics gathering
  D. Automatic SQL Tuning Advisor

• Question 64:

  You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command: SQL> SELECT dbms_addm.get_report(lmy_instance_analysis_mode_task') FROM dual;

  You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT's segments. What would you do to achieve this?

  A. Add a finding directive for the ADDM task.
  B. Add a segment directive for the ADDM task.
  C. Add a parameter directive for the ADDM task.
  D. Disable the Segment Advisor from the Automatic Maintenance Task.
  B. Add a segment directive for the ADDM task.

• Question 65:

  View the Exhibit to examine the replay settings for replay parameters. What is the implication for setting the values for replay parameters? (Choose all that apply.)

  

  A. The COMMIT order in the captured workload is preserved during replay.
  B. The value 100 in the THINK_TIME_SCALE parameter attempts to make the replay client shorten the think time between calls.
  C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.
  D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.
  E. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions immediately as soon as the replay begins.
  A. The COMMIT order in the captured workload is preserved during replay.
  C. The value 100 in the CONNECT_TIME_SCALE parameter attempts to connect all sessions as captured.
  D. The value 100 in the THINK_TIME_SCALE parameter attempts to match the captured user think time while replaying.

• Question 66:

  USER_DATA is a nonencrypted tablespace that contains a set of tables with data. You want to convert all existing data in the USER_DATA tablespace and the new data into the encrypted format. Which methods would you use to achieve this? (Choose all that apply.)

  A. Use Data Pump to transfer the existing data to a new encrypted tablespace.
  B. Use ALTER TABLE..MOVE to transfer the existing data to a new encrypted tablespace.
  C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.
  D. Enable row movement for each table to be encrypted and then use ALTER TABLESPACE to encrypt the tablespace.
  E. Encrypt the USER_DATA tablespace using the ALTER TABLESPACE statement so that all the data in the tablespace is automatically encrypted.
  A. Use Data Pump to transfer the existing data to a new encrypted tablespace.
  B. Use ALTER TABLE..MOVE to transfer the existing data to a new encrypted tablespace.
  C. Use CREATE TABLE AS SELECT to transfer the existing data to a new encrypted tablespace.

• Question 67:

  View the Exhibit to examine the parameters set for your database instance.

  

  You execute the following command to perform I/O calibration after the declaration of bind variables in the session that are used in the command:

  SQL> EXECUTE dbms_resource_manager.calibrate_io( num_physical_disks=>1, - max_latency=>5u,- max_iops=>:max_iops, max_mbps=>:max_mbps, actual latency=>: actual_latency);

  Which statement describes the consequence?

  A. The command produces an error.
  B. The calibration process runs successfully and populates all the bind variables.
  C. The calibration process runs successfully but the latency time is not computed.
  D. The calibration process runs successfully but only the latency time is computed.
  A. The command produces an error.

• Question 68:

  You are in the process of creating a virtual private catalog in your Oracle Database 11 g database. The PROD1 ,, PROD and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who own

  the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11 g RMAN executables:

  RMAN> GRANT CATALOG FOR DATABASE prod1, prod2 TO vpc1;

  Then you issue the following commands:

  RMAN> CONNECT CATALOG vpc1/oracle@catdb;

  RMAN> SQL "EXEC catowner.dbms_rcvcat.create_virtual_catalog;"

  What is the outcome of the above commands?

  A. They execute and create a virtual catalog for pre-Oracle 11 g clients.
  B. They produce an error because PROD1 and PROD2 databases belong to the older version.
  C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.
  D. They produce an error because you need to connect to the target database to execute this packaged procedure.
  A. They execute and create a virtual catalog for pre-Oracle 11 g clients.

• Question 69:

  View the Exhibit to examine a portion of the output from the VALIDATE DATABASE command.

  

  Which statement is true about the block corruption detected by the command?

  A. No action is taken except the output in the Exhibit.
  B. The corruption is repaired by the command implicitly.
  C. The failure is logged into the Automatic Diagnostic Repository (ADR).
  D. The ADVISE FAILURE command is automatically called to display the repair script.
  C. The failure is logged into the Automatic Diagnostic Repository (ADR).

• Question 70:

  During the installation of Oracle Database 11 g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?

  A. The installation terminates with an error.
  B. The installation proceeds with the default value without warnings and errors.
  C. The installation proceeds with the default value but it would not be an OFA-compliant database.
  D. The installation proceeds with the default value but a message would be generated in the alert log file.
  D. The installation proceeds with the default value but a message would be generated in the alert log file.