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 a directory object?

1097

How to call a sub procedure?

1093

How to retrieve values from data fields in record variables?

1115

What are the general rules on data consistency?

1009

How to define a procedure inside another procedure?

1024

What to do if the binary spfile is wrong for the default instance?

1069

How to create a server parameter file?

1135

How to rename an existing table?

1129

What are the execution control statements?

1063

How to run create database statement?

1032

What happens if the update subquery returns multiple rows?

1116

How to use "startup" command to start default instance?

1031

What happens if the imported table already exists?

1033

How to create a stored program unit?

1228

How to call a stored function with parameters?

1045

Un-Answered Questions { Databases }

Tell me what is the order in which the sql query is executed?

951

What are the advantages/disadvantages of mysql and php?

959

What is Fully Functional dependency?

951

What are the different types of synonyms?

1140

What is the best free database?

915

What happens if strings are casted into wrong code pages in ms sql server?

1113

What is difference between schema and table?

915

How to drop an index in oracle?

1076

What is the bookmark lookup and rid lookup?

998

Why do we use view in sql?

961

What is the relation between database and instance?

644

What are the different mysql database engines?

1163

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1194

What is the difference between getdate and sysdatetime?

1007

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

981

For More Un-Answered { Databases } Questions Click Here