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. Sets the active MySQL database






3. Returns information about the last query






4. Returns the number of rows in a recordset






5. Returns MySQL protocol info






6. Returns a row from a recordset as an object






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






8. Returns the type of a field in a recordset






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






10. Closes a non-persistent MySQL connection






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






12. Returns the current thread ID






13. Returns the error description of the last MySQL operation






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






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






16. Returns the error number of the last MySQL operation






17. Executes a query on a MySQL database






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






19. Opens a non-persistent MySQL connection






20. Lists MySQL processes






21. Returns MySQL host info






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






23. Escapes a string for use in SQL statements






24. Returns MySQL client info






25. Opens a persistent MySQL connection






26. Returns column info from a recordset as an object






27. Lists available databases on a MySQL server






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






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






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






31. Returns the name of a field in a recordset






32. Returns the value of a field in a recordset






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






34. Free result memory






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






36. Returns the current system status of the MySQL server






37. Returns MySQL server info






38. Moves the result pointer to a specified field






39. Returns the number of fields in a recordset






40. Moves the record pointer