Multiple Choice Questions on SQL Inbuilt Functions
1. Which logical method can be used in SQL Server 2012 to returns an item from the specified index in a list of values?
a) SELECT
b) SELECTION
c) CHOOSE
d) None of the above
2. RAND () method can be used for:
a) Executing the query randomly.
b) gives a pseudo-random float value
c) return values randomly
d) All of the above
3. A method in SQL server which is also called as arcsine?
a) ASIN
b) ASINE
c) SIN
d) None of the above
4. What will an IIF() method of SQL server 2012 do in a query?
a) Nothing
b) It will return 1 of 2 values supplied as parameters and depends on whether the Boolean parameter evaluates to true or false.
c) It works inside the IF statement
d) None of the above.
5. What is the significance of LEFT method in SQL server 2012?
a) Executes left query in joins
b) There is no method called LEFT in SQL Server.
c) It gives the left part of a character input string with the mentioned no. of characters.
d) None of the above
6. Which function in SQL server is used to insert a string into another string?
a) FILL
b) STUFF
c) MERGE
d) None of the above
7. What is the purpose of CAST function in SQL server?
a) It converts or casts an expression of 1 data type to another.
b) It cannot be in SQL Server
c) Add description to statement
d) None of the above
8. Is there any function in SQL server which can be used to check whether value can be Casted or not? If yes, name it.
a) No there is no method
b) Try_Cast
c) CAST
d) None of the above
9. What is the purpose of MIN function in SQL Server?
a) It returns the minimum value in the expression
b) It is use for decrementing the integer value
c) MIN is not a SQL server function
d) None of the above
10. Which function in SQL server is used in query to find the count of the items in the concerned object (i.e. table, view, etc.)?
a) COUNTER
b) COUNT
c) DETECT
d) None of the above
Answers