1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


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 2506

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 3206

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

CTS, HSBC,

1370

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

Access Info,

1091

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 2531

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

Flipkart, HCL, TCS,

5 4801

How to find locks exists in a table or not?

HCL,

1 2547

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,

1260

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

TCS,

1136

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

TCS,

1100

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

TCS,

1 1956

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

Arrow Electronics,

1 1903

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

Arrow Electronics,

1221

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

CTS,

1282

what is reindexing?

Tata Technologies,

1179

Un-Answered Questions { Oracle }

Which profile required to access Models in Designer tool?

391

when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1475

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

581

How many data types are supported?

620

What is ole automation?

1




State any two functions of oracle?

636

What is main function of database administrator?

288

How to open and close an explicit cursor in oracle?

577

In oracle forms report, what is the maximum length of record group column? What are the different types of record groups?

812

What is oracle rowcount?

578

How to use "in out" parameter properly?

612

What is the difference between $oracle_base and $oracle_home?

585

How to use "in" parameter properly?

617

Can you convert a bit-mapped report to ASCII (character-mode) Report ? How ?

1859

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

1758

For More Un-Answered { Oracle } Questions Click Here