___________ returns a general overview of the status of the database, detailing disk usage, memory use, connection, journaling, and index access.

You install your boot volume on volume C on your Windows 2000 Server computer. You mirror volume C on dynamic Disk 1. Two years later, during routine server maintenance, you open Disk Management and find that the status of volume C is Failed Redundancy. The status of Disk 1 is Missing. You attempt to reactivate Disk 1, but the status of volume C does not return to Healthy. What should you do next?

A

Replace Disk 1 and restart the computer. The mirror will automatically regenerate

B

Remove the mirror on Disk 1, replace the disk, and then add back the mirror to the new Disk 1

C

Replace Disk 1 and copy all data from volume C to a new NTFS primary partition on the new Disk 1. Restart the computer

D

Rescan the disks, remove the mirror, and delete the data on Disk 1. Then re-create the mirror

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'

Your Windows 2000 Server computer contains a stripe set with parity on a four-disk array. You convert the stripe set with parity to a dynamic RAID-5 volume. Six months later, users report that disk access on the server is slower than it had been on the previous day, You use Disk Management and discover that the status of the third disk in the array is Missing. You want to recover the failed RAID-5 volume. What should you do first?

A

Replace the third disk and restart the server. Use disk Management to repair the volume

B

Ensure that the third disk is attached to the server and has power. Use Disk Management to reactivate the disk

C

Ensure that the third disk is attached to the server and has power. Use Disk Management to repair the volume

D

Install a new disk and create a single extended partition on the new disk. Restart the computer and allow Windows 2000 to automatically repair the volume on the extended partition

E

None of above

Your Windows 2000 Server computer contains a stripe set with parity on a four-disk array. You convert the stripe set with parity to a dynamic RAID-5 volume. Six months later, users report that disk access on the server is slower than it had been on the previous day. You use Disk Management and discover that the status of the third disk in the array is missing. You want to recover the failed RAID-5 volume. What should you do first?

A

Replace the third disk and restart the server. Use Disk Management to repair the volume

B

Ensure that the third disk is attached to the server and has power. Use Disk Management to reactivate the disk

C

Ensure that the third disk is attached to the server and has power. Use Disk Management to repair the volume

D

Install a new disk and create a single extended partition on the new disk. Restart the computer and allow Windows 2000 to automatically repair the volume on the extended partition

E

None of above

In a paged memory, the page hit ratio is 0.35. The required to access a page in secondary memory is equal to 100 ns. The time required to access a page in primary memory is 10 ns. The average time required to access a page is?

A

3.0 ns

B

68.0 ns

C

68.5 ns

D

78.5 ns

A solid cast iron disk of mass 1000kg is rotating at 350rpm. Diameter of the disk is 1m and time taken to come to stop the disk by brake is 1.6sec.Square of radius of gyration is 0.2. Calculate the angle through which disk rotated during braking period.

A

27.5rad

B

24.6rad

C

29.3rad

D

32.4rad

You are the administrator of Windows 2000 Server computer. Your computer has a span volume that consists of areas on three physical hard disks on the server. The three disks support hot swapping. You regularly backup the span volume by using windows backup. One of the disk fail, you replace the disk with a new un-partitioned disk. You want to recover the span volume and disk data as soon as possible. What should you do?

A

Extend the span volume to include the new disk, rescan the disk

B

Extend the span volume to include the new disk, shut down and restart the server, use windows backup to restore the data

C

Re scan the disk, format the span volume. Use windows back up to restore the data

D

Re scan the disk, extend the span volume to include the new disk. Shut down and restart the server, use windows backup to restore the new data

E

Re scan the disk, remove the span volume and create a new span volume that includes the new disk. Format the span volume, use Windows back up to restore the data

The disk system consists of which of the following? i. Disk ii. Disk drive iii. Disk controller

A

i and ii

B

i, ii and iii

C

ii and iii

D

i

You are a Web developer for XYZ. You create an ASP.NET application that accesses sales and marketing data. The data is stored in a Microsoft SQL Server 2000 database on a server named XYZ01.
The company purchases a factory automation software application. The application is installed on XYZ01, where it creates a second instance of SQL Server 2000 named Factory and a database named FactoryDB. You connect to FactoryDB by using Windows Integrated authentication.
You want to add a page to your ASP.NET application to display inventory data from FactoryDB. You use a SqlConnection object to connect to the database. You need to create a connection string to FactoryDB in the instance of SQL Server named Factory on XYZ01. Which string should you use?

A

?Server=XYZ01;Data Source=Factory; Initial Catalog=FactoryDB;Integrated Security=SSPI?

B

?Server=XYZ01;Data Source=Factory; Database=FactoryDB;Integrated Security=SSP1?

C

?Data Source=XYZ01\\Factory; Initial Category=Factory; Integrated Security=SSP1?

D

?Data Source=XYZ01\\Factory; Database=FactoryDB; Integrated Security=SSP1?

You want to provide Internet access for the clients on your network. You decide to use Network Address Translation (NAT). You have a Windows 2000 computer you try to establish a secure Virtual Private Networking session with. You try connecting to the Remote Windows 2000 computer using L2TP. You are unable to establish a connection with the remote node using L2TP. You are able to make a connection with another computer in your same office. Why are you unable to make a connection.to the remote location?

A

NAT does not allow for remote networking

B

L2TP does not work with Windows 2000 computers

C

You can not establish a L2TP connection behind a computer running NAT. The L2TP session fails because the IP Security packets become corrupted

D

You have not configured the NAT server to translate the IP Security packets

E

None of above

___________ returns a general overview of the status of the database, detailing disk usage, memory use, connection, journaling, and index access.

Related Questions