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 cold backup and hot backup (in case of oracle)?

921

What are the two major subsystems of system r?

1115

What are cursors give different types of cursors?

971

What is cold backup (in case of oracle)?

976

What is hot backup (in case of oracle)?

939

Explain ddl statements in pl/sql?

1022

How to return multiple rows from the stored procedure?

992

What is the life of an sql statement?

1050

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1032

What steps server process has to take to execute an update statement?

991

Can %notfound return null after a fetch?

1082

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

1229

Determine if oracle date is on a weekend?

1061

How to create a menu in sqlplus or pl/sql?

1139

How to use boolean type in select statement?

1096

Un-Answered Questions { Databases }

What is stored in a database?

985

List down some advantages of sql stored procedure?

984

What is pls_integer in pl sql?

1120

What are analytic functions in sql?

1045

How to check if microsoft access database engine 2010 redistributable is installed?

881

What is pl sql architecture?

979

Why are views required in the sql server or in any other database?

983

Is ms access easy to learn?

868

explain the advantages and disadvantages of stored procedure? : Sql dba

1032

Explain the purpose of indexes?

998

What is mysql and why it is used?

1103

How many triggers are possible in mysql?

984

What is bind variable in oracle 11g?

1059

Why do we need different type of parameter?

1072

Should you normalize audio?

969

For More Un-Answered { Databases } Questions Click Here