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. Moves the record pointer
mysql_select_db()
mysql_data_seek()
mysql_ping()
mysql_free_result()

2. Returns the type of a field in a recordset
mysql_error()
mysql_field_type()
mysql_db_name()
mysql_errno()

3. Returns MySQL host info
mysql_get_host_info()
mysql_errno()
mysql_get_server_info()
mysql_list_dbs()

4. Sets the active MySQL database
mysql_affected_rows()
mysql_field_type()
mysql_query()
mysql_select_db()

5. Escapes a string for use in SQL statements
mysql_num_rows()
mysql_real_escape_string()
mysql_fetch_array()
mysql_select_db()

6. Returns a row from a recordset as a numeric array
mysql_data_seek()
mysql_fetch_row()
mysql_unbuffered_query()
mysql_fetch_object()

7. Returns the name of the table the specified field is in
mysql_field_table()
mysql_field_type()
mysql_ping()
mysql_field_seek()

8. Pings a server connection or reconnects if there is no connection
mysql_get_host_info()
mysql_get_proto_info()
mysql_ping()
mysql_affected_rows()

9. Opens a persistent MySQL connection
mysql_fetch_object()
mysql_pconnect()
mysql_field_table()
mysql_field_seek()

10. Returns the flags associated with a field in a recordset
mysql_info()
mysql_field_flags()
mysql_get_host_info()
mysql_errno()

11. Lists MySQL processes
mysql_fetch_row()
mysql_field_name()
mysql_field_seek()
mysql_list_processes()

12. Returns the name of a field in a recordset
mysql_field_name()
mysql_real_escape_string()
mysql_free_result()
mysql_client_encoding()

13. Returns the number of fields in a recordset
mysql_num_fields()
mysql_select_db()
mysql_get_proto_info()
mysql_list_processes()

14. Returns the number of affected rows in the previous MySQL operation
mysql_affected_rows()
mysql_fetch_lengths()
mysql_field_flags()
mysql_field_name()

15. Returns MySQL server info
mysql_get_client_info()
mysql_fetch_lengths()
mysql_get_server_info()
mysql_field_seek()

16. Returns column info from a recordset as an object
mysql_fetch_field()
mysql_db_name()
mysql_insert_id()
mysql_get_server_info()

17. Executes a query on a MySQL database
mysql_info()
mysql_get_server_info()
mysql_query()
mysql_field_type()

18. Returns the length of the contents of each field in a result row
mysql_fetch_lengths()
mysql_real_escape_string()
mysql_error()
mysql_get_server_info()

19. Returns the error number of the last MySQL operation
mysql_errno()
mysql_pconnect()
mysql_free_result()
mysql_field_flags()

20. Returns the error description of the last MySQL operation
mysql_error()
mysql_field_seek()
mysql_get_server_info()
mysql_field_flags()

21. Returns a row from a recordset as an associative array
mysql_field_len()
mysql_num_rows()
mysql_data_seek()
mysql_fetch_assoc()

22. Returns the current thread ID
mysql_close()
mysql_thread_id()
mysql_fetch_object()
mysql_fetch_array()

23. Returns a database name from a call to mysql_list_dbs()
mysql_field_len()
mysql_info()
mysql_fetch_row()
mysql_db_name()

24. Executes a query on a MySQL database (without fetching / buffering the result)
mysql_list_processes()
mysql_unbuffered_query()
mysql_error()
mysql_real_escape_string()

25. Returns MySQL protocol info
mysql_get_proto_info()
mysql_list_dbs()
mysql_num_fields()
mysql_list_processes()

26. Opens a non-persistent MySQL connection
mysql_num_fields()
mysql_ping()
mysql_connect()
mysql_fetch_field()

27. Returns the maximum length of a field in a recordset
mysql_field_len()
mysql_client_encoding()
mysql_real_escape_string()
mysql_field_name()

28. Returns the current system status of the MySQL server
mysql_stat()
mysql_fetch_object()
mysql_client_encoding()
mysql_field_table()

29. Moves the result pointer to a specified field
mysql_num_rows()
mysql_get_proto_info()
mysql_select_db()
mysql_field_seek()

30. Returns the number of rows in a recordset
mysql_client_encoding()
mysql_num_rows()
mysql_errno()
mysql_get_proto_info()

31. Free result memory
mysql_num_rows()
mysql_get_host_info()
mysql_field_name()
mysql_free_result()

32. Lists available databases on a MySQL server
mysql_thread_id()
mysql_fetch_lengths()
mysql_num_rows()
mysql_list_dbs()

33. Returns the AUTO_INCREMENT ID generated from the previous INSERT operation
mysql_result()
mysql_insert_id()
mysql_get_server_info()
mysql_unbuffered_query()

34. Returns the value of a field in a recordset
mysql_get_server_info()
mysql_result()
mysql_list_dbs()
mysql_stat()

35. Returns a row from a recordset as an object
mysql_errno()
mysql_data_seek()
mysql_unbuffered_query()
mysql_fetch_object()

36. Closes a non-persistent MySQL connection
mysql_fetch_array()
mysql_close()
mysql_client_encoding()
mysql_thread_id()

37. Returns information about the last query
mysql_unbuffered_query()
mysql_info()
mysql_fetch_row()
mysql_stat()

38. Returns a row from a recordset as an associative array and/or a numeric array
mysql_connect()
mysql_fetch_array()
mysql_insert_id()
mysql_pconnect()

39. Returns the name of the character set for the current connection
mysql_get_server_info()
mysql_field_table()
mysql_real_escape_string()
mysql_client_encoding()

40. Returns MySQL client info
mysql_client_encoding()
mysql_ping()
mysql_num_fields()
mysql_get_client_info()