Oracle General Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 21677

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

BeBo Technologies, Wipro,

7 69929

What are inner join and outer join?

3 11652

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

Amdocs, CSC, TCS,

29 76241

what are Triggers?

TCS,

7 13673

what are stored procedures?

TCS, Wells Fargo,

7 12140

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

Green Info Solutions, TCS,

7 16692

what are views?

TCS,

8 19222

Define 'view' advantage ?

AZTEC, TCS,

2 10312

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

4 11203

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

4 12888

What is a Tablespace?

5 7842

What is SYSTEM tablespace and When is it Created?

2 6197

Explain the relationship among Database, Tablespace and Data file?

4 10836

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 52653


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

Why do you create or replace procedures rather that drop and recreate.

518


Can objects of the same schema reside in different tablespace?

567


What are the advantages of oracle 12c?

527


What are the ansi data types supported in oracle?

496


How to increment dates by 1 in oracle?

540






What is oracle host variable?

518


What is null value in oracle?

607


What is the use of aggregate functions in oracle?

556


How to find the duplicate rows count from employees table in oracle?

522


How to define a data field as not null?

608


What is partitioned table in Oracle?

608


How to use existing values in update statements using oracle?

520


I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.

1676


What are the differences between primary key and unique key?

487


How to do a full database export?

610