Skip to main content

Posts

Showing posts from March, 2019

TestNG Interview Questions

TestNG Framework TestNG is a testing framework designed to simplify a broad range of testing needs, from unit testing (testing a class in isolation of the others) to integration testing (testing entire systems made of several classes, several packages and even several external frameworks, such as application servers). Initially, it is developed to simplify a broad range of testing, no matter from system testing or Unit testing. It is an open source framework which is inspired from the Java platform (JUnit) and NET platform (NUnit). It can be used for any testing, be it API testing or UI testing. What are the Benefits of TestNG? Test cases can be Grouped & Prioritized more easily. Parallel testing is possible Generates Logs Data Parameterization is possible. Execution Order of TestNG  ? Before Suite Annotation Before Test Annotation Before Class Annotation Before Method Annotation Case I After Method Annotation Before Method Annotation Case II

SQL Interview Questions

SQL stands for Structured Query Language , and it is used to communicate with the Database. This is a standard language used to perform tasks such as retrieval, updation, insertion and deletion of data from a database. Q1. What is the difference between DELETE and TRUNCATE statements? Delete  :- Delete command is used to delete a row in a table. You can rollback data after using delete statement. t is a DML command. It is slower than truncate statement. TRUNCATE Truncate is used to delete all the rows from a table. You cannot rollback data. It is a DDL command. It is faster. Q2. What are the different subsets of SQL? DDL (Data Definition Language) –  It allows you to perform various operations on the database such as CREATE, ALTER and DELETE objects. DML ( Data Manipulation Language)  – It allows you to access and manipulate data. It helps you to insert, update, delete and retrieve data from the database. DCL ( Data Control Language)  – It allows you to