SQL

1. What is difference between decode and case?

2. How will you delete duplicate records?
3. how will select first 5 records from a table?
4. what are the psedu columns?
5. Difference between delete and truncate?
6. What are the type of constraints?
7. Under which constraints the index will be created?
8. What is the difference between union and union all?
9. How will you fetch nth max salary?
10. Difference between inner join and outer join?

Architecture

1. Explain Oracle architecture?

2. what will happen if you give commit?
[Link] is difference between
    pinned vs dirty buffer
    keep and recycle
4. what is logical and physical structures in database?
5. what are the components in SGA?
6. which process will read data from datafile and put in DBBC?
7. What is instance?
8. name 10 instance level parameters?
9. what are the memory parameters in oracle 10G and 11G?
10. what are the new background parameter in 10G and 11G?
11. what is consistent read, logical read and physical read?
12. what are the logical contents of tablespace?
13. what are the physical structures of database?
14. Is it possible to create a database with no paraments in [Link]?
15. what is difference between LMT and DMT?
16. what are the options for shutdown? explain the difference?
17. Explain the process when you give startup?
18. what is checkpoint?
19. what is instance recovery? Who does it?
20. what is contents of control file?
21. what are the parameters for PGA?
22. Explain the usage of PGA and its working  policy?
23. when will dbwr write into datafile?
24. when will log writer write into log file?
25. what is dead lock? how will you know which sql statement has caused it?
26. what is guarantee retention in undo?
27. what is PCTFREE, PCTUSED?
28. what is free list?
29. What is row chaining and row migration?
30. how will find fragmentation? how will you rectify it and how will you avoid it?
31. what do pmon do ?
32. how will you create a password file?
33. what is use of oerr?
34. explain 1555 error? how will you solve it?
34. I have rollback segment of size 1gb,2gb and 3 gb? if i want to update a 3Gb table data , how will you
do it without getting unable to extend error.
35. explain undo and is use?
36. how will you find database size, table/index size, tablespace size?
37. how will get the script of a table?
38.  What are the types of indexes?
39. Difference between btree and bitmap indexes?
40. what is difference between rebuild and rebuild online?
41. how will you find index fragmentation?

Set -I

[Link] to detach oracle and attach oracle.

[Link] will you remove oracle home from inventory details.
[Link] some tuning parameters.
[Link] is the purpose of exact,similar,force.
[Link] will you apply stdby logs on stdby server. For some reason logs are not applied on stdby db.
[Link] the tablespace is in begin backup mode, will you able to resize the datafile.
[Link] betweeen LMT,DMT. Features of LMT.
[Link] is the purpose of keep cache in SGA.
[Link] will you pin a table to the buffer cache.
[Link] of index.
11. there is a decode function in the where clause, what type of index will you choose.
12. difference between nested loops and hash join.
13. have you installed oracle in silent mode. What are the parameters that should be given in response
file.
14. purpose of commit,buffer in imp
15. Purpose of consistent parameter in exp
16. Some questions on datapump
[Link] between cpu and psu.
[Link] are not moving from primary db to stdby [Link] will you resolve this.
[Link] - forgot the question
[Link] commands.
21. What is Clusterware ?
22. how many IP required for RAC configuration.
[Link] installing RAC, what are the checks that should be performed.
24. The dbbc size is 1 GB, the output of a table is 5 GB. How the data is retrieved from the database.
[Link] ? GRD? name some bg process?.
[Link] of RBAL?
[Link] will you list the disks in asm.
[Link] is the rman command to restore the db to a different filesystem.
[Link] of table_exists_action in dp.
[Link] not complete in alert log file. What could be the issue.
31. Restored the db, need to apply the logs . how will you check whether my db is consistent or not.
[Link] ways of collecting stats for a table. what is the difference between dbms_stats and analyze
table.
33. what is the execution plan. how will you generate execution plan. how will you interpret the plan.
On what basis you will provide the suggestion.
[Link] is AWR.
35.fast_start_mttr_target?
[Link] will you block [Link] ways of identifying the block corruption.
[Link] of #$
38. linux cmd to list the first 5 lines in a file
39. linux cmd to go the first letter in the file.
[Link] cmd to find in linux,solaris,aix (top,topas,sar).
[Link] installing oracle, there are no enough space in /tmp directory. how will you overcome this.
42. purpose of undo_retention, undo_supress_errors.
43. In primary db, one filesystem is added. In stand by db it is not there. Will the logs be applied to the
standby db
44. What is te purpose of FAL_server and fal_client.
45. Wy redos are generated while taking hot backup.
[Link] of resumable parameter in oracle.
[Link] features of 11g.
[Link] will you start crs.