java, programming

12 Database SQL Index Interview Questions and Answers [New!!]

A good understanding of Index is very important for any programmer working with database and SQL. It doesn't matter whether you are working as DBA or Application developer, working in Oracle, MySQL, or Microsoft SQL Server or any other database, you must have good understanding of how index works in general. You should know different types of index and their pros and cons, how your database or Query engine chooses indexes and the impact of table scan, index scan, and index seek. You should also be able to build upon your knowledge to optimize your SQL queries as well as troubleshoot a production issue involving long running queries or poor performing queries. This is also a great skill for experience developers with 5 to 6 years of experience under his belt. 

from Javarevisited https://ift.tt/fxMphDJ
via IFTTT

java, programming

50+ Java Collections and Generics Interview Questions with Answers [New!!]

Hello guys, If you are preparing for Java interviews then you may know that Java Generics and Collections are two of the most important topics, particularly Generics where some of the trickiest Java questions can be asked. They are also used to gauge your experience and depth of your Java knowledge, hence it's imperative for both beginners and experienced Java programmers to prepare this topic well. While the Java Collection framework provides an implementation of some command data structures like ListSetArray, Hash table, Queue, Stack, PriorityQueue, etc, Generics provides Type safety.

from Javarevisited https://ift.tt/vIU2arY
via IFTTT

java, programming

Java Consumer Functional Interface Example [New!!]

A Java Consumer is a predefined function interface that has been introduced by java 8. This type of interface accepts only one argument in order to generate the result. We can use Consumer once an object is ready to be used, so we send the input and it executes some operation on the object without returning any kind of value. In the last few article, I have explained what is Functional interface and showed example of Predicate Interface and in this article, I will show you how to use Consumer functional Interface in Java. 

from Javarevisited https://ift.tt/GfmkECY
via IFTTT

java, programming

Top 40 Java HashMap Interview Questions and Answers for 3 to 5 Years Experienced [New!!]

Hello guys, HashMap and ArrayList is two of the most useful classes from JDK and every Java programmer should be familiar with them. Because of their usefulness, they are also very popular on Java interviews. You will always find a couple of questions on HashMap, ArrayList and its close cousins like Hashtable and ConcurrentHashMap on various Java interviews, ranging from freshers to experienced, junior to senior programmers, and telephonic to face-to-face interviews. To help my readers to better prepare for Java interviews, I have shared some of the essential ArrayList interview questions in my last article and today I am going to share  frequently asked questions on Java HashMap. 

from Javarevisited https://ift.tt/7L8NKyV
via IFTTT

java, programming

Switch case vs if-else-if vs Polymorphism in Java – Example Tutorial [New!!]

Hello guys, conditionals like if-else and switch are very important for programming. After all, programming is for decision making and that's where these conditional programming elements help, but you may have heard that excessive use of if-else and switch is bad and is often taught as code smell. So does that mean, should you never use a switch case in Java? In this article, I will share my thoughts about using switch case vs if-else and then whether we can use Polymorphism to replace if-else in Java and Programming, but before that let's see what is a switch constructor in  Java. A switch construct allows you to choose between multiple options depending upon input,

from Javarevisited https://ift.tt/CjGPrIq
via IFTTT