Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

MySQL Interview Questions
Questions Answers Views Company eMail

Explain the architecture models of SQL Server?

1605

why not null is not allowed at table level

Cognizant,

1910

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

2077

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

1173

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

2 2301

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

843

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

649

What is the difference between truncate and delete?

DELL,

266

how to add a new column to an existing table?

MCN Solutions,

227

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

223

Which statement is used to delete a table in MySQL.

213

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

420

Explain about the architecture of MYSQL?

210

Explain about reporting services of MYSQL?

229

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 ?

215


Post New MySQL Questions






Un-Answered Questions { MySQL }

Can mysql handle billions of records?

144


How can you find out the version of the installed mysql?

240


How can I insert images into a Mysql database?

228


Is sql similar to mysql?

164


How can I connect mysql database?

146






How do you insert a table?

165


What is mysql database used for?

158


What is data directory in mysql?

163


Is pdo faster than mysqli?

163


How to insert html code into mysql database using php?

167


What is the datatype of image in mysql?

161


How set mysql root password?

172


Can you tell the difference between ereg_replace() and eregi_replace()?

197


How do I exit mysql?

156


Consider a scenario where you have two to three tables with thousand tuples in each of them. Now, if you have to perform a join operation between them will you choose to perform filtering of rows or transforming of rows first.

211