MySQL Test:
Instruction:
Total number of questions : 30.
Time allotted : 60 minutes.
Each question carry 1 mark, no negative marks.
DO NOT refresh the page.
All the best :-).
MySQL Online Test
Quiz-summary
0 of 15 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
Information
MySQL Online Test
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 15 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- Answered
- Review
-
Question 1 of 15
1. Question
how do you select a column named “FirstName” from a table named “Persons”?
Correct
Incorrect
-
Question 2 of 15
2. Question
Which one correct update query syntax?
Correct
Incorrect
-
Question 3 of 15
3. Question
Which one Database is best MyISAM Or InnoDB?
Correct
Incorrect
-
Question 4 of 15
4. Question
How mouch type of JOIN use in MYSQL?
Correct
Inner Join
LEFT Join
Right Join
Self JoinIncorrect
-
Question 5 of 15
5. Question
How to select all record from table?
Correct
Incorrect
-
Question 6 of 15
6. Question
How to Select All Columns From Table?
Correct
Incorrect
-
Question 7 of 15
7. Question
how do you select all the records from a table named “Students” where the value of the column “FirstName” is “Joy”?
Correct
Incorrect
-
Question 8 of 15
8. Question
how do you select all the records from a table named “Students” where the value of the column “FirstName” starts with an “J”?
Correct
Incorrect
-
Question 9 of 15
9. Question
The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL the conditions listed are true?
Correct
Incorrect
-
Question 10 of 15
10. Question
how do you select all the records from a table named “Students” where the “FirstName” is “Joy” and the “LastName” is “Majo”?
Correct
Incorrect
-
Question 11 of 15
11. Question
Which SQL keyword is used to sort the result-set?
Correct
Incorrect
-
Question 12 of 15
12. Question
how can you return all the records from a table named “Students” sorted descending by “FirstName”?
Correct
Incorrect
-
Question 13 of 15
13. Question
Select Correct Insert Query Syntax?
Correct
Incorrect
-
Question 14 of 15
14. Question
How can you change “Joy” into “Ajay” in the “LastName” column in the students table?
Correct
Incorrect
-
Question 15 of 15
15. Question
how can you delete the records where the “FirstName” is “Joy” in the Studens Table?
Correct
Incorrect
Excellent goods from you, man. I’ve understand your stuff previous to and you’re just extremely wonderful.
I really like what you have acquired here, really like what you are
saying and the way in which you say it. You make
it enjoyable and you still take care of to keep it smart. I cant wait to read much more from you.
This is actually a wonderful website.