A. ALTER TABLE table_name ENABLE constraint_name;
B. ALTER TABLE table_name STATUS = ENABLE CONSTRAINT constraint _ name;
C. ALTER TABLE table_name ENABLE CONSTRAINT constraint _ name;
D. ALTER TABLE table_name TURN ON CONSTRAINT constraint _ name;
第1题:
Giventhetwosecurityconstraintsinadeploymentdescriptor:
101.<security-constraint>
102.<!--acorrecturl-patternandhttp-methodgoeshere-->
103.<auth-constraint><role-name>SALES</role-name></auth-.<auth-constraint>
104.<role-name>SALES</role-name>
105.</auth-constraint>
106.</security-constraint>
107.<security-constraint>
108.<!--acorrecturl-patternandhttp-methodgoeshere-->
109.<!--Insertanauth-constrainthere-->
110.</security-constraint>
Ifthetwosecurityconstraintshavethesameurl-patternandhttp-method
whichtwo insertedindependentlyatline109,willallowuserswithrolenamesofeitherSALESorMARKETINGtoaccessthisresource?()
第2题:
A) changes
B) makes
C) sets
D) turns
第3题:
Youareresponsibleforadatawarehouseapplicationthatusesrecordsfromanexternaltabletoupdateoneofthedimensiontablesperiodically.Therecordsintheexternaltablemaycontaindatafornewrowsinthedimensiontable,orforupdatestoitsexistingrows.WhichtypeofSQLcommandwouldyouusetotransferthedatafromtheexternaltabletothedimensiontableasefficientlyaspossible?()
A.MERGE
B.SELECT…CROSSJOIN
C.INSERTALL…SELECT
D.CREATEVIEW…CONSTRAINT
第4题:
GiventhesecurityconstraintinaDD:101.<security-constraint>102.<web-resource-collection>103.<web-resource-name>Foo</web-resource-name>104.<url-pattern>/Bar/Baz/*</url-pattern>105.<http-method>POST</http-method>106.</web-resource-collection>107.<auth-constraint>108.<role-name>DEVELOPER</role-name>109.</auth-constraint>110.</security-constraint>Andgiventhat"MANAGER"isavalidrole-name,whichfouraretrueforthissecurityconstraint?()
A.MANAGERcandoaGETonresourcesinthe/Bar/Bazdirectory.
B.MANAGERcandoaPOSTonanyresourceinthe/Bar/Bazdirectory.
C.MANAGERcandoaTRACEonanyresourceinthe/Bar/Bazdirectory.
D.DEVELOPERcandoaGETonresourcesinthe/Bar/Bazdirectory.
E.DEVELOPERcandoonlyaPOSTonresourcesinthe/Bar/Bazdirectory.
F.DEVELOPERcandoaTRACEonanyresourceinthe/Bar/Bazdirectory.
第5题:
【C9】
A.changes
B.makes
C.sets
D.turns
第6题: