What is scan ip?
How will you dataguard mrp manual apply?
Difference between index and index range scan?
how will you change explain plan stats?
configure normal backup with cold backup.
difference beyween dsa and rsa
cfr asm
1. how many partitions you can have in linux
Ans : 3 primary 1 extended and 59 logical
2. Difference between remote listener and local listener?
Wipro:
1.
How to recover a table with
RMAN backup without affecting other tables?
2.
What happens while giving
startup upgrade?
3.
Diff between AWR and ADDM?
4.
How to increase the whole db
performance with several users?
5.
In dataguard, primary database
has lost some archives, it does not contain backup what will do for stand by
d/b.
6.
In RMAN some archives are
missing, how to recover it ?
7.
What will do for buffer busy
wait?
8.
How will you stop single
instance in RAC environment?
9.
What are the errors you face in
RMAN?
10.
If alert log destination
deleted, thennwat happen?
11.
In AWR report, What all are
shown?
12.
What will happened if redo log
files removed?
13.
What is the difference between
Active and passive nodes?
14.
How to monitor the database in
OS level?
15.
How to check the user's list connected
with database?
16.
How to check the invalid object
list?
17.
What is PMON and SMON? (Wipro
and capgemini)
18.
What is the use of Stats?
19.
How to configure RMAN?
20.
Wat is the maximum performance
mode in Dataguard?
21.
What will happen if temporary
tablespace deleted in OS level?
CAPGEMINI
22.
Export, import and datadump
difference?
23.
block recovery?
24.
Object Recovery?
25.
How to validate object?
26.
Performance tuning?
27.
Shell Scripts?
28.
Uses of O2cb?
29.
Diff between spfile and pfile?
30.
In exp, what does compress y?
31.
Precheck the parameters of
oracle installation
32.
Upgradation
33.
Shared pool
34.
Ckpt
35.
Restore operation
36.
How many database in RAC
environment
37.
How many database you handle?
38.
Database size
39.
Difficult situation
40.
Backup strategy
WIPRO
41.
Export and import
42.
How will you import from server
A to B
43.
What is the parameter to
improve the speech of export
44.
Are you faced any questionable
statistics error in import and export
45.
How will you apply patches
46.
How to check whether the patch
is applied successfully or not
47.
How will you get the trace file
for particular session
48.
What is your team size
49.
When was the company started
50.
When wiil you go for rebuild,
index
51.
How will you rebuild index
52.
How will do the schema refresh
53.
What are allthe issues comes
from end user
TCS
54.
What is dataguardbrocker
55.
Difference b/w spfile and pfile
56.
RAC installation
57.
If any occur means what will
you do?
58.
Architecture
59.
Which file is taken backup by
RMAN.whetherspfile or pfile
60.
What is ckpt
61.
What is lgwr
62.
What is archieve log
63.
What is physical stand by
64.
What is the difference between
logical and physical stand by?
65.
How to resize datafile and table space?
66.
what all are the table spaces
created in fresh db?
67.
what all are the things takes
place in pfile?
68.
what all are the stages of
startup? (no mount,mount,open)
69.
What is Redo log buffer cache?
70.
What is SCN?
71.
weather the logs from primary
to stand by is moved automatically or manually?
72.
what is your current project
and which environment it was run?
73.
what are the pysical files in
database?
74.
Tech mahindra:
75.
How will you check the instance
status in OS level and database level
76.
how will you fill the gaps in
physical
77.
oracledcurrent_scn from
v$database
78.
standby->v$archieve_gap
79.
what are the basic nods of RAC
installation?
80.
what are the basic components
of dataguard?
81.
what is the difference between
logical and physical standby?
82.
what is the fact of oratab
file?
83.
what will do if one node is
failure in RAC?
84.
Data dictionary views for
indentifying gap of archeives in dataguard?
85.
What are the tools used for
dataguard?
86.
What about the backup
strategies and can you golden gole?
87.
Ticketing tools You
recover the table
88.
What is the complexity of
oracle installation on Linux?
89.
How will you backup the OCR
& VP?
90.
How will you recover the lost
table?
91.
What are the parameters needs
to flashback?
92.
What is scan listener? (Single
Client Access Name)
93.
What are the diff b/w max
performance, max availability and max protection?
94.
Why you are going for IIR1
Instead of IIR2?
95.
What is the solution for buffer
busy wait?
96.
What is the diff b/w backup
piece and backup image in RMAN?
97.
What are all the services are run
in RAC?
98.
What is the monitoring tool for
oracle ->OEM?
99.
What are the kernel parameters are used for db
and processor?
100.
Why you are taking OCR &VD backup daily?
101.
What is the error occur in VD backup using dd
command in IIR2?
Wipro:
102.
Row log wait event?
103.
Dbfilescater need?
104.
What will happen if oracle home
reaches 100% -> DB hang for crash issue.
105.
What will happen if archieve
location reaches 100% ->DB Hang?
106.
How will you monitor your
database?
107.
TechMahindra:
108.
What is instance?
109.
What is database?
110.
What is SGA?
111.
What is shared pool?
112.
Compress in exp/imp?
113.
Compress in datapump?
114.
How will you take compressed
export import?
115.
The database has only one table
space of 100gb and have last day night hot back up. The imp table was lost. how
will
116.
how with you find the control file trace in
default location
117.
default location of control
file trace àudump
118.
query tuning
119.
db file sequential read
120.
Index file in export import
121.
how will you do schema refresh
122.
show =y
123.
Snapshot too old error
124.
how will you rectify snapshot
too old user
125.
stat up modes
126.
Fixed valus& variables
values
127.
how is the difference b/w cold
backup & hot backup
128.
what will happen while giving begin backup mode
129.
Weather the transaction will takes place in
datafile at the time of begin backup
130.
How will find the trace in udump
131.
Instance recovery
132.
Installation steps
133.
Cloning Steps
134.
Rmancatalog& no catalog difference
135.
136.
INFOSYS
137.
138.
In arch_dest_location some archives are missed
how will you recover it without backup?
139.
primary database have 4 stand by in that one is
sync well but others stand by db’s or not sync. How will you rectify that?
140.
ora inventory was deleted how will you recover
141.
How will you Apply Patch
