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.
Give an example of VBA?
At the time of sap implementation what are the basic details required by CO guy, SD, MM, and PP guy from a FI guy...?
"OPERATIONAL AMPLIFIERS MODEL" means what and what are the topics comes under these
How can get elongation of 2 k.G aluminium, if elongated aluminium dia is 2.5 mm?
What is S/MIME ?
The present state of recession in the IT Industry – as a Human Resource Manager how are you going to undertake Human Resource Planning to Macro level to tide over the crisis
Do you studied an postgrade?
At what temperature should fresh sweet potato leaves be stored and dried?
What is the order for installing the application, tools, and third party products?
8. How many E1s are supported by one E1 card in BTS
Hi all, I am unable to view TAX details for INDIAN HR/PAYROLL. Please share knowledge in this regard.
Hi, can anyone tell me what is the difference between SYSVOL and NTDS folder in AD? I know SYSVOL is for shared information between Domain controllers, but isn't AD database shared as well? Don't they use the same DB which is stored in NTDS folder? I know SYSVOL size is much smaller than NTDS', but what is it for? Does it contain a part of NTDS folder? If so, what namely? Thanks
I have a process chain is running the infopackage get error don't process the error of that info package and then you can run the dependent variants is it possible?
how to identify np3 pipe and np4 pipe