MySQL Questions asked in MNC

MySQL is not so efficient for large scale databases. It does not support COMMIT and STORED PROCEDURES functions version less than 5.0. Transactions are not handled very efficiently. The functionality of MySQL is highly dependent on other addons. Development is not community-driven. MySQL, like any technology, has its drawbacks: Limited Functionality: Compared to some other … Read more

MySQL is a free, fast, reliable, open-source relational database while Oracle is expensive, although they have provided Oracle free edition to attract MySQL users. MySQL uses only just under 1 MB of RAM on your laptop, while Oracle 9i installation uses 128 MB. MySQL is great for database enabled websites while Oracle is made for … Read more

FLOAT stores floating-point numbers with accuracy up to 8 places and allocate 4 bytes. On the other hand, DOUBLE stores floating-point numbers with accuracy up to 18 places and allocates 8 bytes. In MySQL, FLOAT and DOUBLE are both data types used for storing floating-point numbers. The primary difference between them lies in their storage … Read more

Heap tables: Heap tables are found in memory that is used for high-speed storage temporarily. They do not allow BLOB or TEXT fields. Heap tables do not support AUTO_INCREMENT. Indexes should be NOT NULL. Temporary tables: The temporary tables are used to keep the transient data. Sometimes it is beneficial in cases to hold temporary … Read more

A trigger is a set of codes that executes in response to some events. A trigger in MySQL is a set of SQL statements that automatically “fires” or executes when a specific event occurs on a table, such as INSERT, UPDATE, or DELETE operations. Triggers are commonly used to enforce data integrity rules, audit changes … Read more