List of practice Questions

$5 \,g$ of $NaOH$ was dissolved in deionized water to prepare a $450 \,mL$ stock solution What volume (in $mL$ ) of this solution would be required to prepare $500 \,mL$ of $01\, M$ solution? Given: Molar Mass of $Na, O$ and $H$ is 23,16 and $1 \,g\, mol ^{-1}$ respectively

An ac source is connected to a capacitor C. Due to decrease in its operating frequency:

The tangent at point(a cosθ, b sinθ), 0<θ<\(\frac{\pi}{2}\), to the ellipse \(\frac{x^2}{a^2}+\frac{y^2}{b^2}=1\) meets the x-axis at T and y-axis at T₁, Then the value of \(\min_{\,\,\,0<\theta<\frac{\pi}{2}}\)(OT)(OT₁) is

EMPLOYEE Table

Emp No	Ename	Salary	Bonus	DeptId
101	Aaliya	10000	234	D02
102	Kritika	60000	123	D01
103	Shabbir	45000	566	D01
104	Gurpreet	19000	565	D04
105	Joseph	34000	875	D03
106	Sanya	48000	695	D02
107	Vergeese	15000	NULL	D01
108	Nachaobi	29000	NULL	D05
109	Daribha	42000	NULL	D04
110	Tanya	50000	467	D05

What will be the output of the SQL query based on above EM PLOYEE table?

Data is a collection of characters, numbers and other symbols that represents the value of some situations or variables. Structured and Unstructured are two types of data. Data storage is the process of storing the data on storage devices so that data can be retrieved later. There are various data pre-processing cycle. Store, retrieve, classify and update is a pre-processing step. RDBMS can be used to remove the certain limitations in processing the files.
Based on the above paragraph answer the following:

Consider a computer system connected with a transmission medium having minimum frequency 500 kHz and maximum frequency 1500 kHz. A user wants to upload a text document at the rate of 10 (1 page = 1600 characters and each character is of 8 bits) pages per 20 seconds. Simultaneously, he is also receiving data from the system from the transmission medium. On the basis of the above assumptions, answer the following questions:

Temperature, Rainfall, and Humidity Data for 5 States

State	Avg Temp (°C)	Rainfall (in cm)	Humidity
Assam	20	150	10.6
Delhi	30	70	7.5
Kerala	20	120	10.9
Rajasthan	35	50	5.6
Telangana	28	90	8.7

Using the above data frame answer the questions:

Two thin lenses of power +3D and -1D are held in contact with each other. Focal length of the combination would be:

If A= {P,O,L,Y,T,E,C,H,N, I} and B = {E, X, A, M}, then \(A∩B =\)

What are two advantages of using fiber-optic cabling instead of UTP (any two)?
A. Lower cost B. Easier to install
C. Allows longer distances D. Less affected by external signals
E. Easier to terminate the cable ends.
Choose the correct answer from the options given below:

Choose the options which come under the category of net etiquettes
A. Be Ethical B. Respect Privacy
C. Be Responsible D. Be Respectful
Choose the correct answer from the options given below:

Single row or scalar functions are applied on a single value and return a single value.
Which of the following is NOT a Date Function?

Match List I with List II

LIST I	LIST II
A. DataFrame.std()	IV. Standard Deviation
B. DataFrame.describe()	III. Descriptive statistical values
C. DataFrame.var()	I. Variance
D. DataFrame.mode()	II. Value that appears most

The process of secret capture and analysis of network traffic by malicious users is called:

Match List I with List II

LIST I	LIST II
A. Mesh topology	III. Each node is connected to two other devices, one each on either side
B. Ring topology	IV. Each communicating device is connected with every other device
C. Bus topology	I. Single backbone wire shared among the nodes
D. Star topology	II. Each communicating device is connected to a central networking device

The way a dataset is arranged into rows and columns is referred to as the shape of data. Following function is used to reshape and create a new DataFrame from the original one:

........ and .......... are popular free and open source software tools.

Unsolicited commercial email is known as:

Match List I with List II

LIST I	LIST II
A. Doxing operations	IV. Cyber bullying
B. FOSS	III. It grants a user substantial rights and freedom
C. WORM	II. It is a program which copies itself across a network
D. TROJAN HORSE	I. It is a program which is intended to carry out malicious operations

Creative creations of mind such as patents, trademark, and copyright are called:

The scatter() function

Which of the following plots makes it easy to compare two or more distributions on the same set of axes?

Which of the following statements is used to create a histogram of 'step' type with 20 bins?