Wednesday 30 July 2014

Hello Everyone...!!!

 

Every Thursday we conduct a quiz practice for PHP DEVELOPER which help them to improve their WEB DEVELOPMENT skills

 

Today i am Here are some mySQL (Database) questions to solve...

 

 
interview questions for PHP developers, PHP web development test, PHP quiz questions
PHP interview questions

 

Que.1 The updated MySQL extension released with PHP 5 is typically referred to as..


a) MySQL
b) mysql
c) mysqli
d) mysqly 


Que. 2 mysql_connect( ) does not take following parameter


a) Database host 
b) User ID
c) Password
d) Database name


Que. 3 Which one of the following statements instantiates the mysqli class?

a) mysqli = new mysqli()
b) $mysqli = new mysqli()
c) $mysqli->new.mysqli()
d) mysqli->new.mysqli()

Que. 4 Which of the following is not a session function?


a) sssion_decode
b) session_destroy
c) sessipon_id
d) session_PW


Que. 5 Which one of the following methods is responsible for sending the query to the database?


a) query()
b) send_query()
c) sendquery()
d) query_send()


Que.6  Which one of the following methods recuperates any memory consumed by a result set?


a) destroy()
b) remover()
c) alloc()
d) free()


Que.7  If there is no error, then what will the error() method return?


a) TRUE
b) FALSE
c) Empty String
d) 0


Que. 8 Which version of MySQL introduced the prepared statements?


a) MySQL 4.0
b) MySQL 4.1
c) MySQL 4.2
d) MySQL 4.3


Que.9  Which method retrieves each row from the prepared statement result and assigns the fields to the bound results?


a) get_row()
b) fetch_row()
c) fetch()
d) row()


Que. 10 Which one of the following statements should be used to include a file?


a) #include ‘filename’;
b) include ‘filename’;
c) @include ‘filename’;
d) #include 


Answersheet of this quiz will be available tomorrow ..


Want more Questions CLICK THE LINKS BELOW


 PHP Multiple choice questions and answers-1
  PHP Multiple choice questions and answers-2
  PHP Multiple choice questions and answers-3
  PHP Multiple choice questions-4
 



Share your experience or if you have any suggestion feel free to give in comments


Regards : M2 Software Solutions Pvt. Ltd. 




0 comments:

Post a Comment

  • RSS
  • Delicious
  • Digg
  • Facebook
  • Twitter
  • Linkedin
  • Youtube