sql考试题(国外英语资料).docVIP

sql考试题(国外英语资料) SQL Server 2000 questions 1, choice (2 points, 40 points) () is a layer of data management software between the user and the operating system. The database is managed and controlled by unified management when it is established, used and maintained. B C.D B C.D In the following systems, you can delete () A. master, tempdb C. pubs, Northwind d. Northwind, tempdb for Which database is not SQL Server 2000s system database () A database of B.m SDB database, D.m odel database The SQL language allows for string matching using wildcards, where % can be represented (). A, zero character B, one character C, multiple characters D, all of these can be In the transact-sql syntax, the full syntax of the SELECT statement is more complex, but at least the part (). Use keywords () to block duplicate rows. A, SELECT, INTO B, SELECT, FROM C, SELECT, GROUP D, SELECT only A, DISTINCT B, UNION C, ALL C, TOP Use the query analyzer to (). A, directly execute the SQL statement B, and submit the SQL statement to the server C, used as a service manager, as a business manager The default extension of the transaction log file is (). A, MDF B, NDF C, LDF D, DBF The main database for SQL Server is (). A, MASTER B, TEMPDB C, MODEL D, MSDB The capacity of the database (). A, can only specify the fixed size. B, a minimum of 10 m C, the maximum 100 m. You can set it to automatic growth The length of datetime data type (datetime) is (). A, 2, B, 4, C, 8, D, 16 Tables are a very important data object in the database, which is used for () various data content. A, display B, query C, store D, retrieve All the system-level information in the SQL Server system is stored in which database (). By Martin C.t empdb d.m.sdb Which of the following constraints is not null? (a) A. key b. foreign key c. default d. UNIQUE In the SQL2000 statement, the following correct Where word is () if all au_id in the query table record satisfies the record of the first two letters 88. Where au_id = 88%. Where au_