|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)

MyISAM is of course the default table type i'm MySQL. It's an improvement over the now-deprecated ISAM table type. It provides a simple tree structure for quick indexing on small tables, typicall fewer than 10,000 rows of data.
There are some other types of tables supported in MySQL, most of which won't provide any noticable differences.
A MERGE table is a table that only exists in memory, and will not be saved if MySQL crashes or has to be restarted.
It is, as the name suggests, a merge of two (or more) tables. If you drop a MERGE table, it only drops the
reference to the merge, not to the tables that are combined in it. It's not good for much!
Another table, the one which is best for huge tables, is InnoDB. It's probably the best RDBMS out there; it's
actually a whole set of drivers on it's own, and when you use it, MySQL is really just a wrapper around the InnoDB table. Slashdot and other megamammoth sites out there use it, it's fast and effecient, but the trees are pretty large, so it's not good for smaller tables.
There are a few others.. like BerkeleyDB, which isn't anything special and doesn't provide any major performance increase.
The major difference between the various table types are the data tree structures and how they're handled within the RDBMS.
In the end, you'll probably find yourself sticking to MyISAM unless you're on a very large-scale project, in which cas eyou probably woudln't use MySQL anyway =D
Create Date
:
Sunday, March 09, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
Responsibility,it is the collection of menus,forms and requests .It will show the menus and
functions associated with the responsibility.
Adding responsibility for a specific user --
-> Go to administrator
-> security->User->Define
-> Query it,by pressing f11
-> enter the username for which u want to add the responsibility
-> Then press ctrl+f11
-> Then in the line information in the responsibility field add responsibility then save it.
Create Date
:
Monday, March 10, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
AIM methodlogy,,it has got six phases
definition,
Operation Analysis
Design
Build
Transition
Production
Create Date
:
Monday, March 10, 2008
Click here
to improve the Interview Question, Answer and other fields.
|
|
Inappropriate
|
See Answer
To Email:
Subject:
Note to go along with the question: (Optional, no
more than 1,000 characters)
P2P is Procure to Pay cycle.
1) Requisition creation in PO
2) Purchase order creation (Manual or Automatic)
3) Receipt creation
4) Invoicing in AP
5) Payment in AP
Create Date
:
Monday, March 10, 2008
Click here
to improve the Interview Question, Answer and other fields.