Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1803)
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 3443

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 4140

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

CTS, HSBC,

1947

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

Access Info,

1509

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 3358

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

Flipkart, HCL, TCS,

5 6719

How to find locks exists in a table or not?

HCL,

1 3544

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,

1838

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

TCS,

1688

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

TCS,

1657

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

TCS,

1 2776

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

Arrow Electronics,

1 2809

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

Arrow Electronics,

1733

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

CTS,

1808

what is reindexing?

Tata Technologies,

1736

Un-Answered Questions { Oracle }

Explain an index?

1182

How do you set up your tablespace on installation level: low?

602

What is a matrix report and how many minimum groups are required to prepare the same?

1208

What is an oracle tablespace?

1098

How to initialize variables with default values?

1310

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

1362

What do you mean by cdb and pdb in oracle 12c?

1112

What happens if the imported table already exists?

1081

What is an oracle function?

1246

What are the most common interview questions on ETL Testing for experience?

1196

How do I manually uninstall oracle client?

1157

How do you find current date and time in oracle?

1106

State some uses of redo log files?

1070

can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2441

How to calculate the approximate size of the SGA based on the size of the block,shared_pool,redo_buffer_cache and db_buffer_cache?

2764

For More Un-Answered { Oracle } Questions Click Here