Oracle General Interview Questions
Questions Answers Views Company eMail

How to create DSN..Explain?

Accenture, BeBo Technologies, Infosys,

2 21898

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

BeBo Technologies, Wipro,

7 70307

What are inner join and outer join?

3 11807

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

Amdocs, CSC, TCS,

29 76938

what are Triggers?

TCS,

7 13940

what are stored procedures?

TCS, Wells Fargo,

7 12470

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

Green Info Solutions, TCS,

7 16927

what are views?

TCS,

8 19544

Define 'view' advantage ?

AZTEC, TCS,

2 10410

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

4 11329

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

4 13043

What is a Tablespace?

5 7990

What is SYSTEM tablespace and When is it Created?

2 6295

Explain the relationship among Database, Tablespace and Data file?

4 10950

What is schema?

Bodhi Global Services, Cognizant, HCL,

41 53392


Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to assign query results to variables?

605


Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

659


What is the scope of a local variable?

594


What do you mean by merge in oracle and how can you merge two tables?

539


What is rich query?

556






How do we create privileges in oracle?

601


Explain the function of optimizer in oracle?

614


What is the relation of a user account and a schema?

627


Explain the use of consistent option in exp command.

564


Describe an oracle table?

584


How to create additional tablespaces for an new database?

591


How to do clean up if create database failed?

586


How can I create database in oracle?

581


What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

665


IS it possible to built the oracle database without setting the kernal parameters?

1775