List of top Computer Science Questions

There are five statements listed below. Each statement having some information related to data structure. Identify the correct statement(s).
(A) A stack is an example of a FIFO data structure 
(B) The function top() removes the value from the top of a stack 
(C) The term deque stands for double ended queue 
(D) A queue is a data structure in which items can be added or removed from either end 
(E) PEEK is an operation used to view elements at the front of the queue, without removing it from the queue 
Choose the correct answer from the options given below:

Which one of the fallowing statement is wrong for Queue and stack data structures ?

Given an infix expression ((X+Y)*Z)/(5i+W) write its postfix notation :

Nisha wants to install a computer network in her office at minimum cost. Help her to choose a topology in which less wire is used:

Which device is used to send the signals to only selected device instead of sending to all:

Which is not correct about string function?

Arrange the following commands in the correct order of execution
(A) SELECT 
(B) ORDER BY 
(C) GROUP BY 
(D) WHERE 
(E) FROM
 Choose the correct answer from the options given below:

Consider the tables A and B given below. How many tuples will be in the output after apply A B operation.
A

SNO	Name	Class
1	Meena	8
2	Meena	6
3	Leena	7
4	Vijaya	7
5	Sujata	8

B

SNO	Name	Class
1	Asha	7
2	Meena	6
3	Mohit	7
4	Vijaya	7

How many join operation are needed to combine N tables on equality condition.

A key is used to represent the relationship between two relations.

In relational database management system RDBMS, a tuple is defined as :

Yash wrote a program for inserting and deleting data in a file, using Python, One of the functions, he used is incorrect. identify the incorrect function.

If an error encountered in a method, then what would be one of the correct sequence of the following steps in the exception handling process :
(A) Exception is raised 
(B) Create exception object 
(C) Searches for method in call stack in reverse sequence 
(D) An error encountered in a method 
(E) Runtime system searches for exception handler in the current method 
Choose the correct answer from the options given below :

If a statement int ('Hello') is written in python, then what kind of exception will it give ?

Match LIST I with LIST II

LIST I Mineral		LIST II  States
A	UNIQUE	I	The column which refers to value of an attributes defined primary key in another table
B	Primary key	II	A value specified for the column if no value is specified
C	Default	III	The column which can uniquely identify each row/record in a table
D	Foreign key	IV	Ensures that all the values in a column are distinct

Choose the Correct answer from the options given below

The file pointer is at beginning of the file in :
\((A) r \\ (B) r+ \\(C) a+ \\ (D) W+ \\ (E) a\)
 Choose the correct answer from the options given below :

Sahil is a student of Class X has just started understanding the basics of Internet and Web technologies. He is a bit confused in between the terms “World Wide Web”, “Uniform Resource Locator”, “Internet”, “Domain Name”, “DNS”
Answer the questions using the above paragraph :

A record of each student with its sports preference is given :
SPORT

R.no	Sports
9	Cricket
13	Football
14	Badminton
16	Football
19	NULL
20	Cricket
22	Football

Based on the data, answer the questions

Consider the following table and answer the questions that follow :
Teacher

No	Name	Age	Department	Dob	Salary	Sex
1	Jagan	34	Comp	10/1/97	12000	M
2	Shona	31	Hist	24/3/98	NULL	F
3	Sandeep	32	Maths	12/12/98	30000	M
4	Sangita	35	Hist	01/07/99	40000	F
5	Rohit	42	Maths	05/09/97	25000	M
6	Sharma	50	Hist	27/06/98	30000	M
7	Amit	44	Comp	25/02/97	21000	M
8	Girisha	NULL	Maths	31/07/97	20000	F

Consider the following paragraph and answer the questions that follow :
Mohan keeps working on various IT projects. He is continuously online for many hours. Many a times while working o various softwares, he is required to share his personal/sensitive information like mobile number, date of birth etc. He has started facing a number of problems while working on his computer.
1. His bank account showed a debit transaction of ₹ 50,000, which was not done by him.
2. He cannot open some of the application.
3. He has started getting junk emails.
4. Many a times unwanted advertisements have started popping up onto his computer.
5. He has started getting backache, shoulder pain and stress.

Which of the following is a Frequency range of Radio waves ?

The purpose of attribute dataframe.dtypes is :

Match List I with List II

List I		List II
A.	Dataframe.min()	I.	Display the total number of values for each columns or a row of a dataframe
B.	Dataframe.sum()	II.	Display the sum of the values from the dataframe
C.	Dataframe.count()	III.	Display the middle values of the data
D.	Dataframe.median()	IV.	Display the minimum values from the dataframe

Choose the correct answer from the options given below :

The e-banking page logged out automatically by _____.

Which of the following is correct code to plot line Chart with dotted linestyle ?