多項(xiàng)選擇題對于刪除操作以下說法正確的是()

A.drop database數(shù)據(jù)庫名:刪除數(shù)據(jù)庫
B.delete from表名;刪除表中所有記錄條
C.delete from表名where字段名=值;刪除符合條件的記錄條
D.drop table表名;刪除表


您可能感興趣的試卷

你可能感興趣的試題

2.單項(xiàng)選擇題刪除數(shù)據(jù)表中的一條記錄用以下哪一項(xiàng)()

A.DELETED
B.DELETE
C.DROP
D.UPDATE

4.單項(xiàng)選擇題DECIMAL是()數(shù)據(jù)類型

A.可變精度浮點(diǎn)值
B.整數(shù)值
C.雙精度浮點(diǎn)值
D.單精度浮點(diǎn)值

5.單項(xiàng)選擇題統(tǒng)計(jì)每個(gè)部門中人數(shù)()

A.SELECT SUM(ID)FROM EMP GROUP BY DEPTNO;
B.SELECT SUM(ID)FROM EMP ORDER BY DEPTNO;
C.SELECT COUNT(ID)FROM EMP ORDER BY DEPTNO;
D.SELECT COUNT(ID)FROM EMP GROUP BY DEPTNO;