Oracle General Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Infosys, BeBo Technologies, Accenture,

2 16433

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

Wipro, BeBo Technologies,

7 61594

What are inner join and outer join?

3 8444




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

CSC, TCS, Amdocs,

29 61859

what are Triggers?

TCS,

5 8537

what are stored procedures?

TCS,

6 6880

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

TCS, Green Info Solutions,

7 11889

what are views?

TCS,

7 13398




Define 'view' advantage ?

TCS, AZTEC,

2 8473

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

4 8169

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

4 10003

What is a Tablespace?

5 5015

What is SYSTEM tablespace and When is it Created?

2 4575

Explain the relationship among Database, Tablespace and Data file?

4 7502

What is schema?

Cognizant, HCL, Bodhi Global Services,

41 37870


Post New Oracle General Questions






Un-Answered Questions { Oracle General }

what happened to the global index when I truncate the data in one of the partition?

830


Whats the benefit of dbms_stats over analyze?

784


In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

1193


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

743


What is the recommended interval at which to run statspack snapshots, and why?

1614






can u plz provide me oca sql dumps please i need them

752


I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

871


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1079


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?

256


An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

934


In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.

786


What is integrity and what is constraint??Explain with example

978


nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

964


ABOUT IDENTITY?

808


can anyody please send me the dump for Oracle 10g certifications for DBA path?

984