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

How to change sql*plus system settings?

1106

What is output spooling in sql*plus?

1089

What is oracle sql developer?

1118

How to place comments in pl/sql?

1215

How to install oracle sql developer?

1096

What are sql*plus environment variables?

1155

What operating systems are supported by oracle sql developer?

1012

What are the parameter modes supported by pl/sql?

1152

How to connect a sql*plus session to an oracle server?

1174

How to run sql statements through the web interface?

1091

How to run sql commands in sql*plus?

1252

What is null in pl/sql?

1119

How to look at the current sql*plus system settings?

1213

How to run pl/sql statements in sql*plus?

1143

How many scalar data types are supported in pl/sql?

1103

Un-Answered Questions { Databases }

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

1115

Please illustrate physical database architecture? : SQL Server Architecture

1026

How does a covering index work?

1008

In which language mysql has been written?

1391

What is dense_rank?

989

Tell me in brief how sql server enhances scalability of the database system?

1040

all steps of bitmap report?

2397

What is the difference between nvl and nvl2?

1028

What is the difference between TRUNCATE and DROP?

1188

What are the 3 main types of search queries?

880

Which sql server table is used to hold the stored procedure script?

1004

Is ms access part of ms office?

1022

What is the difference between upgrade and migration in sql server?

1150

How can Oracle users be audited?

1170

What is the difference between clustered and non-clustered index? : sql server DBA

1141

For More Un-Answered { Databases } Questions Click Here