Select chapter



Basics (2.papers)
Data Types (2.papers)
Table-designing (1.papers)
Queries-Commands (3.papers)
String functions (2.papers)
Subqueries (1.papers)
Joins (1.papers)
Constraints (1.papers)
Triggers (1.papers)
Hide

Sponsored Links


  

sql interview questions and answers

1
Which of the following queries is used to get ASCII value of a character in SQL?
  1. select ascii('somecharacter') 
  2. select ascii_value('somecharacter')
  3. select ascii 'somecharacter'
  4. None of the above.
Show Answer
Share Facebook gmail Twitter
2
Which of the following queries is used to remove trailing white spaces or blanks in SQL?
  1. use removespace function.
  2. use remove function.
  3. use space function.
  4. use rtrim function.
Show Answer
Share Facebook gmail Twitter
3
Which of the following queries is used to remove all leading blanks or white spaces in SQL?
  1. use removespace function.
  2. use remove function.
  3. use space function.
  4. use ltrim function.
Show Answer
Share Facebook gmail Twitter
4
What is the use of char function in SQL?
  1. char function converts strings into character array.
  2. char function used for converting an ascii value into character .
Show Answer
Share Facebook gmail Twitter
5
What is the use of space function in SQL?
  1. space function used for removing white spaces.
  2. space function used for adding one or more white spaces to a string.
  3. space function can be used for adding only one white space in a given string.
  4. None of the above.
Show Answer
Share Facebook gmail Twitter
6
What is the use of charindex function in SQL?
  1. charindex function used for returning an index of last occurrence of a given character.
  2. charindex function used for returning first ocuurence of a single or multiple characters.
  3. charindex function used for returning an index of first occurrence of a single character.
  4. None of the above
Show Answer
Share Facebook gmail Twitter
7
What is the use of patindex function in SQL?
  1. patindex function returns first occurrence of a pattern in a specified expression.
  2. patindex function returns last occurrence of a pattern in a specified expression.
Show Answer
Share Facebook gmail Twitter
8
What is the use of concat function in SQL?
  1. concat function is used for concatenating 2 or more strings into a single string.
  2. concat function appends one string to the other and returns concatenated string.
Show Answer
Share Facebook gmail Twitter
9
What is the use of quotename function?
  1. Returns a Unicode string with the delimiters added to make the input string a valid Microsoft SQL Server delimited identifier.
  2. Quotename function used for adding placing the given string in between double quotations.
Show Answer
Share Facebook gmail Twitter
10
What is the use of stuff function in SQL?
  1. stuff function used for removing a 
    portion of string present in current string.
  2. stuff function is used for inserting a new string into the existing string by removing few characters present in the existing string.
Show Answer
Share Facebook gmail Twitter
11
What is the use of replace function in SQL?
  1. replace function used for  replacing a single character with another character.
  2. replace function used for replacing all occurences of a character with another character.
  3. replace function used for replacing all occurences of a character or string with another character or string.
  4. None of the above.
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
13
What is the use of substring function in sql ?
  1. substring function is used for returning part of a string or character or text.
  2. substring function is used for replacing a character present in a string with another character.
  3. substring function is used for removing few characters and returns remaining characters after removal.
  4. None of the above.
Show Answer
Share Facebook gmail Twitter
14
What is the use of left function in SQL?
  1. left function removes given number of left side characters present in a given string.
  2. left function returns given number of left side characters present in a string.
  3. left function returns all right hand side characters beginning from given position.
  4. None of the above.
Show Answer
Share Facebook gmail Twitter
15
What is the use of right function in SQL?
  1. right function removes given number of right side characters present in a given string.
  2. right function returns given number of right side characters present in a string.
  3. right function returns all left hand side characters beginning from given position.
  4. None of the above.
Show Answer
Share Facebook gmail Twitter
16
What is the use of len function in SQL?
  1. len function used for identifying 
    total number of characters present in a given string.
  2. len function used for comparing 
    two strings length.
  3. len function used for identifying 
    total number of occurence of a given character.
  4. None of the above.
Show Answer
Share Facebook gmail Twitter
17
What is the use of reverse function in SQL?
  1. reverse function is used for reversing 
    the sum of ascii values of all the characters present in a given string.
  2. reverse function is used for reversing all the characters present in a given string.
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
Show Answer
Share Facebook gmail Twitter
Read more papers :