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 3352

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 4018

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

CTS, HSBC,

1886

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

Access Info,

1442

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 3274

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

Flipkart, HCL, TCS,

5 6506

How to find locks exists in a table or not?

HCL,

1 3457

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,

1775

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

TCS,

1632

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

TCS,

1599

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

TCS,

1 2685

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

Arrow Electronics,

1 2708

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

Arrow Electronics,

1680

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

CTS,

1747

what is reindexing?

Tata Technologies,

1665

Un-Answered Questions { Oracle }

How to write date and time interval literals in oracle?

1027

What is a snapshot log?

998

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

601

What are object group?

what systems can odi extract and load data into?

582

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

2065

How to create a new view in oracle?

1069

How to loop through data rows in the implicit cursor?

1066

What is difference between co-related sub query and nested sub query?

561

Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?

548

When should an artificial (or derived) primary key be used?

591

How to pass a cursor variable to a procedure?

1098

How to apply filtering criteria at group level in oracle?

1035

what are savepoint mode and cursor mode properties ?

How can you determine the number of sqlnet users logged in to the unix system?

572

For More Un-Answered { Oracle } Questions Click Here