Font size
WorksheetsCS / IP Marathon (SQL & CN)
Total questions: 100
Worksheet time: 51mins
What is a firewall in a Computer Network?
The physical boundary of network
An operating system of computer network
A system designed to prevent unauthorized access
A web browsing software
DNS is the abbreviation of :-
Dynamic Name System
Dynamic Network System
Domain Name System
Domain Network Service
________________ provides a connection-oriented reliable service for sending messages.
TCP
IP
UDP
All of the above
The Internet is an example of
Cell switched network
circuit switched network
packet switched network
all of the above
Which of the following is not a networking device?
Gateways
Linux
Routers
Firewalls
Which of the following network devices broadcasts the incoming packets to all the hosts connected to the network?
Switch
Hub
Bridge
Router
Which of these is not a communication channel?
Satellite
Microwave
Radiowave
Wi-Fi
Which of these is not an example of unguided media?
Optical fibre cable
Radio wave
Bluetooth
Satellite
___________ is the measuring unit of speed at which the data transfer takes place
GHz/Second
Hertz/Second
Bytes/Second
Bits/Second
_________ is a dedicated line between the caller and the sender
Packet switching
Circuit switching
Line switching
Message switching
................................ isresponsible for handling the address of the destination computerso that each packet is delivered to its proper destination
IP
TP
TCP
MAC
The techniques of switching in which data is fragmented into smaller techniques is called ..............
Circuit switching
Message switching
Packet switching
Line switching
Which network topology requires a central controller or hub?
Mesh
Ring
Star
Bus
Data communication system within a building or campus is________
WAN
LAN
MAN
PAN
The ____ translates internet domain and host names to IP address.
routing information protocol
domain name system
network time protocol
internet relay chat
Transmission media are usually categorized as:
Fixed or unfixed
Guided or unguided
Determinate or indeterminate
Metallic or non-metallic
Transmission media lie below
Physical
Application
Data link
Network
Protocol for Network virtual terminal is___________
FTP
HTTP
Telnet
SMTP
Ethernet card is also known as
NIC
Graphics Card
Internet card
Website card
The device sued to strengthen weak signals
Transformer
Repeater
HUB
MODEM
MAN stands for
Metro Access Network
Metropolitan Area Network
Metropolitan Access Network
Modulator Network
Gokul has connected his PC to a bluetooth speaker so that he can attend to the classes / recorded videos easily. Which network technology is he using?
LAN
WAN
PAN
MAN
The first ever form of a network was
NSF Net
WiFi
Internet
ARPANET
What does VLAN stand for?
Virtual Local Area Network
Visual Local Area Network
Virtual Land Access Network
Video Local Area Network
Which technology is used for creating a personal 'hotspot'
bluetooth
greentooth
bluecoat
greencoat
Network of network makes the __________
Intranet
Internet
Interspace
NSFNET
Network components are connected to the same cable in the _______ topology.
A. Mesh
B. Bus
C. Star
D. Ring
What does HTTPS stand for?
Hypertext Transfer Protocol Secure
Hyper Text Protocol Secure
Hidden Text Transfer Protocol Station
Hypertext Transfer Protocol Station
Mr John is a small businessman that runs a Hardware, he has been experiencing problem with his small accounting department which he depends on to provide him with the sales reports. Mr John want to be able to shared information between his 7 computer station and have on central printing area, what type of network would you recommend to Mr John?
LAN
MAN
WAN
SAN
The generally recognised term for the government protection afforded to intellectual property (written and electronic) is called ....................
Computer security law
aggregate information
copyright law
data security standards
A software that can be freely accessed and modified is called .................
Synchronous software
Package Software
Open source software
Middleware
The digital trail which gets created as a person's Internet usage using computers, smartphones, gaming consoles etc. is called ..........
Internet data
Internet trail
Digital footprint
e-footprint
Stealing someone else's intellectual work and representing it as own, is called .............
Intellectual steal
Plagiarism
Copyright
Hacking
What is Malware?
Software that protects your computer from viruses
Software that protects your computer from spyware and adware infections
Software that updates your computers operating system
Software that may harm your computer
Special program which can detect and remove viruses from computer is called
Virus
Anti virus
Group ware
Custom
Which SQL function is used to count the number of rows in a SQL query?
COUNT()
NUMBER()
SUM()
COUNT(*)
If you don’t specify ASC or DESC after a SQL ORDER BY clause, the following is used by default
ASC
DESC
There is no default value
None of the mentioned
The command to remove rows from a table ‘CUSTOMER’ is __________________
DROP FROM CUSTOMER
UPDATE FROM CUSTOMER
REMOVE FROM CUSTOMER
DELETE FROM CUSTOMER WHERE
Mismatched redundant copies of data is known as data ............
dependance
redundancy
inconsistency
isolation
A data ................ is a set of rules that define valid data.
constraint
data dictionary
query
all of these
______ command is used to see the structure of a table.
Drop
Insert
Select
Describe
CREATE & DROP IS A ----------STATEMENT
DDL
DCL
DML
TCL
Pool of values from where a column draws the value is called .............
table
attribute
dataset
domain
The column which has unique values in all the rows but is not a primary key is called ............. key.
candidate
alternate
composite
foreign
You are required to update the phone number for only the DesignerID "SMI01" in the "Designer" table. Which of these would successfully do that?
UPDATE Designer SET PhoneNo = '01224123456'
UPDATE Designer (PhoneNo) VALUES ('01224123456')
UPDATE Designer SET PhoneNo = '01224123456' WHERE DesignerID = 'SMI01'
UPDATE PhoneNo = '01224123456' FROM Designer WHERE DesignerID = 'SMI01'
How would you DELETE records from the Items table with a "Chair" Type?
DELETE 'Chair' FROM Items
DELETE Type FROM Items WHERE Type = 'Chair'
DELETE FROM Items WHERE Type = 'Chair'
DELETE ITEMS WHERE Type = 'Chair'
Write a query to display name and year of movies starting with B and display with latest year first
SELECT name, year FROM movies WHERE name LIKE '%B' ORDER BY year DESC ;
SELECT * FROM movies WHERE name LIKE 'B%' ORDER BY year DESC ;
SELECT name, year FROM movies WHERE name LIKE 'B%' ORDER BY year ASC ;
SELECT name, year FROM movies WHERE name LIKE 'B%' ORDER BY year DESC ;
This symbol is an SQL wildcard that can substitute for one or more characters when searching for data in a database.
$
%
=
*
SELECT title
FROM videogames
WHERE title LIKE '%2'
Which of the following is also called an INNER JOIN?
SELF JOIN
EQUI JOIN
NON-EQUI JOIN
None of them
Which of the following is true about the HAVING clause?
Similar to the WHERE clause but is used for columns rather than groups.
Similar to WHERE clause but is used for rows rather than columns.
Similar to WHERE clause but is used for groups rather than rows.
Acts exactly like a WHERE clause.
What is cardinality of a table having 5 rows and 7 columns?
5
7
12
35
Assuming UserProfile is a table containing a column Profession which accepts NULL value. What is the result of the following query. SELECT Profession FROM UserProfile WHERE Profession <> NULL
Gives an error
Returns all Profession which has values
Is not an operator in SQL Server
Returns an empty result set as the condition evaluated to unknown
_________ key is used to create a natural join on two tables.
Candidate Keys
Alternate Keys
Foreign Key
Which product is returned in a join query having no join condition?
Equi join
Cartesian
Both Equi joins and Cartesian
Natural
In which type of join, no duplicate columns are there?
Equi join
Natural
Left join
Right join
What is the correct statement for describing the INTERSECT operation?
It returns the common values from the results of any two different queries
It returns the common rows of two different queries which have the same set of attributes in the select clause
It returns the common rows of two different queries which have the same condition in the where clause
None of these
______________ constraint prevents NULL values
UNIQUE
NOT NULL
NULL
FOREIGN KEY
select count(distinct(fuel) ) from car_sales;
What will be the output of this query?
2
4
6
8
SQL is
Structured Query Language
Simple Query Language
Structured Question Language
Structure Quality Language
To remove a record from a table which SQL statement would you use?
Remove
Cancel
Delete
Eradicate
In order to modify data in a database we would use which SQL statement?
Update
Amend
Alter
Modify
Which SQL statement would add a record to the database?
INSERT INTO Designer VALUES ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456')
INSERT VALUES ('SMI01', 'M Smith', 'mail@msmith.com', 01224123456') INTO Designer
INSERT ('SMI01', 'M Smith', 'mail@msmith.com', '01224123456') INTO Designer
INSERT Designer INTO VALUES (''SMI01', 'M Smith', 'mail@msmith.com', '01224123456')
With SQL, how do you select all the records from a table named “Persons” where the value of the column “FirstName” ends with an “a”?
SELECT * FROM Persons WHERE FirstName=’a’
SELECT * FROM Persons WHERE FirstName LIKE ‘a%’
SELECT * FROM Persons WHERE FirstName LIKE ‘%a’
SELECT * FROM Persons WHERE FirstName=’%a%’
What does the ALTER TABLE clause do?
The SQL ALTER TABLE clause modifies a table definition by altering, adding, or deleting table columns and/or constraints
The SQL ALTER TABLE clause is used to insert data into database table
THE SQL ALTER TABLE deletes data from database table
The SQL ALTER TABLE clause is used to delete a database table
How can you change “Hansen” into “Nilsen” in the “LastName” column in the Persons table?
UPDATE Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
MODIFY Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
MODIFY Persons SET LastName=’Hansen’ INTO LastName=’Nilsen’
UPDATE Persons SET LastName=’Nilsen’ WHERE LastName=’Hansen’
Find the names of these cities with temperature and condition whose condition is neither sunny nor cloudy.
SELECT city, temperature, condition FROM weather WHERE condition NOT IN (‘sunny’, ‘cloudy’)
SELECT city, temperature, condition FROM weather WHERE condition NOT BETWEEN (‘sunny’, ‘cloudy’)
SELECT city, temperature, condition FROM weather WHERE condition IN (‘sunny’, ‘cloudy’)
SELECT city, temperature, condition FROM weather WHERE condition BETWEEN (‘sunny’, ‘cloudy’);
Which would find pupils with "er" anywhere in their name?
SELECT * FROM Pupils Where Name = "%er"
SELECT * FROM Pupils Where Name = "$er$"
SELECT * FROM Pupils Where Name = "%er%"
SELECT * FROM Pupils Where Name = "er%"
The number of rows in a relation
degree
tuple
cardinality
domain
Data about data is ______________
Data Description
Metadata
Data redundancy
Data inconsistency
A relational database consists of a collection of ..............
tables
fields
records
keys
What do you mean by one to many relationships?
One class may have many teaches
One teacher can have many classes
Many classes may have many teachers
Many teachers may have many classes
The ability to query data as well as insert, delete, and alter tuples is offered by ________
DML(Data Manipulation Language)
TCL(Transaction Control Language)
DDL(Data Definition Language)
DCL(Data Control Language)
Which of the following is not a function of the database?
Managing stored data
Manipulating data
Security for stored data
Analyzing data
What is the primary key in this database?
Emp_Id
Last Name
Gender
Title
Which one is correct?
Alternate key – primary key = Candidate keys
Candidate keys - Alternate key = primary key
Candidate keys – primary key = Alternate key
The column which has unique values in all the rows but is not a primary key is called ............. key.
candidate
alternate
composite
foreign
Which word is missing from the following SQL statement?
Select * table_name
With
Where
From
And
Which clause of Alter command can change the size of the Column?
ADD
MODIFY
CHANGE
COLUMN SIZE
Which command is used to display list of all databases.
Display
Display List
Show Databases
Show Database
Which of the following are SQL Components?
Data Definition Language
Data Manipulation Language
Transaction Control Language
All
To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included
ONLY
UNIQUE
DISTINCT
SINGLE
What would the SQL query pictured do?
Find all the men
Find all of the female writers
Find all of Elgar's friends
Find all the male writers
Find all the fish
Which of the following statements are true about the COUNT function?
The COUNT function counts the number of rows
The COUNT(*) function counts the number of rows with duplicates and NULL values
The COUNT(DISTINCT) function counts the number of distinct rows
COUNT(*) is equivalent to COUNT(ALL)
In which type of join, the join condition contains an equality operator?
Equi join
Natural
Left join
Right join
In the given query which of the keyword has to be inserted?
INSERT INTO employee _____ (1002,Joey,2000);
Table
Values
Relation
Field
SELECT * FROM Students WHERE Gender="Female" AND Class=2.2
would return how many records?
1
2
3
4
SELECT * FROM cars WHERE Doors > 3
would return how many records?
1
2
3
4
