Databases Interview Questions
Questions Answers Views Company eMail

What is the SQL?????????????????????????????

CMS,

5 4077

What is the Query to print out the individual total number of duplicate row in sql.

TCS,

5 7516

what is the index and synonym. i have the definitions ...can any one give me brief explanation.. with regards,

1070




How to display the hierarchy of employee and managers without using connect by prior.

1 2207

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

IBM,

1257

how to know the tables in database having foreign key?

2 2415

find the second highest salary of the emp table

6 4287

Difference between MYSQL_ASSOC,MYSQL_NUM and MYSQL_BOTH ?

TCS,

3 17610

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

HP,

877

what is pragma ?

Polaris,

1 5117

A and B are tables. x is a column. Then What is difference between A.x = B.x(+) and A.x = B.x ?

Cognizant, IBM,

7 4674

What is the Query Optimizer. How you optimize your qeury.

Ericsson,

2 4675

what is an sql server?

1 2419

cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..

2 2524

find 2nd highest salary of person using cursor concept?

HCL,

6 5981







Un-Answered Questions { Databases }

what is logical system in sap basis

433


Please can the SQL code below be interpreted IF @xMatchCriteria='MATCH12' BEGIN IF EXISTS (Select * from #InsightData where (EmailAddress=@xDCPEmailAddress ) ) BEGIN SET @xTestMatchCriteria = @xMatchCriteria; SELECT @xCRMCustomerId=CustomerId, @xCRMDcpCustomerId=DcpCustomerId, @xCRMPortalCustomerID=PortalCustomerID,@xCRMDcpID=DcpID, @xCRMCardNumber=CardNumber, @xCRMEmailAddress=EmailAddress, @xCRMfirtLetterFirstName=firtLetterFirstName, @xCRMLastName=Surname,@xCRMAddressLine1=AddressLine1, @xCRMPostCode=PostCode FROM #InsightData where (EmailAddress=@xDCPEmailAddress ) END ELSE BEGIN SET @xTestMatchCriteria='No'+@xMatchCriteria; END END

536


Whis is not false in primary key?

270


Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun

958


If the job running very slow what is the action you do

771






Can we modify approve purchase order?if yes what is navigation?

834


what is the Ticketing tool used in Wipro technologies at Bangalore...???

5233


What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

1101


Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

926


How can we tune a oracle database if log file sync issue comes

1034


i want to know rdbms certification details and syallabus and for whom i contact for rdbms certification in bangalore i need answer very urgent please mail to aniltelkar50@gmail.com please as soon as possible

1358


default triggers available for reports

1045


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1106


Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

776


explain about the critical recovery scenario you had experienced

1039