1. Categories >> Software >> Databases >> Oracle
  2. Suggest New Category


Oracle Interview Questions
Questions Answers Views Company eMail

How to import one table back from a dump file?

 585

How to start your 10g xe server from command line?

 544

How to invoke the data pump export utility?

 555

How to define an anonymous block?

 612

How to list all tables in your schema?

 603

How to use "in out" parameter properly?

 610

How to use windows user to connect to the server?

 530

How to execute a stored program unit?

 578

How to load data from external tables to regular tables?

 533

What happens to the current transaction if a ddl statement is executed?

 571

How to drop a tablespace?

 565

How to retrieve the count of updated rows?

 568

What happens to the indexes if a table is recovered?

 572

How to get execution path reports on query statements?

 554

How to add another datafile to a tablespace?

 573

Un-Answered Questions { Oracle }

How oracle flex asm works?

1

How can we delete duplicate rows in a table?

559

Explain what are synonyms used for?

600

What is a user role in oracle?

613

How can you tell if an index on particular table is used or not used in 9i?

271




How do I find the database name in oracle?

599

Name the different triggers supported by oracle reports and their firing order.

586

What is CKM and when we will use this CKM?

297

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.

1500

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1874

What are the different windows events activated at runtime ?

2408

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

545

Explain how are indexes update?

619

What are record groups ? Explain the types of record group.

1

What is the difference between a user and a schema in oracle?

556

For More Un-Answered { Oracle } Questions Click Here