Oracle General Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General Interview Questions

Questions Answers Views Company eMail

Can you use a commit statement within a database trigger?

4 5458

What WHERE CURRENT OF clause does in a cursor?

2 4235

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,

1949

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

4 5518

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 3855

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 3374

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 3597

how to we delete a row using varray

CTC,

3 4663

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

MasterCard,

2 4368

difference between bind variable and variable

Attra,

1 3103

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

Attra, Metric Stream,

4 7368

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

TCS,

1 3360

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6

TCS,

2 4038

write a query that displays every Friday in a year with date?

Flipkart, HCL, TCS,

5 6528

Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.

TCS,

1785

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Explain index?

1258

What is difference between truncate and delete?

1040

How to work with data objects interactively?

982

What is an oracle cursor variable?

1075

What is a sub query? Describe its types?

1017

How to retrieve values from data fields in record variables?

1113

What is oracle update statement with inner join ?

1059

How does one get the view definition of fixed views/tables?

1021

How to define a cusotmer as a supplier in ORACLE R12

2230

How to rename a column in an existing table?

1035

What is a trigger oracle?

1085

What is the implicit cursor in oracle?

1105

What is the difference between translate and replace in oracle?

1164

what is difference between sql plus and sql*plus? (not sql and sql plus).

3897

What types of joins are used in writing subqueries?

982

For More Un-Answered { Oracle General } Questions Click Here