SQL FOR TESTING

 Introduction, framework explanation.  OOPS application in Selenium project.  Selenium architecture. Parameterization syntaxes. How to capture screen shots? How to handle mouse and keyboard events? Webelement & Webdriver methods. Exceptions in Selenium. What are Locators. TestNG annotations with their sequence.  TestNG keywords.  How to group tests? How to execute tests in parallel?  What are TestNG listners? Core Java basic questions Static vs nonstatic  Polymorphism  Constructor  Main method  Up casting  Wrapper classes Object class, String class methods Differences between String, String buffer, Stringbuilder.  Collection & its subinterfaces and classes their differences.  Cursors : iterator, list iterator, enumeration.  Abstract class, Interface applications. 1 Logical program based on String & collection like hashmap.  Asked to find XPath for some Webelement or list of webelements.  Write PO...

  SQL Server Query Interview Questions with Answers SQL Server DATEADD() Function 1) Write a Query to display the date after 15 days?   SELECT DATEADD(dd, 15,getdate()) 2) Write a Query to display the date after 12 months? SELECT DATEADD(mm, 2, getdate()) 2) Write a Query to display the date before 15 days?   SELECT DATEADD(dd, -15, getdate()) SQL Server DATEDIFF() Function 3) Write a Query to display employee details along with exp? SELECT * DATEDIFF(yy, doj, getdate()) AS ‘Exp’ FROM employee 4) Write a Query to display employee details who is working in ECE department & who his having more than 3 years of exp? SELECT * DATEDIFF(yy, doj, getdate()) AS ‘Exp’ FROM employee WHERE DATEDIFF(yy, doj, getdate())>3 AND dept_name=’ECE’ 5) Write a Query to display employee details along with age? SELECT * DATEDIFF(yy, dob, getdate()) AS ‘Age’ FROM employee 6) Write a Query to display employee details whose age >18? SELECT * DATEDIFF(yy, dob, getdate()) AS ‘Age’ FROM em...

    1. ORACLE : DESCRIBE table; OR DESC table; OUTPUT: Name Null Type FIRST_NAME CHAR(20) LAST_NAME CHAR(20) PHONE NUMBER(10) 2. SQL SERVER EXEC sp_columns Table TABLE_QUALIFIER | Employee TABLE_OWNER | HRDB TABLE_NAME | Emp COLUMN_NAME | Salary DATA_TYPE | -4 TYPE_NAME | Salary PRECISION | 2147483647 LENGTH | 2147483647 SCALE | NULL RADIX | NULL NULLABLE | 1 REMARKS | NULL COLUMN_DEF | NULL SQL_DATA_TYPE | -4 SQL_DATETIME_SUB | NULL CHAR_OCTET_LENGTH | 2147483647 ORDINAL_POSITION | 4 IS_NULLABLE | YES SS_DATA_TYPE | 23 (1 row affected)

  SQL order of execution is: "FM WG HAVING SOL" 1: from 2: where 3: group by 4: having 5: select 6:order by 7:limit eg: Write an SQL Query find number of Employees with GENDERaccording to gender whose DOB is between '01/01/1996' to '31/12/1999' select count(*) as NO OF EMPLYEES,Gender from Employees WHERE DOB BETWEEN '01/01/1996' AND '31/12/1999' GROUP BY GENDER STEPS: 1.FROM  CHOOSE AND JOIN TABLE TO GET BASE DATA Here "EMPLOYEES" is Selected. 2.WHERE  Filters the DATA WHERE DOB BETWEEN '01/01/1996' AND '31/12/1999' 3.GROUP BY AGGREGATES THE BASE DATA GROUP BY GENDER MALE,FEMALE MALE: 1 FEMALE: 3,4 4.HAVING FILTERS THE AGGREGATED DATA EG: HAVING  EMPID < 100 5.SELECT : RETURNS FINAL DATA 6.ORDER BY : SORTS THE FINAL DATA EG ORDER BY NO OF EMPLYEES ASC 7.LIMIT : LIMIT THE RETURN DATA TO ROW COUNT select count(*) as NO OF EMPLYEES,Gender from Employees WHERE DOB BETWEEN '01/01/1996' AND '31/12/1999' L...