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 is store procedure? How do they work?

1037

What is sql view?

1059

How to change server name in sql server?

1204

What is store procedure? How do they work? When do you use?

964

When we should use @@error?

990

What is a sql join?

1045

How to create function with parameter in sql server?

1129

Create and insert into temp table in sql server?

1053

When would you use sql joins?

977

How to create and drop temp table in sql server?

1072

What does this statement do @@rowcount?

986

How do database indexes work?

1026

How to execute function in stored procedure sql server?

1176

How can I check if a view exists in a sql server database?

1051

How to execute stored procedure and set temp table in sql server?

1063

Un-Answered Questions { Databases }

What are the functions used to encrypt and decrypt the data present in mysql?

1122

Write a program using SQL queries to find a unique entry in a table.

1015

how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration

1003

What is 'Join' and explain its various types.

1168

How to process query result in pl/sql?

1152

Compare ‘postgresql’ with ‘nosql’?

881

Can we use trigger new in before insert?

932

What is extended stored procedures?

979

In which format does an image save in SQL Server database ?

1019

What is @@error in sql?

1084

Why do you create or replace procedures rather that drop and recreate.

1024

Why we use mysql database?

947

Find columns used in stored procedure?

1007

What is difference between materialized view and view?

930

how to get help information from the server? : Sql dba

957

For More Un-Answered { Databases } Questions Click Here