Cambridge International Sr Sec School, Bhadana, Jhajjar
Unit Test-4
Class: XI
Subject: Computer Science
Max. Marks: 50 Time Allowed:2Hrs.
Name:_________________ Roll No. :_________________
Sec._____________ :_______________
Que 1. Multiple choice [Link] any twenty . 20×1=20M
i)Which of the following is a DML command in SQL ?
(A) UPDATE (B) CREATE (C) ALTER (D) DROP
ii)In MYSQL, which type of value should not be enclosed within quotation marks ?
(A) DATE (B) VARCHAR (C) FLOAT (D) CHAR
iii)Which of the following networking devices is used to regenerate and transmit the weakened signal ahead ?
(A) Hub (B) Ethernet Card (C) Repeater (D) Modem
iv)Which of the following options is the correct protocol used for phone calls over the internet ?
(A) PPP (B) FTP (C) HTTP (D) VoIP
v)If a table which has one Primary key and two alternate keys. How many Candidate keys will this table have? (A) 1.
(B) 2. (C) 3. (D) 4
vi)In which datatype the value stored is padded with spaces to fit the specified length.(A) DATE. (B) VARCHAR (C)
FLOAT. (D) CHAR
vii)Which protocol is used to transfer files over the Internet?
(A) HTTP. (B) FTP. (C)PPP. (D)HTTPS
viii) Which network device is used to connect two networks that use different protocols?
(A) Modem. (B) Gateway. (C)Switch. (D)Repeater
ix)Which of the following service is a type of Internet hosting service that allows individuals and organisations to
make their website accessible via the WWW?
(a) Web server (b) Website (c) Web hosting (d) both (a) and (b)
x)__________is the communication protocol that sets the standard used by every computer that accesses web
based information.
(a) XML. (b)HTML (c) HTTP (d) FTP
xi)Which of the following is not a part of DDL query?
(a) DROP. (b) MODIFY. (c) DISTINCT. (d) ADD
xii) Which of the following is not a valid data type in SQL?
(a) VARCHAR. (b) BOOLEAN. (c) DATETIME. (d) DECIMALS
xiii)What is the maximum width of numeric value in data type int of MySQL.
a. 10 digits b. 11 digits. c. 9 digits d. 12 digits
xiv)______ is a standard mail protocol used to receive emails from a remote server to a local email client.
(a) SMTP (b) POP. (c) HTTP. (d) FTP
xv) Pawan wants to transfer files and photos from laptop to his mobile. He uses Bluetooth Technology to connect
two devices. Which type of network will be formed in this case.
a. PAN. b. LAN. c. MAN d. WAN
xvi)Which SQL statement is used to add new records to a table?
(a) ADD. (b) CREATE. (c) INSERT (d) UPDATE
xvii)To identify each node uniquely in a computer network ___________ address is assigned.
(a) TCP/IP (b) IP. (c) MAC (d)TCP
xviii)Identify the device which can connect dissimilar network.
(a) Router (b) Gateway. (c) Modem. (d) Both (a) and (b)
xix)Which among the following are the correct representation of “float(4,2)”?
(A) 24.33 (B) 124.4. (C) 12.123 (D) Both (A) and (B)
xx)Which of the following protocols allows use of HTML on the World Wide Web
(A) HTTP (B) PPP. (C) FTP (D) POP
xxi)Which of the following wireless transmission medium is best suited for MAN ?
(A) Microwave (B) Radio Link. (C) Infrared. (D) Bluetooth
xxii)State True or False."Sorted() method sorts a list and stores the result into a new list."
Que [Link] question [Link] any five . 5×2=10M
i)Which SQL command is used to delete a table and its data from a database?
ii) What is Wi-Fi communication?
iii) Give one basic difference between guided and unguided transmission channels.
iv)Assertion (A): We can retrieve records from more than one table in MYSQL.
Reason (R): Foreign key is used to establish a relationship between two tables.
Options:
(A) Both Assertion (A) and Reason (R) are true and Reason (R) is the correct explanation for Assertion (A).
(B) Both Assertion (A) and Reason (R) are true and Reason (R) is not the correct explanation for Assertion (A).
(C) Assertion (A) is true but, Reason (R) is false.
(D) Assertion (A) is false but, Reason (R) is true.
v)Assertion (A): Both DELETE and DROP TABLE carries out the same thing – deletion in
tables.
Reason (R): The DELETE command deletes the rows and DROP TABLE deletes the whole
table.
Options:
(A) Both Assertion (A) and Reason (R) are true and Reason (R) is the correct explanation for Assertion (A).
(B) Both Assertion (A) and Reason (R) are true and Reason (R) is not the correct explanation for Assertion (A).
(C) Assertion (A) is true but, Reason (R) is false.
(D) Assertion (A) is false but, Reason (R) is true.
vi)Expand ARPANET.
vii)Expand Modem.
Que [Link] question [Link] any five . 5×3=15M
i)Write the full forms of the URL and VoIP and their utility?
ii) Mention any two differences between IP and MAC address in networking
iii)Give the difference between XML and HTML.
iv) How is http different from https?
v)Expand and explain the term URL.
vi) Expand the term PPP. What is the use of PPP ?
vii) Expand the term FTP. What is the use of FTP?
viii)Expand the term SMTP. What is the use of SMTP?
Que [Link] [Link] any one . 1×5=5M
i)Explain types of networks.
ii)Explain any three types of topologies with diagram.