Databases Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies,

2 12472

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

Wipro, BeBo Technologies,

7 54507

What are inner join and outer join?

3 6306

What are many types of joins are there?

CSC, TCS, Amdocs,

27 55542

what are Triggers?


4 6311

what are stored procedures?


6 4730

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

TCS, Green Info Solutions,

6 9370

what are views?


7 10902

what is web server?


3 4849

What are functions

3 4063

What are the different table present in MYsql?

3 6520

What is the difference between mysql_fetch_array and mysql_fetch_object?


4 6270

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

Oracle, i2,

2 13023

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


1 1565

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

2 2237

Un-Answered Questions { Databases }

how do u setup a replication site?


whats the maximum size of view state??


what is the difference difference between procedure and packages


What is a Built_in subprogram ?


what is IDE,DMV in sql server?


what is package and it uses and how can u call a package


how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping


I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me


How consistent is the view of the data between and within multiple sessions, transactions or statements ?


Where would you look for errors from the database engine?


what are parameter, we can check after creating a database in terms of QC and for each tables what should be the parameters for QC and QA?


suppose data is copie to oracle to sql by using DTS. Actully it taken 2 hours. suppose some day distribute the server in the middle of 2 hours. after how can i get the data ?


What are statistics, under what circumstances they go out of date, how do you update them?


query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp


what are the differences of where and if in SAS?