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

How to enable tcp/ip protocol on a sql server?

1222

How to list all objects in a given schema?

1113

How to delete existing triggers using "drop trigger"?

1110

How to download microsoft sql server 2005 express edition?

1099

How do you know if sql server is running on your local system?

1109

How to get a list of columns in a view using the "sp_columns" stored procedure?

1090

How to use values from other tables in update statements in ms sql server?

1191

How to count duplicated values in a column in ms sql server?

1181

How to write a query with a left outer join in ms sql server?

1033

What to perform pattern match with the like operator?

938

How to list all field names in the result set using mssql_field_name()?

955

What happens if null values are involved in comparison operations?

1047

What is transact-sql language?

1137

How to grant a permission in ms sql server using "grant execute" statements?

1140

How to create a scrollable cursor with the scroll option?

1051

Un-Answered Questions { Databases }

List the different index configurations possible for a table?

986

How to use subqueries with the in operators in ms sql server?

1135

Introduction of rollup clause using sum and group by clause?

1024

What are the features of rdbms?

912

How does recursive cte works in sql server?

1062

How will you optimize a stored procedure optimization?

1121

Explain oracle’s server parameter file.

1041

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

2043

What is the difference between a delete command and truncate command?

1041

describe mysql connection using mysql binary. : Sql dba

1127

What are the different Topologies in which Replication can be configured?

1249

How sql query is executed?

1189

Explain about the properties of cursors?

1082

1. What is PO rate variance gain and loss?

3020

What are sql triggers used for?

1037

For More Un-Answered { Databases } Questions Click Here