Skip to main content

Interview Tips for Freshers on Technical and HR round to crack job in IT industry #DOTC_Mdb


Interview Tips for Freshers on SQL developer Technical and HR round to crack job in IT industry :


When you are going for interview in IT organisation , please focus on  below points to crack interview.

Technical Round :

Interviewer will start with basics questions and when you start giving answers they will go further and ask some logical queries as well as commands which is used on daily basis. Also they will ask some programming questions on PL/SQL to see the logic of candidate.

Some useful Tips for Technical Interview:
1.      You need to very clear what is your objective, Like If you are technically strong in any technologies like Java, Oracle , C ,C++ etc . Make sure what you put in your resume you should be comfortable to give answers. Because you can’t put all programming language in CV as company need expert in any one of the technology with operating system like Unix/Linux knowledge . Assume in your CV you mention your technology Oracle with unix , Interviewer will ask questions related to Oracle and unix only not much questions from other technology but if you mention Java and other technology in secondary option they might ask you some basic questions. But if you are good in your Primary skills then easily you can crack your interview.


2.      Most important thing During Technical Round is that if you are not aware about any question during interview , Don’t try to give wrong answer or something else , Just tell interviewer that I am not aware about this and be confident and think about next questions and try to explain in better ways to impress the recruiter . Technical round is one of the interview process which decides whether you are eligible to get that job or not. so before entering to interview a candidate must check out these. First of all check your Soft Skills: You may technically sound, but if are weak in soft skills you will have lesser chance get job . So Before interview make some practice and improve your soft skill.

3.      If you impressed Recruiter during your Technical interview , more chance you will get the job . Technical round can be 1-3 but for fresher 1 round is enough. Also if technical round will go more than hour or 45 minutes it means recruiter are impressed with your technical skills and they will ask you if you have any question , Here you can ask any questions related to company projects and technology and be confident as it will give you positive feedback.

4.      HR Round : In HR round they will not ask you any technical questions as they already received the feedback from Technical Panel . They will ask you behavioral questions like tell me something about yourself, your strength , weakness etc. In this round HR will check your soft skills, qualification and body language . So be confident as you already clear your technical round and try to give all the answers in proper way .


Please feel free to reach me anytime for any clarification.

Thanks and all the best.

Comments

Post a Comment

Popular posts from this blog

SQL and Classification of SQL in Oracle Database #Diksha Oracle Training Centre

  SQL and Classification of SQL in Oracle Database.   SQL is Structured Query Language , which is used for storing, manipulating and retrieving data stored in a relational database .SQL is the standard language for RDBMS. All the Relational Database Management Systems (RDMS) like Oracle, MySQL, Sybase, Informix, IBM DB2 and Microsoft SQL Server use SQL as their standard database language. Oracle is one of the more secured database as compared to other databases. Importance of   SQL : SQL and PL/SQL is a backend process where all data is stored and retrieved in GUI which created either by any programming languages like Java, C++, PHP etc. so we need to have very secure database so that there will be no impact for users. SQL allows users to access data in the relational database management systems. SQL is used to communicate with a database.SQL and PL/SQL allows users to create and drop databases tables , views , stored procedures , functions , packages , trigger etc. SQL allows

Materialized View uses and Benefits in Database #DOTC_Mdb

Materialized View uses and Benefits in Database. Hello Everyone, Today we will discuss about Materialized view as it’s play important role in database. We already discussed about Simple Views and complex views in my previous blog. Before Materialized view go through my previous blog which related to simple view. https://dheeraj60.blogspot.com/2020/05/benefits-of-creating-and-using-view-in.html As we know View is not a database object and not like table which is stored in database, but view can be created from base table a view is an SQL statement that’s stored in the database. This statement, or view, has a name.A view looks and acts a lot like a table. It has columns and rows, and can be included in SELECT queries just like a table. In other word we can say View is a virtual/logical table which is basically used for security purpose. Let’s understand   about   Materialized view : A materialized view is a view that stores the results of the view’s query. Whenever you query the ma

Top 50 Interview Questions On SQL and PL/SQL #DOTC_Mdb

                    Top 50 Interview Questions On SQL and PL/SQL. Today we will Discuss Top 50 interview questions and answers of SQL and PL/SQL which is frequently asked in interview.     Question 1: What is SQL and Classification of SQL? Answer SQL is a Structure Query Language which is vastly used in RDBMS database like Oracle, Sybase, DB2 , Microsoft SQL server etc.   Classification of SQL is as below: DDL (Data Definition Language):  Commands are  create , alter , drop , truncate etc DML (Data Manipulation Language) : Commands are  insert,update and delete . TCL (Transaction Control Language ) : Commands are  Commit , Rollback and Save point. DCL (Data Control Language) : Commands are Grant , Revoke Question 2:    What is meant by Joins? What are the types of join? Answer Joins are basically used to extract/get data from multiple tables using some common columns or conditions and also by using alias to fulfill the condition.   There are various types of Joins as li