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 oracle database objects?

1115

State all possible different index configurations a table can possibly have?

1039

What is the difference between translate and replace?

1084

How can we delete duplicate rows in a table?

999

What is a cursor and what are the steps need to be taken?

1226

Compare and contrast between sql and sql server and explain its various functions?

979

How different is ms access and oracle?

1063

How to display employee records who gets more salary than the average salary in the department?

1091

State some uses of redo log files?

1038

What is coalesce function?

1091

How can we view last record added to a table?

1071

What is the maximum number of triggers that can be applied to a single table?

1048

What is the usage of merge statement?

1171

Explain the difference between a procedure and a function?

1197

What is the difference between $oracle_base and $oracle_home?

1106

Un-Answered Questions { Databases }

What is cold data?

974

what are the disadvantages of mysql? : Sql dba

1166

What is having clause in sql?

990

What do you understand by data independence?

1118

What is normalization? How many normalization forms are there?

1097

How do I edit a table in mysql workbench?

865

What is temporary stored procedure?

969

Define outer join?

1013

What is db_recovery_file_dest in oracle? When do you need to set this value?

1138

How to connect Azure federated root database and apply federation in entity framework?

107

How to rename databases in ms sql server?

1216

How many tables we can create in mysql database?

970

The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?

587

What packages are available to pl/sql developers?

1085

what is error ora-03113: end-of-file on communication channel?

1181

For More Un-Answered { Databases } Questions Click Here