单选题In which case would you use a FULL OUTER JOIN?（）A Both tables have NULL values.B You want all unmatched data from one table.C You want all matched data from both tables.D You want all unmatched data from both tables.E One of the tables has more data th

You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.

You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.

You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.

What should you do?

A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.

B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.

C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.

D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.

You are the administrator of a database that contains 64 lookup tables. These tables store static data that should not change. However, users report that some of this data is being changed. You need to prevent users from modifying the data.

You want to minimize changes to your security model and to your database applications. How should you modify the database?

A．Create a filegroup named LOOKUP. Move the lookup tables to this filegroup. Select the read only check box for the filegroup.

B．Create a database role named datamodifier. Grant SELECT permissions to the datamodifier role. Add all users to the role.

C．Deny INSERT, UPDATE, and DELETE permissions for all users. Create stored procedures that modify data in all tables except lookup tables. Require users to modify data through these stored procedures.

D．Create a view of the lookup tables. Use the view to allow users access to the lookup tables.

A. Both tables have NULL values.

B. You want all unmatched data from one table.

C. You want all matched data from both tables.

D. You want all unmatched data from both tables.

E. One of the tables has more data than the other.

F. You want all matched and unmatched data from only one table.

A.You want to create a nonequijoin.

B.The tables to be joined have multiple NULL columns.

C.The tables to be joined have columns of the same name and different data types.

D.The tables to be joined have columns with the same name and compatible data types.

E.You want to use a NATURAL join, but you want to restrict the number of columns in the join condition.

You are the administrator of SQL Server 2000 computer named FABSQL2K01. You create a Data Transformation Services package that contains definition for two transform. data tasks.

The tasks gets data from two text files named Customers and Sales. The DTS package is configured as shown in the exhibit.

You do not want the DTS package to add any data to the server unless both transform. data tasks complete successfully.

You select the use transactions check box of DTS package and the Join transaction of present check box of both transform. data tasks. You then select the fail package on step failure check box of both transform. data tasks.

You want to use the DTS package to import data from the text files to the server. You want to ensure that changes are committed if all imported data is successfully transformed.

What should you do?

A．Select the commit on successful completion check box of the DTS package.

B．Select the commit transaction on successful completion of this step check box of the customers transform. data task.

C．Select the commit transaction on successful completion of this step check box of the sales transform. data task.

D．Select the commit transaction on successful completion of this step check box of both transform. data tasks.