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 triggers in ms sql server?

1177

How to disable triggers using "disable trigger"?

1066

Can the query output be sorted by multiple columns in ms sql server?

999

How many ways to create table-valued functions?

1012

How to list all stored procedures in the current database using ms sql server?

1151

How to get a list of columns using the "sp_help" stored procedure in ms sql server?

1032

How to create user defined functions with parameters?

1249

How to create a view using data from another view?

959

How to drop an existing user defined function in ms sql server?

1041

How to execute the cursor queries with "open" statements?

1192

How to configure odbc dsn with different port numbers?

1100

What happens if null values are involved in bitwise operations?

1048

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

1036

How to create a view on an existing table in ms sql server?

1141

How to change the password of a login name in ms sql server?

1027

Un-Answered Questions { Databases }

What is difference between server and database?

1103

What to do if the startbd.bat failed to start the xe instance?

1098

What is the Maximum size for a table in PostgreSQL?

1539

what happens if null values are involved in expressions? : Sql dba

1058

how to return query output in html format? : Sql dba

1081

How do you write an inner join query?

967

How to delete a trigger in mysql?

936

How can we get count of the number of records in a table?

966

Is mongodb a key value store?

Is it true, that there is no difference between a rule and a check constraint?

1069

Explain transaction server consistency?

988

How to retrieve data from an cursor to a record?

1118

Which operations lock the database in mongodb?

When to use ms access vs excel?

899

Write the SQL query to drop, truncate and delete table.

988

For More Un-Answered { Databases } Questions Click Here