MySQL online test - MySQL certification dumps - MySQL quiz

Preparing to face a written test, job interview or certification exam on MySQL? Reading books after books on MySQL alone will not help you to face an interview or take a written test -you would need some real time practice to do that. These sample questions on MySQL are an excellent mix of various aspects of MySQL. Questions here range from checking your very basic fundamentals on MySQL to more advanced tricky technical topics as a MySQL professional. Practice with online objective test to face the written tests on MySQL confidently.
Online Practice Test > MySQL online test
Click here to start MySQL online quiz/test
Here are few sample MySQL test/quiz questions

How can we get the number of records or rows in a table?

Using COUNT
Using NUM
Using NUMBER
Both a and c above

How do I find out all databases starting with ‘test to which I have access to?

SHOW DATABASES LIKE ‘%test%’;
SHOW DATABASES LIKE ‘%test;
SHOW DATABASES LIKE ‘'test'%’;
SHOW DATABASES LIKE ‘test%’;
 

Click here to start MySQL online quiz/test  

More Links

How will you export tables as an XML file in MySQL?
What is the use of i-am-a-dummy flag in MySQL?
What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?
What is difference between mysql_connect and mysql_pconnect?
What is MySQL data directory? How to determine the location of the data directory?
What you can use Regular Expression for in MySQL? Support your answer with an example.
 



Write your comment - Share Knowledge and Experience

Discussion Board
MySQL Online Test - MySQL Certification dumps - MySQL Quiz

A view is nothing but a ________ table or a stored query

Dymanic
Real
Virtual
Static


MySQL Online Test 05-11-2012 07:47 AM

MySQL Online Test - MySQL Certification dumps - MySQL Quiz

How can we get the number of records or rows in a table?

Using COUNT
Using NUM
Using NUMBER
Both a and c above


MySQL Online Test 05-11-2012 07:47 AM

MySQL Online Test - MySQL Certification dumps - MySQL Quiz

How do I find out all databases starting with ‘test to which I have access to?

SHOW DATABASES LIKE ‘%test%’;
SHOW DATABASES LIKE ‘%test;
SHOW DATABASES LIKE ‘'test'%’;
SHOW DATABASES LIKE ‘test%’;


MySQL Online Test 05-11-2012 07:47 AM

MySQL Online Test - MySQL Certification dumps - MySQL Quiz

Can I define multiple unique constraints on a table?

Yes
No


MySQL Online Test 05-11-2012 07:46 AM

More online test

Biztalk Test
Networking Test
Iphone Test
Android Quiz
Wireless Communication Test
OS test
Linux Test
Linux Quiz
Linux Certification
C Online Quiz
C++ Online Test


Career 12-20-2011 04:39 AM

 


Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring