Interview Questions by iteanz

CHAPTER 1:INTRODUCTION An Introduction to Python CHAPTER 2:BEGINNING PYTHON BASICS The print statement Comments Python Data Structures & Data Types String Operations in Python Simple Input & Output Simple Output Formatting CHAPTER 3:PYTHON PROGRAM FLOW Indentation The If statement and its’ related statement An example with if and it’s related statement The while loop The for loop The range statement Break & Continue Assert Examples for looping CHAPTER 4:FUNCTIONS & MODULES Create your own functions Functions Parameters Variable Arguments Scope of aFunction FunctionDocumentation/Docstrings Lambda Functions & map An Exercise with functions Create a Module Standard Modules CHAPTER 5:EXCEPTIONS Errors Exception Handling with try Handling Multiple Exceptions Writing your own Exceptions CHAPTER 6:FILE HANDLING File Handling Modes Reading Files Writing & Appending to Files Handling File Exceptions The with st...

GET ALL EMPLOYEE DETAILS FROM THE EMPLOYEE TABLE Select * from employee SQL QUERY TO FIND SECOND HIGHEST SALARY OF EMPLOYEE There are many ways to find second highest salary of Employee in SQL, you can either use SQL Join or Subquery to solve this problem. Here is SQL query using Subquery: select MAX(Salary) from Employee WHERE Salary NOT IN (select MAX(Salary) from Employee ); GET FIRST_NAME,LAST_NAME FROM EMPLOYEE TABLE Select first_name, Last_Name from employee SQL QUERY TO FIND MAX SALARY FROM EACH DEPARTMENT. You can find the maximum salary for each department by grouping all records by DeptId and then using MAX() function to calculate maximum salary in each group or each department. SELECT DeptID, MAX(Salary) FROM Employee  GROUP BY DeptID. These questions become more interesting if Interviewer will ask you to print department name instead of department id, in that case, you need...

WHAT IS JQUERY? jQuery  is not a programming language but a well written JavaScript code. It is a JavaScript code, which do document traversing, event handling, Ajax interactions and Animations. WHY JQUERY IS NEEDED? jQuery is needed for the following list: Used to develop browser compatible web applications Improve the performance of an application Very fast and extensible UI related functions are written in minimal lines of codes WHETHER JQUERY HTML WORK FOR BOTH HTML AND XML DOCUMENTS? No, jQuery HTML only works for HTML documents not for XML Documents. WHAT ARE THE METHODS USED TO PROVIDE EFFECTS? Some of the effects methods are: Show() Hide() Toggle() FadeIn() and FadeOut() WHAT IS THE ADVANTAGE OF USING MINIMIZED VERSION OF JQUERY? Efficiency of web page increases when minimized version of jQuery is used.min.js file will be more than 50% less than the normal js file. Reduction in the file size makes the web page faster. ...