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 14225

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 7263

can foreign key take role of primary key?

CarrizalSoft Technologies, TCS, Villa Marie,

5 9791

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

Wipro,

4 10216

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

8 10556

What is the different between Stored Procedure and Procedure?

Informatica, MIS,

7 14424

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

NIC, Rolta,

4 12633

plz suggest me the book for preparation of NIC exam.

NIC,

10 14515

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

4179

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

1 6868

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

IBM,

1935

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

1 3767

what is Oracle10g? Please refer some sites...

1 4354

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

Satyam,

1 4275

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

Baidu, HCL, Yashu Systems,

4 10462

Un-Answered Questions { Databases }

Tell me when is the update_statistics command used?

1115

What are different types of raid configurations? : SQL Server Architecture

1086

Explain about Joins?

997

What is the use of aggregate functions in oracle?

1026

Can group functions be mixed with non-group selection fields in ms sql server?

945

How to create table in particular schema in postgresql?

837

Does asenumerable execute the query?

1050

What is the use of drop command?

1309

Define dml compiler.

1037

How does cross join work?

961

What is the new security features added in sql server 2014? : sql server security

1005

Where does mongodb store data ubuntu?

What is @@rowcount in sql?

1009

What are operators available in sql?

1051

Can we call stored procedure in trigger?

951

For More Un-Answered { Databases } Questions Click Here