harsha


{ City } hyderabad
< Country > india
* Profession * oracle
User No # 27022
Total Questions Posted # 0
Total Answers Posted # 9

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

Users Marked my Answers as Correct # 24
Users Marked my Answers as Wrong # 11
Questions / { harsha }
Questions Answers Category Views Company eMail




Answers / { harsha }

Question { 8010 }

What is SAVE POINT ?


Answer

SAVEPOINT is used to locate the transaction for further
manipulations.

Is This Answer Correct ?    1 Yes 2 No

Question { 9027 }

what is the syntax of DELETE command?


Answer

delete from [where ]

Is This Answer Correct ?    4 Yes 2 No


Question { 5214 }

What are triggers?Where are they used?


Answer

A set of PLSQL statements "automatically" executed when DML
statements are performed and stored parmanently in database.


USES:- used to impose user defined restrictions or business
rules on database table

Is This Answer Correct ?    1 Yes 1 No

Question { Thermotech, 9393 }

Tell me New Feature of Oracle 10g?


Answer

1.it is DBA version

2.supports GRID technology.

3.highly improved performance

Is This Answer Correct ?    1 Yes 2 No

Question { Cap Gemini, 7666 }

difference between imlicit cursor and explicit cursor ?


Answer

implicit: it is generating by sql server.

explicit: it is generating by user.

Is This Answer Correct ?    0 Yes 0 No

Question { TCS, 7809 }

What is cursor


Answer

CURSOR is a temporary workspace area used to hold
transaction data.

It is valid in PLSQL only.

It is not stored in database.

It cannot be reuse.

Is This Answer Correct ?    1 Yes 3 No

Question { Oracle, 13450 }

what is null value?


Answer

1.It is undefined and uncomparable value.

2.It is not equal to 0 and SPACE.

3.It will not occupy any MEMORY.

4.It has to be supported by every RDBMS package to have
unique treatment for all data types.

5.Any arithematic operations with null returns a null value.

6.It represents with "NULL" keyword and display a space.

Is This Answer Correct ?    10 Yes 1 No

Question { Mind Tree, 10053 }

what is optional prompt in boxi r2


Answer

Prompts are available in WEBI filters, we have so 6 options
in prompts in that optional promt is one. if we enable
optional prompt, user can select prompts or else he can run
report without selecting the prompts.

Is This Answer Correct ?    2 Yes 0 No

Question { 7601 }

Report have 10000 records,how to restrict the end user to 1000
Records?


Answer

set max rows limit in universe->properties->controls

Is This Answer Correct ?    4 Yes 0 No