List of top Computer Science Questions

Which is the source of a recorded data in a well defined format ?

Which operator is used to match a pattern or string in SQL?

Match LIST I with LIST II

LIST I Mineral		LIST II  States
A	Round()	I	Date function
B	Rtrim()	II	Aggregrate function
C	Count()	III	Math function
D	Monthname()	IV	String function

Choose the correct answer from the options given below:

What will be the output of the given SQL Query SELECT DAY("2023-03-01);

Consider a table P with 4 rows and 5 columns and table S with 6 rows and 3 columns. What will be the size of resultant table if we apply Cartesian product ?

Match LIST I with LIST II

LIST I		LIST II
A	Relation	I	Number of rows
B	Tuple	II	Logically related data organised in a table
C	Degree	III	Number of columns
D	Cardinality	IV	Row in a table

Choose the Correct answer from the options given below

Which of the following are true about DBMS ?
(A) Each attribute should have unique name 
(B) Order of attribute is immaterial 
(C) Each tuple should be unique 
(D) The values of attributes do not belong to same domain 
(E) An attribute can have multiple values in tuple 
Choose the correct answer from the options given below :

Unstructured data are sometimes described with the help of some other data is called

What is the number of passes made by bubble sort for a list containing n elements ?

Consider that:
a = [20, 30, 40] 
b=a 
b[0] = 72 
print (a)
The output will be : 

Which of the following is(are) true for hashing
(A) The time required to compute the index value is independent of the number of items in the list 
(B) The time required to compute the index value depend on the number of items in the list 
(C) The cost of computing a hash function does not affect the performance of hashing based searching 
(D) The time taken by different hash functions may be different 
(E) There is no problem of collision in hashing 
Choose the correct answer from the options given below :

Which statement is incorrect in relation to searching an element in a list :

Consider the following number list [8, 7, 13, 1, -9, 4] After applying selection sort, which of the list is correct after Pass 3 ?

Consider the algorithm:
NameSearch (numList, key,n)
Step1: SET index = 0
Step2: WHILE index < n, REPEAT step3
Step3: IF numlist [index]-key THEN
                        PRINT "Element found at position", index + 1
                           STOP
             ELSE
                             index = index+1
Step4: PRINT "Search unsuccessfull"
The algorithm performs

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:

identify the stack in given example :

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

if len(Stack) =0 : print("error") The above statement is handling the situation called :

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:

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

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

Which is not correct about string function?

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

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