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


Oracle Interview Questions
Questions Answers Views Company eMail

There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep

Microsoft,

4 6592

I have two tables : COuntry,city I want all the cities in each country.Question on Cross Join.

Microsoft,

3 5497

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

Microsoft,

1664

I have one table :EID,Depid,ename,sal I want to have max(sal) in each department.

Microsoft, Oracle, TCS,

5 8323

how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group

Verizon,

2 5242

how to get the second max val for every group in a table

Verizon,

6 8066

what is the step for rmanbackup?

 1 3193

write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

Wipro,

11 14460

dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.

 3 4239

how to select second mauximum value in a given table under salary column

Sapient,

6 8213

what are basic modules required to implement oracle application in any oraganisation?

 1818

Define Normalization with example?

 1 4369

what is dynamic SGA and static SGA

Oracle,

3947

sql query to get zero records from a table

CTS,

7 9777

what is integrity constrains?

 3 4935

Un-Answered Questions { Oracle }

What is the difference between a user and a schema in oracle?

667

How can be determining the size of the log files?

332

How to find out what oracle odbc drivers are installed?

674

Explain about achiever in sql?

672

How to omit columns with default values in insert statement in oracle?

661




When do you analyze the tables?

1

What is ELT? Or What is the difference between ODI and other ETL Tools?

393

Describe an oracle table?

668

Difference between open_form and call_form in oracle.

788

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

338

What is confine mode and flex mode?

1

What is enter substitution variable in oracle?

660

What do database buffers contain?

659

What is merge statement used for?

663

How to convert character types to numeric types?

672

For More Un-Answered { Oracle } Questions Click Here