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

How to create a table index?

1151

How to assign data of the deleted row to variables?

1075

How to work with data objects interactively?

984

How to add a new column to an existing table with a default value?

1016

How to get a list of all tables in the database?

1 4279

How to set up autotrace for a user account?

1059

How to run the anonymous block again?

1132

How to see the table columns used in an index?

1024

How to drop an index?

959

What happens to the current transaction if the session is killed?

989

How to define an external table with a text file?

1069

How to get a list of all user accounts in the database?

1087

How to define a sub function?

1133

How to define a data field as not null?

1109

How to enter a new row into a table interactively?

1014

Un-Answered Questions { Databases }

How will you run ms_batch file in forms?

Can a unique key be a foreign key?

828

Are views faster than queries?

992

How do you remove a foreign key constraint?

809

What is meant by temporal data?

969

What is the difference between truncate and delete? Why is one faster? Can we rollback both? How would a full table scan behave after?

577

What are the differences between primary key and unique key?

1010

Explain go command in sql server?

1040

How to do Data integrity testing? Who does this testing (Developer or tester)?

2108

Define object-oriented model.

1037

Define cursor locking

1009

what is the maximum length of a table name, database name, and fieldname in mysql? : Sql dba

1125

How to rename an existing table?

1129

How to write a query with a right outer join in ms sql server?

913

Difference between aggregate functions of sql?

1105

For More Un-Answered { Databases } Questions Click Here