Register|Login

Have a question? Click here to ask the community.

Quiz 5 – Selecting Data From A Database

| In: MySQL Quizzes | 9,888 views

*You are currently not logged in and your quiz score will not be recorded. Please login or register if you would like to submit your quiz score.

Directions: Answer all questions. Any questions skipped will be scored as wrong answers. Good Luck! :)

1. The “mysql_fetch_array()” when used in a while loop will evalute to TRUE when it reaches the last record/row within a table?

True
False

2. The SELECT query is used to get information from a database?

True
False

3. Assuming the table and fields below exists, what is wrong with the following mysql query example:

mysql_query(“SELECT * FROM contacts”);

No columns/fields were selected
There should be a comma after the “*” character
Nothing, everything is fine

4. Assuming the table and fields below exists, what is wrong with the following mysql query example:

mysql_query(“SELECT firstName lastName FROM contacts”);

There should be a comma after “lastName”
There should be a comma after “firstName”
Nothing, everything is fine

5. Assuming the table and fields below exists, what is wrong with the following mysql query example:

mysql_query(“SELECT FROM contacts”);

No columns/fields were selected
There should be a comma after “SELECT”
Nothing, everything is fine



1 Response to Quiz 5 – Selecting Data From A Database

Avatar

Manas

April 28th, 2015 at 2:37 am

Very easy

Comment Form

You must be logged in to post a comment.

Users Online

Users Online: 2 Users

Most Users Ever Online: 91

Quiz Scores

Advertisments