Scribd
Upload
56 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
56 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

OracleArchitectureInterviewQuestions|GeekInterview.

com

[Link]'sdataisstoredintheextentsofitsdata
[Link]'s
datasegment.

SID(SystemIdentifier):ASID(almost)[Link],$ORACLE_HOME,
$ORACLE_SIDand$HOSTNAMEidentifyaninstanceuniquely.TheSIDis64characters,orlessatleaston
Oracle9i.ThesystemidentifierisincludedintheCONNECT_DATApartsoftheconnectdescriptorsina
[Link]...

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

NOTNULLConstraintDisallowsNullsinatable'[Link]
[Link]
[Link]
inarelatedtable'[Link]...

[Link]
[Link]
storesthespecifiedrows.

Nodatafound.

[Link]
[Link]
storesthespecifiedrows.
[Link]'sdataisstoredintheextentsofitsdata
[Link]'s
datasegment.

[Link]
[Link]
storesthespecifiedrows.

You might also like