单选题How dirty the tables are! They need _____.A to cleanB cleanC cleaningD cleaned

题目
单选题
How dirty the tables are! They need _____.
A

to clean

B

clean

C

cleaning

D

cleaned


相似考题
更多“How dirty the tables are! They need _____.”相关问题
  • 第1题:

    We'll have to______ how much food we'll need for the party.

    A、work out

    B、work up

    C、work in

    D、work on


    参考答案:A

  • 第2题:

    You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database.What must you do accomplish this task?()

    A. Enable supplemental logging for the database.

    B. Specify undo retention guarantee for the database

    C. Create Flashback Data Archive in the tablespace where the tables are stored.

    D. Create Flashback Data Archive and enable Flashback Data Archive for specific tables


    参考答案:D

  • 第3题:

    How are bridge tables delivered to classify groups of dimension records associated to a singlefact?

    简述桥接表是如何将维度表和事实表进行关联的?


    正确答案:
    答:桥接表(Bridge Table)是维度建模中的一类比较特殊的表。
    在数据仓库的建模时,会遇到具有层次结构的维度表,对于这样的表有一种建模方式是建立父子表,即每条记录上包括一个指向其父记录的字段。这种父子表的建立在层级深度可变时尤其有用,是一个紧凑而有效的建模方式。但是这种建模方式也有缺点,就是用标准SQL很难对递归结构进行操作。
    与这种递归结构的父子表不同,桥接表采用不同的建模方式也可以表示这种层级结构。桥接表是建立在维度表和事实表中间的一个具有较多冗余信息的表,其中的记录包含层级结构中节点到其下面每个节点的路径。表结构如下所示:
    父关键字
    子关键字
    父层数
    层名
    底端标识
    顶端标识
    在桥接表中,节点与其下面的任意一个节点都建立一个关联记录保存在表中,即父子关系不再局限在相邻层,如第一层与第三层同样有父子关系,通过父层数可以区分相隔了几层。这样,可以通过父层数和父子关系来进行层级结构的查询。
    当然,桥接表也不是一个完备的解决方案,它只能是在某些情况下是查询变得容易。

  • 第4题:

    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
    解析:Explanation:SQLServer2000allowsfilegroupsotherthantheprimaryfilegrouptobemarkedasreadonly.Afilegroupthatismarkedread-onlycannotbemodified.Tablesthatmustnotbemodifiedcanbeplacedonafilegroupthatcanthenbemarkasread-only.Thiswillpreventsaccidentalupdates.IncorrectAnswers:B:Thissolutioneffectivelypermitsalluserstomodifyanytableinthedatabase,astheywouldallhaveSELECTpermissionstothedatabase.C:ThissolutionwilleffectivelypreventallusersfrombeingabletoperformingthesetasksonalltablesinthedatabaseastheyaredeniedpermissionstorunINSERT,UPDATE,orDELETEstatementsagainstthedatabase.Abettersolutionwouldbetoapplythedenypermissionsatthetablelevelofthelookuptables.Thiswould,however,requireunnecessaryadministrativetime.D:Viewsarevirtualtablesthatareusedtofiltertablesorrowsthattheusersshouldnothaveaccessto,however,iftheusershaveaccesstothebasetables,theycanstillrunINSERT,UPDATE,andDELETEstatementsagainstthebasetable.

  • 第5题:

    There is no need__________ to teach children how to behave.


    A.however

    B.whatsoever

    C.forever

    D.whenever

    答案:B
    解析:
    考查whatsoever的用法。本句意思是“教孩子如何守规矩是没有必要的”。本句去掉设空部分完全成立,意思完整,不缺任何成分。whatsoever作副词,相当于at all,用在否定句中,与no,not或nothing等具有否定意义的词连用.构成加强否定式。

  • 第6题:

    When configuring an interface using SMIT and Further Configuration with an IP address and netmask, which of the following outcomes indicates how the routing tables will be affected?()

    • A、A subnet route is automatically added
    • B、A default route is automatically added
    • C、All other routes are automatically added
    • D、The routing table is not affected

    正确答案:A

  • 第7题:

    What is necessary for your query on an existing view to execute successfully?()

    • A、The underlying tables must have data.
    • B、You need SELECT privileges on the view.
    • C、The underlying tables must be in the same schema.
    • D、You need SELECT privileges only on the underlying tables.

    正确答案:B

  • 第8题:

    单选题
    The VPN termination function provides the ability to connect two networks together securely over the internet. Which of these is true of IP addressing with regard to VPN termination?()
    A

    termination devices need routable addresses inside the VPN

    B

    termination devices need not routable addresses inside the VPN

    C

    IGP routing protocols will update their routing tables over anIPsec VPN

    D

    addressing designs need to allow for summarization


    正确答案: A
    解析: 暂无解析

  • 第9题:

    单选题
    You design a Business Intelligence (BI) solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services (SSRS) solution. Developers generate random reports against a data source that contains 200 tables. Power users generate random reports against four of the 200 tables. You need to design a strategy for the SSRS solution to meet the following requirements: ·Uses minimum amount of development effort. ·Provides two sets of tables in SSRS to the developers group and the power users group. Which strategy should you use?()
    A

     Create two Report Builder models.Include the four frequently used tables in the first model and all the tables in the second model.

    B

     Create a Report Builder model by using all the tables.Create a perspective within the model to use only the four frequently used tables.

    C

     Create a Report Builder model by using all the tables. Create two folders.Place the four frequently used tables in the first folder and the remaining tables in the second folder.

    D

     Create two Data Source Views.Include all the tables in one Data Source View and the four frequently used tables in the other Data Source View.Create two Report Builder models so that each model uses one of the Data Source Views.


    正确答案: C
    解析: 暂无解析

  • 第10题:

    多选题
    You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform?()
    A

    Move tempdb onto a faster disk volume.

    B

    Increase the initial size of tempdb to 1.5 GB

    C

    Increase the size of the data files in the Tracking database.

    D

    Decrease the file growth increment for tempdb to 25 MB

    E

    Use more local temporary tables and fewer global temporary tables in the Tracking database.


    正确答案: B,D
    解析: 暂无解析

  • 第11题:

    单选题
    What is necessary for your query on an existing view to execute successfully?()
    A

    The underlying tables must have data.

    B

    You need SELECT privileges on the view.

    C

    The underlying tables must be in the same schema.

    D

    You need SELECT privileges only on the underlying tables.


    正确答案: C
    解析: 暂无解析

  • 第12题:

    单选题
    The ‘fsck -p /dev/lv00’ command returned the following message:Not a recognized filesystem type. What is the likely cause of the problem and how should it be resolved?()
    A

    The file system superblock is dirty. It can be replaced from the VGDA

    B

    The logical volume superblock is dirty. It can be replaced from the VGDA

    C

    The file system superblock is dirty. It can be replaced from the secondary copy

    D

    The logical volume superblock is dirty. It can be replaced from the secondary copy


    正确答案: C
    解析: 暂无解析

  • 第13题:

    —I can't see the words on the blackboard. —Perhaps you need _( )

    A. How long ago did you get it this

    B. How long have you been like this

    C. How soon have you got it

    D. How soon have you liked this


    正确答案:B 

  • 第14题:

    What is necessary for your query on an existing view to execute successfully? ()

    A. The underlying tables must have data.

    B. You need SELECT privileges on the view.

    C. The underlying tables must be in the same schema.

    D. You need SELECT privileges only on the underlying tables.


    参考答案:B

  • 第15题:

    Your ERX router is supporting 100 virtual routers.A specific line module supports IP interfaces in 5 virtual routers.How many routing tables are maintained on that module?()

    A.0

    B.1

    C.5

    D.100


    参考答案:C

  • 第16题:

    The VPN termination function provides the ability to connect two networks together securely over the internet. Which of these is true of IP addressing with regard to VPN termination?()

    A. termination devices need routable addresses inside the VPN

    B. termination devices need not routable addresses inside the VPN

    C. IGP routing protocols will update their routing tables over anIPsec VPN

    D. addressing designs need to allow for summarization


    参考答案:D

  • 第17题:

    The ‘fsck -p /dev/lv00’ command returned the following message:Not a recognized filesystem type. What is the likely cause of the problem and how should it be resolved?()

    • A、The file system superblock is dirty. It can be replaced from the VGDA
    • B、The logical volume superblock is dirty. It can be replaced from the VGDA
    • C、The file system superblock is dirty. It can be replaced from the secondary copy
    • D、The logical volume superblock is dirty. It can be replaced from the secondary copy

    正确答案:C

  • 第18题:

     The IT department is creating a human resources application that will require several new tables. You need to develop a standard alone executable that will defines these tables and their relationships. Which developer/2000 component could you use to create the executable?()

    • A、Procedure builder. 
    • B、Query builder. 
    • C、Schema builder. 
    • D、Form builder. 
    • E、Project builder. 
    • F、Transactional builder.

    正确答案:C

  • 第19题:

    单选题
    How dirty the tables are! They need _____.
    A

    to clean

    B

    clean

    C

    cleaning

    D

    cleaned


    正确答案: C
    解析:
    句意:桌子实在是太脏了!它们需要被擦干净。need doing等于need to be done,主动表示被动。

  • 第20题:

    单选题
    You are creating a view to join the Customers and Orders tables in a SQL Server 2005 database. You need to ensure that the view cannot be affected by modifications to underlying table schemas. You want to accomplish this goal by using the least possible amount of overhead. What should you do?()
    A

    Create CHECK constraints on the tables. 

    B

    Create a DDL trigger to roll back any changes to the tables if the changes affect the columns in the view. 

    C

    Create the view, specifying the WITH SCHEMABINDING option. 

    D

    Create the view, specifying the WITH CHECK option. 


    正确答案: A
    解析: 暂无解析

  • 第21题:

    多选题
    You need to ensure that the stored procedure that inserts new loan requests can access data in tables that are stored in another database on the same SQL Server instance. Which two actions should you perform?()
    A

    Ensure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login.

    B

    Ensure that the stored procedure and the tables are owned by the same database user.

    C

    Ensure that the stored procedure and the tables use the same database schema.

    D

    Configure the multiuser database option on both databases.

    E

    Configure the cross-database ownership chaining option on both databases.


    正确答案: C,B
    解析: 暂无解析

  • 第22题:

    单选题
    The IT department is creating a human resources application that will require several new tables. You need to develop a standard alone executable that will defines these tables and their relationships. Which developer/2000 component could you use to create the executable?()
    A

    Procedure builder. 

    B

    Query builder. 

    C

    Schema builder. 

    D

    Form builder. 

    E

    Project builder. 

    F

    Transactional builder.


    正确答案: B
    解析: 暂无解析

  • 第23题:

    单选题
    You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task?()
    A

    Enable supplemental logging for the database.

    B

    Specify undo retention guarantee for the database

    C

    Create Flashback Data Archive in the tablespace where the tables are stored.

    D

    Create Flashback Data Archive and enable Flashback Data Archive for specific tables


    正确答案: D
    解析: 暂无解析

  • 第24题:

    单选题
    The VPN termination function provides the ability to connect two networks together securely overthe internet. Which of these is true of IP addressing with regard to VPN termination?()
    A

     termination devices need routable addresses inside the VPN

    B

     termination devices need not routable addresses inside the VPN

    C

     IGP routing protocols will update their routing tables over an IPsec VPN

    D

     addressing designs need to allow for summarization


    正确答案: D
    解析: 暂无解析