《wxh第七章-关系数据库标准语言SQL.ppt

例题 1.SQL语言是（ ）的语言，容易学习 。  A. 过程化  B.非过程化  C.格式化  D.导航式  Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 3.SQL语言集数据查询、数据操纵、数据定义和数据控制功能于一体，其中，CREATE、DROP、ALTER语句是实现哪种功能（ ）。  A.数据查询  B.数据操纵  C.数据定义  D.数据控制  Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 4. SQL语言中，删除一个视图的命令是（ ）。  A.DELETE  B.DROP  C.CLEAR  D.REMOVE  Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 5.在SQL语言中的视图VIEW是数据库的（ ） 。  A.外模式  B.模式  C.内模式  D.存储模式 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 6.下列的SQL语句中，（ ）不是数据定义语句。  A.CREATE TABLE  B.DROP VIEW  C.CREATE VIEW  D.GRANT  GRANT 语句:为现有用户或组授予指定的特权。 Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. 7.若要撤销数据库中已经存在的表S，可用（ ）。  A.DELETE TABLE S  B.DELETE S  C.DROP TABLE S  D.DROP S Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. Evaluation only. Created with Aspose.Slides for .NET 3.5 Client Profile 5.2.0.0. Copyright 2004-2011 Aspose Pty Ltd. NCRE模拟题 SQL的基本命令中，插入数据命令所用到的语句是（ ）。 A.SELECT B.INS