What is meant by joins? List out the types of joins.
State the various uses of dbcc command?
What is a Private Synonyms ?
What is the function of Optimizer ?
Is a rollback possible to any savepoint?
Can a parameter be passed to a cursor?
Can u make a synonym for deptno=10 only from emp table.
2. Display the item number and total cost for each order line (total cost = no of items X item cost). Name the calculated column TOTAL COST.
I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database
Explain the use of rows option in exp command.
Why is oracle used?
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
What is an Extent ?