ALLInterview.com :: Home Page
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   Errors
   Testimonials Refer this Site  Refer This Site to Your Friends  Site Map  Contact Us      
   
 
 Categories >> Software >> Databases
 
  Oracle (1965)   SQL Server (1097)   MS Access (27)   MySQL (201)   Postgre (50)
  Sybase (22)   DB Architecture (8)   DB Administration (215)   DB Development (56)   SQL PLSQL (835)
  Databases AllOther (114)
 
Suggest New Category 
 


   


Question Asked @ Answers Views     Select
How to find locks exists in a table or not?    1  23
How collections are improve the performance?    0  16
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    0  12
What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..    1  33
What is user define exception and example    1  153
What is Temp Table and type of temp table?    0  76
How to find the count of letter "L" in HELLO    5  215
HP Interview -2016 Unix 1) grep command in unix 2) what is set command    1  173
display null value rows with out using null function?    5  356
write a query that displays every Friday in a year with date?    3  309
How to display all Friday's in a year with date?    2  242
how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.    1  149
HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??    0  79
how to solve cardinality in dbms...many to many ralationships    0  127
what is logical system in sap basis    0  70
E-Mail New Answers        Answer Selected Questions       
 [1]    2  ... 22   ... 43   ... 64   ... 85   ... 106   ... 127   ... 148   ... 169   ... 190   ... 211   ... 232   ... 253   ... 274   ... 295    Next
 
 
 
 
 
Un-Answered Questions
 
 Question Views   Select
 
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They?? 163
what is the difference between functional dependecy and multilevel dependency? 834
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error. 366
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9 189
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it? 825
What is supporting issues GL AP and AR? 795
A) Which two are benefits of Teradata's support for ANSI Standard SQL? (Choose two.) 1.data is distributed automatically 2.queries get optimized to better plans 3.submit queries from other database systems 4.can interface with BI tools B) Which statement is true when comparing the advantages of third normal form to star schema? 1.Star schema tends to have fewer entities. 2.Star schema requires additional data storage. 3.Third normal form tends to have fewer entities. 4.Third normal form requires additional data storage. C)Which two sets of functions does the Parsing Engine (PE) perform? (Select two.) 1.sorting, formatting, and aggregating of the final answer set 2.flow control of the data to and from the participating tables 3.SQL statement interpretation, syntax validation, and semantic evaluation 4.dispatching the step execution sequence to the AMP via the BYNET D) Which two can be achieved with Teradata Active System Management (TASM)? (Choose two.) 1.disable hardware 2.react to hardware failure 3.influence response times 4.collect metadata E) Which three mechanisms can be used to ensure security within the Teradata Database? (Choose three.) 1.views 2.spool limits 3.roles 4.access rights 5.profiles 3830
what is isolation level at dead lock? 647
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram 366
what is port in oracle? how is it related to database application. 398
What is a Built_in subprogram ? 1924
role of sql sever 2005 in database rather than any other database 573
what is rcp,if rcp disabled what happen? 661
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that? 768
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That?? 200
E-Mail New Answers        Answer Selected Questions