CUET (UG) entrance exam Question Bank Solutions

Name a function of MySQL which is used to remove trailing and leading spaces from a string.

"COUNT" keyword belongs to which categories in Mysql?

The ______ function returns m raised to the n^th power.

Name a function of MySQL used to give position of the first occurrence of a string2 in string1.

What will be returned by the given query? SELECT MID('BoardExamination', 2, 4) = ______.

What will be returned by the given query? SELECT INSTR('INFORMATIONFORM', 'FOR') = ______.

What will be returned by the given query? SELECT DAYOFYEAR('2015-01-10') = ______.

Which of the following is not a date function?

Which of the following is not a text function?

Which function will be used to remove only the trailing spaces from a string?

The string function that returns the index of the first occurrence of substring is ______.

What is the general format of UPPER() return type?

Which statement is used to count the number of rows in table?

Select the correct statement:

Pandas Series is a ______.

Which command is correct to display the plot?

Which of the following is not a valid plotting function of pyplot?

Which function is used to find the most often appeared value from a set of numbers?  

The command used to draw a line graph is:

Give the output of:

s=pd.Series([10,20,30,40,50],index =[‘a’,‘b’,‘c’,0,1])
print(s.loc[1])