Advantages of MyISAM over InnoDB
Explain advantages of MyISAM over InnoDB?
Expert
Advantages are:
a. MyISAM follows a much more conservative approach to disk space management – storing each MyISAM table in a separate file, if required can further be compresses.
b. InnoDB stores the tables in tablespace in which further optimization is difficult with them.
Define the term sparse column sets.
Create a procedure named BASKET_ADD_SP that accepts a product id, basket id, price, quantity, size code(1or2) and from code(3 or 4) and that uses this information to add a new item to the BB_BASKETITEM table.
Explain about the Entity Data Services within sql server 2008.
Illustrates the term Linked Server in the SQL Statement?
Explain about encryption of whole databases without the requirement for application changes in SQL server 2008.
Explain about the Commit.
Explain about the Sequences in SQL?
What do you mean by Heap tables? And also define its characteristics?
What is TEXT?
Define the Notification services.
18,76,764
1950502 Asked
3,689
Active Tutors
1414806
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!