Most Important SQL Query for Interview:- 1)  Write Query to add and remove a new column in tables? 2)  Write a Query to add a primary Key into a table? 3)  Write a Query to add a foreign key in a table? 4)  Write a Query to rename the table, database, and column? 5)  Write q Query to implement self join, inner join, outer join, and natural join? 6)  Write a Query to use Group by and having Most Important SQL Query for Interview:- Dept(Deptid, Deptname) Emp(Empid,Empname, Job, Salary, Deptid) 7)  WAQ to display total employee and each dept? 8)  WAQ to display the record of the employee who is getting second max salary? 9)  WAQ to select deptname and job where number of employee is more then 3? 10)  WAQ to  display max, min,avg salary on each dept excluding IT dept? 11) WAQ to display the name of dept where employee is null? 12) WAQ to display the empname whose salary is minium?

  Collection Framework  Interview In Java? Q1) What is Iterable Interface In Java? Q2) What is the difference between Collections and Collection? Q3) Which is faster to access ArrayList or LinkedList? Q4) Which is faster ArrayList or Vector? Q5) How to create Synchronized ArrayList? Q6) What is hashCode() in Java, how to get the hashcode of Object? Q7) Difference between Iterator and ListIterator? Q8)  What is Comparable and Comparator Interface in Java? Q9)  What is the difference between Hashtable and HashMap? Q10)  Difference between LIST and Set? Q11)  What is the difference between Set and MAP? Q12)  What is Queue Interface In java? Q13)  What is Priority Queue and Abstract Queue in Java?                         

  Skype  Interview |  Interview of freshers | Telephonic Interview | Skype round of interview:- In this article, I am explaining, how to prepare for a Skype technical interview session. I have also provided a Live Skype Interview Session below, you can see and get an idea of Skype round. Skype interviews are more common in today’s job market due to convenience, flexibility, and money-saving benefits for employers. This video is going to talk about how to face Skype interviews. Watch this video to know more tips during the and after the Skype interview. T his is a Skype round interview of java fresher's, I have posted a live interview to get an idea about the skype round of technical interviews for Java learners. He performs well because this was the first interview of him on skype, you can learn from this. you should also discover the weakness and positiveness during the interview. When we take an interview with fresher or experienced then they do some common mistakes, ...

 OOPS Interview Question in Java:- OOP's is the most important topic of the interview, especially for JAVA. I am providing some most important interview questions based on OOP'S. 1)   What is OOPS? 2)   Why we use OOP'S technique in programming? 3)  What is the full form of OOP'S? 4)  What is the definition of Object, Class depends on object or Object is depend on class? 5) What is the difference between Object and Instance(reference)? 6)  What is the Garbage collector in Java, how it works? 7)  What are the Access modifier(Access Control, Access Specifier) and non-access modifiers in Java? 8) What is an immutable object in Java? 9) What is Singleton class, Concreate class,  Inner class in Java? 10) What is the final class, the final method, and the final variable in Java? 11)  What is another way to protect class from an inheritance except for the final class? 12) What is init block, static block, and constructor, if all three pres...

Python Live Interview | TOP 20 Interview Question of Python, Django | Django + PYTHON MOCK Interview This is Python Live Interview, session We have posted this session to know the live experience of the interviewee during the interview and provide important interview questions. If any positive point you got then you can apply and if any negative point you got then you can improve in your skills. Share it on your group and Jobseeker for interview assistance. #pythonprogramming #computerscience #jobseekers #interviewquestions This Shiva Concept Solution video on "Django Interview Questions and Answers" will help you understand the 50 most asked Django Interview Questions with their best answers. It will help in preparing for your upcoming Django Developer Interviews. I am providing the LIVE Interview session, you can view all sessions and check your technical skills, you can also learn common mistakes during the interview. Interview on Core concept of Python:- Python Live ...

 Python Interview Question for freshers:- Many freshers students face problems in Python basic interview questions, now I am posting some basic interview questions of Python. 1)  What is  Python? Python is compiled or Interpreted?  Python has a machine code or Byte code? Who develops python? 2)  using python, can we create System software? 3)  Python has a data type or not?  explain the size of int, float, char, etc? 4)  What is the difference between C and Python? 5)  Python is Script-based or Code based language, explain in details? 6)  Python is an operating System dependent or Independent? 7)  Python is low level, high level or Middle-level language explain it? 8) Which operating System python script executed first? 9)  What is docstring in Python? 10)  How we can remove front-space from Python code? 11)  What is the membership and identity operator in Python? 12)  Python support typecasting or Type conversio...

What is Web, Web page, and Web Designing? Introduction of WWW? Type of WebSite Essential Interview Question For Web Designer and Developer What is the web? The web is the collections of a network that is used to contain unlimited data and transfer from one platform to another using Web Container that is called a Web page. Web always will be accessed by www (World wide web. It is used to display web content worldwide using Internet Protocol. We can also access Web pages using Intranet(local server)  What is Web page:- It is used to contain static and dynamic data that will be accessed by the network. if a web page contains static data then it is called a static web page and if the web page contains dynamic data then it is called a dynamic web page. Static web page content can not be modified by user's and it does not provide database integration. Dynamic web page content can be modified by user's and it contains database integration to store dynamic data. name of the static web ...

---Question for all Java learners and Java Job seeker--- In this article, I will discuss, some important questions of java. What is System.out.println() in Java?  What is public static void main(String args[])? If you know advance questions then ok, if you do not know silly questions then you will definitely be rejected on the interview hence focus on fundamentals then go for an advance topic. What is System.out.println() in Java?   System is the predefined final class of Java, which exists under java.lang package, It is used to manage input and output operation in java. When we want to take input from the keyboard in Java then System.in the reference variable will use, if we want to display output on any output screen such as to monitor, laptop, desktop, etc then System.out the reference variable will work. out is the static reference or static variable of PrintStream Class which is declared under System class. println():-   It is the predefined method of Pri...

  Java Unique Interview Question:- Q) WAP to print data without using System.out.printlln()?  import java.io.*; class Addition {    public static void main(String args[]) throws IOException    {      FileOutputStream fo= new FileOutputStream(FileDescriptor.out)      OutputStreamWriter o= new OutputStreamWriter(fo, "ASCII")      BufferedWriter out = new BufferedWriter(o, 512);      out.write("test string");      out.write('\n');      out.flush();    }  } Q)  WAP to calculate addition without using + operator? class Addition {    public static void main(String args[]) throws IOException    {      int a=100,b=20;      while(b>0)      {          a++;          b--;      }      Syste...

Angular Interview Question:-  1) How we can navigate from one component to another using a router link, button link? 2) what is forRoot and forChild() in Angular Framework? 3) What is Data Binding? How many ways it can be done? 4) what is observable, subscribe, and promise in Angular? 5) What is ngOnInit()? How to define it? 6)What is string interpolation in Angular? 7) What Is Dependency Injection (DI)? 8) What Is runGuardsAndResolvers function? 9). What is bazel in angular 8? 10) What is typeofchecks in Angular 8?                                   

Angular JS Interview Question :- ANGULAR JS 1.0 and ANGULAR JS Framework 2.0,4.0,5.0,6.0,7.0 .................................................................................................... Q1 what is difference between Angular JS and normal javascript? Q2 what is directive elements in angular js?       ng-model       ng-bind      ng-repeat      ng-pattern      ng-style     Q3 what is $scope variable in Angular? Q4  what is Angular API? Q5  what is module in Angular JS and How we can create Module? Q6  what is Component and Sub Component and root Component? Q7 what is data binding concept in angular js ,explain one-way and two-way binding with example Q8 what is Property binding and Event binding? Q9 what is dependancy injection in angular JS .how we can implement them Q10 what SPA means Single Page Application? Q 11 what is Routing Concept.ho...

Core Java Interview Question for an experienced candidate Top 20 Java Interview Question, Check Your Java Skills. 1)  What is annotation in Java, How we can create custom annotation? 2)  What is Reflection API in Java? 3)  How we can create Checked User Define Exception and  Unchecked User Define Exception? 4)  What is Inner class, Local Inner Class, Static Inner Class, Anonymous Class 5)   What is a Generic Class in Java  How we can define Custom Generic Class 6)  How we can Synchronize Array List? 7)   Which is the best Collection class to add and edit elements concurrently? 8)   What is the Marker interface, the difference between annotation and marker Interface? 9)    What will be the output when we call run() manually in Thread? 10)   What is the Design pattern in Java define Creational, Behavioral, and Structural Design Pattern? 11)    Difference between Comparable and Comparator? 12)...

Q1 What is Hibernate Architecture? Q2 What is annotation in Hibernate, provide the name of all annotation? Q3  What is the relationship in hibernate explain all relationships with annotation? Q4  what is HQL? Q5  What is the Criteria, Criterion, Restrictions, Projection, Projections, ProjectionSet? Q6  Hibernate Join? Q7  What is SQL query,namedquery ? Q8  How we use Pagination in Hibernate Q9 Hibernate Cache primary and secondary? Q10 Difference between get() and load()? Q11  Difference between save() and persist() in Hibernate? Q12  Difference between merge() and update() in Hibernate?

Top MNC Technical Round Logical QUESTION, Check Your Logical Skills:- In this article, I am providing list of questions that will be more helpful for you, and you can check your technical skills, create a program, and comment on it. Q1 How to check if two Strings are anagrams of each other? For example, the Army and Mary are an anagram of each other. Q2 How to find all permutations of String? for example, if the input is "xyz" then it should print "xyz", "yzx", "zxy", "xzy", "yxz", "zyx". Q3 Given string str, How do you find the longest palindromic substring in str? Q4 How to find common elements in three sorted arrays? input1 = {1, 5, 10, 20, 40, 80} input2 = {6, 7, 20, 80, 100} input3 = {3, 4, 15, 20, 30, 70, 80, 120} Output: 20, 80 Q5 WAP to display array elements in binary form? Q6 How to check the cases of String and display string each char in binary form? String s = "123456"; display bin...

PHP Interview Question If you read it then sure you can crack interview ,this session is also available on my YOU-TUBE CHANNEL or go www.shivatutorials.com 1)What is difference between echo and print? 2)What is  difference between ' ' and " " in PHP? 3)What is Super Global Variable in PHP? 4)What is Constant declaration in PHP? 5)What is Difference between Index Array ,Associative Array and Mixed array in PHP? 6)Write the name of five datatype function? 7)Write the name of five String function? 8)What is implode and explode function in PHP? 9)What is Curl and PEAR in PHP? 10)What json_encode and json_decode() in PHP? 11)What is implode and explode() in PHP? 12)How we can upload multiple files in PHP ? 13)Write the query to update and insert record into database ? 14)Write the query to check email id already exist with complete PHP Code? 15)What is difference between mysql and mysqli? 16)What is mysqli_fecth_row and mysqli_fetch_array()? 17)What is Ajax explain  AJAX ...