31. How can we get the number of rows affected by query? Number of rows can be obtained by SELECT COUNT (user_id) FROM users;
Questions and Answers for Freshers
- Interview Questions and AnswersPHP and MySQLTechnical Interview Questions and Answers
- Interview Questions and AnswersPHP and MySQLTechnical Interview Questions and Answers
MySQL Interview Questions and Answers Part-3
by Sby S21. 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 …
- Interview Questions and AnswersPHP and MySQLTechnical Interview Questions and Answers
MySQL Interview Questions and Answers Part-2
by Sby S11. 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 …
- Interview Questions and AnswersPHP and MySQLTechnical Interview Questions and Answers
MySQL Interview Questions and Answers Part-1
by Sby S1. What is MySQL? MySQL is an open source DBMS which is built, supported and distributed by MySQL AB (now acquired by Oracle)
- Interview Questions and AnswersSoftware TestingTechnical Interview Questions and Answers
Latest Manual Testing Interview Questions and Answers Part-4
by Sby S31. 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 …
- Interview Questions and AnswersSoftware TestingTechnical Interview Questions and Answers
Latest Manual Testing Interview Questions and Answers Part-3
by Sby S21. 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 …
- Interview Questions and AnswersSoftware TestingTechnical Interview Questions and Answers
Latest Manual Testing Interview Questions and Answers Part-2
by Sby S11. 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 …
- Interview Questions and AnswersSoftware TestingTechnical Interview Questions and Answers
Latest Manual Testing Interview Questions and Answers Part-1
by Sby S1. What are the components of an SRS? An SRS contains the following basic components: Introduction Overall Description External Interface Requirements System Requirements System Features
- C++Interview Questions and AnswersTechnical Interview Questions and Answers
Latest C++ Interview Questions and Answers Part-4
by Sby S31. What is difference between function overloading and operator overloading? A function is overloaded when same name is given to different function. While overloading a function, the return type of …
- C++Interview Questions and AnswersTechnical Interview Questions and Answers
Latest C++ Interview Questions and Answers Part-3
by Sby S21. What is the difference between macro and iniine? Inline follows strict parameter type checking, macros do not. Macros are always expanded by preprocessor, whereas compiler may or may not …