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 do you know about normalization and de- normalization?

936

What is built-in function?

1023

Explain database normalization?

1237

Do you know exporting and importing utility?

1054

Explain microsoft sql server functions?

1127

What are scalar functions?

1011

Explain steps of normalization?

1019

explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

913

what is the system function to get current user's user id? : Sql server database administration

1014

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1067

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

958

what are acid properties? : Sql server database administration

1009

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

920

explain how to create a new schema in a database? : Sql server database administration

1119

there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration

937

Un-Answered Questions { Databases }

How to use the inserted and deleted pseudo tables?

975

Can you have more than one cursor open at any one time in a program ?

971

What is sql engine in oracle?

1001

how can we know the count/number of elements of an array? : Sql dba

1072

What is the use of access database?

900

State and explain the different types of data models?

956

What are the types of database engines available in mysql?

1050

What are the different types of replication are there in sql server 2000?

1048

What is rank in database?

895

Is postgres a sql database?

918

What are wait types?

1129

How you can get a list of all the table constraints in a database?

972

What are inner outer left and right joins in sql?

1026

What is a light scan in informix?

Whis is not false in primary key?

1470

For More Un-Answered { Databases } Questions Click Here