当前位置： 找题吧 >  微软认证
[单选题]

E．xhibit:

UPDATE EzonexamConsolidated

SET District = ‘Mexico’

WHERE RtvID = 45

You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database.

When users run the query in the exhibit above the receive the following error message:

Server: Mrh3612, Level 16, Stats 1, Line 1

View or function ‘EzonexamConsolidated’ is not updateable because it

contains aggregates:

H．ow should you enable the query to run?

A．Create a non-normalized EzonexamConsolidated table and populate the table with data from the base tables.

B．The appropriate users should be granted UPDATE permissions on each base table.

C．To enable updates on the composite tables create an INSTEAD OF trigger on the view.

D．On each base table add a cascading update trigger.

参考答案与解析：

相关试题

Click the Exhibit button and examine the

[单选题]Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables.You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?（）A . SELECT last_name, depart

  • 查看答案

    • When a fire ____ at the National Exhibit

    [试题]Whenafire____attheNationalExhibitioninLondon,atleasttenpricelesspaintingswerecompletelydestroyed.(A)brokeoff(C)brokedown(B)brokeout(D)brokeup

  • 查看答案

    • A translation B interpretation C exhibit

    [单选题]A． translation B interpretation C exhibition D demonstration

  • 查看答案

    • Refer to the exhibit. Based on the outpu

    [单选题]Refer to the exhibit. Based on the output from the show command on RT1which statement is true? （）A . OSPFv3 uses global IPv6 addresses to establish neighbor adjacencies.B . RT1 has a subnet mask of 64 bits .C . RT1 has FastEthernet0/0 set as a DR

  • 查看答案

    • SQL 语言的查询语句是A)INSERT B)UPDATE C)DELETE D

    [单选题]SQL 语言的查询语句是A．)INSERTB．)UPDATEC．)DELETED．)SELECT

  • 查看答案

    • The economycontinued to [exhibit] signs of decline in September.

    [单选题]The economycontinued to [exhibit] signs of decline in September.A.playB.sen

  • 查看答案

    • Refer to the exhibit. Which three statem

    [多选题] Refer to the exhibit. Which three statements are true?（）A . On the routing table of R4, the 10.1.1.0/24 route appears as an O E2 routeB . On R4, the 172.16.1.0/24 route has a metric of 20C . The R3 S0/0 interface should not need the no ip split - ho

  • 查看答案

    • Exhibit:BULK INSERT Ezonexam.dbo.employe

    [单选题]E．xhibit:B．ULK INSERT Ezonexam.dbo.employeesF．ROM ‘tk/africe/fubar512.txt’WITH DATAFILETYPE = ‘char’,F．IELD/TERMINATOR = ‘/t’,ROWTERMINATOR = ‘/n,’TABLOCKYou work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer.H．ow

  • 查看答案

    • Investors who exhibit loss aversion most likely：

    [单选题]Investors who exhibit loss aversion most likely：A.Have symmetric risk prefe

  • 查看答案

    • The assertion that investors, analysts, and portfolio managers exhibit psychological tendencies that

    [单选题]The assertion that investors, analysts, and portfolio managers exhibit psyc

  • 查看答案

    • Exhibit:UPDATE EzonexamConsolidatedSET D