Test your basic knowledge |

Php Mysql Basics

Subject : it-skills
Instructions:
  • Answer 40 questions in 15 minutes.
  • If you are not ready to take this test, you can study here.
  • Match each statement with the correct term.
  • Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.

This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Returns the current thread ID






2. Returns the maximum length of a field in a recordset






3. Returns MySQL server info






4. Opens a persistent MySQL connection






5. Returns the AUTO_INCREMENT ID generated from the previous INSERT operation






6. Pings a server connection or reconnects if there is no connection






7. Returns the number of rows in a recordset






8. Returns a database name from a call to mysql_list_dbs()






9. Returns MySQL protocol info






10. Returns the value of a field in a recordset






11. Executes a query on a MySQL database






12. Returns column info from a recordset as an object






13. Lists MySQL processes






14. Executes a query on a MySQL database (without fetching / buffering the result)






15. Returns the name of the character set for the current connection






16. Closes a non-persistent MySQL connection






17. Returns MySQL client info






18. Returns the length of the contents of each field in a result row






19. Returns the name of a field in a recordset






20. Returns a row from a recordset as an associative array and/or a numeric array






21. Returns a row from a recordset as an associative array






22. Returns a row from a recordset as an object






23. Returns the name of the table the specified field is in






24. Free result memory






25. Returns a row from a recordset as a numeric array






26. Returns the type of a field in a recordset






27. Returns the number of fields in a recordset






28. Opens a non-persistent MySQL connection






29. Returns the error description of the last MySQL operation






30. Returns the number of affected rows in the previous MySQL operation






31. Returns the error number of the last MySQL operation






32. Returns information about the last query






33. Returns the flags associated with a field in a recordset






34. Returns MySQL host info






35. Sets the active MySQL database






36. Moves the result pointer to a specified field






37. Moves the record pointer






38. Lists available databases on a MySQL server






39. Returns the current system status of the MySQL server






40. Escapes a string for use in SQL statements