List of top Computer Science Questions

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 method is used to display row labels of as dataframe ?

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

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

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 :

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

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

Which of the following is the type of software that has self-replicating software that cause damageto files and system ?

Physical address of a machine is a ?

In a noisy environment, the best transmission medium would be.

Today E-waste become a major concern to the environment. To save the environment we should avoid this practise:

Which of the following is not an example of social media ?Which of the following is not an example of social media ?

Which of the following lets others distribute, remix, tweak and build upon Four work even commercially, as long as they credit you for original creation :

Presenting someone else's idea or work as one's own idea or work is called:

Data Visualization helps in:
(A) Understanding results of analysis
(B) Connect to database
(C) Perform operations on file
(D) Visualize variation
(E) Show relation between variables
Choose the correct answer from the options given below :

Which graph is called "correlation plots" also :

In the given list

10

9

4

21

5

7

8

what do you think is the best technique to search an element?

Library used to interact with MYSQL database by providing the required credentials.

The max() function of Pandas descriptive statistics axis = 1 gives,