Interested to Buy Any Domain ? << Click Here >> for more details...
What statistic will tell the DBA how must space can be
reclaimed from dropped table spaces on the next reorg run?
- 1 Answers
- 4299 Views
- I also Faced
- E-Mail Answers
Answer / guest
The question should be how much space can be reclaimed from
dropped tables, that would be PERCDROP from
SYSIBM.SYSTABLEPART
| Is This Answer Correct ? | 0 Yes | 0 No |
what is cursor stability?
we can code COPY DCLGEN or INCLUDE DCLGEN, At which stage of the precompilation , dclgen get expanded if we write 1) copy 2) include one question about dclgen.. Is it mandatory to use declare table in dclgen.. I think no...but it will be used by the precompiler to validate the table name,column name etc.., can one clear my doubt ..is it necessary to include declare table or not?
How to rename a table in DB2 ?
how to identify the pseudo conversation by seeing the program
What is a clustered index?
What is filter factor?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .
What is db2 isolation?
i have an employment table whch has salary,dept,name? i want salary b/w 1000 to 5000 can anyone pls say the query for ths ?
8 Answers Cap Gemini, CGI, EDS, IBM, Satyam, Wipro,
List down the types of triggers in the db2 database?
What if we fail to give values in columns declared as NOT NULL ?
COBOL 
