CUET (UG) entrance exam Question Bank Solutions for Computer Science\Information Practices

What will be returned by the given query? select substr("Computer", 4) = ______.

What will be returned by the given query? select power(3, 2) = ______.

What will be returned by the given query? Select length(trim("ABC Public School")) = ______.

What will be returned by the given query? SELECT RIGHT("LEFT", 2) = ______.

HTTP stands for Hypertext Transfer Protocol.

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

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?

They are the programmers or computer experts with adequate knowledge of programming and coding who find the loopholes present in a system and try to cover them and hence protect the system.