Oracle Interview Questions
Questions Answers Views Company eMail

What are various constraints used in SQL?

Polaris,

1 2935

Can cursor variables be stored in PL/SQL tables.If yes how. If not why?

1 3029

Difference between NO DATA FOUND and %NOTFOUND?

1 3663

Can you use a commit statement within a database trigger?

4 3857

What WHERE CURRENT OF clause does in a cursor?

2 3130

i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

Oracle,

1445

which institute and which faculty is providing best training for oracle sql, plsql in hyderabad

4 3993

I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?

Oracle,

1 2328

if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

MasterCard,

1 3095

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

MasterCard,

1 2600

t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.

MasterCard,

2 2677

how to we delete a row using varray

CTC,

3 3288

if i am using dml statement in function. then i am writing select statement what was the output

MasterCard,

2 3227

difference between bind variable and variable

Attra,

1 2314

how to i write the query 'NISHI' TO N I S H I

Attra, Metric Stream,

4 5818


Un-Answered Questions { Oracle }

Which flexfields you have customized?

1


What is data type in oracle?

534


what does the no logging option do? Why would we use it?

258


What is an Oracle Data Block?

607


Why do we need integrity constraints in a database?

560






What are the ways tablespaces can be managed and how do they differ?

1597


How to define a specific record type?

595


if u want to delete all these detail block etc what will happen in form

1450


How to filter out duplications in the returning rows using oracle?

610


Which profile required to access Models in Designer tool?

362


Discuss row chaining, how does it happen? How can you reduce it?

280


How do you run ms_batch file in forms?

1


What is the sql query to find the employee who has Nth maximum salary?

4231


What do you understand by anchoring in reports?

1


Difference between vat and property class.

1