LaxmiAcademy

https://www.youtube.com/watch?v=epvNp7xLtg8 1)What is  a Database? Database is an organized collection of data, which provides efficient retrieval of the data. 2) What is DBMS? DBMS: Data base  Management System.  It is system of systematic  way of  Creating, Storing, Retrieving and Managing of data. Ex: File system, XML 3) What is RDBMS? Relational Database Management System: Is a database system based on relational model. Ex: SQL Server, Oracle 4) What is Database testing? Database testing is a process of testing the behavior of the database with reference to front-end web/desktop application. Any changes made in the front end should change backend and vice versa Data Integrity Data Validity Data base performance Testing of functions, procedure and triggers  5) What do we need to check in Database testing ? Constraint check Verification of a field size and type Stored procedures, Triggers Performance based issues 6) How do you test Data Integrity? What do you

https://www.youtube.com/watch?v=DnizzffAphc

https://www.youtube.com/watch?v=jAipY2qFuuk     1) What is Integration  testing? Integration testing is to Integrate/combine the unit tested module and test them as a combined unit . Integration testing tests integration or interfaces between components, interactions to different parts of the system such as an operating system, file system and hardware. The individual modules are first tested (unit testing). Once the modules are unit tested, they are integrated to validate that they communicate with each and function as per the requirements. 2) When should be Integration testing implemented ? At the end of the cycle Simultaneously with the development. 3) What are the types of Integration testing techniques? A) Big Bang Approach : In Big Bang integration testing all modules are integrated simultaneously, after which everything is tested as a whole. Advantage : testers get completely developed module. Challenge of testing which does not exist does not exist. Disadvantage: D

https://www.youtube.com/watch?v=KzXn0JJTTsI Row is a horizontal stack of cells and labelled by numbers ex row 1, row 2 and so on. Column is a vertical stack of cells and labelled by alphabets Column A, Column B and so on. Shortcut Copy  Ctrl C Cut Ctrl  X Paste Ctrl V Undo Ctrl Z    

https://www.youtube.com/watch?v=wCln1fzvaDQ Tips for mental addition Start from left Avoid using  words like "plus", and" as that takes time to process. Practice, practice Learn compliments.            

https://www.youtube.com/watch?v=qaANTCZt20g What is Regression testing? It is a type of software testing that verifies that software performs correctly after the change or defect fix. Changes may include software enhancements, patches, hardware, networking, data structure, configuration changes, etc. In other words purpose of regression testing is to identify that  new defects are not introduced in the system after the change. 2) At what levels regression testing should be done? At all levels mainly Unit Testing, Integration testing and System Testing: Focus on testing is different at different levels. 3) What are the types of Regression testing techniques? Corrective Regression Testing: Progressive Regression Testing: Retest-All Strategy:. Selective Strategy: (dependencies between a test case and the program entities it covers) 4) What should be the frequency of regression testing? Ideally Regression testing should be done after bug fix and after any change to the syste

https://www.youtube.com/watch?v=2yPpaez1MPk Manual Testing  is a process carried by testing team to find the defects  and to confirm that application works as per the requirements. Testers manually execute test cases without using any automation tools. Tester plays an important role as end user and verify all features of the application work as per requirements. Identify any unexpected behavior or bug Manual testing is necessary find feasibility of automation. 100% automation is difficult task for any software. In Manual testing the designed test cases or test scenarios will be executed and any differences between actual and expected results are reported as defects. Once the reported defects are fixed, the testers will retest the defect to make sure that the defects are fixed It is preferable to execute User Interface test cases using manual testing. Manual testing is slower than automation. Running tests manually can be very time consuming. What is Automated Testi

https://www.youtube.com/watch?v=3EWghmo9Mfg   1. What is SDLC? Answer: SDLC, Software Development Life Cycle is a process used by software industry to design, develop and test high quality software that meets or exceeds customer expectations. 2. What are The different models of SDLC? Waterfall Model Agile Model Prototyping Model Iterative Model Spiral Model V-Model Incremental Model 3. What are the different types  of software requirements? Business Requirements (BR): High level Market Requirements (MR ): high level drilling down into BR Functional Requirements (FR) – Functionality of the product Non-Functional Requirements (NFR)- Reliability, Scalability, Security, Integration, etc. UI Requirements (UIR ): Market Requirements (MR) and  UI Requirements (UIR) are not included in traditional software requirements.   4. Why do software have bugs? SDLC involves humans at all levels which make software prone to human errors and also technical errors.

https://www.youtube.com/watch?v=O9pDF5eGfw0 Adding two digit numbers mentally is easy once you practice few examples. 16 =10+6 1 is in the tens place so value of 1 =10 6 is in the units place so value of 6 =6 Begin adding from the left column.  

https://www.youtube.com/watch?v=DDBf_jI8FNQ From the software testers point of view it is very important to verify that the software performs its basic functions as per the requirements. In this testing tester always check for only valid set of input values and verifies if software under test or application behaves as expected with its expected output values. The main goal of positive testing is to check whether software application  is not showing  an error when it is not supposed to  and showing an error  or warning when it is supposed to. Positive Testing always tries to prove that a given product or software always meets the requirements and specifications. Techniques used for Positive validation of testing are:  Boundary Value Analysis  Equivalence Partitioning Example: Phone number:  ” Phone number should be numeric” Test using numeric values, number of characters. Etc. Age: “Age should be greater than 0 or Age should be numeric: depending on specifications. Zip

https://www.youtube.com/watch?v=9isF5oZP_hA Desktop application runs on personal computers and work stations, so when you test the desktop application you are focusing on a specific known environment. Since the environment is known compatibility testing for desktop application is fairly easier. In client server application, application is loaded on server machine while the application executes on every client machine. Compatibility testing becomes little bit complex since it needs to be tested at 2 levels. Web application is loaded on the server but location and environment of users is unknown. Since users environment is unknown multiple conditions need to be considered while testing web application which makes it complex. Compatibility is a non- functional testing and goal is  to determine whether your software application or product is efficiently working and stable to run in different browsers ,hardware, screen size, resolution, operating system, mobile devices, users and networks.

https://www.youtube.com/watch?v=9isF5oZP_hA From the software testers point of view it is very important to verify that the software performs its basic functions as per the requirements, but it is equally important to verify that the software is able to gracefully handle any abnormal situations or invalid data input which helps to determine stability of the software. Negative Testing is performed to find the situation where there is possibility of software to crash. Last thing you want to see is software crashing at end user hand. so Negative testing plays an important role in testing software.  It is a negative approach, where testers try to design test cases to find the negative aspects of the application and validating against invalid input. Example: Phone number: User can enter alpha numeric characters in phone number field. so system should display error message like " Phone number should be numeric" Another example can be : Age: User can enter negative numbers or alphan

https://www.youtube.com/watch?v=jxJVomBW8tg 25 can be written as 100/4 If you want to multiply any number by 25, Multiply by 100 and divide by 4. Multiplying any number by 100, you just add two zeros towards the end of the number and then divide by 4

https://www.youtube.com/watch?v=Jd8c6zlbwEQ Functionality Testing Usability testing Interface testing Compatibility testing Performance Testing      Load testing      Stress testing      Soak testing      Spike testing Security Testing Web Applications are open to the world with potentially multiple users accessing the application simultaneously at various times, so load testing and stress testing are important. Web applications are also vulnerable to all forms of attacks, so security testing is also very important to consider when testing web application.

https://www.youtube.com/watch?v=XwzK68l0hJo Dividing any number by 5 can be made easy  by multiplying and dividing by 2. Multiplying and dividing by same number does not change the value of the original number. Multiplying by 2 is same as doubling the number . 16/5 =16/5 X 2/2 =32/10 =3.2

https://www.youtube.com/watch?v=IJF13Xl5TMs Alt-Shift-D to insert date. This will insert today's date. Control-B will make content  bold. Control-U  will underline content Control-Shift-D will  double underline the content. To create horizontal line type hyphen --- 3 times and press enter =Rand(8,10) will generate random text to test or to fill document with any random text. Ctrl +Shift+ +> will increase font size Ctril +Shift +< will decrease font size

https://www.youtube.com/watch?v=Kx4KdXeUSWA We can add numbers mentally by knowing the complements of a number. The "complement" is the number to add to  make 10 (or 100, 1000, etc, depending on how many digits we have) Let us see complement to make 10. Complement of 1<->9 2<->8 3<->7 4<->6 5<->5 Once you know compliments at the tip of your tongue then it is easy to solve addition problems. First scan the complements and then add remaining numbers to the total of complements.

https://www.youtube.com/watch?v=rqymPFil-So 5=10/2 If we want to multiply any number by 5 then multiply by 10 and divide by 2. This concept makes multiplication of bigger numbers easier. To multiply any number by 10, you put 0 at the end of the number Ex 23 X 10=230 456 X 10=4560 Then divide by 2. Ex 21 X 5 = 21*10/2 =210/2 =105