SQL基础测试题（SQL base test questions）.doc

SQL基础测试题（SQL base test questions） 1. Selection 1. Which paradigm is not the paradigm in the relationship model (C) A, first paradigm B. Second normal form C. Van der monde paradigm D, BCNF paradigm 2. SQL Server 2000 does not contain any of the following versions (B) A, SQL Server 2000 Enterprise Edition (Enterprise Edition) B, SQL Server 2000 Professional Edition standard Edition C, SQL Server 2000 Personal Edition (Personal Edition) D, SQL Server 2000 development Edition (Developer Edition) 3. Which of the following does not belong to the components of the t-sql language (B) A, data definition language (DDL) Data Definition Language (DDL) is a Language that is responsible for the Definition of Data structures and database objects in SQL Language, consisting of the three grammars of CREATE, ALTER and DROP, B. Data query language (DFL) C. Data manipulation language (DML) DML (Data Manipulation Language), which enables users to implement basic database operations. For example, INSERT, DELETE, and modify INSERT, UPDATE, and DELETE for the data in the table D. Data control language (DCL) Data control language (DCL) is a statement used to set or change a database user or role permission, such as GRANT, DENY, REVOKE, etc 4. Which of the following is not the system data type (C) of the SQL Server database? A, int, smallint B, char, varchar C, String, char D, datetime, int 5. The following description of variables in SQL Server database is incorrect (C) A, the variables in SQL Server can be divided into global variables and local variables. B, global variables are provided by the system and are declared in advance, and are distinguished from local variables by adding two @ symbols to the name. C, do not assign values to variables without a SELECT statement D, DECLARE local variables using DECLARE statements in batch or stored procedures The following program results in (B) DECLARE @var1 int, @var2 int The SET @ var1 = 200 The SET @ var2 = 100 IF @ var1 @ var2 PRINT is wor