List of top Computer Science Questions

Which of the file modes in the following is invalid for a text-file?

Which offset of the seek() method in the following is not valid?

Which of the following device filters the data before forwarding it? A. Switch
B. Repeater
C. Gateway
D. Ethernet Card

Which of the following is a service that does the mapping between domain name and IP address?

SQL applies conditions on the groups through which clause after groups have been formed?

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?

Which of the following command is DML command?

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?

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