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

What are triggers in ms sql server?

1235

How to disable triggers using "disable trigger"?

1120

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

1039

How many ways to create table-valued functions?

1057

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

1201

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

1077

How to create user defined functions with parameters?

1301

How to create a view using data from another view?

998

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

1070

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

1249

How to configure odbc dsn with different port numbers?

1156

What happens if null values are involved in bitwise operations?

1085

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

1079

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

1198

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

1063

Un-Answered Questions { Databases }

how to extract a unit value from a date and time? : Sql dba

1045

Explain the wait events in statspack report 'db sequential real'?

694

What are the different types of constraints?

1288

What can I use microsoft access for?

869

Name three of the features managed by the surface area configuration tool? : sql server security

1034

What is pragma autonomous transaction in oracle?

1128

How do I trace a query in sql server?

1004

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1118

What is order by clause?

969

What are the other commands to know the structure of a table using mysql commands except explain command?

1097

Is sql free?

1031

What is store procedure? How do they work?

1071

How to save query output to a local file?

1089

How do I remove all rows from a table?

892

What is the port number for postgresql?

944

For More Un-Answered { Databases } Questions Click Here