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 14217

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 9787

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

Wipro,

4 10206

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

8 10535

What is the different between Stored Procedure and Procedure?

Informatica, MIS,

7 14408

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

NIC, Rolta,

4 12619

plz suggest me the book for preparation of NIC exam.

NIC,

10 14491

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 6864

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 10445

Un-Answered Questions { Databases }

Is nosql relational?

943

How many ways we can retrieve the date in result set of mysql using php?

1116

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2443

What is primary key and unique key?

1119

What are the varoius components of physical database structure of oracle database?

1006

what are archived logs?

2199

What are the several methods to enter data in ms access 2013?

805

What is user defined datatypes and when you should go for them?

1016

What is the fastest query method to fetch data from the table?

1361

what is a schema in sql server 2005? : Sql server database administration

1027

What is e-r model in the dbms?

1058

What are the limitations of check constraint?

1033

How to load data through external tables?

1135

What Are Cross Validation & Adi?

1157

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

2323

For More Un-Answered { Databases } Questions Click Here