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 2484

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 3190

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

CTS, HSBC,

1362

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

Access Info,

1085

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 2513

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

Flipkart, HCL, TCS,

5 4787

How to find locks exists in a table or not?

HCL,

1 2531

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,

1250

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

TCS,

1126

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

TCS,

1089

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

TCS,

1 1947

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

Arrow Electronics,

1 1877

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

Arrow Electronics,

1216

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

CTS,

1276

what is reindexing?

Tata Technologies,

1168

Un-Answered Questions { Oracle }

What is variable? What is Flow of variable?

294

What do you understand by the term 'normalization'?

282

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1480

What are the constraints in odi?

317

List out the types of joins.

585




What are the different types of database objects?

520

In the oracle version 9.3.0.5.0, what does each number shows?

739

What are the different oracle database objects?

579

Explain odi architecture?

292

What is a junior dba?

285

How to write an inner join with the where clause in oracle?

575

What is a nested table?

626

what is the difference between functional dependecy and multilevel dependency?

1985

What are the major difference between truncate and delete?

513

How a database is related to tablespaces?

574

For More Un-Answered { Oracle } Questions Click Here