List of practice Questions

Cancer patient analysis in the Mumbai region is to be plotted. The command used to give title to X-axis as "No. of patients" in the graph is:

Which of the following is not a web browser?

Match List I with List II

LIST I	LIST II
A. Slammer	IV. Virus
B. Microwave	II. Uni directional
C. Radio wave	I. Omni directional
D. White hats	III. Ethical hacker

Match List I with List II

LIST I	LIST II
A. RDBMS	III. Store data in related table
B. Primary Key	I. Unique identification of tuples
C. Tuple is collection of	II. Attribute Value
D. Database Schema and Constraints	IV. Database catalog

Match List I with List II

LIST I	LIST II
A. SELECT LOWER('COMPUTER');	IV. 'computer'
B. SELECT LEFT('COMPUTER', 3);	I. 'COM'
C. SELECT RIGHT('COMPUTER', 4);	II. 'UTER'
D. SELECT MID('COMPUTER', 2, 3);	III. 'OMP'

Which one in the following options is not a constraint ?

Which of the following is not a Descriptive Statistical method that can be applied to a DataFrame?

Which of the following is not an aggregate function that can be applied to a DataFrame?

Which of the following denotes a missing value in a DataFrame?

This exception occurs whenever a local or global variable name is not defined.

Match List I with List II

LIST I	LIST II
C. Deletion operation	IV. Dequeue
A. Insertion in a queue at	I. FRONT
B. Deletion in a queue at	III. REAR
D. Insertion operation	II. Enqueue

In search by hashing, we have size of the hash table and the size of list, then:

............. sorts a given list of elements by repeatedly comparing the adjacent elements and swapping them if they are unordered.

To sort a list having n elements, the Selection sort makes .......... number of passes through the list.

The first page of a website is known as ......... .

Which of the following is a text file which is transferred by the website to the browser when it is browsed?

Match List I with List II

LIST I	LIST II
C. Router	I. It receives the information, examines it and transfers it to other network.
B. Ethernet	III. Set of rules that governs functioning of LAN
A. MAN	IV. It covers a larger geographical area such as town or city.
D. Repeater	II. It regenerates the received weak signals.

Which of the following statement(s) is/are true?

A. Selection operation yields horizontal subset of a relation.
B. Selection operation yields vertical subset of a relation.
C. Union operator can work on relation with different degree.
D. Intersection and Cartesian product operations are not binary.
E. A record is a column on a datasheet.

Before the usage of .................. table command to add a primary key, one needs to make sure that the field is ...........

Which clause amongst the following can be used along with aggregate functions?

Which term is used to add an element into a stack?

Match List I with List II

LIST I	LIST II
A. Stack	IV. LIFO
B. EOF	III. Exception
C. Tree	II. Non-linear Data Structure
D. Queue	I. FIFO

What is the term for inserting into a full queue known as?

Insertion and deletion in a queue takes place respectively at which end? A. Front
B. Rear
C. Middle
D. Second element from right end
E. Second element from left end