List of top Computer Science Questions

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

Physical address of a machine is a ?

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

Identify the virus from the following:

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 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

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

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 key is used to link two tables together?

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

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

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

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

In ............ topology, if the server is not working, the entire network does not work.

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

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?

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