manoj kumar


{ City } hyderabad
< Country > india
* Profession *
User No # 11015
Total Questions Posted # 0
Total Answers Posted # 3

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 36
Users Marked my Answers as Wrong # 2
Questions / { manoj kumar }
Questions Answers Category Views Company eMail




Answers / { manoj kumar }

Question { 3479 }

what is bit map and character mode


Answer

if you want to display images,font style,etc you should use
bit map mode.
chatacter mode allows only characters

Is This Answer Correct ?    3 Yes 0 No

Question { PCS, 6893 }

what is place holder column


Answer

Place holder column is a column for which you set the
datatype and value in pl/sql that you difine
you can set the value of a placeholder column in the
following places
1. the before report trigger, if the placeholder is a
report_level column.
2. A report level formula column,if the placeholder is a
report_level column.
3. A formula in the placeholders group or a group below
it(the value is set once for each record of the group)

Is This Answer Correct ?    4 Yes 2 No


Question { HCL, 17966 }

diff between DELETE and TRUNCATE?.


Answer

Delete command is a dml command
truncate command is a ddl command

Delete command has a where clause.
truncate hasn't where clause.

Delete doesn't release memory space(means we can rollback
the deleted rows)
truncate releases memory space(means we can't rollback)

By using synonym we can delete a rows(Delete command).
By using synonym we can't delete a rows(Truncate command).




Is This Answer Correct ?    29 Yes 0 No