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

What are triggers?Where are they used?

 3 5213

What are cursor?where are they used?

 2 5458

Please explain the difference between outer join and inner join? With examples would be appreciable..!

IBM,

6 17167

how can db_files > maxdatafiles since db_files is for instance and the later is for database

CTS,

2168

What are the composite date types in oracle?

HCL,

6 15951

Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table

 3 5276

how to use sequence and what use of sequence cache

 1 3738

what is difference between where clause and having clause?

 13 32901

Hi Every One , What is the table Space in Oracle Database ? waiting for answere and thankyou

 8 9152

what is primary key and foreign key when and where have to use

 5 5847

what is view?

Accenture,

7 8914

how to truncate date and get only time part 9:20:00

 5 8183

what is the output of select * from emp where null=null & select * from emp where 1=1

IMS Health, NIIT,

8 16795

defination of bitmap index

NIIT,

1614

diff between DELETE and TRUNCATE?.

HCL, Yalamanchili Software,

14 17979

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

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

1438

How to define default values for formal parameters?

584

How many memory layers are in the oracle shared pool?

632

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

1498

What is set operator oracle?

516




How to rename an existing table?

603

What is oracle server autotrace in oracle?

601

What is an oracle wallet?

504

What is oracle database 10g express edition?

583

How to create id with auto_increment on oracle?

537

How to export data to a csv file?

612

What is memory advisor in Oracle?

624

Can we call procedure inside function in oracle?

598

How to create a stored procedure in oracle?

567

How would you go about verifying the network name that the local_listener is currently using?

1600

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