Home › Quizzes › Php With SQL

Php With SQL

Tests knowledge of PHP programming with SQL databases, covering MySQLi and SQLite extensions, PHP file handling, session management, and core language constructs.

13 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

Which of the following extensions is an embedded structured query language library that does not require any SQL server?

  1. SimpleXML extension
  2. SQLite extension
  3. New MySqli extension
  4. Oracle server
  5. Oracle instance
Question 2 Multiple Choice (Single Answer)

Which of the following techniques enables you to embed large piece of text in your script which may include lots of double quotes without having to constantly escape them?

  1. Here-docs
  2. String offset
  3. MySqli_connect
  4. MySql_opt_connect_timeout
  5. MySqli_multi_query()
Question 3 Multiple Choice (Single Answer)

Which of the following constants represents that the size of the uploaded files exceeded the value of the special form field MAX_FILE_SIZE?

  1. UPLOAD_ERR_PARTIAL
  2. UPLOAD_ERR_FORM_SIZE
  3. UPLOAD_ERR_NO_FILE
  4. UPLOAD_ERR_OK
  5. $_POST[]
Question 4 Multiple Choice (Single Answer)

Which of the following functions is used to send a query to the database and return a result object?

  1. MySqli_multi_query()
  2. MySqli_fetch_object()
  3. MySqli_connect()
  4. next()
  5. MySqli_query()
Question 5 Multiple Choice (Single Answer)

Which of the following functions is used to execute a query and return the first column of the first returned record?

  1. Sqlite_query()
  2. Sqlite_exec()
  3. Upload_err_no_file
  4. Sqlite_single_query()
  5. $_GET[]
Question 6 Multiple Choice (Single Answer)

Which of the following functions is used to fetch all the results from the most recent query on the connection and stores them in memory?

  1. MySqli_fetch_assoc()
  2. MySqli_fetch_object()
  3. MySqli_query()
  4. Sqlite_fetch_array()
  5. MySqli_connect()
Question 7 Multiple Choice (Single Answer)

Which of the following allows an application to store information for the current session which can be defined as one user being logged into your application?

  1. EnableSession
  2. PHP session
  3. Session memory
  4. SQL injection
  5. MySqli_connect
Question 8 Multiple Choice (Single Answer)

Which of the following functions is used to send a query to the database and buffers the result?

  1. MySqli_query()
  2. MySqli_fetch_object()
  3. MySqli_fetch_row()
  4. Sqlite_fetch_array()
  5. MySqli_opt_connect_timeout
Question 9 Multiple Choice (Single Answer)

Which of the following extensions enables PHP developers to parse, diagnose, clean and repair hyper text markup language documents?

  1. New MySqli extension
  2. SimpleXML extension
  3. Perl extension
  4. Tidy extension
  5. An exact pattern to match
Question 10 Multiple Choice (Single Answer)

Which of the following extensions supports three kind of schemas for extensive markup language validation such as DTD, XML schema and RelaxNG?

  1. DOM extension
  2. SimpleXML extension
  3. New MySqli extension
  4. Perl extension
  5. An exact pattern match
Question 11 Multiple Choice (Single Answer)

Which of the following language constructs is used to check if a form variable has not been sent or does not contain data?

  1. unset()
  2. empty()
  3. NULL
  4. _construct()
  5. isset()
Question 12 Multiple Choice (Single Answer)

Which of the following language constructs is a way of assigning multiple array offsets to multiple variables in one statement?

  1. list()
  2. each()
  3. $_GET[]
  4. Array
  5. foreach()
Question 13 Multiple Choice (Single Answer)

Which of the following functions is used to return the whole result set as a two-dimensional array?

  1. Sqlite_fetch_array()
  2. Sqlite_fetch_all()
  3. Sqlite_query()
  4. Sqlite_exec()
  5. Mysqli_fetch_object()
← Back to Quizzes