adspace


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


Oracle Interview Questions
Questions Answers Views Company eMail

Explain the wait events in statspack report 'db sequential real'?

 1 733

Explain the wait events in statspack report 'db scattered read'?

 1 672

What is your favorite tool for day-to-day oracle operation?

 1 640

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

 1 643

What is difference between co-related sub query and nested sub query?

 1 660

What is oracle full backup?

 1 662

What is pga_aggregate_target?

 1 677

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.

 1 696

What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?

 1 721

If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?

 1 680

Tell me about standby database? What should we watch out for?

 1 624

What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

 1 729

Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?

 1 737

What are the steps involved in instance recovery in oracle?

 1 638

What is oracle log switch?

 1 713

Un-Answered Questions { Oracle }

Are you familiar with user exits in reports?

72

How to use values from other tables in update statements using oracle?

1173

Have you used lexical parameters in reports?

57

How to select all columns of all rows from a table in oracle?

1149

what ASIS BUSINESS PROCESS IN ORACLE FINANCE

2372

in user parameter property we have list of values.can we write select query for binding? for example:: select empno from emp where deptno=:deptnum :deptnum is first parameter it displays distinct dept nos. if i do like this it is giving error:: bind variables are not allowed in the select statement

2227

please send me oracle pl/sql exp resume. and also faqs...

2588

How to write a left outer join with the where clause in oracle?

1164

Have you created fact table and dimension tables?

725

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1967

How many concurrent programs you have customized, can you name some of them?

51

How to start an oracle instance?

1111

Were you involved in any data conversion, which one?

78

How to put more than 1000 values into an oracle in clause?

1125

What is oracle latest version?

1185

For More Un-Answered { Oracle } Questions Click Here