-
Which two IntServ functions are required on a router?()
A . admission control
B . DSCP classification
C . monitoring
D . marking
E . scheduling
-
Which two statements are true regarding single row functions?()
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
-
What are three of the functions that AutoQoS performs when it is configured on a switch?()
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
-
Which three statements describe the functionality of the DO_KEY built-in?()
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
-
Which four are types of functions available in SQL? ()
A . string
B . character
C . integer
D . calendar
E . numeric
F . translation
G . date
H . conversio
-
Which two are functions of an IP voice gateway?()
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
-
Which three statements are true?()
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.
-
Which three are Cisco architectures?()
A . cloud computing
B . consumerization
C . collaboration
D . virtualization
E . digital media
F . borderless network
-
Which three statements are true regarding the functioning of the Autotask Background Process (ABP)?()
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.
-
Which four are attributes of single row functions? ()
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
-
Which two are true about aggregate functions?()
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.
-
Which three functions are performed by the SQL Tuning Advisor? ()
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
-
Which three statements are true?()
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.
-
Which three functions are performed by the SQL Tuning Advisor?()
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
-
Which three functions can an Integrated Services Router perform in a VoIP network?()
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
-
What are three functions of a WebSphere Node Agent?()
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
-
Which two are character manipulation functions?()
A . TRIM
B . REPLACE
C . TRUNC
D . TO_DATE
E . MOD
F . CASE
-
What are three functions of the Cisco wireless LAN controller, which is being used in the Company Centralized WLAN solution network? ()
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
-
Which three WLAN statements are true? (Choose three.) ()
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.
-
Which three functions are performed by the SQL Tuning Advisor?() (Choose three.)
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
-
Which three statements are true regarding single-row functions?()
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.
-
Which three statements correctly describe the functions and use of constraints? ()
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.
-
Which three functions are performed by the SQL Tuning Advisor?()
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