Databases Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies,

2 15579

What is the difference between SQL, DDL, and DML?

Wipro, BeBo Technologies,

7 60292

What are inner join and outer join?

3 7986




What are joins..how many types of joins are there?

CSC, TCS, Amdocs,

29 60549

what are Triggers?

TCS,

5 7885

what are stored procedures?

TCS,

6 6334

what are indexes..how many types of index's are there and what are they?

TCS, Green Info Solutions,

7 11186

what are views?

TCS,

7 12796

what is web server?

Satyam,

3 7218

What are functions

3 5656

What are the different table present in MYsql?

3 7942

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 7614

what is the difference between oracle 81,91,11i

Oracle, i2,

2 14470

How client makes connection with server in client/server architecture?

CA,

1 2302

Is Oracle 7.3 is a single user or multi user..Is it possible to use this as a backend for web applications?

2 2879







Un-Answered Questions { Databases }

how the indexes are stored in the Oracle Database?

981


What is inverted file ?

324


What is Reduced List of Values?

826


What is built_in Subprogram ?

1370


Is it possible to insert comments into sql statements return in the data model editor ?

1189






what is the difference difference between procedure and packages

5279


What are the critical issues you have resolved in your company

983


You create a private database link and upon connection, fails with: ORA-2085: connects to . What is the problem? How would you go about resolving this error?

818


a table has 2 classifications 1)liabilities 2)earnings this liabitity has 2 elements with 2 input values and the earnings have 2 elements with 2 input values i wrote a query so that my input is liability savings amount1 amount2 xxxx null xxxxxx 0 xxx1 null xxxxx1 0 null yyyy 0 yyyy null yyy1 0 yyy1 my problem is --when i developed a report(d2k) with this data my o/p is liabilities,amount1,savings,amount2 xxxx xxxxxx xxx1 xxxxx1 yyyy yyyy yyy1 yyy1 how could i move this savings,savings values 2 palces up. can any body provide me witha better solution

1018


OPTIMIZATION OF SP,CURSOR,TRIGGERS

1459


How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

1933


can we delete autodiff back up that we have set through sql server agent.

1035


WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

1564


what are the Prerequisites for Replication?

8235


wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

1289