Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?
3 12418What is Query Execution Plan? How does it help optimize or tune a database driven application?
2 10239in report level u find from which context u use,why it appears,what is the reason,how u resolve in report level
3 9757in universe perameter u dont give the option multiple contexts ,what is the impact in report level
2 8928I have PCB with structure: PCB TYPE=DB, C DBDNAME=EMPCADBD, C KEYLEN=18, C PROCOPT=LS SENSEG NAME=EMPLOYEE, C PARENT=0 SENSEG NAME=COMPDTL, C PARENT=EMPLOYEE SENSEG NAME=BANKDTL, C PARENT=COMPDTL SENSEG NAME=SALDTLS, C PARENT=BANKDTL SENSEG NAME=EDUCDATA, C PARENT=EMPLOYEE SENSEG NAME=EMERDETL, C PARENT=EDUCDATA SENSEG NAME=ADDRESS, C PARENT=EMPLOYEE ************************************************************ *********** PSBGEN PSBNAME=PSBCALDP,LANG=COBOL END Requirement is to Create a report based on Salary brackets. ( Use SSA’s for logic) · It should have CTCGROSS brackets and No of employees o Employee names falling in each bracket Salary < 100,000 No of Employees Employee-Name Level 100,000 < Salary < 300,000 No of Employees Employee-Name Level 300,000 < Salary No of Employees Employee-Name Level
1 5967Post New Accenture Interview Questions
How to find the path in unix?
Describe Partition and Partitioner in Apache Spark?
How to change system global area (sga) in oracle?
Explain useful data mining queries?
What are vldb properties?
What is the main difference between ‘between’ and ‘in’ condition operators?
What is use of static in java?
Should I learn c or c++ first?
What is the meaning of 0:1 cardinality of context node in web dynpro application?
What is the use of hidden field in html?
Is multiple inheritance possible in swift?
8000 jobs r there i given commit, suddenly job will abort? what happens? 2)diff b/t transformer stage & filter stage? 3)how to load the data in the source?
WHAT IS THE QUANTITY OF DBM
What is enterprise information system resource?
What are the different areas of sociology?