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 are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

1123

Explain “row_number()” in sql server with an example?

1024

List out the different types of locks available in sql server?

998

What is a view in sql?

991

What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1248

What are the different types of subquery?

1177

Can sql servers link to other servers like oracle?

858

Why we use the openxml clause?

1032

Can one drop a column from a table?

1036

What are the main differences between #temp tables and @table variables and which one is preferred?

1098

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

976

What is a not null constraint?

1059

What is the use of “join” in sql server?

1121

What are the steps you will take to improve the performance of a poor performing query?

995

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

997

Un-Answered Questions { Databases }

Can you have more than one trigger on a table?

1019

What is byte access?

955

How do you select a table?

972

How you can add messages to the nt event log from within a stored procedure?

1096

What is the data pump import utility?

1051

What is a cursor variable?

1156

Does unique constraint create index postgres?

790

How many types of indexes are there in sql?

1005

What is 'mysqlcheck'?

1041

How to get all stored procedures in sql server?

1020

How to connect asp pages to oracle servers?

1095

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1098

Characterize join and name diverse sorts of joins?

992

What is the Repository and how many types of repository?

602

What are open_form,call_form,new_form?

For More Un-Answered { Databases } Questions Click Here