Answers were Sorted based on User's Feedback
Answer / subrat
MyISAM: This is default. Based on Indexed Sequntial Access
Method. The above SQL will create a MyISA table.
ISAM : same
HEAP : Fast data access, but will loose data if there is a
crash. Cannot have BLOB, TEXT & AUTO INCRIMENT fields
BDB : Supports Transactions using COMMIT & ROLLBACK. Slower
InoDB : same as BDB
|Is This Answer Correct ?||13 Yes||1 No|
Answer / sankar
its not inoDB is InnoDB
|Is This Answer Correct ?||9 Yes||1 No|
Answer / rajesh kumar
BDB supports transaction and page level locking. InnoDB
Supports Foreign Keys, Row level locking & transaction .
|Is This Answer Correct ?||3 Yes||0 No|
How do you start MySQL on Linux?
Ondelete clause is specified with a.)Drop table b.)Delete command c.)Create table d.)Select command
what is the advantage of left outer join?
what is mySQL. Is there any specific qualification required to do this course ? What is the scope in India after doing mySQL
What is Foreign Key? What is the main difference between primary key and Foreign Key ? How Foreign Key can be defined? Is Foreign key is used to join two or more table?
What is difference b/w composit key n primary key and forigion key?
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
how to take mysql database structure backup
Can you save your connection settings to a conf file?
What is check constraint?
What is striped backup
Give the syntax of GRANT commands?