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 the types of model in sql server and explain

TCS,

2 6680

Wht is the difference between stored procedure and trigger

HCL, TCS,

6 15151

What are the types of backup and tell me the difference between full and differential backup?

CTS, TCS,

4 14074

What is the difference between login and a user?

CTS, TCS,

13 32212

can primary key of one table be a primary key in many other tables

4 10655

HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?

3 10800

what diffrence between function and procedure?

4 8151

Who i will insert 1 lacks record in a Database table

TCS,

4 13074

how can i get company email id's can anybody answer to this question. bcz it is very important for me, looking for the best answer.

1 3759

What is the use of placing primary key and foreign key constrains on columns.

Value Labs,

4 8726

what is IDE,DMV in sql server?

Value Labs,

1 8863

How many tables will create when we create table, what are they?

5 10262

what is IDE,DMV in sql server?

1 2917

how to create object in plsql

TCS,

2 8652

how to create object in plsql

Microsoft,

3 8994

Un-Answered Questions { Databases }

How do I remove duplicates in two columns?

1179

Design database draw er diagram for a certain scenario ?

4650

What is standby servers? Explain types of standby servers.

1076

how many tables will create when we create table, what are they? : Sql dba

1140

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1130

how to escape special characters in sql statements? : Sql dba

1111

What is current version of mysql?

1072

how to use regular expression in pattern match conditions? : Sql dba

1106

What is temporary table in sql server? Why we use temp table?

1014

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2703

How to write a left outer join with the where clause in oracle?

1150

Can sql servers link to other servers like oracle?

913

How to put more than 1000 values into an oracle in clause?

1111

How to enter binary string literals in ms sql server?

1235

Have you used lexical parameters in reports?

For More Un-Answered { Databases } Questions Click Here