-
Which two of these Cisco Catalyst are distribution-area switches？ （）
A . Catalyst 2800/E Series
B . Catalyst 3750 Series
C . Catalyst 3900/E Series
D . Catalyst 4500/E Series
E . Catalyst 6500/E Serie
-
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 about the function of CAC？ （）
A . CAC provides guaranteed voice quality on a link.
B . CAC artificially limits the number of concurrent voice calls.
C . CAC is used to control the amount of bandwidth that is taken by a call on a link.
D . CAC prevents oversubscription of WAN resources that is caused by too much voice traffic.
E . CAC allows an unlimited number of voice calls while severely restricting， if necessary， other forms of traffic.
F . CAC solves voice congestion problems by using QoS to give priority to UDP traffic.
-
For which two actions can you use the TO_DATE function? （）
A . convert any date literal to a date
B . convert any numeric literal to a date
C . convert any date to a character literal
D . format 'January 10 1999' for input
E . format '10-JAN-99' to 'January 10 1999'
-
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
-
Into which two types of areas would an area border router (ABR) inject a default route?（）
A . stub
B . the autonomous system of an exte rior gateway protocol (EGP)
C . NSSA
D . totally stubby
E . the autonomous system of a different interior gateway protocol (IGP)
F . area 0
-
Which two statements about the QoS functionality of the Cisco SDM are true？（）
A . the first step when using the SDM QoS wizard is to select the inbound interface on which the QoS policy must be applied
B . the SDM QoS wizard can be used to optimize LAN， WAN， and VPN interfaces
C . he SDM QoS wizard supports network-based application recognition （NBAR） to provide deep and stateful packet inspection
D . he SDM QoS wizard will apply custom queuing and priority queuing policies to the identified interfaces
E . he SDM QoS wizard will apply low latency-queuing，custom-queuing and priority-queuing policies to the identified interfaces
F . to create and manage the QoS settings， the user must select the QoS wizard task under the Monitor optio
-
Which two Cisco router functional planes are protected by Control Plane Policing （COPP）？（）
A . data plane
B . control plane
C . service plane
D . management plane
E . hyper plane
-
Which two functions does Cisco Configuration Assistant provide?（）
A . wireless connectivity
B . call routing configuration
C . device discovery
D . call forwarding
E . command line configuratio
-
Which two statements are true about Shared SQL Area and Private SQL Areas（）
A . Shared SQL Area will be allocated in the shared pool.
B . Shared SQL Area will be allocated when a session starts.
C . Shared SQL Area will be allocated in the large pool always.
D . The whole of Private SQL Area will be allocated in the Program Global Area （PGA） always.
E . Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
F . The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.
-
Which two functions does Cisco Configuration Assistant provide？（）
A . device Discovery
B . call forwarding
C . call routing configuration
D . command line configuration
E . wireless connectivity
-
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
-
For which two situations would you use functionality provided by the Resource Manager? （）(Choose two.)
A . setting idle timeout limits on resource plans
B . saving storage space by using compressed backup sets
C . creating jobs that will run automatically at a scheduled time
D . assigning priorities to jobs to manage access to system resources
E . creating alerts to perform notification when tablespaces are low on available space resource
-
Which two tasks can your perform by using the TO_CHAR function? （）
A . Convert 10 to 'TEN'
B . Convert '10' to 10
C . Convert '10' to '10'
D . Convert 'TEN' to 10
E . Convert a date to a character expression
F . Convert a character expression to a date
-
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 two of these statements best describe the benefits of Cisco’s wireless IDS functionality？ （Choose two.） （）
A . AirDefense for wireless IDS is required by autonomous APs.
B . 2.40Hz CK management can monitor both 802.11 and non-802.11 CK interference.
C . APs only monitor the RF channels that are servicing the clients.
D . Cisco or CCX compatible client cards can extend the CK IDS service for autonomous APs.
E . Autonomous APs must be dedicated IDS sensors while lightweight APs can combine client traffic and RF monitoring.
-
Which two tasks can you perform using only the TO_CHAR function? （）
A . convert 10 to 'TEN'
B . convert '10' to 10
C . convert 10 to '10'
D . convert 'TEN' to 10
E . convert a date to a character expression
F . convert a character expression to a date
-
Which two tasks can your perform by using the TO_CHAR function?（）
A . Convert 10 to ‘TEN’
B . Convert ‘10’ to 10
C . Convert ‘10’ to ‘10’
D . Convert ‘TEN’ to 10
E . Convert a date to a character expression
F . Convert a character expression to a date
-
Which two provide intra -area routing services?（）
A . L1 ES
B . L2 IS
C . L2 ES
D . L1 IS
E . L1/L2 IS
-
Which two are character manipulation functions?（）
A . TRIM
B . REPLACE
C . TRUNC
D . TO_DATE
E . MOD
F . CASE
-
Which two statements are true about the function of CAC？（）
A . CAC provides guaranteed voice quality on a link.
B . CAC artificially limits the number of concurrent voice calls.
C . CAC is used to control the amount of bandwidth that is taken by a call on a link.
D . CAC prevents oversubscription of WAN resources that is caused by too much voice traffic.
E . CAC allows an unlimited number of voice calls while severely restricting，if necessary，other forms of traffic.
F . CAC solves voice congestion problems by using QoS to give priority to UDP traffic.
-
Which two statements describe the functions and operations of IDS and IPS systems？（）
A . A network administrator entering a wrong password would generate a true-negative alarm.
B . A false positive alarm is generated when an IDS/IPS signature is correctly identified.
C . An IDS is significantly more advanced over IPS because of its ability to prevent network attacks.
D . Cisco IDS works inline and stops attacks before they enter the network.
E . Cisco IPS taps the network traffic and responds after an attack.
F . Profile-based intrusion detection is also known as "anomaly detection".
-
Which two statements are true about Shared SQL Area and Private SQL Area（）
A . Shared SQL Area will be allocated in the shared pool.
B . Shared SQL Area will be allocated when a session starts.
C . Shared SQL Area will be allocated in the large pool always.
D . Private SQL Area will be allocated in the Program Global Area （PGA） always.
E . Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.
F . The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.
