Web Programming (3160713) MCQs

MCQs of Database programming with PHP and MySQL

Showing 1 to 6 out of 6 Questions
1.
Which one of the following databases has PHP supported almost since the beginning?
(a) Oracle
(b) SQL
(c) MySQL
(d) SQL+
Answer:

Option (c)

2.
Which one of the following statements is used to create a table?
(a) CREATE TABLE table_name (column_name column_type);
(b) CREATE table_name (column_type column_name);
(c) CREATE table_name (column_name column_type);
(d) CREATE TABLE table_name (column_type column_name);
Answer:

Option (a)

3.
Which one of the following statements is used to create a database?
(a) CREATE db databasename
(b) CREATE DATABASE databasename
(c) CREATE databasename
(d) DATABASE create databasename
Answer:

Option (b)

4.
Which one of the following is not a function to access the result generated in PHP
(a) mysql_fetch_row
(b) mysql_fetch_result
(c) mysql_fetch_assoc
(d) mysql_fetch_array
Answer:

Option (b)

5.
If you want to access the result generated by query using numberic index which method can be used
(a) mysql_fetch_row
(b) mysql_fetch_result
(c) mysql_fetch_assoc
(d) mysql_fetch_numeric
Answer:

Option (a)

6.
If you want to access the result generated by query using string index which method can be used
(a) mysql_fetch_row
(b) mysql_fetch_result
(c) mysql_fetch_assoc
(d) mysql_fetch_numeric
Answer:

Option (c)

Showing 1 to 6 out of 6 Questions