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

Why I am getting this error when dropping a database in ms sql server?

1087

Why I can not enter 0.001 second in date and time literals in ms sql server?

1078

How to loop through the result set with @@fetch_status?

1368

What is the impact on other user sessions when creating indexes?

942

How to insert multiple rows with one insert statement in ms sql server?

1136

How to drop existing views from a database in ms sql server?

1116

What is open database communication (odbc)?

1075

What are the underflow and overflow behaviors on float literals?

1128

How to create new tables with "select ... Into" statements in ms sql server?

1008

Can group functions be used in the order by clause in ms sql server?

1031

Can you pass expressions to stored procedure parameters?

1051

How to return the top 5 rows from a select query in ms sql server?

1155

How to add more data to the testing table in ms sql server?

1107

How to declare and use cursor variables?

1189

How to use "begin ... End" statement structures in ms sql server?

1060

Un-Answered Questions { Databases }

How to execute multiple stored procedures at one time in sql server?

1027

What are aggregate and scalar functions?

1043

How do you create a database in microsoft access?

897

What is ms sql server service broker?

1008

How would you get the current date in mysql?

1117

What is mutating error in pl sql?

1039

What is an Oracle Data Segment?

1066

What is a data manipulation language?

1035

Explain the concepts of a primary key and foreign key.

899

what is a field in a database ? : Sql dba

1075

What is blob database?

951

what are different types of raid configurations? : Sql server database administration

1073

Which parameters are optional in init.ora parameter file?

2225

Which database is best for storing images?

969

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5586

For More Un-Answered { Databases } Questions Click Here