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 3365

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 4043

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

CTS, HSBC,

1896

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

Access Info,

1456

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 3298

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

Flipkart, HCL, TCS,

5 6536

How to find locks exists in a table or not?

HCL,

1 3469

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,

1789

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

TCS,

1643

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

TCS,

1607

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

TCS,

1 2697

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

Arrow Electronics,

1 2727

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

Arrow Electronics,

1688

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

CTS,

1755

what is reindexing?

Tata Technologies,

1683

Un-Answered Questions { Oracle }

How to store pictures on to the database?

980

Where in the Oracle directory tree structure are audit traces placed?

2641

What is flashback in Oracle?

1024

Explain what are the advantages of views?

1069

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

2069

Difference between bind parameter and lexical parameter.

Difference between ETL and E_LT?

600

What is a synonym? What are its various types?

1111

What is an oracle cursor variable?

1083

Mention how oracle flex asm works?

Can we connect to ORACLE db using Windows Authentication?

1264

what is the scenario where you take the database to NoArchivelog mode?

2333

How different is ms access and oracle?

1045

Explain the benefits and uses lexical parameter.

What are the various types of snapshots ?

1032

For More Un-Answered { Oracle } Questions Click Here