12th Class Computers Science Sample Paper

done SQL - Sample Paper-4 Total Questions - 20    [Download]

• question_answer1)
  After applying Where clause in Select Statement you will get only one value.
  A)
  True       
  done clear
  B)
  False
  done clear
  C)
  None of these
  done clear
  D)
  All of the above
  done clear
  View Answer play_arrow

• question_answer2)
  AS keyword is use to assign a meaningful column name to the result of queues.
  A)
  True     
  done clear
  B)
  False
  done clear
  C)
  None of these
  done clear
  D)
  All of the above
  done clear
  View Answer play_arrow

• question_answer3)
  SQL is a programming language.
  A)
  True                 
  done clear
  B)
  False
  done clear
  C)
  None of these
  done clear
  D)
  All of the above
  done clear
  View Answer play_arrow

• question_answer4)
  If you want to see duplicate result in a query, then you should use DISTINCT
  A)
  True                 
  done clear
  B)
  False
  done clear
  C)
  None of these
  done clear
  D)
  All of the above
  done clear
  View Answer play_arrow

• question_answer5)
  Creating a database, including creating, altering, an dropping tables and establishing consents are example of Data Manipulation Language (DML).
  A)
  True                 
  done clear
  B)
  False
  done clear
  C)
  None of these
  done clear
  D)
  All of the above
  done clear
  View Answer play_arrow

• question_answer6)
  To work with range of values, LIKE keyword is used with WHERE statement.
  A)
  True                 
  done clear
  B)
  False
  done clear
  C)
  None of these
  done clear
  D)
  All of the above
  done clear
  View Answer play_arrow

• question_answer7)
  The keyword BETWEEN can be used while working with a range of values.
  A)
  True  
  done clear
  B)
  False
  done clear
  C)
  None of these
  done clear
  D)
  All of the above
  done clear
  View Answer play_arrow

• question_answer8)
  .....................keyword is used to specify the table that contains the data to be retrieved.
  A)
  from                 
  done clear
  B)
  where
  done clear
  C)
  having              
  done clear
  D)
  like
  done clear
  View Answer play_arrow

• question_answer9)

  What Is the output of the following query:

  Select CHAR(70,65,67,69),

  A)
  Face                 
  done clear
  B)
  Fbce
  done clear
  C)
  FACE 
  done clear
  D)
  ‘70656769'
  done clear
  View Answer play_arrow

• question_answer10)
  To get all the columns, use ............... instead of column names.
  A)
         
  done clear
  B)
       
  done clear
  C)
     
  done clear
  D)
  
  done clear
  View Answer play_arrow

• question_answer11)
  .................... clause contains the condition in SELECT statement.
  A)
  having                          
  done clear
  B)
  like
  done clear
  C)
  group by         
  done clear
  D)
  where
  done clear
  View Answer play_arrow

• question_answer12)
  If you want to execute a statement when both the conditions are true In Where clause, then you will use............... operator.
  A)
  OR      
  done clear
  B)
  NOT IN
  done clear
  C)
  NOT                
  done clear
  D)
  AND
  done clear
  View Answer play_arrow

• question_answer13)
  If you want to execute a statement when one of the condition is true in Where clause, then you will use............... operator.
  A)
  OR     
  done clear
  B)
  NOT IN
  done clear
  C)
  IN                    
  done clear
  D)
  AND
  done clear
  View Answer play_arrow

• question_answer14)
  Consider the query: SELECT name FROM Study where Fees.............NULL; Fill In the above blank with an appropriate operator
  A)
  AND                
  done clear
  B)
  IS
  done clear
  C)
  LIKE                
  done clear
  D)
  NOT LIKE
  done clear
  View Answer play_arrow

• question_answer15)
  If you want to exclude one or more values (from list), then you will use..................
  A)
  OR      
  done clear
  B)
  NOT IN
  done clear
  C)
  IN                    
  done clear
  D)
  AND
  done clear
  View Answer play_arrow

• question_answer16)
  Pattern matching is possible by...................... Keyword.
  A)
  LIKE                
  done clear
  B)
  NOT LIKE
  done clear
  C)
  both a and b       
  done clear
  D)
  none of these
  done clear
  View Answer play_arrow

• question_answer17)

  What is the output of the following query:

  Select SUBSTR('Study Trigger', 6, 7);

  A)
  Study               
  done clear
  B)
  Trigger
  done clear
  C)
  Study Trigger     
  done clear
  D)
  none of these
  done clear
  View Answer play_arrow

• question_answer18)

  What is the output of the following query:

  Select INSTR('Study Trigger', 'ri');

  A)
  8       
  done clear
  B)
  7
  done clear
  C)
  6                     
  done clear
  D)
  none of these
  done clear
  View Answer play_arrow

• question_answer19)

  What is the output of the following query:

  Select DATE(2021-08-03 01:02:03');

  A)
  2021-08-03     
  done clear
  B)
  03
  done clear
  C)
  08                    
  done clear
  D)
  2021-08-03 01:02:03
  done clear
  View Answer play_arrow

• question_answer20)

  What is the output of the following query:

  Select MOD(15,4);

  A)
  0         
  done clear
  B)
  1
  done clear
  C)
  2                     
  done clear
  D)
  3
  done clear
  View Answer play_arrow