[go: up one dir, main page]
Scribd
Upload
55 views2 pages

Oracle Architecture Interview Questions

The document outlines key concepts related to Oracle architecture, including the structure of data segments for non-clustered and clustered tables. It explains the significance of the System Identifier (SID) and various constraints such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK. Additionally, it discusses the advantages of hash clusters for tables frequently queried with equality queries.

Uploaded by

Cherrie Ann Bautista Domingo-Dillera
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
55 views2 pages

Oracle Architecture Interview Questions

The document outlines key concepts related to Oracle architecture, including the structure of data segments for non-clustered and clustered tables. It explains the significance of the System Identifier (SID) and various constraints such as NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, and CHECK. Additionally, it discusses the advantages of hash clusters for tables frequently queried with equality queries.

Uploaded by

Cherrie Ann Bautista Domingo-Dillera
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

OracleArchitectureInterviewQuestions|GeekInterview.

com

EachNonclusteredtablehasadatasegment.Allofthetable'sdataisstoredintheextentsofitsdata
segment.Eachclusterhasadatasegment.Thedataofeverytableintheclusterisstoredinthecluster's
datasegment.

SID(SystemIdentifier):ASID(almost)uniquelyidentifiesaninstance.Actually,$ORACLE_HOME,
$ORACLE_SIDand$HOSTNAMEidentifyaninstanceuniquely.TheSIDis64characters,orlessatleaston
Oracle9i.ThesystemidentifierisincludedintheCONNECT_DATApartsoftheconnectdescriptorsina
tnsnames.orafile.TheSIDdefaultstothedatabasename.GlobalDatabaseName...

Aruledefinedonacolumn(orsetofcolumns)inonetablethatallowstheinsertorupdateofarowonlyif
thevalueforthecolumnorsetofcolumns(thedependentvalue)matchesavalueinacolumnofarelated
table(thereferencedvalue).Italsospecifiesthetypeofdatamanipulationallowedonreferenceddataand
theactiontobeperformedondependentdataasaresultofanyactiononreferenced...

NOTNULLConstraintDisallowsNullsinatable'scolumn.UNIQUEConstraintDisallowsduplicatevaluesin
acolumnorsetofcolumns.PRIMARYKEYConstraintDisallowsduplicatevaluesandNullsinacolumnor
setofcolumns.FOREIGNKEYConstrainRequireeachvalueinacolumnorsetofcolumnsmatchavalue
inarelatedtable'sUNIQUEorPRIMARYKEY.CHECKConstraintDisallowsvaluesthatdo...

Hashclustersarebetterchoicewhenatableisoftenqueriedwithequalityqueries.Forsuchqueriesthe
specifiedclusterkeyvalueishashed.Theresultinghashkeyvaluepointsdirectlytotheareaondiskthat
storesthespecifiedrows.

Nodatafound.

Hashclustersarebetterchoicewhenatableisoftenqueriedwithequalityqueries.Forsuchqueriesthe
specifiedclusterkeyvalueishashed.Theresultinghashkeyvaluepointsdirectlytotheareaondiskthat
storesthespecifiedrows.
EachNonclusteredtablehasadatasegment.Allofthetable'sdataisstoredintheextentsofitsdata
segment.Eachclusterhasadatasegment.Thedataofeverytableintheclusterisstoredinthecluster's
datasegment.

Hashclustersarebetterchoicewhenatableisoftenqueriedwithequalityqueries.Forsuchqueriesthe
specifiedclusterkeyvalueishashed.Theresultinghashkeyvaluepointsdirectlytotheareaondiskthat
storesthespecifiedrows.

You might also like