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

Oracle (3253)
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?

1115

What are the different set operators available in sql?

1084

How can you select unique records from a table?

1154

What is the need of merge statement?

1100

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

1122

What is the difference between drop and truncate commands?

1118

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

1006

List the different type of joins?

1121

What do you mean by field in sql?

1133

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

1069

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

1064

How can you fetch first 5 characters of the string?

1070

How can you fetch common records from two tables?

1108

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

947

What are joins in sql?

1114

Un-Answered Questions { Databases }

How can you insert null values in a column while inserting the data?

1348

Is it possible to pass parameters to triggers?

1165

what is a view? : Sql dba

1139

How to connect to the server with user account: sys?

1063

Why do gaps in sequences occur?

1038

How self join is different from outer join?

1187

What is the reports view in oracle sql developer?

1049

What is foreign key in database?

1035

What is mysql root?

1006

How big can a postgres database be?

964

What is the difference between database and table?

1057

What is offset in sql query?

1182

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

1025

What is field record and table in database?

1036

How to use timestamp datatypes

2080

For More Un-Answered { Databases } Questions Click Here