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

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

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 3295

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 3932

Teradata: How can we know the indexed column in a table?

CTS, HSBC,

1853

HI Friends I m new dev(forms & report). can anyone tell me how we upload a document on form 11g.??

Access Info,

1416

how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.

Alshaya,

1 3204

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

Flipkart, HCL, TCS,

5 6311

How to find locks exists in a table or not?

HCL,

1 3382

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,

1717

What the is the diff between local index and global index. give some example.

TCS,

1595

What is snapshot is too old? Give and example for better understand.

TCS,

1550

Can u make a synonym for deptno=10 only from emp table.

TCS,

1 2614

what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?

Arrow Electronics,

1 2649

how to do daily transactions with out sql* loader control file regesterd in apps?

Arrow Electronics,

1644

1) Does oracle have any table which contain all the exceptions and it's code internally?

CTS,

1712

what is reindexing?

Tata Technologies,

1618

Un-Answered Questions { Oracle }

What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable

1145

query optmization techniques and quwry analyser+projects+ppts

2378

What is meant by joins? List out the types of joins.

969

What is an Oracle SYSTEM tablespace and when is it Created?

1074

How to create a testing table in oracle?

952

I have applied the following commands: now what will happen, will the database will give an error / it will work?

517

What is the load plans? And how to create for the load plans?

623

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

1114

What is the difference between count (*), count (expression), count (distinct expression)?

968

Can a View based on another View in Oracle?

991

where the dff data will be stored

2358

What are the differences between blob and clob in oracle?

1039

How to speed up webrick?

1014

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

2007

How to write text literals in oracle?

1028

For More Un-Answered { Oracle } Questions Click Here