Databases Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies, Accenture,

2 18072

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

Wipro, BeBo Technologies,

7 64335

What are inner join and outer join?

3 9362

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

CSC, TCS, Amdocs,

29 65273

what are Triggers?

TCS,

6 10062

what are stored procedures?

TCS, Wells Fargo,

7 8318

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

TCS, Green Info Solutions,

7 13263

what are views?

TCS,

8 15017

what is web server?

Satyam,

3 9376

What are functions

3 7029

What are the different table present in MYsql?

3 9437

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 9594

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

Oracle, i2,

2 15700

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

CA,

1 3128

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

2 3726







Un-Answered Questions { Databases }

What is partition by in sql?

50


How to connect Silverlight application to database?

112


How do you know if a relationship is 2nf?

46


What happens if the update subquery returns multiple rows?

89


What is the difference between insensitive and scroll cursor?

76






WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?

1360


What is MySQL?

103


What is tuple in rdbms?

42


What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

80


Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

283


what is a relationship and what are they? : Sql dba

84


Why do we use pragma autonomous transaction?

49


What is a trigger and what are its types in oracle?

64


What is the function of DML Compiler?

101


How do you login to MySql using Unix shell?

115