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

Oracle General (1803)
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?

600

Explain procedure to change characterset of a database.

683

What is oracle archived redo log?

639

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

604

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

611

List five most important parameter in 9i affecting performance?

610

What is the difference between rman and a traditional hotbackup?

1 1514

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

598

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

617

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

661

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

616

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

637

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

630

How do you install statspack?

725

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

590

Un-Answered Questions { Oracle }

Explain how one can iterate through items and records in a specified block?

1228

How many types of synonyms in Oracle?

1183

What are the variable types?

682

What are the most common interview questions on ETL Testing for experience?

1196

What is tkprof and how is it used?

660

How to delete a user account in oracle?

1026

When you used JKM ?

650

How to see free space of each tablespace?

1084

What is a relational database management system?

1175

How to connect asp pages to oracle servers?

1125

How to create a new view in oracle?

1131

How many types of database software are there?

629

Â How to use an oracle sequence generator in a mapping?

1136

How to call a stored function with parameters?

1098

A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.

652

For More Un-Answered { Oracle } Questions Click Here