單項(xiàng)選擇題
A.PRIMARY KEYB.FOREIGN KEYC.ADD CONSTRAINTD.AUTO_INCREMENT
A.2B.4C.8D.16
A.READ UNCOMMITTEDB.READ COMMITTEDC.REPEATABLE READD.SERIALIZABLE
A.默認(rèn)值約束通過(guò)關(guān)鍵字DEFAULT進(jìn)行設(shè)置B.默認(rèn)值約束可以在創(chuàng)建表時(shí)設(shè)置C.默認(rèn)值約束可以在修改數(shù)據(jù)表時(shí)設(shè)置D.通過(guò)ALTER TABLE語(yǔ)句的DROP子句刪除默認(rèn)值約束
A.查詢數(shù)據(jù)的SQL語(yǔ)句中多個(gè)字段名使用分號(hào)分隔B.查詢數(shù)據(jù)的SQL語(yǔ)句必須包含數(shù)據(jù)表的所有字段C.通配符“?”表示查詢數(shù)據(jù)表的所有字段名D.通配符“#”表示查詢數(shù)據(jù)表的所有字段名
A.WHEREB.GROUP BYC.LIMITD.TRUNCATE
A.BEGIN TRANSACTIONB.START TRANSACTIONC.END TRANSACTIOND.STOP TRANSACTION
A.DROPB.ALTERC.DELETED.INDEX
A.PASSWORD EXPIREB.PASSWORD EXPIRE DEFAULTC.PASSWORD EXPIRE NEVERD.PASSWORD EXPIRE INTERVAL 10DAY