Sawaal
  • Home/
  • Interview Questions

Interview Questions

Interview Question and Answers

These are the Questions that are normally asked in a job interview. Interview questions are very specific to the job role you are applying. Most of the times, interview for a job is done if different phases or categories. There are different rounds interviewer has to go through. However, there are certain questions in the interview which are common and can be done real well if we went prepared.

Interview Questions can be in various categories like:

Accounting and Finance, Marketing and Sales, Manufacturing, Finance, Hospitality questions, Law , Leadership and management, customer service, medical and health care, call center, Human Resource, etc.

How to prepare for Interview question and answers?

How to prepare for Interview question and answers? There are many possible ways in which you can prepare for the interview question and answers. If it is technical, you have many important questions that you are sure to ask in the interview. Especially, if you are thorough with the fundamentals or basics, most of your interview is cleared without much hassle.

The key is to prepare for with proper research about the company, where you are going to take the interview. Make sure to go through few same Human Resource questions as well. They will enable you to make good answers, and position yourself as a very good prospect for the job. Make sure you answer the interview question in a way that you will be the best fit for the job. And this can happen only through enough confidence. Make sure to go through as many questions as possible to gain the confidence.

Popular Latest Rated
Q:

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

Answer

Disable the foreign key constraint to the parent, drop the table, re-create the table, enable the foreign key constraint.

Report Error

View answer Workspace Report Error Discuss

Subject: Database Administration

5 2309
Q:

What do you mean by a tablespace?

Answer

- These are the Logical Storage Units into which a database is divided.
- It is used to group together the related logical structures.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2309
Q:

Which package is imported by default?

Answer java.lang package is imported by default even without a package declaration.
Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2307
Q:

A database is used to

A) store data B) modify data
C) extract data D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

A database is used to store, modify, extract and to search for the data within it.

Report Error

View Answer Report Error Discuss

Filed Under: SQL
Job Role: Analyst , Database Administration , IT Trainer , Project Manager

7 2306
Q:

What is Shallow and deep cloning in Java?

Answer

Cloning refers to creating duplicate copies of objects in java.


Shallow Cloning: Shallow cloning is a bitwise copy of an object. New object is created which is an exact copy that of the original one. In case any objects are referring the fields of these objects, just the references are copied.


Deep Cloning: In deep cloning, complete duplicate copy of the original copy is created. Deep cloning creates not only the primitive values of the original objects but also copies all its sub objects as well.


Clonable interface is used to perform cloning in java.

Report Error

View answer Workspace Report Error Discuss

Subject: Java

0 2306
Q:

What is a synonym? What are its various types?

Answer

A synonym can be called as an alias for a table, view, sequence or program unit. It is basically of two types:
- Private - Only the owner can access it.
- Public - Can be accessed by any database user.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

0 2304
Q:

What are the usages of the Command object in ADO.NET?

Answer

The following are the usages of the Command object in AD0.NET:

The Command object in AD0.NET executes a command against the database and retrieves a DataReader or DataSet object.

  =>  It also executes the INSERT, UPDATE, or DELETE command against the database.
  =>  All the command objects are derived from the DbCommand class.
  =>  The command object is represented by two classes: SqlCommand and OleDbCommand.
  =>  The Command object provides three methods to execute commands on the database:
  =>  The ExecuteNonQuery() method executes the commands and does not return any value.
  =>  The ExecuteScalar() method returns a single value from a database query.
  =>  The ExecuteReader() method returns a result set by using the DataReader object.

Report Error

View answer Workspace Report Error Discuss

Subject: .NET

0 2304
Q:

What are the uses of synonyms?

Answer

- Mask the real name and owner of an object.
- Provide public access to an object
- Provide location transparency for tables, views or program units of a remote database.
- Simplify the SQL statements for database users.

Report Error

View answer Workspace Report Error Discuss

Subject: Oracle

1 2301