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 5465

What WHERE CURRENT OF clause does in a cursor?

2 4237

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 5519

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 3858

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 3599

how to we delete a row using varray

CTC,

3 4668

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 3109

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

Attra, Metric Stream,

4 7369

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 4040

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

Flipkart, HCL, TCS,

5 6529

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,

1786

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

What is an oracle user account?

990

What does sharding mean?

1000

Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?

2221

Explain the use of constraints option in exp command.

1048

What is a proxy class?

1053

How to create a table index?

1151

How to assign query results to variables?

1050

Â What are the oracle DML commands possible through an update strategy?

1063

Can we connect to ORACLE db using Windows Authentication?

1257

How to count duplicated values in a column in oracle?

1041

List the parts of a database trigger.

1050

How do I reset a sequence in oracle?

1098

How to shutdown your 10g xe server from command line?

1086

Does facebook use oracle?

1031

Explain what does a control file contain?

1098

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