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. Opens a non-persistent MySQL connection






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






3. Opens a persistent MySQL connection






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






5. Returns the current thread ID






6. Sets the active MySQL database






7. Returns the error number of the last MySQL operation






8. Returns the number of fields in a recordset






9. Returns a row from a recordset as an object






10. Lists available databases on a MySQL server






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






12. Returns the type of a field in a recordset






13. Returns MySQL host info






14. Returns the name of a field in a recordset






15. Returns the current system status of the MySQL server






16. Escapes a string for use in SQL statements






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






18. Executes a query on a MySQL database






19. Returns the value of a field in a recordset






20. Free result memory






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






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






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






24. Moves the record pointer






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






26. Moves the result pointer to a specified field






27. Returns the error description of the last MySQL operation






28. Returns MySQL client info






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






30. Returns column info from a recordset as an object






31. Closes a non-persistent MySQL connection






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






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






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






35. Returns the number of rows in a recordset






36. Returns MySQL protocol info






37. Returns MySQL server info






38. Lists MySQL processes






39. Returns information about the last query






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






Content not found.:)

Browse BasicVersity