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

What do you know about normalization and de- normalization?

975

What is built-in function?

1064

Explain database normalization?

1269

Do you know exporting and importing utility?

1113

Explain microsoft sql server functions?

1177

What are scalar functions?

1058

Explain steps of normalization?

1067

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

942

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

1052

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

1109

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

1001

what are acid properties? : Sql server database administration

1062

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

961

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

1159

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

970

Un-Answered Questions { Databases }

What is normal form in dbms?

961

plss anybody specify tha constrian management system in dbms

2208

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

1034

What is the difference between locking and multi-versioning?

1043

what are the disadvantages of mysql? : Sql dba

1213

how to pass a variable more than one values?

707

What is dbms function?

1084

What are a collation and state the different types of collation sensitivity?

1252

Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)

828

Define ACID properties in a Database?

1108

What is dialect in database?

1034

Explain about SQL server 2005?

1026

Is there a database program for mac?

989

Is pgadmin open source?

851

Are pl sql variables case sensitive?

1093

For More Un-Answered { Databases } Questions Click Here