List of top Computer Science Questions asked in CUET (UG)

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;} \]

Which of the following is not an aggregate function?

What is the output of the following SQL query? \[ \text{mysql} \,>\, \text{SELECT RIGHT("PRAYGRAJ", 3);} \]

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

If a computer connected to a star topology fails, the entire network will ..................

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

Which key is used to link two tables together?

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

Which of the following represents the mode of both writing and reading in binary format in a file?

Which of the following is not a valid mode to open a file?

Which error is generated by pickle.load() function when you reach end-of-file while reading from the file?

Which of the following command is DML command?

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.

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:

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

 

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:

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

Which malware usually tracks internet usage data and sells them to advertisers?

Which method is used to display row labels of as dataframe ?

Match LIST I with LIST II

LIST I		LIST II
A	Controlling TV channels through remote	I	Circuit switching
B	Moving elevators up/down	II	Simplex communication
C	Communication between two computers	III	Half-duplex communication
D	Communication through telephone call	IV	Full-duplex communication

Choose the correct answer from the options given below

Match LIST I with LIST II

LIST I		LIST II
A	Exploits a Website to discover loopholes and vulnerabilities	I	Spoofing
B	Forging email addresses	II	Plagiarism
C	Insulting, degrading or intimidating someone online	III	Cyberbullying
D	Using other's work and not giving enough citations	IV	White hat hacker

Choose the correct answer from the options given below

Mohan wants to display all the attributes and all the tupIes of the table 'Teacher', help him to choose the correct SQL statement :
(A) Select % from teacher ; 
(B) Select from teacher ; 
(C) Select all from teacher ; 
(D) Select * from teacher ; 
Choose the correct answer from the options given below :

Which of the following is/are false ?
(A) Computer viruses are healthy codes written to test the security health of a system 
(B) A worm is self replication of a program 
(C) Trojan horse is a utility program that does harm when its date is expired 
(D) Spyware is a healthy software which keeps an eye on activities happening on your computer 
Choose the correct answer from the options given below :

Identify the virus from the following:

Gagan wants to upload a text document at the rate of 20 pages per 10 seconds. What will be the required data rate of the channel? (Assume the 1 page contains 1500 characters and each character is of 8 bit). 23.44 Kbps