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 5293

What WHERE CURRENT OF clause does in a cursor?

2 4084

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,

1898

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

4 5360

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 3760

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 3275

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 3479

how to we delete a row using varray

CTC,

3 4495

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

MasterCard,

2 4257

difference between bind variable and variable

Attra,

1 3003

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

Attra, Metric Stream,

4 7195

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 3285

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 3918

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

Flipkart, HCL, TCS,

5 6284

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,

1700

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to apply filtering criteria at group level in oracle?

989

How to update a table row with a record?

965

Why do you create or replace procedures rather that drop and recreate.

953

How to drop an index?

912

How do I uninstall oracle client from windows?

964

Is insert autocommit in oracle?

1019

How will you differentiate between varchar & varchar2?

994

Explain database link?

1064

How do you bind variables in oracle?

932

What is data type in oracle?

1043

Is oracle a language?

903

What is redo log?

1010

When system tablespace is created?

974

How to rename a column in an existing table?

979

How to get execution path reports on query statements?

931

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