1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
Oracle General Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 21781

What is the difference between SQL, DDL, and DML?

BeBo Technologies, Wipro,

7 70075

What are inner join and outer join?

 3 11717

What are joins..how many types of joins are there?

Amdocs, CSC, TCS,

29 76497

what are Triggers?

TCS,

7 13776

what are stored procedures?

TCS, Wells Fargo,

7 12296

what are indexes..how many types of index's are there and what are they?

Green Info Solutions, TCS,

7 16790

what are views?

TCS,

8 19358

Define 'view' advantage ?

AZTEC, TCS,

2 10351

What are the components of Physical database structure of Oracle Database?

 4 11237

What are the components of Logical database structure of ORACLE database?

 4 12941

What is a Tablespace?

 5 7893

What is SYSTEM tablespace and When is it Created?

 2 6233

Explain the relationship among Database, Tablespace and Data file?

 4 10879

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 52879

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

1475

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

922

What is different types of joins?

565

How to load a large xml file?

574

Design database draw er diagram for a certain scenario ?

4095




What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

516

How to convert numbers to characters in oracle?

580

How to do clean up if create database failed?

563

How to drop a stored function?

670

Is there an oracle sql query that aggregates multiple rows into one row?

536

How do I connect to oracle database?

529

How to execute a stored procedure in oracle?

612

How to store only time; not date and time?

552

How to execute a stored program unit?

576

What is Java Pool in Oracle?

596

For More Un-Answered { Oracle General } Questions Click Here