12th Class Computers Science Sample Paper

done SQL Connectivity - Sample Paper-2 Total Questions - 15    [Download]

• question_answer1)
  To count the number of rows in a database, .........................command is used
  A)
  row                              
  done clear
  B)
  rowcount
  done clear
  C)
  count()             
  done clear
  D)
  row_count
  done clear
  View Answer play_arrow

• question_answer2)
  To displaying only one row from resultset, we use.................... method
  A)
  fetchmany       
  done clear
  B)
  fetchno
  done clear
  C)
  fetchall             
  done clear
  D)
  fetchone
  done clear
  View Answer play_arrow

• question_answer3)
  ...........................method is used to execute all the rows from the result set.
  A)
  fetchmany       
  done clear
  B)
  fetchone
  done clear
  C)
  fetchall             
  done clear
  D)
  none of the above
  done clear
  View Answer play_arrow

• question_answer4)
  fetchmany(1) and fetchone() gives the same result
  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)
  Which of the following method require parameters to execute.
  A)
  fetchall()        
  done clear
  B)
  fetchmany()
  done clear
  C)
  fetchone()       
  done clear
  D)
  none of the above
  done clear
  View Answer play_arrow

• question_answer6)
  What will fetchone() method the return if there are no record in the database
  A)
  error                 
  done clear
  B)
  None
  done clear
  C)
  crash the program
  done clear
  D)
  none of the above
  done clear
  View Answer play_arrow

• question_answer7)
  Which command is used for cleaning up the environment.
  A)
  my.close()       
  done clear
  B)
  is.close ()
  done clear
  C)
  con.close()  
  done clear
  D)
  mycon.close()
  done clear
  View Answer play_arrow

• question_answer8)
  Read the given code, assume that all the necessary file already imported: Which method will you use for executing the above query?
  A)
  fetchall()           
  done clear
  B)
  cursor()
  done clear
  C)
  execute()  
  done clear
  D)
  None of the above
  done clear
  View Answer play_arrow

• question_answer9)
  ...................statement will be executed to ensure that changes you made in the code related to table are also being reflected in the database.
  A)
  fetchall()           
  done clear
  B)
  commit()
  done clear
  C)
  execute()        
  done clear
  D)
  None of the above
  done clear
  View Answer play_arrow

• question_answer10)
  Whenever you run Insert, Update and Delete query using Python code, you must run ...........method within the connection object.
  A)
  fetchall()           
  done clear
  B)
  commit()
  done clear
  C)
  execute()        
  done clear
  D)
  None of the above
  done clear
  View Answer play_arrow

• question_answer11)

  What is the correct statement for line 1 to Import the mysql file

   
  A)
  sql        
  done clear
  B)
  mysql
  done clear
  C)
  connection       
  done clear
  D)
  None of the above
  done clear
  View Answer play_arrow

• question_answer12)

  What Is the correct statement for line 2 to select all student whose marks Is greater than 70

   
  A)
  select * from Students where marks >=70
  done clear
  B)
  select Name from Students where marks >=70
  done clear
  C)
  select* from Students where marks >70
  done clear
  D)
  None of the above
  done clear
  View Answer play_arrow

• question_answer13)

  What Is the correct statement for line 3 to fetch all records

   
  A)
  fetchone()       
  done clear
  B)
  fetchall()
  done clear
  C)
  fetchmany()      
  done clear
  D)
  None of the above
  done clear
  View Answer play_arrow

• question_answer14)

  What Is the correct statement for line 4 to display total number of rows you will from the database

   
  A)
  rows                 
  done clear
  B)
  rowcount
  done clear
  C)
  data.count       
  done clear
  D)
  data.length
  done clear
  View Answer play_arrow

• question_answer15)

  What Is the correct statement for line 5 to cleanup the environment as well as remove the connection

   
  A)
  clear()               
  done clear
  B)
  clean()
  done clear
  C)
  close()     
  done clear
  D)
  none of the above
  done clear
  View Answer play_arrow