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 14220

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 7259

can foreign key take role of primary key?

CarrizalSoft Technologies, TCS, Villa Marie,

5 9788

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

Wipro,

4 10210

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

8 10545

What is the different between Stored Procedure and Procedure?

Informatica, MIS,

7 14411

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

NIC, Rolta,

4 12622

plz suggest me the book for preparation of NIC exam.

NIC,

10 14493

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 6865

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

IBM,

1932

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

1 3759

what is Oracle10g? Please refer some sites...

1 4352

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 10457

Un-Answered Questions { Databases }

What is different between sql and mysql?

1018

What are trace files?

958

Is there a difference in storage type of numeric and decimal data types in sybase? If yes, what?

838

what's the difference between a primary key and a unique key? : Sql server database administration

950

What is use of dbms?

939

What are the different methods available under sqlcommand class to access the data?

1121

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

1079

Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?

910

What is a schema in ms sql server 2005?

970

What does the not null constraint do?

1088

How do you remove a foreign key constraint?

809

What is the purpose of TNS?

1031

what are steps for interface? where is exchange rate defined in which table?

2158

how to create a new view in mysql? : Sql dba

935

Define transaction and transaction isolation levels?

984

For More Un-Answered { Databases } Questions Click Here