>
Computer Science
List of top Computer Science Questions
Which of the file modes in the following is invalid for a text-file?
CUET (UG) - 2023
CUET (UG)
Computer Science
File Handling in Python
The statements inside the ............ block are always executed regardless of whether an exception occurred in the ................. block. What will be the appropriate clause in the above statement respectively?
CUET (UG) - 2023
CUET (UG)
Computer Science
Exception Handling
Which offset of the seek() method in the following is not valid?
CUET (UG) - 2023
CUET (UG)
Computer Science
File Handling in Python
Which of the following is a service that does the mapping between domain name and IP address?
CUET (UG) - 2023
CUET (UG)
Computer Science
Networking Protocols
Evaluate the following postfix expression and find the correct value in the following: 50, 60, +, 20, 10, -, *
CUET (UG) - 2023
CUET (UG)
Computer Science
Postfix Evaluation
Which of the following device filters the data before forwarding it?
A.
Switch
B.
Repeater
C.
Gateway
D.
Ethernet Card
CUET (UG) - 2023
CUET (UG)
Computer Science
Networking Devices
Match List I with List II
LIST I
LIST II
A. HTTP
IV. Hyper Text Transfer Protocol
B. FTP
I. File Transfer Protocol
C. SMTP
II. Simple Mail Transfer Protocol
D. TCP
III. Transmission Control Protocol
CUET (UG) - 2023
CUET (UG)
Computer Science
Networking Protocols
SQL applies conditions on the groups through which clause after groups have been formed?
CUET (UG) - 2023
CUET (UG)
Computer Science
SQL
If column "Payment" contains the data set \{10000, 15000, 25000, 10000, 15000\}, what will be the output after the execution of the given query?
\[ \text{SELECT SUM(DISTINCT PAYMENT) FROM EMPLOYEE;} \]
CUET (UG) - 2023
CUET (UG)
Computer Science
SQL
Which of the following is not an aggregate function?
CUET (UG) - 2023
CUET (UG)
Computer Science
SQL
What is the output of the following SQL query?
\[ \text{mysql} \,>\, \text{SELECT RIGHT("PRAYGRAJ", 3);} \]
CUET (UG) - 2023
CUET (UG)
Computer Science
SQL
The criteria for selecting a primary key for a table:
A.
It must uniquely identify the row.
B.
It cannot have NULL value.
C.
It can have NULL value.
D.
It can have duplicate values.
E.
It never uniquely identifies the row.
%Option
CUET (UG) - 2023
CUET (UG)
Computer Science
Database Concepts
If a computer connected to a star topology fails, the entire network will ..................
CUET (UG) - 2023
CUET (UG)
Computer Science
Network Topologies
Which key is used to link two tables together?
CUET (UG) - 2023
CUET (UG)
Computer Science
Database Concepts
Which of the following command is DML command?
CUET (UG) - 2023
CUET (UG)
Computer Science
SQL
Match List I with List II
LIST I
LIST II
A. write lines
III. Writing a sequence of string
B. pickle
I. Module for binary files
C. try-except
IV. Exception handling
D. rb
II. Opening and reading a binary file
CUET (UG) - 2023
CUET (UG)
Computer Science
File Handling in Python
Which of the following represents the mode of both writing and reading in binary format in a file?
CUET (UG) - 2023
CUET (UG)
Computer Science
File Handling in Python
Which of the following is not a valid mode to open a file?
CUET (UG) - 2023
CUET (UG)
Computer Science
File Handling in Python
Which error is generated by pickle.load() function when you reach end-of-file while reading from the file?
CUET (UG) - 2023
CUET (UG)
Computer Science
File Handling in Python
A table student has two text fields defined as below:
Name_1 varchar(20),
Name2 char(20)
If Name_1 stores value as ‘Ana' and Name2 stores value as ‘Anuj', then Name_1 will consume characters space and Name2 will consume characters space.
CUET (UG) - 2023
CUET (UG)
Computer Science
Programming in C
Arjun has been given following incomplete code, which takes a student details (name, marks) and writes into a binary file student.dat.
import pickle
stname = input("enter name")
stmarks int(input ("enter marks"))
stdict ("Name" : stname, "Marks" : stmarks)
_________ :
\( \#\)
line 1
_________ :
\(\#\)
line 2
_________ :
\( \#\)
line 3
_________ :
\(\#\)
line 4
print (r)
if r["marks"]
\(>=\)
85:
print("eligible for scholarship")
else:
print("not eligible for scholarship")
Complete code for line 1 to open the given binary file in f object using with statement:
CUET (UG) - 2023
CUET (UG)
Computer Science
Reading Comprehension
St. Angles school at Mumbai is setting up the network between its different wings of school campus. There are 4 buildings named Senior(S), Junior (J), Admin(A) and Hostel (H).
Senior(S)
Junior(J)
Admin(A)
Hostel(H)
Distance between various wings:
A to S
100m
A to J
110m
A to H
400m
S to J
300m
S to H
`70m
J to H
80m
No. of computers in each wing :
Wing A
20
Wing S
150
Wing J
50
Wing H
25
CUET (UG) - 2023
CUET (UG)
Computer Science
Reading Comprehension
Given Dataframe, df:
State
Geographical_Area
Area_Under_Dense_Forest
1
Manipur
78438
2797
2
Delhi
1483
6.72
3
Kerala
38852
1663
4
Tamil Nadu
40699
1904
Based on the above data, solve questions:
CUET (UG) - 2023
CUET (UG)
Computer Science
Reading Comprehension
Vrinda enterprises is planning to setup a secure network in Delhi for its web based activities. It is having 4 buildings. Answer the questions that follows based on the information given below.
Distance Between Buildings
A to B
40m
B to C
60m
C to D
125m
A to D
102m
B to D
190m
A to C
162m
No of Computers
Block
Computers
A
25
B
80
C
150
D
35
CUET (UG) - 2023
CUET (UG)
Computer Science
Reading Comprehension
Which method is used to display row labels of as dataframe ?
CUET (UG) - 2023
CUET (UG)
Computer Science
File Organization and Indexing
Prev
1
...
6
7
8
9
10
...
13
Next