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?

2339

why not null is not allowed at table level

Cognizant,

2765

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

2835

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

2128

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

2 4039

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

1644

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

1388

What is the difference between truncate and delete?

DELL,

1198

how to add a new column to an existing table?

MCN Solutions,

1032

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

1020

Which statement is used to delete a table in MySQL.

914

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

1460

Explain about the architecture of MYSQL?

982

Explain about reporting services of MYSQL?

1073

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 ?

1075

Post New MySQL Questions

Un-Answered Questions { MySQL }

In a property booking section want a query to check that property is booked from StartDate to EndDate.Booking Table field are given id proerty_id start_date checkout_date no_of_visitor booking date status Waiting yours answer.. Thanks In Advance...

3203

What are the limitations of mysql?

1048

What are all the Common SQL Function?

1139

Which is best pdo or mysqli?

922

How can you add and remove any column of a table?

947

How big is a blob mysql?

896

How do I create a database in mysql workbench?

878

What is difference between mongodb and mysql?

921

What is the use of i-am-a-dummy flag in mysql?

1015

how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

912

What is insert query in mysql?

916

How can you export the table as an xml file in mysql?

890

How to display top 10 rows in mysql?

1039

Where is the mysql config file?

990

Where is mysql data stored linux?

1025

For More Un-Answered { MySQL } Questions Click Here