Explain oracle’s system global area (sga).
No Answer is Posted For this Question
Be the First to Post Answer
What happens to the current transaction if the session is killed?
how to see the data (in unix) using dataset in datastage?
How to define a data field as not null?
what is normalisation?what are its uses?
What is Private Database Link ?
Is java required for oracle client?
Query to get max and second max in oracle in one query ?
34 Answers CTS, Keane India Ltd, TCS, Wipro,
12 RULES OF RDBMS
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.
What is the maximum limit on the number of columns in a table?
How many memory layers are in the oracle shared pool?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?