题目内容

You are the administrator of a SQL Server 2000 computer. The server contains a database named MedicalRecords. You have recently added a hard disk to the server and configured the database.
The data files are configured as shown in the Database Properties exhibit.
The database is configured as shown in the Database Schema exhibit.
Each primary key is clustered. All foreign keys contain nonclustered indexes. You want to use the space on the new hard disk to make the database respond more quickly to queries.
What should you do?

A. Re-create the Notes table on the SECONDARY filegroup.
B. Re-create the nonclustered indexes on the SECONDARY filegroup.
C. Re-create the Patients and Doctors tables and their indexes on the SECONDARY filegroup.
D. Re-create the Cases and Notes tables and their indexes on the SECONDARY filegroup.

查看答案
更多问题

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.

Eruptions of Mount Saint Helens
On March 27, the US Government scientists made a decision after they predicted the eruption of Mount Saint Helens. They telephoned all state and local officials in the area and told them that a serious eruption was possible at any time. Roads were closed to every one except scientists and forest keepers struggled to keep curious visitors away from the mountain.
Shortly after noon on March 27, Mount Saint Helens erupted for the first time in 123 years. People living north of the mountain heard a loud boom that shook their windows, and airline pilots flying near the volcano soon afterwards described a thick black column of ash and steam shooting more than 2,100 meters into the sky.
Later, scientists found that the explosion had made a new crater (大坑) in the top of the mountain, not far from the old crater. The north side of the peak now had a huge bulge (凸出部分) where rock and ice had been pushed out by the eruption.
A second eruption shook the mountain on March 28. It, too, sent up a column of black ash high into the sky. By March 29, scientists flying over the mountain saw that a second crater formed about 9 meters from the first one. Strange blue flames flickered (闪烁) inside the crater and sometimes jumped from one crater to the other.
By April 1 the mountain had erupted several more times and the snow on the north slope of the peak was black with ash. Ash carried by the wind had fallen on towns as far as 240 kilometers away from Mount Saint Helens.
During the first week of April, Mount Saint Helens gave scientists something new to worry about: harmonic tremors (震动) recorded by scientists showed a big eruption would happen. All during April and into May Mount Saint Helens continued to shudder (震动) and shoot out ash. By April 8, the two craters had merged to form. a vast hole nearly a half of a kilometer wide and 250 meters deep.
Scientists' main worry during this time was the growing bulge of rock and ice on the north face of the mountain. By May 7 scientists feared the worst. Their warnings led Washington Governor to set up safety zones around the mountain. The inner' "red" zone was open to scientists only. The outer "blue" zone was open only to people who got special permits. But in spite of these warnings, some people got past the road barriers and risked their lives trying to get close to the volcano.
American scientists predicted that Mount Saint Helens was to erupt soon.

A. Right
B. Wrong
C. Not mentioned

Lake Nyos and Lake Monoun explode because

A. the gases rise to the top and mix with air.
B. people from the villages turn over the water.
C. scientists have put in a computer system.
D. they have more gases trapped at the bottom than other crater lakes.

公司股份的全部注销只有公司清算时才发生。另外,通过股份的回购及持有本公司股票的公司合并等方式,也可以达到注销股份的目的。 ()

A. 正确
B. 错误

答案查题题库