Which three functions are performed by the SQL Tuning Advisor？（） 

A . admission control B . DSCP classification C . monitoring D . marking E . scheduling

A . They accept only a single argument  B . They can be nested only to two levels  C . Arguments can only be column values or constants  D . They always return a single result row for every row of a queried table  E . They can return a data type value different from the one that is referenced

A . synchronizes FIFO， PQ， CQ， and MDRR， with WFQ， CBWFQ， and LLQ B . enables strict priority queuing for voice traffic， and weighted round robin queuing for data traffic C . enables low latency queuing to ensure that voice traffic receives priority treatment D . enforces a trust boundary on switch access ports and uplinks/downlinks  E . modifies queue sizes as well as queue weights where required  F . adjusts link speeds to adapt to QoS need

A .  connects traditional telephony devices to voice over IP infrastructure B .  converts analog signals to digital format C .  performs voice compression D .  performs call processing E .  performs dial plan administration F .  performs signaling and device control

A . It accepts both a built-in and a key name as argument.  B . If no key trigger is defined, the specified built-in executes.  C . Its parameter must be specified in upper case, enclosed in single quotation marks.  D . It performs the same task as if you pressed the function key associated with the specified argument.  E . It executes the key trigger that corresponds to the built-in specified as its parameter.&e

A . string B . character C . integer D . calendar E . numeric F . translation G . date H . conversio

A . provide far-end call control  B . provide far-end camera control  C . translate analog voice to packetized voice  D . transition call path between different networks  E . provide locations-based call admission control&e

A . A final method in class X can be abstract if and only if X is abstract. B . A protected method in class X can be overridden by any subclass of X. C . A private static method can be called only within other static methods in class X. D . A non-static public final method in class X can be overridden in any subclass of X. E . A public static method in class X can be called by a subclass of X without explicitly referencing the class X. F . A method with the same signature as a private final method in class X can be implemented in a subclass of X. G . A protected method in class X can be overridden by a subclass of X only if the subclass is in the same package as X.

A . cloud computing B . consumerization C . collaboration D . virtualization E . digital media F . borderless network

A .  It creates jobs without considering the priorities associated with them. B .  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. E .  It maintains a repository in the SYSTEM tablespace to store the history of the execution of all tasks.

A . cannot be nested B . manipulate data items C . act on each row returned D . return one result per row E . accept only one argument and return only one value F . accept arguments which can be a column or an expressio

A . You can use aggregate functions in any clause of a SELECT statement. B . You can use aggregate functions only in the column list of the select clause and in the WHERE clause of a SELECT statement. C . You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns. D . You can pass column names, expressions, constants, or functions as parameter to an aggregate function. E . You can use aggregate functions on a table, only by grouping the whole table as one single group. F . You cannot group the rows of a table by more than one column while using aggregate functions.

A . Building the SQL profile B . Recommending optimization of materialized views C . Checking query objects for missing and stale statistics D . Recommending bitmap, function-based, and B-tree indexes E . Recommending restructuring SQL queries that are using bad pla

A .  The default constructor initializes method variables. B .  The default constructor has the same access as its class. C .  The default constructor invoked the no-arg constructor of the superclass. D .  If a class lacks a no-arg constructor， the compiler always creates a default constructor.  E .  The compiler creates a default constructor only when there are no other constructors for the class.

A .  voice stream mixing for conference calling B .  voice gateway C .  call admission control D .  analog or digital phone interfaces E .  XML application services F .  large scale dial plan applicatio

A . monitors performance B . manages JVM memory C . serves J2EE applications D . manages the deployment manager E . manages configuration synchronization F . routes administrative requests to server

A . TRIM B . REPLACE C . TRUNC D . TO_DATE E . MOD F . CASE

A .  Authentication   B .  Mobility C .  Security management D .  Transmission of beacon frames E .  Real-time portions of MAC management F .  Real-time aspects of the 802.11 prtocol management G .  SNMP collectio

A .  A lightweight AP receives control and configuration from a WLAN controller to which it is associated. B .  A WLAN client that is operating in half-duplex mode will delay all clients in that WLAN C .  A dhoc mode allows mobile clients to connect directly without an intermediate AP D .  Another term for infrastructure mode is independent service set （IBSS） E .  The Aironet 1230 access point is an example of an access point that operates solely as a lightweight  access point. F .  WLANs are designed to share the medium and can easily handle an increased demand of channel  contention.

A . Building the SQL profile B . Recommending optimization of materialized views C . Checking query objects for missing and stale statistics D . Recommending bitmap, function-based, and B-tree indexes E . Recommending restructuring SQL queries that are using bad pla

A .  They can accept only one argument. B .  They can be nested up to only two levels. C .  They can return multiple values of more than one data type. D .  They can be used in SELECT， WHERE， and ORDER BY clauses.   E .  They can modify the data type of the argument that is referenced. F .  They can accept a column name， expression， variable name， or a user-supplied constant as arguments.

A . Constraints provide data independence. B . Constraints make complex queries easy. C . Constraints enforce rules at the view level. D . Constraints enforce rules at the table level. E . Constraints prevent the deletion of a table if there are dependencies. F . Constraints prevent the deletion of an index if there are dependencies.

A . Building and implementing SQL profiles B . Recommending the optimization of materialized views C . Checking query objects for missing and stale statistics D . Recommending bitmap, function-based, and B-tree indexes E . Recommending the restructuring of SQL queries that are using bad pla