|
Question |
Rating |
View Answer |
|
Is it same we set log_archive _start =true or alter system archive log start if u use any one then automatic archive ing start or not ? |
|
View Answer |
|
Why are we not use tablespce begin backup with read only tablespace? |
|
View Answer |
|
Is it possible we can define the path of control file backup by creating a text tarce file default where this is store ? |
|
View Answer |
|
How sga use if i execute select * from emp where empid=111; |
|
View Answer |
|
what type of indexes? |
|
View Answer |
|
How data store in bitmap & btree index what is benefit ? |
|
View Answer |
|
If i create unquie index on empid of employees table which index i create bitmap or btree why ? |
|
View Answer |
|
Which files of unix or linux use or configure in oracle installation ? |
|
View Answer |
|
If a user complaint his query run slow how u detre mine which is reason ? |
|
View Answer |
|
How you implement trace of query when user run query what is syntax ? |
|
View Answer |
|
where is trace file generate & when this is create . |
|
View Answer |
|
I don't set user dump test parameter where trace file default store on linux platform. |
|
View Answer |
|
How you can determine query use full table scan? |
|
View Answer |
|
Your query return 80 % data from table is it we use index or not why ? |
|
View Answer |
|
How we determine index require rebuilding ? |
|
View Answer |
|
How we determine index require rebuilding ? |
|
View Answer |
|
What is row changing how u eliminate ? |
|
View Answer |
|
What is view is it possible to create index on view on view & how ? |
|
View Answer |
|
What is primary & unique key which type index oracle create when we make those key ? |
|
View Answer |
|
If i have primary key this is possible to create another primary key on table. |
|
View Answer |