SQL Database Topics for Freshers IT Job Preparation

Here is the SQL database fine blended topics list for freshers that must be prepared for your first IT Job interviews preparation. This list is taken from the book “IT Jobs Made Easy For Freshers” by Rakesh Singh. SQL TOPICS: Database: create, drop Table: Create, drop, insert, update, select, delete, alias, re-name and truncate. Constraints: … Read more

Freshers FAQ during IT jobs hunt

Fresher’s FAQs: Many fresh candidates get questions and doubts during IT job hunt. Here you’ll find the questions and answers for clarifications: Q) Can a fresher negotiate salary? Answer: At the fresher level most, companies follow their standard and does not go for negotiation. But, Yes, a fresher can negotiate salary with some supportive reasons. … Read more

Fine Grained List of Coding Questions

This is the fine-grained list of coding problems to jump start with the coding questions and get confidence in writing algorithms and learning data structures and algorithms. As per experience, the right way to learn data structures and algorithms is through solving a coding problem. Start solving the coding problems and learn the data structure … Read more

How to achieve abstraction in C# -oops

Learn how to provide necessary information to the users and hide the unnecessary details using C# programs. The concept of “providing necessary details to the clients/users and hiding the unnecessary details” is called Abstraction. As an example consider a login page where username and password is enough for the users. so, only username and password … Read more

What is Encapsulation in C# – Best Answer

Answer includes concept of encapsulation in C# oops with various C# encapsulation examples with programs. Answer:Encapsulation in C# is one of the oops principles that is used for hiding complexities in programs. NOTE: Many candidates answer to this interview question “What is encapsulation in C#” like wrapping the class member fields into a method as … Read more

NULL vs Empty string in oracle

Learn about NULL value and an empty string behavior in oracle database with example queries. NULL means no-value(nothing). An empty string(”) treated as NULL value Let’s create a table suppliers_tbl with the following table definition. Next, we’ll insert following records into this table. The first statement inserts a record with a supplier_name that is null, … Read more

C# Exercise – On Constructor with Solution

C# exercises on constructor with solutions. EXERCISE-1: Answer the following questions in brief. When a class constructor gets called? If you create 5 objects of a class, then how many time constructors will be called? When you write a constructor, what return type do you write in constructor declaration? Why do you use constructor? EXERCISE-2: … Read more