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 3360

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 4040

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

CTS, HSBC,

1893

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

Access Info,

1450

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 3288

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

Flipkart, HCL, TCS,

5 6528

How to find locks exists in a table or not?

HCL,

1 3465

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,

1786

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

TCS,

1639

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

TCS,

1603

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

TCS,

1 2694

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

Arrow Electronics,

1 2717

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

Arrow Electronics,

1687

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

CTS,

1749

what is reindexing?

Tata Technologies,

1677

Un-Answered Questions { Oracle }

How to define a record variable to store a table row?

1058

What is a read write transaction in oracle?

1093

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?

2113

Can you create a synonym without having a table?

1042

What is the difference between cold backup and hot backup?

583

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

1971

Explain the term 'oracle grid architecture'?

587

Which dba certification is best?

571

What to do if dba lost the system password?

1172

what are the tools used for oracle 10g in real time.

2441

What does >> do?

586

how can we store any pdf file in oracle

2164

Is there a function to split a string in plsql?

1056

How can you find all the processes on your system?

570

What are the logical operations?

1125

For More Un-Answered { Oracle } Questions Click Here