Databases Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)

Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)

DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)

Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)

Database Management (1411)
Databases AllOther (288)

Databases Interview Questions

Questions Answers Views Company eMail

What are the different types of a subquery?

1052

What are the different set operators available in sql?

1027

How can you select unique records from a table?

1081

What is the need of merge statement?

1038

Write a sql query to get the third highest salary of an employee from employee_table?

1075

What is the difference between drop and truncate commands?

1062

Name the operator which is used in the query for pattern matching?

958

List the different type of joins?

1061

What do you mean by field in sql?

1080

What do you mean by dbms? What are its different types?

1019

Write a sql query to find the names of employees that begin with ‘a’?

1016

How can you fetch first 5 characters of the string?

1018

How can you fetch common records from two tables?

1063

List the ways to get the count of records in a table?

900

What are joins in sql?

1049

Un-Answered Questions { Databases }

Why do you think it is advised to not to use guid and character columns as clustered index arrays?

1124

List the data types available in mssql?

1036

Explain error handling in ssis?

1028

What does postgresql do?

882

Define object-oriented model.

1037

Hi Can any one tell me what are the API's used in requisition import.

1923

What if your ocr (oracle cluster registry) is corrupted?

What is the difference between microsoft sql and mysql?

967

Explain the rollup operator?

1082

Is sql database free?

983

How to update muliple row in single query?

1063

If no size is defined while creating the database, what size will the database have?

996

What is the difference between Delete, Truncate and Drop in Oracle?

1131

What are date and time data types?

1002

What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f

4446

For More Un-Answered { Databases } Questions Click Here