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 joins..how many types of joins are there?

CSC, TCS, Amdocs,

27 55542

what are Triggers?

TCS,

4 6311

what are stored procedures?

TCS,

6 4730

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

TCS, Green Info Solutions,

6 9370

what are views?

TCS,

7 10902

what is web server?

Satyam,

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?

CTS,

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?

CA,

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?

507


whats the maximum size of view state??

673


what is the difference difference between procedure and packages

3792


What is a Built_in subprogram ?

2098


what is IDE,DMV in sql server?

1062


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

628


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

483


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

2587


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

597


Where would you look for errors from the database engine?

1431


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?

1275


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 ?

750


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

838


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

476


what are the differences of where and if in SAS?

679