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

Why do we use %rowtype & %type in plsql?

1101

Why do we create stored procedures & functions in pl/sql and how are they different?

995

How will you distinguish a global variable with a local variable in pl/sql?

1209

What are the packages in pl sql?

1067

Can we convert a date to char in oracle and if so, what would be the syntax?

1071

What is oracle and what are its different editions?

1122

What is the difference between substr & instr functions?

1297

What is meant by joins?

1113

Can we save images in a database and if yes, how?

1116

What is a view and how is it different from a table?

1138

How will you write a query to get a 5th rank student from a table student_report?

1926

What are the different editions of oracle?

1183

What is meant by an index?

1227

What is meant by a deadlock situation?

1156

What is the difference between a primary key & a unique key?

1142

Un-Answered Questions { Databases }

What is temporary Interface( Yellow Interface) ?

616

What is the size limitation for an access database?

1109

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

1062

How do we select distinct values from a table?

973

Write a query to select all teams that won either 1, 3, 5 or 7 games.

1451

How do database connections work?

993

Can postgresql scale horizontally?

964

How to pump the data from one database to another?

975

What are the indexes in sql server?

1192

Does mysql case matter?

966

How to load a csv file into a table

1082

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

2862

What is the drawbacks of normalization?

1020

Equi join and non equi join is possible with sql server?

1102

What is a partition function in sql server?

1223

For More Un-Answered { Databases } Questions Click Here