A. CASCADE
B. UNIQUE
C. NONUNIQUE
D. CHECK
E. PRIMARY KEY
F. CONSTANT
G. NOT NULL
第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题:
Youareresponsibleforadatawarehouseapplicationthatusesrecordsfromanexternaltabletoupdateoneofthedimensiontablesperiodically.Therecordsintheexternaltablemaycontaindatafornewrowsinthedimensiontable,orforupdatestoitsexistingrows.WhichtypeofSQLcommandwouldyouusetotransferthedatafromtheexternaltabletothedimensiontableasefficientlyaspossible?()
A.MERGE
B.SELECT…CROSSJOIN
C.INSERTALL…SELECT
D.CREATEVIEW…CONSTRAINT
第3题:
第4题:
A. V$VALID_NLS_VALUES
B. NLS_VALID_VALUES
C. NLS_VALUE_OPTIONS
D. V$NLS_VALUE_OPTIONS
E. V$NLS_VALID_VALUES
第5题:
A.DBMS_STANDARD
B.DBMS_STD
C.DBMS_SQL
D.DBMS_TYPES
第6题:
下列给字符串二维数组进行赋值的语句中,错误的是()。
A.String s[ ] [ ] = new String [ ] [ ] { { “One “ , “ Two “ }, { “ Three “ , “ Four “ } } ;
B.String s[ ] [ ] = { { “ One “ , “Two “},{ “ Three “ , “ Four “ } } ;
C.String s[ ] [ ] = new String [ ] [ ] { { “Zero”} , { “ One ” , “Two” , “ Three” , “ Four” } } ;
D.String s[ 2] [2 ] = { { “ One ” , “Two”},{“ Three” , “ Four” } } ;