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 AUTO_INCREMENT ID generated from the previous INSERT operation






2. Executes a query on a MySQL database






3. Returns the error number of the last MySQL operation






4. Moves the result pointer to a specified field






5. Opens a persistent MySQL connection






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






7. Returns the name of a field in a recordset






8. Opens a non-persistent MySQL connection






9. Closes a non-persistent MySQL connection






10. Returns MySQL host info






11. Returns the number of rows in a recordset






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






13. Returns the value of a field in a recordset






14. Returns information about the last query






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






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






17. Returns the type of a field in a recordset






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






19. Returns the current system status of the MySQL server






20. Lists MySQL processes






21. Returns column info from a recordset as an object






22. Returns the number of fields in a recordset






23. Free result memory






24. Returns MySQL client info






25. Escapes a string for use in SQL statements






26. Returns the current thread ID






27. Lists available databases on a MySQL server






28. Returns MySQL server info






29. Returns MySQL protocol info






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






31. Returns a row from a recordset as an object






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






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






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






35. Sets the active MySQL database






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






37. Returns the error description of the last MySQL operation






38. Moves the record pointer






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






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