Which of the following SQL statements will return the year and average salary for all employees hired within a given year that have a salary greater than $30,000?（）

相似题目

• You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? （）

  A . Library cache  B . Row cache C . Dictionary cache  D . Large area  E . Buffer cache

  查看最佳答案

• Which of the following cannot be used as input to the SQL Tuning Advisor?（） (Choose all that apply.)

  A . A single SQL statement provided by a user B . An existing SQL Tuning Set (STS) C . A preprocessed Database Replay workload D . A schema name E . SQL statement identified in EM as using excessive resource

  查看最佳答案

• 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 optio

  查看最佳答案

• You execute the following command to start an Automatic Storage Management （ASM） instance：   SQL>STARTUP；   In which of the following modes will the ASM instance start？（）

  A .  OPEN B .  MOUNT C .  NORMAL D .  NOMOUNT

  查看最佳答案

• Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems?（）

  A . ADR diagnostic files B . all the optimizer statistics C . initialization parameter settings D . PL/SQL functions, procedures, and packages E . the table and index definitions and actual data

  查看最佳答案

• Which two statements are true regarding the starting of the database instance using the following command?（） 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.

  查看最佳答案

• Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement？（）  

  A .  The SGA Tuning Advisor B .  The SQL Access Advisor C .  The SQL Tuning Advisor D .  The Memory Advisor

  查看最佳答案

• 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>@utlu111i.sql   Which statement about the execution of this script is true？（）

  A .  It must be executed from the Oracle Database 11g 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 11g and Oracle Database 9i environments.

  查看最佳答案

• Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file？（）

  A . ROWS B . SKIP C . LOAD D . BINDSIZE

  查看最佳答案

• You issued the following block of code：        SQL>BEGIN   DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP（        ’PROG_ROLE’， ’DEVELOPERS’ ，FALSE）；        END；        SQL>/   Which option is NOT a result of executing the above code？（）  

  A .  The switch privilege is granted to the PROG_ROLE role. B .  The users granted the role PROG_ROLE will be able to switch to the DEVELOPERS group. C .  The users cannot grant the switch privilege to other users. D .  The above code will not be executed successfully because the GRANT_SWITCH_CONSUMER_GROUP procedure is an invalid procedure in Oracle10g.

  查看最佳答案

• You execute the following command to change the status of the SALES tablespace：  SQL> ALTER TABLESPACE sales OFFLINE；  Which statements describe the effect of the command（）

  A . The tablespace would require recovery to go back online. B . A checkpoint is taken on all data files that are associated with the SALES tablespace. C . The sessions that subsequently try to access the objects in the SALES tablespace receive an error. D . The new status of the SALES tablespace is recorded in the control file when the database instance is closed.

  查看最佳答案

• Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?（）

  A . SQL Repair Advisor B . SQL Optimizer C . SQL Access Advisor D . SQL Tuning Advisor SQL

  查看最佳答案

• 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>@utlu111i.sql Which statement about the execution of this script is true?（）

  A . It must be executed from the Oracle Database 11g 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 11g and Oracle Database 9i environments.

  查看最佳答案

• Which of the following identifies and creates an index to minimize the DB time for a particular SQL statement?（）

  A . The SGA Tuning Advisor B . The SQL Access Advisor C . The SQL Tuning Advisor D . The Memory Advisor

  查看最佳答案

• To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）  

  A .  EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning Advisor B .  EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor C .  EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor D .  Either B or C E .  All of the above

  查看最佳答案

• You execute the following command to change the status of the SALES tablespace：SQL> ALTER TABLESPACE sales OFFLINE； Which statements describe the effect of the command（）

  A . The tablespace would require recovery to go back online. B . A checkpoint is taken on all data files that are associated with the SALES tablespace. C . The sessions that subsequently try to access the objects in the SALES tablespace receive an error D . The new status of the SALES tablespace is recorded in the control file when the database instance isclosed

  查看最佳答案

• Which of the following database objects is considered executable using SQL?（）

  A . View B . Table C . Routine D . Package

  查看最佳答案

• Which of the following IOS commands can detect whether the SQL slammer virus propagates in yournetworks？（）

  A . access-list 100 permit any any udp eq 1434 B . access-list 100 permit any any udp eq 1434 log C . access-list 110 permit any any udp eq 69 D . access-list 110 permit any any udp eq 69 log E . None of above.

  查看最佳答案

• A customer is running business-critical applications on a few SQL servers in their environment.  The customer needs to know if and when the SQL server stops， so the service can be restarted immediately.  Which of the following will accomplish this？（）

  A . Use the Capacity Manager to monitor the processes on the servers.Log the events to the event log and use the resource monitor to restart the SQL process. B . Use the System Availability tool that comes with IBM Director to improve the availability of the SQL applications. C . Use the IBM Director Application PING function to watch the SQL service. When the SQL service goes down， restart the service remotely on the managed server using the software distribution function. D . Utilize Process Management and create a threshold to monitor the SQL process.Create an Event Action Plan and set the task to restart the SQL process when stopped and apply it to the managed SQL servers.

  查看最佳答案

• Which two statements are true regarding the starting of the database instance using the following command？（） 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.

  查看最佳答案

• Which of the following cannot be used as input to the SQL Tuning Advisor？（）

  A .  A single SQL statement provided by a user B .  An existing SQL Tuning Set （STS） C .  A preprocessed Database Replay workload D .  A schema name E .  SQL statement identified in EM as using excessive resource

  查看最佳答案

• Which of the following objects contains control structures that are considered the bound form of SQL statements?（）

  A . UDT B . Trigger C . Package D . Access pla

  查看最佳答案

• Which of the following is a potential performance tuning recommendation from the SQL Access Advisor？（）  

  A .  Create new indexes. B .  Modify existing indexes. C .  Implement partitioning on a nonpartitioned table. D .  Create materialized views. E .  All of the above

  查看最佳答案