CTS int questions:
1.Temperory tablespace corrupted,how to resolve?If you need
to recover?
2.In tablespace begin backup mode,Its possible to add the
datafile?
3.How to partition the table using Hash partioning,what
happened internally?
4.During rman backup,some files are missing Rman will
continue the backup?
5.what are the errors occurs frequently?
6.which join method is best?why?
7.how to solve deadlock errors?
please reply anyone....
regards
siva
employee table has employee id
-----------
empid
----------------
1
2
3
3
3
4
5
5
5
6
6
6
7
here the values r repeated two times.how to select the
repeated values only.i.e 3,5,6 should alone come.
i have 9 values in a table i.e
-99
-56
-32
41
-2
33
95
-88
55
my question is that i wanna elimenate all -ve values and
wann sum of + values in report
i m using devsuite 10g
its urgent
kindly if anyone knows that answer message me the following
yahoo id
thanx
ALI
smalipaki@yahoo.com
i have one table with accounts and amounts as
colums.accounts with columns c and d. and amounts with
values 1000,2000,3000 for c and 4000,5000,8000 for d.i need
to find the sum of these accounts c and d individually
and find the differences between their sum using one select
statement.
How would you go about increasing the buffer cache hit
ratio?
95
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????
Give the stages of instance startup to a usable state where
normal users may access it.
71
How to enable or disable a row of a table using MySQL in
struts?
56
When installing the datastage7.5x2 edtion iam getting
aproblem i.e the cpu count is 2 but the cpu count in
installation is one . how can i install in my p.c (system
is dual core).
62
how do u compile a form i.e .fmb file in Unix or in dos
HI
THIS IS SHEKAR MY QUTION IS IF I HAD 10 YEARS DATA IN MY
SOURCE THEN I WANT TO LOAD ONLY LAST YEAR DATA HOW IT IS
POSSIBLE BY USING DATASTAGE7.5.
25
i use few third party softwares. they r all having their
own databases .
but the data is repeated in all these databases - say a
person is in all the three databases, but his name is
stoared in diff format in all databases
i want to create a centralised database ,and i dont want to
re-enter the records .
using the exisating records how can i build a centralised
database?
64
What type of index should you use on a fact table?
96
Explain the difference between ARCHIVELOG mode and
NOARCHIVELOG mode and the benefits and disadvantages to
each.
114
did u p prepared complex report
52
i want to know about the javaBean.what is its purpose and
how it can use in Forms.
You have modified 100 store procedures and want to
replicate these changes from development to prodution, and
production can have users using the Server/DB, how would
you replicate without causing issues?
25
hi iam kavya, i completed Oracle11i(finance module), i do
not know how to face the interview questions
please adivese me
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map