| 51 |
Table A has 4 rows and 3 columns; table B has 5 rows and 2 columns. How many rows does SELECT * FROM A, B; re… |
Computer Science/Informatics Practices
Operations on relations |
Easy |
| 52 |
Which set operation returns the rows of the first query that do not appear in the second? |
Computer Science/Informatics Practices
Operations on relations |
Easy |
| 53 |
Query 1 returns the cities Delhi, Pune, Agra and query 2 returns Pune, Agra, Goa. How many rows does query1 U… |
Computer Science/Informatics Practices
Operations on relations |
Medium |
| 54 |
Emp(EmpNo, Name, DeptNo) and Dept(DeptNo, DName) are combined with NATURAL JOIN. How many columns does the re… |
Computer Science/Informatics Practices
Operations on relations |
Medium |
| 55 |
Which statement about an equi-join of Emp and Dept on DeptNo is correct? |
Computer Science/Informatics Practices
Operations on relations |
Hard |
| 56 |
Which network type is formed by a smartphone connected to wireless earphones and a smartwatch? |
Computer Science/Informatics Practices
Introduction to networks |
Easy |
| 57 |
Which early network, started in 1969, is regarded as the forerunner of the Internet? |
Computer Science/Informatics Practices
Introduction to networks |
Easy |
| 58 |
A company links the computers in its head office in Mumbai with its branch offices in Chennai and Kolkata. Wh… |
Computer Science/Informatics Practices
Introduction to networks |
Medium |
| 59 |
Computers in the labs and library of a single school campus are connected to share a printer. This network is… |
Computer Science/Informatics Practices
Introduction to networks |
Medium |
| 60 |
Which statement comparing LAN and WAN is generally correct? |
Computer Science/Informatics Practices
Introduction to networks |
Hard |
| 61 |
Which device converts digital signals into analog signals and back? |
Computer Science/Informatics Practices
Network devices |
Easy |
| 62 |
Which device regenerates a weak signal so that it can travel further? |
Computer Science/Informatics Practices
Network devices |
Easy |
| 63 |
Which device sends incoming data only to the port of the intended computer instead of to all ports? |
Computer Science/Informatics Practices
Network devices |
Medium |
| 64 |
A school wants to connect its computer lab LAN to the Internet and forward packets between the two networks. … |
Computer Science/Informatics Practices
Network devices |
Medium |
| 65 |
Two networks that use entirely different communication protocols must exchange data. Which device performs th… |
Computer Science/Informatics Practices
Network devices |
Hard |
| 66 |
In which topology are all nodes connected to a single central hub or switch? |
Computer Science/Informatics Practices
Network topologies |
Easy |
| 67 |
Which topology uses a single backbone cable with terminators at both ends? |
Computer Science/Informatics Practices
Network topologies |
Easy |
| 68 |
How many links are needed to connect 6 computers in a fully connected mesh topology? |
Computer Science/Informatics Practices
Network topologies |
Medium |
| 69 |
In a star network, the cable connecting one computer to the switch breaks. What is the effect? |
Computer Science/Informatics Practices
Network topologies |
Medium |
| 70 |
A bank needs a network in which data can still reach its destination even if several links fail, and cost is … |
Computer Science/Informatics Practices
Network topologies |
Hard |
| 71 |
How many bits are there in an IPv4 address? |
Computer Science/Informatics Practices
Addressing and the web |
Easy |
| 72 |
Which system translates a domain name such as www.example.org into an IP address? |
Computer Science/Informatics Practices
Addressing and the web |
Easy |
| 73 |
Which of the following is a valid IPv4 address? |
Computer Science/Informatics Practices
Addressing and the web |
Medium |
| 74 |
Which statement best describes the difference between the Internet and the World Wide Web? |
Computer Science/Informatics Practices
Addressing and the web |
Medium |
| 75 |
A laptop moves from the school Wi-Fi to a home Wi-Fi network. Which statement is most likely true? |
Computer Science/Informatics Practices
Addressing and the web |
Hard |
| 76 |
In the URL https://www.school.edu.in/admission/form.html, what is "www.school.edu.in"? |
Computer Science/Informatics Practices
Internet applications and websites |
Easy |
| 77 |
Which Internet application carries voice calls as data packets over the Internet? |
Computer Science/Informatics Practices
Internet applications and websites |
Easy |
| 78 |
A results website shows each student only their own marks after they enter their roll number. What type of we… |
Computer Science/Informatics Practices
Internet applications and websites |
Medium |
| 79 |
What is web hosting? |
Computer Science/Informatics Practices
Internet applications and websites |
Medium |
| 80 |
Riya sends an email to Arun with Meena in BCC. Which statement is true? |
Computer Science/Informatics Practices
Internet applications and websites |
Hard |
| 81 |
Which of the following is a web browser? |
Computer Science/Informatics Practices
Web browsers |
Easy |
| 82 |
A small text file stored by a website on a user's computer to remember preferences is called a |
Computer Science/Informatics Practices
Web browsers |
Easy |
| 83 |
A user installs a small program in the browser that blocks advertisements on all websites. This program is be… |
Computer Science/Informatics Practices
Web browsers |
Medium |
| 84 |
Which statement about incognito (private) browsing is correct? |
Computer Science/Informatics Practices
Web browsers |
Medium |
| 85 |
Why are third-party cookies considered a privacy risk? |
Computer Science/Informatics Practices
Web browsers |
Hard |
| 86 |
Which exception is raised by int('abc')? |
Computer Science/Informatics Practices
Exceptions |
Easy |
| 87 |
When does Python report a syntax error such as a missing colon after an if condition? |
Computer Science/Informatics Practices
Exceptions |
Easy |
| 88 |
Which exception occurs when the code x = [1, 2, 3] is followed by print(x[5])? |
Computer Science/Informatics Practices
Exceptions |
Medium |
| 89 |
What happens when the statement assert 2 > 3, "check failed" is executed? |
Computer Science/Informatics Practices
Exceptions |
Medium |
| 90 |
Which is the correct way to define and raise a user-defined exception in Python? |
Computer Science/Informatics Practices
Exceptions |
Hard |
| 91 |
Which block runs whether or not an exception occurs in the try block? |
Computer Science/Informatics Practices
try, except, else and finally |
Easy |
| 92 |
When is the else block of a try statement executed? |
Computer Science/Informatics Practices
try, except, else and finally |
Easy |
| 93 |
A try block contains print(5/0); it is followed by except ZeroDivisionError: print("Z"), else: print("E") and… |
Computer Science/Informatics Practices
try, except, else and finally |
Medium |
| 94 |
A try block contains x = int("12"); it is followed by except ValueError: print("V"), else: print("E", x) and … |
Computer Science/Informatics Practices
try, except, else and finally |
Medium |
| 95 |
A function has try: return "T" followed by finally: print("F"). What is printed when print(f()) is executed? |
Computer Science/Informatics Practices
try, except, else and finally |
Hard |
| 96 |
Which mode opens a text file for adding data at the end without erasing existing content? |
Computer Science/Informatics Practices
Text files |
Easy |
| 97 |
What does the readlines() method return? |
Computer Science/Informatics Practices
Text files |
Easy |
| 98 |
A file contains the text PYTHON PROGRAM. After f = open(...) in read mode, s = f.read(6) is executed. What is… |
Computer Science/Informatics Practices
Text files |
Medium |
| 99 |
For the same file containing PYTHON PROGRAM, f.seek(7) is followed by print(f.read(3)). What is printed? |
Computer Science/Informatics Practices
Text files |
Medium |
| 100 |
A file has lines one, two and three. It is opened with 'w' mode, f.write("x") is executed and the file is clo… |
Computer Science/Informatics Practices
Text files |
Hard |