MySQL Interview Questions
Questions Answers Views Company eMail

Explain the architecture models of SQL Server?

1244

why not null is not allowed at table level

Cognizant,

1437

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

1628




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

777

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

2 1449

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

478

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

309


Post New MySQL Questions






Un-Answered Questions { MySQL }

why not null is not allowed at table level

1437


1.how to fetch a value and Execute store procudure in mysql(INNODB) using phpMyAdmin? 2.can i wright a package in mysql database(INNODB)?

1090


What are the method you will follow while sql installing

1228


i made a table whih contain a column "Photo" with image data type and i want to insert the byte of a picture present in my hardisk using insert statement in that colum... so what will be my insert statement?

1460


How can you plan the logshipping before processing?

1179






What are the critical issues you have resolved in your company

1047


explain GROUPBY & HAVING clause with examples.

1154


How to set the time zone for MySQL to particular country time?

2040


all the queries used in sql

1478


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

478


what is mysql optimization in brief?

1212


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

309


How internally data stores in MyISAM and INNODB table types?

1402


How can you move the master database

847


Explain the architecture models of SQL Server?

1244