单项选择题

YouworkasadatabaseadministratorforSupportcenter.cn.Youenabledtracingwhilecreatingalistenertoyourdatabase.Whatadditionalinformationisavailabletoyouwhenyouenabletracing？（）

A.InformationabouteachOracleNetconnection.
B.InformationabouteachentryintheLinstener.orafile
C.Informationaboutthechangeddoneinthedatabase
D.Informationaboutthedifferentlistenersinyoursystem
E.Informationaboutallthenondatabasefilesrequiredtooperatethedatabase

你可能感兴趣的试题

问答题

Youneedtodesignthestorageoftheloanresponsemessage.Whichactionsoractionsshouldyouperform?（）

A.Usethexmldatatypetostorethemessage.
B.Useauser-defineddatatypetostorethemessage.
C.Usethenvarchar（max）datatypetostorethemessage.
D.Useacheckconstrainttovalidatethatthecorrecttagsareused.
E.UseanXMLschemadefinition（XSD）tovalidatethatthecorrecttagsareused.
F.Useaforeignkeyconstrainttovalidatethatthecorrecttagsareused.

问答题

YouneedtodesigntherestrictionsontheBank.Customerstable.Whichthreeactionsshouldyouperform?（）

A.Designatriggerthatverifiesthatthefirstnamesandsurnamesarenotemptystrings.
B.Designacheckconstraintthatverifiesthatthefirstnamesandsurnamesarenotemptystrings.
C.DesignacheckconstraintthatusesaCLRuser-definedfunctiontoverifythateitherthephonenumberisanullvalueortheformatofthephonenumberisvalid.
D.DesignatriggerthatusesaCLRuser-definedfunctiontoverifythateitherthephonenumberisanullvalueortheformatofthephonenumberisvalid.
E.Designacheckconstraintthatensuresthatthephonenumbercannotbechangedfromavalidformattoanullvalueortoaninvalidformat.
F.Designatriggerthatensuresthatthephonenumbercannotbechangedfromavalidformattoanullvalue.