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

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

1058

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

961

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

1163

What are the packages in pl sql?

1030

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

1033

What is oracle and what are its different editions?

1086

What is the difference between substr & instr functions?

1245

What is meant by joins?

1073

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

1081

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

1063

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

1880

What are the different editions of oracle?

1124

What is meant by an index?

1162

What is meant by a deadlock situation?

1122

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

1104

Un-Answered Questions { Databases }

What is 2nf normalization?

1043

What is t sql in sql server?

1088

Is it possible to update views?

974

Explain the uses of database trigger.

1125

What are pages and extents? : SQL Server Architecture

1033

How to modify the underlying query of an existing view?

996

What are pages and extents? : sql server architect

833

What do you understand by the oracle?

556

What is 'mysqlshow'?

1081

What are the objects can be created using CREATE statement?

1003

How to verify a login name with sqlcmd tool?

1232

Can you explain important index characteristics?

1002

What is filter index?

962

What is the maximum size of sqlite database?

1117

Is there a free mysql?

914

For More Un-Answered { Databases } Questions Click Here