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

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

CTS, Wipro,

3 14442

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 7500

can foreign key take role of primary key?

CarrizalSoft Technologies, TCS, Villa Marie,

5 10075

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

Wipro,

4 10502

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

8 10900

What is the different between Stored Procedure and Procedure?

Informatica, MIS,

7 14780

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

NIC, Rolta,

4 12842

plz suggest me the book for preparation of NIC exam.

NIC,

10 14888

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

1 4258

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

1 6978

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

IBM,

1 2016

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

1 3884

what is Oracle10g? Please refer some sites...

1 4446

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

Satyam,

1 4395

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

Baidu, HCL, Yashu Systems,

4 10620

Un-Answered Questions { Databases }

Does view occupy space?

1005

How to define array in mongoose schema?

please send me oracle pl/sql exp resume. and also faqs...

2566

in oracle BPM composer in part BA model on design model in enterprise model i cannot connection with value chain model work not links in part properties do you can me help me?

1605

What are the types of database explain each of them briefly?

1053

i have all the Oracle Certification material from 1z0-001 to 1Z0-643, if required just drop me a mail to: summi4you@yahoo.co.in

1856

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1021

How many concurrent programs you have customized, can you name some of them?

Can delete statement be rollbacked?

1050

How to remove duplicate rows from table except one?

1081

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

1149

If a cursor is open, how can we find in a pl/sql block?

1235

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

2100

What are the kinds of subquery?

1101

What are the source of constraints?

1006

For More Un-Answered { Databases } Questions Click Here