I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?
2 7432Can we use commit or rollback in trigger? If yes, then how. Please explain with a suitable example?
5 13424Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
1 3605Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS
1 2926Post New HSBC Interview Questions
Define adapters?
When would you use abend command?
Explain the difference between amnion and chorion?
how brushed dc motor operating ?
The problem-solving agent with several immediate options of unknown value can decide what to do by just examining different possible sequences of actions that lead to states of known value, and then choosing the best sequence. This process of looking for such a sequence is called Search. State True or False a) True b) False
When you are using sap bi7.x, you can load the data to which component?
Explain what is google penguin?
What is the function of xslt?
Explain difference between nil and nil?
What happen to a denaturated enzyme regarding its functionality? How that result can be explained with the help of the lock and key model?
How many records can be stored in mysql table?
Are udp sockets bidirectional?
How do I make synchronous data calls in actionscript? : adobe flex action script
Java is fully object oriented languages or not?
can penalty be imposed under sec 96 of vat act west bengalfor goods destroyed or damaged