WhichthreetaskscanbeperformedusingregularexpressionsupportinOracleDatabase10g?()
A. itcanbeusedtoconcatenatetwostrings.
B. itcanbeusedtofindoutthetotallengthofthestring.
C. itcanbeusedforstringmanipulationandsearchingoperations.
D. itcanbeusedtoformattheoutputforacolumnorexpressionhavingstringdata.
E. itcanbeusedtofindandreplaceoperationsforacolumnorexpressionhavingstringdata.
Examinethisstatement:RMAN>BACKUPFORMAT’/BACKUP/df_%d_%s_%p.bus1DATABASEfilesperset=2;WhatstatemustthetargetdatabasebeinforyoutousethisRMANcommand?()
A. Thetargetdatabasemustbeopen.
B. Thetargetdatabasemustbeclosed.
C. Thetargetdatabasemustbemounted.
D. Thetargetdatabasemustbemountedoropen.
Whichfilesmustbesynchronizedinorderforadatabasetostart?()
A. tempfiles
B. onlinedatafiles
C. offlinedatafiles
D. readonlydatafiles
YouneedtoimportalldefinitionsofobjectsbelongingtotheTS_EMPLOYEEStablespacebyusingtheexportfileexpdat.dmp.Whichimportstatementiscorrect?()
A. imphr/hrTABLES=(ts_employees)rows=y
B. impsystem/managerFROMUSER=hrfile=expdat.dmp
C. imphr/hrTRANSPORT_TABLESPACE=yfile=expdat.dmp
D. impsystem/managerTRANSPORT_TABLESPACE=yTABLESPACE=ts_employees