WEB DEV - QUIZ #2

In the MySQLi extension, what does "i" stands for?

• inversed

• insert

• improved

• inherit

Which of the following is a parameter needed to establish connection to the database?

• attribute

• query

• $con

• password

Which of the following function is used to establish database connection?

• mysqli_query()

• mysqli_connect()

• mysqli_connection()

• db_connect()

The _______ clause is used to extract only those records that fulfill a specified condition.

• WHERE

• FETCH

• QUERY

• SQL

What method is used to fetch value passed in the URL?

• POST

• GET

• SESSION

• FETCH

Which of the following is the correct syntax of deleting record?

• DELETE table_name
  WHERE some_column = some_value

• DELETE FROM table_name
  WHERE some_column : some_value

• DELETE table_name
  WHERE some_column : some_value

• DELETE FROM table_name
  WHERE some_column = some_value

This function accepts a string value representing a query as one of the parameters and, executes/performs the given query on the database.

• mysqli_connect()

• mysqli(connect)

• mysqli(query)

• mysqli_query()

The _____________ function accepts a result object as a parameter and retrieves the number of rows in the given result.

• mysqli_num_rows()

• mysqli_count_rows()

• mysqli_rows()

• mysqli_rows_count()

The SQL query must be quoted in PHP.

• TRUE

• FALSE

Which of the following is the syntax to select all records in the database?

• SELECT ^ FROM table_name

• SELECT * FROM table_name

• SELECT # FROM table_name

• SELECT ALL FROM table_name