Oracle Interview Question Help Plz ..

[ganesh]

[quote name='jamajacha' timestamp='1335453702' post='1301690916']
nee perey google...nuvu google cheyadam enti ?
[/quote]mahesh joke adirindi gif eskoo

[mtkr]

[quote name='jamajacha' timestamp='1335453599' post='1301690894']
ok OFFICER...google2011 tappu ga teeskunattu undhi nee answer ni
[/quote]
he he tq tq...[img]http://i56.tinypic.com/25kj3tt.gif[/img]

[150bryant]

[quote name='mtkr' timestamp='1335453684' post='1301690912']


he he vastadi le ba.. dnt wrryyyy....
n eadina Q ki thread tadithe paaka ga ne sol untadi ga anduloo....
[/quote]
panchi vachedi gnyanam...
daanikuda panchakapovatam...avivekam

[150bryant]

[quote name='ganesh' timestamp='1335453733' post='1301690927']
mahesh joke adirindi gif eskoo
[/quote]
ladies kadha...andhkey...mb laga acting

[ganesh]

[quote name='jamajacha' timestamp='1335453773' post='1301690935']

ladies kadha...andhkey...mb laga acting
[/quote]hhahaa....ledante jr.ntr ee na

[google2011]

[quote name='jamajacha' timestamp='1335453702' post='1301690916']
nee perey google...nuvu google cheyadam enti ?
[/quote]

automation aa ... QTP antaru kada ???

anni gurtupettukodaniki na brain lo space saripodani .. google create chesi akkada pettina .. ela appudapudu chudataniki
joke esa navvandi ..

[mettastar]

Clustered and non.clustered ki diff enti?
Clustered keys and non clustered keys or indexes???

[google2011]

[quote name='ganesh' timestamp='1335453704' post='1301690917']
mee company o zob sudu ante suttalevu gaa
[/quote]


adendi atla matladtunav ??? typo na leka kavalane kottava ala ??

ma company lona ??? oka 20k PM plz ante.. inka pampaledu .. avi vachinaka na proj lite thiskoni neku ichesta...

[150bryant]

[quote name='google2011' timestamp='1335453826' post='1301690946']
automation aa ... QTP antaru kada ???

anni gurtupettukodaniki na brain lo space saripodani .. google create chesi akkada pettina .. ela appudapudu chudataniki
joke esa navvandi ..
[/quote] QTP,HP-QC, etc etc..anni nerchkodamey...em chesthaam
aada RAJNI kanth vaaa? anni create chesi...ekadoo pettaneeki

[150bryant]

[quote name='ganesh' timestamp='1335453803' post='1301690941']
hhahaa....ledante jr.ntr ee na
[/quote]anthey anthey

[mtkr]

[quote name='jamajacha' timestamp='1335453744' post='1301690929']
panchi vachedi gnyanam...
daanikuda panchakapovatam...avivekam
[/quote]


[img]http://4.bp.blogspot.com/-NAxIHoIZDEs/T1j_AvTITlI/AAAAAAAACCI/2xCrG8P1jZY/s1600/chitikelu-o.gif[/img]

[ganesh]

[quote name='google2011' timestamp='1335453910' post='1301690966']



adendi atla matladtunav ??? typo na leka kavalane kottava ala ??

ma company lona ??? oka 20k PM plz ante.. inka pampaledu .. avi vachinaka na proj lite thiskoni neku ichesta...
[/quote]mari dumps icchinappudu 25k transfer cheyyalsindee....so migilina 5k naku trnsfer cheyyu....anyways maa frnd ki certification vacchindi...nene chesa

[google2011]

[quote name='jamajacha' timestamp='1335453911' post='1301690967']
QTP,HP-QC, etc etc..anni nerchkodamey...em chesthaam
aada RAJNI kanth vaaa? anni create chesi...ekadoo pettaneeki
[/quote]

heheh.. endulo vaste andulo jump aipovadame na ???


performance kuda nercheskondi .. load runner ... pay kuda baguntundi anta. ..

[150bryant]

[quote name='mettastar' timestamp='1335453898' post='1301690964']
Clustered and non.clustered ki diff enti?
Clustered keys and non clustered keys or indexes???
[/quote]
[b]Clustered Indexes[/b]
SQL Server only supports a single clustered index per each database table.
Clustered indexes do not support included columns. This is because clustered indexes contain all the columns which aren’t in the index as included columns already. There is no way to override this. Columns with the data type of TEXT, NTEXT and IMAGE are not included within the clustered index. As with the normal table these values are stored out of bounds and only the pointer to the physical location on disk is stored within the index.
Clustered indexes must be placed within the same file group as the physical table which they are created against.
***Update***
Let me point out that SQL Server won’t throw an error if you try and put the clustered index on another file group. SQL Server will let you do this, however the table will be moved to this file group as well. The Clustered index and the physical table must be in the same file group.
*************
[b]Nonclustered Indexes[/b]
Nonclustered indexes (also called “indexes”) are the normal indexes that are created on your tables. SQL Server supports 999 nonclustered indexes per table.
Each nonclustered index can contain upto 1023 included columns. Columns of the TEXT, NTEXT and IMAGE data types can not be included either.
There are more things that could be put in here, but this will get you a good start. If you think of anything that I’ve missed please feel free to post them below.

http://itknowledgeexchange.techtarget.com/sql-server/back-to-basics-clustered-vs-nonclustered-indexes-whats-the-difference/

[google2011]

[quote name='ganesh' timestamp='1335454012' post='1301690984']
mari dumps icchinappudu 25k transfer cheyyalsindee....so migilina 5k naku trnsfer cheyyu....anyways maa frnd ki certification vacchindi...nene chesa
[/quote]


dumps aa evaru nuvvu

yeah appudu chepinav kada ??? maku kuda jara help cheste memu kuda techukuntam kada ...