How to Test Oracle Database

《How to Test Oracle Database》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、HowtoTestOracleDatabasePostedIn

2、DatabaseTestingOracleDatabaseTesting–Thisshallbeoneofthe3partsofOracleDatabasetestingseries.Wewillcoverfollowing3partsinthisdatabasetestingseries:#1)IntroductiontoOracleDatabaseTesting#2)TestingthedatabasewithrespecttoMemory,SpaceandC

3、PUprocessing#3)RealDatabaseApplicationTestingLet’sstartwiththeIntroductiontoOracleDatabaseTesting:Weshallcoverthefollowingtopicsinthispart:1.Whatisadatabase?2.WhyOracle?3.Whytheneedtotestadatabase?4.Howdoyoutestone?#1)Whatisadatabase?Alsoread=>AllaboutDatabasetestin

4、gAdatabaseiscollectionofdatastructuredmethodicallywhichhelpsmanage,manipulateandretrievedataasandwhenrequired.AdatabaseismanagedbymakinguseofdatabasesoftwarenamedtheDatabaseManagementSystem(DBMS)whichprovidesaninterfaceforenduserstoaccessthedatastoredinthedatabase.W

5、eaccess,manipulatethisdatabySQLstatements(StructuredQueryLanguage)whichwasdesignedforthisspecificpurpose.Foralaymanwhoisn’tawareoftheterm“database”considerthis–Wehaveadesktop/laptopassumingmostofushavewindowssoftwareinstalledonit,weopenaMicrosoftexcelsheet,storecoup

6、leofnamesandaddressesofindividuals,saveandcloseit.Thisdataisstoredonyourharddiskofyourdesktop/laptop.Nexttimewewanttolookuptheaddressofapersonwhichwehaveintheexcelsheet,weopenthisexcelsheetandlookitup.Considerthisexcelsheetasthe“database”andthewindowsoperatingsystem

7、asthe“DBMS”softwarewhichknowshowtoaccessandopenthefilesothattherequestedpieceofinformationisavailabletous.TheDBMSsoftwareismuchmorecomplex,evolvedandintegratedandisresponsibleforperformingvarioustasksandactivitiestoensuresmoothfunctioningofthedatabase.#2)WhyOracle?O

8、racleisthecorporationwhichhasbuiltthesoftwaretomanageadatabase.Oracledatabaseisoneofthemostsophisticated,robust,scalable,securedatabasesavailableinthemarketduetotheexquisitefeaturesallbundledandavailabletous.Datainthisdatabaseistermedrelationalduetothefactthatdatais

9、storedandsortedintablesandeachofthesetableshasarelationshipestablishedamongthem.Hencethename-RelationalDatabaseManagementSystem(RDBMS).Rea