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.
No Answer is Posted For this Question
Be the First to Post Answer
What will be maximum output current of a 30KVA isolation Transformer?
I went to Germany for my masters and stayed there for 1.5 months. Due to personal reasons I came back to india and I want to apply for student visa for USA..will there be any issues?
What is the purpose of using data modem.
The magnitude of the gain or integrator transfer function using op-amp is A WR1Cf B -1/WR1Cf C -WR1Cf D 1/WR1Cf
i need supervisor exam model qustion paper
What is the power capacity of nuclear power plant used in nuclear submarrine?
Describe the principle of step-up chopper. Derive an expression for the average output voltage in terms of input dc voltage & duty cycle?
Define voltage controller?
Can a transistor be obtained by connecting tow semiconductor diodes back-to-back?
Name one microprocessor that works in the same way as that of intel 8085 but of another company.
HI..!! I THINK THIS SITE IS AN EXCELLENT SOURCE FOR YOUNG ENGINEERS, I READ THE POSTS REGARDING DIFFERENT PLACEMENT PAPERS IT WAS INDEED HELPUFL...BUT FRM WHR CAN I GET THE WHOLE APTITUTE PAPER FOR REFERENCE??
I am working in a private software firm for past two years and now i want to switch to electronics company ... if they ask me ==>what I was doing for the past two years what would the appropriate answer to this ... please reply !