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 length of the contents of each field in a result row






2. Returns the number of fields in a recordset






3. Returns MySQL server info






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






5. Returns MySQL client info






6. Returns the number of rows in a recordset






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






8. Returns the current thread ID






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






10. Returns MySQL host info






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






12. Returns the error number of the last MySQL operation






13. Returns the type of a field in a recordset






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






15. Opens a non-persistent MySQL connection






16. Returns information about the last query






17. Moves the record pointer






18. Opens a persistent MySQL connection






19. Free result memory






20. Returns column info from a recordset as an object






21. Escapes a string for use in SQL statements






22. Moves the result pointer to a specified field






23. Returns the name of a field in a recordset






24. Executes a query on a MySQL database






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






26. Returns the current system status of the MySQL server






27. Returns the value of a field in a recordset






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






29. Lists MySQL processes






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






31. Returns a row from a recordset as an object






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






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






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






35. Closes a non-persistent MySQL connection






36. Lists available databases on a MySQL server






37. Returns the error description of the last MySQL operation






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






39. Sets the active MySQL database






40. Returns MySQL protocol info