MySQL Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

MySQL Interview Questions

Questions Answers Views Company eMail

Explain the architecture models of SQL Server?

2291

why not null is not allowed at table level

Cognizant,

2712

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products

2779

What is difference between Sql server and MySql database? It may be silly question but i really dont know.

2062

Table A has 5 rows and table B has 0 rows Cartesian join on A,B will have----rows

2 3912

Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

1576

what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL

1332

What is the difference between truncate and delete?

DELL,

1118

how to add a new column to an existing table?

MCN Solutions,

949

SQL is not case sensitive. DELETE is the same as delete. State Whether True or False?

960

Which statement is used to delete a table in MySQL.

861

Transactions are used to treat sets of SQL statements atomically. State Whether True or False?

1400

Explain about the architecture of MYSQL?

931

Explain about reporting services of MYSQL?

1016

In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?

1010

Post New MySQL Questions

Un-Answered Questions { MySQL }

How to display top 10 rows in mysql?

987

What are numeric data types?

941

What are triggers mysql?

852

How many rows mysql can handle?

888

How to write optimized query in mysql?

945

Is mongodb faster than mysql?

879

In how many ways we can retrieve data in the result set of mysql using php?

1068

Is mysql and sql are same?

994

What does blob mean in mysql?

910

How to drop an existing table in mysql?

969

Why mysql is open source?

869

How to update database permissions/privilages.

928

Does uninstalling mysql delete database?

954

What is the difference between the primary and unique key in mysql?

928

What is the difference between a database and a table?

958

For More Un-Answered { MySQL } Questions Click Here