I have done oracle 10g. I need a project knowledge. So if u
please send a project how it should be done,Or you can send
email link. I will be very grateful to u.
suppose we have a table in which 200 rows. i want to find
101 row ? what the query....
and how we find 4th and 5th highest salary and 1 to 10
highest salary
How would you go about increasing the buffer cache hit
ratio?
0. Explain the difference between a hot backup and a cold
backup and the benefits associated with each
1. You have just had to restore from backup and do not have
any control files. How would you go about bringing up this
database?
2. How do you switch from an init.ora file to a spfile?
3. Explain the difference between a data block, an extent
and a segment.
4. Give two examples of how you might determine the
structure of the table DEPT.
5. Where would you look for errors from the database engine?
6. Compare and contrast TRUNCATE and DELETE for a table.
7. Give the reasoning behind using an index.
8. Give the two types of tables involved in producing a star
schema and the type of data they hold.
9. What type of index should you use on a fact table?
10. Give two examples of referential integrity constraints.
11. A table is classified as a parent table and you want to
drop and re-create it. How would you do this without
affecting the children tables?
12. Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to
each.
13. What command would you use to create a backup control
file?
14. Give the stages of instance startup to a usable state
where normal users may access it.
15. What column differentiates the V$ views to the GV$ views
and how?
16. How would you go about generating an EXPLAIN plan?
I have done oracle 10g. I need a project knowledge. So if u
please send a project how it should be done,Or you can send
email link. I will be very grateful to u.
3
after tell procedure whole code he asked can i write the
same way in a function
135
GLOBAL TEMPORARY TABLE over Views in advantages insolving
mutating error?
How would you go about increasing the buffer cache hit
ratio?
0. Explain the difference between a hot backup and a cold
backup and the benefits associated with each
1. You have just had to restore from backup and do not have
any control files. How would you go about bringing up this
database?
2. How do you switch from an init.ora file to a spfile?
3. Explain the difference between a data block, an extent
and a segment.
4. Give two examples of how you might determine the
structure of the table DEPT.
5. Where would you look for errors from the database engine?
6. Compare and contrast TRUNCATE and DELETE for a table.
7. Give the reasoning behind using an index.
8. Give the two types of tables involved in producing a star
schema and the type of data they hold.
9. What type of index should you use on a fact table?
10. Give two examples of referential integrity constraints.
11. A table is classified as a parent table and you want to
drop and re-create it. How would you do this without
affecting the children tables?
12. Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to
each.
13. What command would you use to create a backup control
file?
14. Give the stages of instance startup to a usable state
where normal users may access it.
15. What column differentiates the V$ views to the GV$ views
and how?
16. How would you go about generating an EXPLAIN plan?
38
How consistent is the view of the data between and within
multiple sessions, transactions or statements ?
95
Does it possible to pass object (or) table as an argument
to a remote procedure?
hello.....
i am an comp science engineering graduate planning to do
ORACLE certification in PLSQL 9i. just wanted to know whats
the possibility getting job is their openings???? is it
worth doin that course n certification
42
What is the difference between SQL Constraint and PL/SQL
constraint.Pls give all the constraint name.
1. is it possible to use the cursor atttibutes (%found ,%
rowcount , %isopen , %notfound ) to our user defined cursor
names .......
cursor cursor_name is select * from scott.emp
if you use...
cursor_name%found , %rowcount ,%isopen,%notfound...will it
work...
--------------------------
2.what is the difference between the varray and index by
table ..
--------
3.
type type_name is table of number(8,3)
index by binary_integer;
identifier_name type_name;
first , last , prior , next ,trim are the methods we can
use it for the above type...simillary is there any way to
apply for cursors...
with thanks and regards..sarao...
a table has 2 classifications
1)liabilities
2)earnings
this liabitity has 2 elements with 2 input values
and
the earnings have 2 elements with 2 input values
i wrote a query so that my input is
liability savings amount1 amount2
xxxx null xxxxxx 0
xxx1 null xxxxx1 0
null yyyy 0 yyyy
null yyy1 0 yyy1
my problem is
--when i developed a report(d2k) with this data
my o/p is
liabilities,amount1,savings,amount2
xxxx xxxxxx
xxx1 xxxxx1
yyyy yyyy
yyy1 yyy1
how could i move this savings,savings values 2 palces up.
can any body provide me witha better solution
If i can use sys.check_constraints to display my constraints
from my database using sql server 2005, how can i display
then if i am using sql server 2000????