WorksheetsCisco Collaboration Quick Assessment
Total questions: 34
Worksheet time: 17mins
Gateways and Trunks comes under?
Route List
Route Group
Route Pattern
Device
Which technology is used for real-time communication between endpoints in a Cisco Collaboration network?
SIP
H323
MGCP
RTP
Which Cisco Collaboration component provides voice messaging and unified messaging services?
Cisco Unified Communications Manager
Cisco Webex Meetings
Cisco Unity Connection
Cisco Jabber
Which protocol is used for call control in a Cisco Collaboration network?
H323
SIP
SCCP
MGCP
Which Cisco Collaboration component is used for telepresence and video conferencing?
Cisco Webex Meetings
Cisco Telepresence Server
Cisco Unified Communications Manager
Cisco Jabber Voice
Which of the below is not a function of Cisco CUCM in standalone Mode?
Phone Registration
Call Routing
Instant Messaging
Digit Manipulation
What are the names of the two types of mode that are used in Python? Select two.
Interactive mode
Scratch mode
Imperial mode
Script mode
Code for
b is greater than a
a = 33
b = 200
if b > a:
print("b is greater than a")
a = 33
b = 200
if b < a:
print("b is greater than a")
a = 330
b = 200
if b > a:
print("b is greater than a")
Insert the missing part of the code below to output
_________________ "My name is ".
Python has a simple syntax similar to the
coding language
english language
spanish language
DML
(a)
What is a field?
A collection of information
A single item of information
A list of information
A group of records
Using which word allows you to specify that only one of a series of conditions needs to be met in a query filter?
And
Maybe
If
Or
To remove a record from a table which SQL statement would you use?
Remove
Cancel
Delete
Eradicate
______________ constraint prevents NULL values
UNIQUE
NOT NULL
NULL
FOREIGN KEY
Which two constraints apply to PRIMARY KEY?
Unique
Non-null
Alphanumeric
ASCII
Which join returns all records when there is a match in either left or right table?
Full Join
Inner Join
Left Join
Right Join
Find the name of those cities with temperature and condition whose condition is either sunny or cloudy but temperature must be greater than 70.
SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ OR temperature > 70
SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ OR temperature > 70
SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ OR condition = ‘cloudy’ AND temperature > 70
SELECT city, temperature, condition FROM weather WHERE condition = ‘sunny’ AND condition = ‘cloudy’ AND temperature > 70
Which statement allows us to add a record to a table?
Add To
Update To
Add Into
Insert Into
Which clause is used in query to place the condition on groups in MySQL?
where
Having
group by
order by
Which of the following can be used to make a Dataframe?
Series
DataFrame
Structured ndarray
All of the above
Which of the following object you get after reading CSV file?
DataFrame
Character Vector
Panel
All of the mentioned
What will be output for the following code?
import pandas as pd
s = pd.Series([1,2,3,4,5],index = ['a','b','c','d','e'])
print(s['a'])
1
2
3
4
5
To add line description to a device's primary line, which AXL method is best? (Given that dirn no. details are provided)
addLine
updateLine
addPhone
updatePhone
Are Git and GitHub the same thing?
Yes
No
____ removes untracked files from your working directory.
git commit
git clean -f
git clean
git reset
GitHub participants must wait for one to finish working to start the next
True
False
I am a restaurant manager I want to remove a dish from my menu, which method should I not use?
delete
get
post
patch
Primary key from another table.
Primary Key
Foreign Key
Normalization
CRUD
Constraint
Which of these method is equivalent to Update in CRUD operation?
PUT
POST
DELETE
PATCH
Identity Validation is done by-
Authorization
Authentication
