|
发信人: reynolds(雷龙.DBA中) 整理人: reynolds(2002-03-11 12:45:36), 站内信件 |
| 91. You are the administrator of a SQL Server 2000 computer. One of these servers contains a 4-GB database named Marketing. You want to remove the Marketing database from one server and add it to the other as quickly as possible. What should you do?
A. Detach the database from the original server by using the sp_detach_db stored procedure. Copy the database and the transaction log files to the new server, and attach them by using the sp_attach_db stored procedure. B. Use the DTS Export Wizard to transfer all database objects from the original server to the new server. Drop the existing database from the original server. C. Run a full backup of the database on the original server. Create a new database named Marketing on the new server. Restore the backup in the new Marketing database. Drop the database from the original server. D. Shut down the original server. Copy the database and the transaction log files to the new server. Use the DISK INIT and DISK REFIT statements to attach the data file to the new server. Drop the database from the original server. Answer: A Reason: 需要补充吗？不需要吧？^_^ 92. You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. In this database, the Parts table has a primary key that is used to identify each part stored in the company's warehouse. Each part has a unique UPC code that your company's accounting department uses to identify it. The database is configured as shown below: See http://www.cheet-sheets.com/228/image17.jpg 
You want to maintain the referential integrity between the Parts table and the OrderDetails table. You want to minimize the amount of physical I/O that is used within the database. Which two Transact-SQL statements should you execute? (Each correct answer represents part of the solution. Choose two.) A. CREATE UNIQUE INDEX IX_UPC On Parts(UPC) B. CREATE UNIQUE INDEX IX_UPC On OrderDetails(UPC) C. CREATE TRIGGER UPCRI On OrderDetails FOR INSERT, UPDATE As If Not Exists (Select UPC From Parts Where Parts.UPC = inserted.UPC) BEGIN ROLLBACK TRAN END D. CREATE TRIGGER UPCRI On Parts FOR INSERT, UPDATE As If Not Exists (Select UPC From Parts Where OrderDetails.UPC = inserted.UPC) BEGIN ROLLBACK TRAN END E. ALTER TABLE dbo.OrderDetails ADD CONSTRAINT FK_OrderDetails_Parts FOREIGN KEY(UPC) REFERENCES dbo.Parts(UPC) F. ALTER TABLE dbo.Parts ADD CONSTRAINT FK_Parts_OrderDetails FOREIGN KEY (UPC) REFERENCES dbo.Parts(UPC) Answer: A E Reason: 详细资料请翻阅主键、外键相关资料。关系型数据库在建立数据模型初期就必须仔细考虑这些问题，这是必需的基础工作。 ====================================================================== 外键 (FK) (foreign key (FK)) 列或列的组合，其值与同一个表或另一个表中的主键 (PK) 或唯一键相匹配。也称作参照键。 主键 (PK) (primary key (PK)) 唯一标识表中的所有行的一个列或一组列。主键不允许空值。不能存在具有相同的主键值的两个行，因此主键值总是唯一标识单个行。表中可以有不止一个键唯一标识行，每个键都称作候选键。只有一个候选键可以选作表的主键，所有其它候选键称作备用键。尽管表不要求具有主键，但定义主键是很好的做法。 在规范化的表中，每行中的所有数据值都完全依赖于主键。例如，在以 EmployeeID 作为主键的规范化的 employee 表中，所有列都应包含与某个特定职员相关的数据。该表不具有 DepartmentName 列，因为部门的名称依赖于部门 ID，而不是职员 ID。 ====================================================================== 93. You are the administrator of a SQL Server 2000 computer named SQL1. You want to perform ad hoc distributed queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation. You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead. How should you configure SQL1? A. Use the ALTER DATABASE statement to change the collation of the database SQL1. B. Add SQL2 as a remote server. C. Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name. D. Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2. Answer: C Reason: 前面有一样的题目。 94. You are the administrator of a SQL Server 2000 computer. The server contains seven databases that provide data to several company client/server applications. A different user maintains each database. You need to configure server and database permissions so that each user who maintains a database has full permissions on that database. What should you do? A. Create a domain user group for all users. Add a login for the domain user group. Add the login to the sysadmin server role. B. Create a domain user group for all users. Add a login for the domain user group. Map the login to a database user in each database. Add all database users to the db_owner database role in each database. C. Create a login for each user's domain user account. Map each login to a database user in the appropriate databases. Add the database users to the db_owner database role in each database. D. Create a login for each user's domain user account. Add the logins to the dbcreator server role. Answer: C Reason: A显然分配了过高的权限，B也不符合题意，怎么能把所有的用户都添加到db_owner来面，D也是不妥当的。详细请参考数据库角色章节。 95. You are the administrator of a SQL Server 2000 computer. The server contains a Data Transformation Services (DTS) package that queries multiple databases and writes the results to a text file. You run this package by using a Microsoft Windows batch file. The batch file uses the dtsrun utility to execute the DTS package. You want to ensure that connection properties, such as login names and passwords, cannot be read or modified by users. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.) A. Save the DTS package so that it has an owner password. B. Save the DTS package so that it has an user password. C. Encrypt the DTS package details in the command line of the dtsrun utility. D. Store the DTS package in the Meta Data Services repository. E. Store the DTS package as a Microsoft Visual Basic file. Answer: A C Reason: DTSRUN的 /!Y 和 /Z 参数用于加密。 ---- / <>< o /| / <>< (o / |/| ) ) <@ < ( O )( \ |\| <>< ) <>< () \| \ \ 每天在网易游水的鱼 |
|
[关闭][返回] |