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

why can't we assign not null constraint as table level constraint

CTS, Wipro,

3 14251

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

Zensar,

2 7289

can foreign key take role of primary key?

CarrizalSoft Technologies, TCS, Villa Marie,

5 9841

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

Wipro,

4 10252

How to find out name of all employees who has salary less than 200 Rs.?

8 10594

What is the different between Stored Procedure and Procedure?

Informatica, MIS,

7 14475

plz suggest me the books for the preparation of NIC written exam.

NIC, Rolta,

4 12665

plz suggest me the book for preparation of NIC exam.

NIC,

10 14570

for what purpose we use MDM(master data management)tell me plz.

4191

How i get the client machine Ip address through developer 2000 forms, if you are running three tier architech.

1 6877

In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

IBM,

1951

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 3778

what is Oracle10g? Please refer some sites...

1 4371

how can we restore RMAN backup from SUN O/S to AIX 5.3? is it possible or not?

Satyam,

1 4297

What is the maximum size of a row in oracle 9i?

Baidu, HCL, Yashu Systems,

4 10485

Un-Answered Questions { Databases }

What is difference between index and primary key?

1108

Explain natural key?

1151

how to implement the logic in procedures if the source side data deleted that will reflect the target side table?

693

What is a database in business?

958

What does you mean by s4 super key?

1010

When do we use triggers?

1092

Describe the types of keys?

1121

How do I open port 1433?

941

What is federation member?

116

What is RAID? What are the different types of RAID configurations?

1148

What are the types of lock supported by ?

1057

How do I uninstall sql server 2014?

948

Where is microsoft access located?

838

Where do we use pl sql?

1011

What are different types of blocks used in stored procedure?

1145

For More Un-Answered { Databases } Questions Click Here