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

Write down the syntax and an example for create, rename and delete index?

1030

Tell me the difference between clustered and non-clustered index?

994

What is the fillfactor concept in indexes?

1037

What is ms sql server reporting services?

1128

What is the architecture of ms sql reporting service?

1027

Explain ms sql server reporting services vs crystal reports?

975

Do you know what are the reporting services components?

1022

Explain how does the report manager work in ssrs?

1003

Explain having clause?

1031

Define tempdb database?

1043

Explain the microsoft sql server delete command?

1082

What is the use of stored procedure?

987

What is log cache in sql server?

1103

Define msdb database?

1079

Define right outer join?

1017

Un-Answered Questions { Databases }

How does one create a new database?

640

Explain important index characteristics?

1083

Does mysql use sql?

948

Give us a non-computer example of preemptive and non-preemptive scheduling?

977

how to convert character strings to numeric values? : Sql dba

1170

What is meant by recursive hints in oracle?

1135

What is system tablespace?

1153

What is a good replacement for microsoft access?

883

What is data source in connection string?

958

How many types of relationships are there in ms access?

894

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

2169

What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?

920

What is file based approach?

1003

how to create a new view in mysql? : Sql dba

989

What is integrity and what is constraint??Explain with example

2347

For More Un-Answered { Databases } Questions Click Here