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 4039

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

CTS, HSBC,

1891

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

Access Info,

1448

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 3287

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 3463

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,

1785

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

TCS,

1638

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

TCS,

1602

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 2715

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

Arrow Electronics,

1686

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

CTS,

1749

what is reindexing?

Tata Technologies,

1675

Un-Answered Questions { Oracle }

What is meant by joins? List out the types of joins.

1030

What are the different pseudo commands? Explain in general?

1080

How to define an anonymous procedure without variables?

1106

What is an index associated with a constraint?

1040

How do I become a dba?

582

Name the three major set of files on disk that compose a database in Oracle?

1123

How to best split csv strings in oracle 9i?

1041

Which database is best to learn?

566

What is bind variable in oracle 11g?

1039

Can we connect to ORACLE db using Windows Authentication?

1256

What is the difference between pre-select and pre-query?

1216

What do you understand by recovery catalog?

567

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

1011

How to create a new table in oracle?

1153

Is there a combination of "like" and "in" in sql?

1065

For More Un-Answered { Oracle } Questions Click Here