Oracle Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Oracle General (1809)
Oracle DBA (Database Administration) (261)
Oracle Call Interface (OCI) (10)
Oracle Architecture (90)

Oracle Interview Questions

Questions Answers Views Company eMail

Which function is used to find the largest integer less than or equal to aspecific value?

527

Explain procedure to change characterset of a database.

573

What is oracle archived redo log?

550

what does the no logging option do? Why would we use it?

520

What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?

519

List five most important parameter in 9i affecting performance?

516

What is the difference between rman and a traditional hotbackup?

1 1374

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

533

You see a wait on lms process in statspack, what does that mean?

531

What does the no logging option do? Why would we be careful of using it?

563

Tell me about standby database? What are some of the configurations of it?

529

When using oracle export/import what character set concerns might come up? How do you handle them?

544

Which date function is used to find the difference between two dates?

534

How do you install statspack?

643

Tell me about standby database? What are some of the configurations of it? What should we watch out for?

519

Un-Answered Questions { Oracle }

What are object group?

how to load the data with one flat file and one rdbms table using joins?

555

How to use "if" statements on multiple conditions?

1119

What are the uses of synonyms?

1093

What types of joins are used in writing subqueries?

943

How to export data to a csv file?

1218

How to retrieve data from an explicit cursor?

1013

What do you mean by a database transaction & what all tcl statements are available in oracle?

936

What are summary column and placeholder column in reports?

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

1987

How do you recover a lost control file?

Where is the multi connections are used in ORACLE DATA INTEGATOR?

596

How can Oracle users be audited?

1065

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

1024

What is pga_aggregate_target?

527

For More Un-Answered { Oracle } Questions Click Here