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 is package in dbms?

894

What is procedure in dbms?

903

What is the maximum line size that dbms_output can handle?

1184

What is variable dbms?

975

Can we write insert statement in function in oracle?

1106

What is a package in oracle?

1126

What is pragma autonomous transaction in oracle?

1091

What is define in oracle?

1077

Can we write dml statement in function in oracle?

1098

What is a trigger oracle?

1108

Is oracle a programming language?

1004

Is truncate autocommit in oracle?

1103

Why we use bulk collect in oracle?

1068

What is procedure overloading in oracle?

1074

Is oracle a language?

965

Un-Answered Questions { Databases }

How can the performance of a trigger be improved?

1057

how can you see all indexes defined for a table? : Sql dba

1011

What does this statement do @@rowcount?

982

What is the difference between translate and replace?

1079

Explain what stored procedure sp_replcounters is used for? : sql server replication

1533

What is 2nf in dbms?

1120

What is the purpose of primary key?

1045

Do we need commit after truncate?

1094

How is use pl and sql?

1078

How to use "for" statements in oracle?

1089

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1160

What is bcnf normalization form?

1135

What are different between mongodb and sql server databases?

What information is needed to connect sql*plus an oracle server?

1044

What is the current limitation of the size of SQL Azure DB?

127

For More Un-Answered { Databases } Questions Click Here