21. How do you control the max size of a HEAP table? Maximum size of Heal table can be controlled by MySQL config variable called max_heap_table_size. 22. What is the …
11. Define REGEXP? REGEXP is a pattern match in which matches pattern anywhere in the search value. 12. Difference between CHAR and VARCHAR? Following are the differences between CHAR and …
1. What is MySQL? MySQL is an open source DBMS which is built, supported and distributed by MySQL AB (now acquired by Oracle)
31. In which phase should testing begin – requirements, planning, design, or coding? Testing should begin as early as the requirements phase. 32. Can you test a program and find …
21. What is the difference between QA and testing? The goals of QA are very different from the goals of testing. The purpose of QA is to prevent errors is …
11. If an application is in production, and one module of code is modified, is it necessary to retest? just that module or should all of the other modules be …
1. What are the components of an SRS? An SRS contains the following basic components: Introduction Overall Description External Interface Requirements System Requirements System Features
41. Explain autonomous transaction. An autonomous transaction is an independent transaction of the main or parent transaction. It is not nested if it is started by another transaction. There are …
31. How would you reference column values BEFORE and AFTER you have inserted and deleted triggers? Using the keyword “new.column name”, the triggers can reference column values by new collection. …
21. Show the two PL/SQL cursor exceptions. Cursor_Already_Open Invaid_cursor 22. What operators deal with NULL? NVL converts NULL to another specified value.
