QYSQL各章习题(国外英语资料).doc

QYSQL各章习题 Chapter 1: What platform does 1:SQL SERVER2000 run on? What are the tools of 2:SQL, ENTERPRISE, MANAGER, QUERY, ANALYZER? 3: what is DBA? What is the function of DBA? 4:SQL SERVER2000 installation and notes, what version of SQL SERVER2000 can be installed in WIN98? 5: system database? 6: what is a watch? Records? Field? Second chapters: 1: the creation of the server group and the registration of the SQL SERVER server 2: server startup, pause, stop and significance? 3: what is login? Login creation? Default logon account settings? 4: how do you set manual startup SQL SERVER? 5: display and hide system objects? Third chapters: 1: database storage structure? 2: the composition of the database file? File group? What is the composition of a file group? 3: create a USERS database, the logical name of the database master data file is: USERSBIN, the operating system is USERS.MDF, file size is 4MB, the maximum is not restricted, with the speed of 10% increase; the logical name of the database log file is: USERSLOG, the operating system file name: USERS.LDF that size is: 5MB, maximum is 25MB, with a rate of 1MB increase. 4: use the SQL statement to expand the main file in the USERS database to 40MB, and add a secondary data file: size: 5MB, maximum: 10MB, increase at the speed of 1MB. 5: deletes a secondary data file that has just been created. 6: change the database USERS name to: user database. 7: delete [user database]. 8: database attachment and separation? What are the data types in the 9:T-SQL language? What is the function of the table? 10: if you create a table without specifying fields as [NULL] or [NOT NULL], SQL SERVER, what values do defaults apply? 11: in the [student curriculum database], create the [students professional form] according to the data shown. Field name, data type, null value Student number VARCHAR (9) No. Name VARCHAR (10) No. Age TINYINT can Sex CHAR (2) can The Department where VARCHAR (30) is available The major VARCHAR (40) is OK Ho