Datasets which reside on the user's hard drive are created by ADO.NET to facilitate the transformation of XML documents to and from relational database constructs.

You are about to install a second IDE hard drive in a PC that has only one IDE adapter. Your first hard drive will still be the boot drive. How should the second drive be configured?

A

as a master

B

as a secondary

C

as a slave

D

as a primary

E

as auto-select

Five Lakes Publishing has a Windows 2000 network serving 200 users. A server named User_srv is used to hold users' files. User_srv is configured with a single, large NTFS volume. Every user has a home folder on User_srv. Users can also use a shared folder named IN_PROGRESS to store files for books that are being prepared. The network administrator at Five Lakes Publishing configured disk quotas for the NTFS volume on User_srv. All users have a default limit of 100 MB, and the option to deny space to users who exceed their limit has been enabled. When a user named Amy Jones attempts to save a chapter of a new book to her home folder on the server, she receives the following error message: "The disk is full or too many files are open." What should Amy do to allow this document to be saved?

A

Compress the files in her home folder to save disk space

B

Change the security setting of some of the files in her home folder to grant Full Control permission to a user who has not reached the quota level

C

Move some of the files from her home folder to the IN_PROGRESS shared folder

D

Remove files from her home folder until the total uncompressed file size is less than 100 MB

E

None of above

You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?

A

EXEC sp_defaultdb 'Andrew','FinanceData'

B

GRANT ALL ON FinanceData TO Andrew

C

EXEC sp_addlogin 'Andrew'

D

EXEC sp_grantdbaccess 'FinanceData','Andrew'GOsp_addrolemember 'db_datareader','Andrew'

Arrange the following in correct sequence of post shipment procedure in exportation process.
1. C and F agent submits the documents to the exporter.
2. Exporter intimates the importer about the shipment of goods.
3. Submission and negotiation of documents with bank.
4. Bank negotiates these documents to the importer's bank in the manner as specified in the letter of credit.
5. Documents are attested with the bill of exchange
6. The exporter gets immediate payment from his bank after signing letter of indemnity.
7. Importer receives the documentary bill of exchange, he releases the payment.
8. After receiving proceeds the exporter intimates the RBI by recording the facts on duplicate copy of GR.
9. The exporter receives subsidies and concessions if he is eligible.

A

1, 2, 3, 4, 5, 6, 7, 8, 9

B

2, 1, 3, 4, 5, 6, 7, 8, 9

C

9, 1, 2, 3, 4, 5, 6, 7, 8

D

9, 2, 1, 3, 4, 5, 6, 7, 8

You are the administrator of the Windows 2000 Server network shown in the exhibit. Users in the Research group and the Executive group have permission to access the Internet through a Windows 2000 Server computer running Microsoft Proxy Server. These users must enter their proxy server user names and passwords to connect to the proxy server, to the Internet, and to your local intranet server. The users who do not access the Internet do not have user accounts on the proxy server and, therefore, cannot connect to the intranet server. You want all users to be able to connect to the intranet server without entering a separate user name and password. What should you do?

A

Move the intranet server to the client segment of the network

B

Move the proxy server to the server segment of the network

C

Configure each client computer to bypass the proxy server for local addresses

D

Configure each client computer to use port 81 for the proxy server

E

None of above

You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to protect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?

A

Create a database maintenance plan to check database integrity and make repairs each night.

B

Enable the torn page detection database option for each database.

C

Disablewrite caching on all disk controllers.

D

Ensure that write caching disk controllers have battery backups.

You are the administrator of a Windows 2000 Server computer named Intra. Intra is a member of an Active Directory domain and hosts an Intranet Web-Ske for your company. Company policy requires that only authenticated users have access to the intranet site. All company users have a user account in the Active Directory domain. You configure directory security for the Web Site to use integrated security. However, you discover that users can access the Web Site without authentication. You need to ensure that only authenticated users can access the web site. What should you do?

A

Install Active Directory on the server

B

Select Basic Authentication check box

C

Clear the Allow Anonymous Connection check box

D

Disable the IUSE_inta user account on Intra

E

Clear the Allow IIS to Control Password check box

The choice of XML technology, native XML versus XML view, generally depends upon the following factors?

A

Storage options

B

Query capabilities

C

Indexing

D

All of the Mentioned

The document containing the XML schema for the XML output by SET STATISTICS XML is located at ______________

A

\Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml. xml

B

\Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml. xsl

C

\Microsoft SQL Server\100\Tools\Binn\schemas\sqlserver\2004\07\showplan\showplanxml. xsd

D

None of the mentioned

________ function can be used to add datasets in R provided with the columns in the datasets should be the same.

A

rbind()

B

bbind()

C

jbind()

D

hbind()

Datasets which reside on the user's hard drive are created by ADO.NET to facilitate the transformation of XML documents to and from relational database constructs.

Related Questions