what is the Difference between Dynaset and Snapshot?

895

Write a program to replace n bits from the position p of the bit representation of an inputted character x with the one's complement. Method invertBit takes 3 parameters x as input character, p as position and n as the number of positions from p. Replace n bits from pth position in 8 bit character x. Then return the characters by inverting the bits.

2974

oracle 1st round What are the different types of joins? Explain normalization with examples. What cursor type do you use to retrieve multiple recordsets? Diffrence between a "where" clause and a "having" clause What is the difference between "procedure" and "function"? How will you copy the structure of a table without copying the data? How to find out the database name from SQL*PLUS command prompt? Tadeoffs with having indexes Talk about "Exception Handling" in PL/SQL? What is the diference between "NULL in C" and "NULL in Oracle?" What is Pro*C? What is OCI? Give some examples of Analytical functions. What is the difference between "translate" and "replace"? What is DYNAMIC SQL method 4? How to remove duplicate records from a table? What is the use of ANALYZing the tables? How to run SQL script from a Unix Shell? What is a "transaction"? Why are they necessary? Explain Normalizationa dn Denormalization with examples. When do you get contraint violtaion? What are the types of constraints? How to convert RAW datatype into TEXT? Difference - Primary Key and Aggregate Key How functional dependency is related to database table design? What is a "trigger"? Why can a "group by" or "order by" clause be expensive to process? What are "HINTS"? What is "index covering" of a query? What is a VIEW? How to get script for a view? What are the Large object types suported by Oracle? What is SQL*Loader? Difference between "VARCHAR" and "VARCHAR2" datatypes. What is the difference among "dropping a table", "truncating a table" and "deleting all records" from a table. Difference between "ORACLE" and "MICROSOFT ACCESS" databases. How to create a database link ? PL/SQL interview questions... Normalize many to many relationships Difference - Equijoin and union What is TEMP table space in Oracle, what is rollback segment How do we find row chaining? Pattern matching operators Features in oracle 9i and 10g Why truncating table is faster than delete copy commit syntax Convert Zulu time zone to US Eastern time zone Difference - union and union all Difference - Group by, Order by clause Which Ranking functions are available? Difference - Decode, NVL, NVL2 Tradeoffs of using partitioned tables How can we call stored procedure in SQL query What are the restrictions on calling PL/SQL from SQL Why EXISTS is preferable to distinct Give 2 examples of avoiding unnecessary parsing.

2518

Someone wants to send a small quantity, say about 500 Kgs., of green coffee beans from Koraput Orissa to Bangalore for Roasting and Packaging of the same there. There will be a loss in weight of about 20% during the processing the green coffee beans into coffee powder, which will then be fit for human consumption. Now, after processing the green coffee beans at Bangalore, the person wants to sell simultaneously a part of the Roasted Coffee Powder to four persons; one of them is in Chandigarh (a registered Dealer in Punjab) and the other is in Mumbai (possibly he is a an individual and not a registered dealer), third one is a registered dealer in Bangalore and the last one is an individual consumer just like you and me, and is not a registered dealer and stays in Mysore. The person wishes to bring the rest of the packed Roasted Coffee Powder back to Koraput, Odisha. The planter is a registered dealer under VAT in Odisha and has produced (manufactured) the coffee beans in his own gardens, and has applied for a CST Number but is yet to obtain the Number. We want to know: As to whether he can send the coffee beans to Bangalore for roasting without obtaining a CST Number beforehand. Or as to whether it is mandatory for him to get the CST registration first, before sending the Coffee beans to outside the state; As to how the person can generate the Way Bills from here and to send these to the transport carriers, for his sales to Chandigarh, Mumbai, Bangalore and Mysore. Tell me as to how he can do the necessary paper works and as to how he can pay the tax collected thus, As to how he can bring the rest of the roasted coffee powder back to Koraput that he can sell afterwards in the state and outside; He shall be sending samples of the Roasted coffee to Philippines and elsewhere, from Bangalore itself. May be in a subsequent times he might export, for which he has to send the roasted coffee powder to Mumbai; If the person wants to send the parchment coffee to Kushal Nagar in Karnataka to do the Curing Pre-Roasting) there, as to how he can send the processed coffee to the Roster at Bangalore. During Curing there is a loss of weight of about 20% too. Until the roasting is done, there will be no transfer of ownership, at any point of time, in between.

1062

why starting current is high and resistance is almost 0 during the starting of motor dc motor...?

619

Please tell me how to discuss about the salary in the hr interview. My current ctc is 3.32l and my expectation is 6.0 L. If they negotiate i can come up to 5.5l. How i can handle the situation. Please answer.

1669

Why did you decide to pursue this career?

3

GD about the reality show on TV

2879

What are HP's objectives for the coming year?

5

What is Form-I, FORM-F, FORM-H, FORM-E and FORM-C?

6058

explain me the relation between torque, frequency,speed,voltage and current in the 3 phase induction motor?

1069

What is meant by positive strand RNA and negative strand RNA?

937

i m selected in AAI JE. my interview is on 25 sept. 2010. i don't hv any idea abt aai interview. can anyone help me, i want to know interview qus of aai. so pls help me... my e-mail id -- mailmanish_kumar@yahoo.co.in

883

How to fetch the last row from the table in SQL (db2)?

201

How do you pick k for K-Means?

4