List of practice Questions

Which of the following lets others distribute, remix, tweak and build upon Four work even commercially, as long as they credit you for original creation :

Data Visualization helps in:
(A) Understanding results of analysis
(B) Connect to database
(C) Perform operations on file
(D) Visualize variation
(E) Show relation between variables
Choose the correct answer from the options given below :

Presenting someone else's idea or work as one's own idea or work is called:

Which graph is called "correlation plots" also :

In the given list

10

9

4

21

5

7

8

what do you think is the best technique to search an element?

Library used to interact with MYSQL database by providing the required credentials.

The max() function of Pandas descriptive statistics axis = 1 gives,

Which of the following commands is used to install Matplotlib for coding?

In SQL, which of the following constraint means that no two values in any column should be the same?

Pandas provide a function ______ to check whether any value is missing or not in the Datafrarne :

_____ the shape of the data set to make it suitable for analysis.

All aggregate functions ignore Nulls except for________ function.

Match LIST I with LIST II

LIST I		LIST II
A	Constraint	I	Clause
B	DDL	II	Operator
C	Where	III	Alter table
D	Like	IV	Default

Choose the correct answer from the options given below

_____used to avoid underflow exception while performing \(\&\) queue operation.

Match LIST I with LIST II

LIST I		LIST II
A	Where	I	Create table
B	DDL	II	Pattern matching
C	Multirow function	III	Clause
D	%	IV	Max()

Choose the correct answer from the options given below

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

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

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

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

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

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

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 :

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