MYSQL - Interview Questions
This is a discussion on MYSQL - Interview Questions within the Interview Questions & Answers and Tips forums, part of the DiscussWeb IT Curriculum category; Can we able to commit a transaction inside a Stored Function? Answer: No, We cannot able to commit the transaction ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
08-29-2007, 02:52 AM
| |||
| |||
 MYSQL - Interview Questions Can we able to commit a transaction inside a Stored Function? Answer: No, We cannot able to commit the transaction in Functions and Triggers.
__________________ -Murali..     |
| Sponsored Links |
|
08-29-2007, 04:40 AM
| |||
| |||
| Re: MYSQL - Interview Questions Which Storage Engine supports Referential constraint integrity with transactions? Answer: InnoDB is the Storage engine supports Referential constraint integrity with transactions.
__________________ -Murali.. |
|
08-31-2007, 08:34 AM
| |||
| |||
 Re: MYSQL - Interview Questions Question: How to store images in Mysql Data base? Answer: We should use with LOB / BLOB / CLOB large object datatypes to store images in DB.
__________________ Thanks & Regards Sabari... |
Re: MYSQL - Interview Questions |
08-31-2007, 08:52 AM
| |||
| |||
 Re: MYSQL - Interview Questions Question: How is Sequences handled in MySQL? Answer:Sequences are handled by primary key or by unique in which primary keys don't allow any duplicate rows and null values are not accepted. Sequences and unique allows multiple NULL values and duplicates values are not allowed
__________________ Thanks & Regards Sabari... |
|
08-31-2007, 09:06 AM
| |||
| |||
| Re: MYSQL - Interview Questions Hi Sabari, There is no sequence object available in mysql but you can have handle sequences using AUTO_INCREMENT value. As you mentioned PRIMARY key & Unique key are contraints and sequence is different one.
__________________ Keep smiling...  |
|
09-04-2007, 04:35 AM
| |||
| |||
| Re: MYSQL - Interview Questions Quote:
__________________ -Murali.. Last edited by Murali : 09-04-2007 at 04:45 AM. |
|
09-04-2007, 07:17 AM
| |||
| |||
| Re: MYSQL - Interview Questions hi priyan & Murali, yes there is no sequence in mysql, using AUTO_INCREMENT we can create sequence values. In my previous posts i was commented like this "Sequences and unique allows multiple NULL values" i'm apology for this mistake. This is correct one is "Sequences not allow NULL values", Thanks for your information...
__________________ Thanks & Regards Sabari... |
|
09-04-2007, 08:42 AM
| |||
| |||
| Re: MYSQL - Interview Questions Quote:
Cool......... there is no need for apologies. Its the place to share our knowledge. The correct information has to be reached to all. Just ask your doubts and get it cleared !!!
__________________ -Murali.. |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
LinkBacks (?)
LinkBack to this Thread: http://www.discussweb.com/interview-questions-answers-tips/3548-mysql-interview-questions.html | |||
| Posted By | For | Type | Date |
| DiscussWeb IT Community - Technical Support and Technology Discussions | This thread | Refback | 09-04-2007 07:43 AM |
|
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| HR Interview Questions with Answers | Sabari | Interview Questions & Answers and Tips | 63 | 11-23-2007 06:13 AM |
| XML Interview Questions and Answer | it.wily | Interview Questions & Answers and Tips | 35 | 11-21-2007 10:32 PM |
| Interview questions from TOP IT Companies | venkat_charya | Interview Questions & Answers and Tips | 19 | 10-13-2007 05:59 AM |
| MYSQL interview questions | it.wily | Interview Questions & Answers and Tips | 1 | 09-04-2007 04:33 AM |
| Interview Questions | shiva | Interview Questions & Answers and Tips | 6 | 08-24-2007 02:28 AM |
All times are GMT -7. The time now is 06:53 PM.
