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

Mention the 3 ways to get a count of the number of records in a table.

1032

Mention a few common trace flags used with sql server?

985

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

1029

What do you understand by coalesce in sql server?

1135

What do you understand by mirroring and mention the advantages of the mirroring?

1130

Mention the differences between local and global temporary tables.

1115

What do you understand by check constraint in sql server?

1028

What is the tcp/ip port on which sql server runs?

1251

What do you understand by intent locks?

1068

Explain log shipping and mention its advantages.

1097

Explain log shipping?

1081

What do you understand by the analysis services in sql server?

993

What are the steps you must follow to hide sql server instances?

1037

What are the advantages of mirroring?

1046

What do you understand by user-defined function in the sql server?

1015

Un-Answered Questions { Databases }

How do I find query history in sql server?

996

What is onf in normalization form?

1117

Find columns used in stored procedure?

1046

explain the delete statements in sql

1147

Explain the use of dde package in d2k.

What is example of database?

1143

What is identity?

1087

What are different types of views?

992

What is a system tablespace and when it is created?

1023

How can you list all the columns in a database?

979

what is the difference between substr and instr function in oracle?

1151

How many tables can a sql database have?

1036

Explain self joins in oracle?

1068

What is indexing in mysql?

1025

What is snapshot replication?

1105

For More Un-Answered { Databases } Questions Click Here