Databases Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies, Accenture,

2 17594

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

Wipro, BeBo Technologies,

7 63292

What are inner join and outer join?

3 9018




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

CSC, TCS, Amdocs,

29 63963

what are Triggers?

TCS,

6 9506

what are stored procedures?

TCS, Wells Fargo,

7 7738

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

TCS, Green Info Solutions,

7 12769

what are views?

TCS,

8 14357

what is web server?

Satyam,

3 8815

What are functions

3 6726

What are the different table present in MYsql?

3 9034

What is the difference between mysql_fetch_array and mysql_fetch_object?

CTS,

4 9109

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

Oracle, i2,

2 15333

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

CA,

1 2925

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

2 3486







Un-Answered Questions { Databases }

How to assign new column names in a view?

23


How do I tell which tables have identities in sybase?

18


What do you know about Master Data & Transaction Info Package?

37


What are the differences between union, intersect, and minus operators?

16


explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

11






What is a ‘namespace’?

1


What is the difference between Triggers and Stored Procedure?

42


What are the different types of DBMS architecture?

53


Why I have to use stored procedures?

40


Explain storage manager?

29


Define Primary key, Foreign key, Weak key in your own words.

2232


what is oltp (online transaction processing)? : Sql dba

15


what are the two integrity rules used in DBMS?

39


How view is related to data independence?

15


What is CDC and explain complete CDC process flow?

1