adspace




Databases Interview Questions
Questions Answers Views Company eMail

what are the main differences between ms access and sqlserver

C DAC, CDAC,

1 5023

Department ----------- salary Deptname 1000 A 3000 A 2000 B 3000 B 4000 C 5000 C select the deptname where salary >=5000 result should be: Deptname --------- C please post only executed query in SQL server 2005 Asked By: Md. Niyaz

3 5866

What is the difference between SQL and SQL Server?

Cognizant, HCL,

3 9326

Which is better Oracle or MS SQL? Why?

Bally Technologies,

3 5120

Which is better Oracle or MS SQL? Why?

Bally Technologies,

3 6592

i want department wise maxmum salary and empolyee name

9 30348

Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?

IBM,

1 4126

in sql table following column r there i want find 1st paid ,2nd paid,3rd paid date for same |service_type|date |vehicle_no| |------------|------|_---------| |paid |23 jan|MH12H2007 | | | | | |paid |26 feb|MH12H2007 | | | | | | | | | |paid |28 mar|MH12H2007 | i want o/p like below vehicle no| 1st paid date | 2nd paid date|3rd paid |latest paid date| pls help me out

4 6171

what is meant by gateway

IBM,

1 4257

hOW TO LOAD SOURCE INTO TARGET 2 TIMES?(INFORMATICA)

2 4926

Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?

1 4755

WHICH IS THE BEST INSTITUTE IN HYD FOR "ORACLE"?

3 5214

what is integrated security (SSPI). why we use in the connection string?

2 7631

emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example

1 3522

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

Zensar,

2 5628


Un-Answered Questions { Databases }

What is acid mean in sql server?

1260


Is inner join faster than left join?

1289


what is the age limit for groups1 examination

2358


How do I find the sql server version?

1119


Is there some bulk load or other way to import a lot of data fast?

942


What is the difference between case version and decode version?

1120


How to use values from other tables in update statements using oracle?

1173


do you know how to configure db2 side of the application? : Sql server database administration

1139


How efficient you are in oracle and SQL server?

1270


What is temporary table in sql server? Why we use temp table?

1031


what is the difference between openrowset and openquery?

1213


What is a concurrency problem in dbms?

1066


how to escape special characters in sql statements? : Sql dba

1127


How to enter binary string literals in ms sql server?

1260


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1140