单选题A data manipulation language statement （）.A completes a transaction on a tableB modifies the structure and data in a tableC modifies the data but not the structure of a tableD modifies the structure but not the data of a table

第1题：

在实现新的CHARGING数据分析时，以下哪个分析表应被首先修改？（）

• A、Charging Case data table
• B、Tariff data table
• C、Tariff Class data table

第2题：

The Company core switches use 802.1Q trunks to connect to each other.  How does 802.1Q  trunking keep track of multiple VLANs？ （）

• A、 It tags the data frame with VLAN information and recalculates the CRC value
• B、 It encapsulates the data frame with a new header and frame check sequence
• C、 It modifies the port index of a data frame to indicate the VLAN
• D、 It adds a new header containing the VLAN ID to the data frame
• E、 None of the other alternatives apply

第3题：

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement?（）

• A、You cannot roll back this statement.
• B、All pending transactions are committed.
• C、All views based on the DEPT table are deleted.
• D、All indexes based on the DEPT table are dropped.
• E、All data in the table is deleted, and the table structure is also deleted.
• F、All data in the table is deleted, but the structure of the table is retained.
• G、All synonyms based on the DEPT table are deleted.

第4题：

You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

• A、All data along with the table structure is deleted 
• B、The pending transaction in the session is committed 
• C、All indexes on the table will remain but they are invalidated 
• D、All views and synonyms will remain but they are invalidated 
• E、All data in the table are deleted but the table structure will remain

第5题：

A data manipulation language statement （）.

• A、completes a transaction on a table
• B、modifies the structure and data in a table
• C、modifies the data but not the structure of a table
• D、modifies the structure but not the data of a table

第6题：

You issue the following statement：   SQL> SELECT FIRSTNAME， LASTNAME FROM HR.EMPLOYEE；  You receive the following error：         01578： ORACLE data block corrupted （file# 6， block # 54）        ORA-01110 ： data file 6： ’u01/oracle/oradata/data1.dbf’   How will you resolve this problem of data block corruption by reducing the mean time to recover （MTTR）？（）

• A、 by using the DBMS_REPAIR package
• B、 by using the DBVERIFY utility
• C、 by using Block Media Recovery
• D、 by issuing the ANALYZE TABLE HR.EMPLOYEES VALIDATE STRUCTURE command

第7题：

You design a Business Intelligence （BI） solution by using SQL Server 2008. The solution includes a SQL Server 2008 Analysis Services （SSAS） database. The database contains a data mining structure that uses a SQL Server 2008 table as a data source. A table named OrderDetails contains detailed information on product sales. The OrderDetails table includes a column named Markup. You build a data mining model by using the Microsoft Decision Trees algorithm. You classify Markup as discretized content.  The algorithm produces a large number of branches for Markup and results in low confidence ratings on predictable columns. You need to verify whether the Markup values include inaccurate data. What should you do？ （）

• A、 Modify the content type of Markup as Continuous.
• B、 Create a data mining dimension in the SSAS database from OrderDetails.
• C、 Create a data profile by using SQL Server 2008 Integration Services （SSIS）.
• D、 Create a cube in SSAS. Use OrderDetails as a measure group. Recreate the data mining structure and mining model from the cube data.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

Which of the following are not BGRP data structures？ （Choose all that apply.）（）

• A、EIGRP database table
• B、EIGRP CEF table
• C、EIGRP neighbor table
• D、EIGRP adjacency table
• E、EIGRP interface table
• F、EIGRP topology table

第14题：

You own a table called EMPLOYEES with this table structure: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE What happens when you execute this DELETE statement? DELETE employees;（）

• A、You get an error because of a primary key violation.
• B、The data and structure of the EMPLOYEES table are deleted.
• C、The data in the EMPLOYEES table is deleted but not the structure.
• D、You get an error because the statement is not syntactically correct.

第15题：

Which  statements are correct about temporary tables（）

• A、Indexes and views can be created on temporary tables.
• B、Both the data and the structure of temporary tables can be exported.
• C、Temporary tables are always created in a user’s temporary tablespace.
• D、The data inserted into a temporary table in a session is available to other sessions.
• E、Data manipulation language （DML） locks are never acquired on the data of temporary tables

第16题：

Identify the logical structure that will never have more than one data segment created for it.（）

• A、external table
• B、partitioned table
• C、partitioned index
• D、nonclustered table
• E、global temporary table

第17题：

Which three statements are correct about temporary tables？（）

• A、Indexes and views can be created on temporary tables.
• B、Both the data and the structure of temporary tables can be exported.
• C、Temporary tables are always created in a user’s temporary tablespace.
• D、The data inserted into a temporary table in a session is available to other sessions.
• E、Data manipulation language （DML） locks are never acquired on the data of temporary tables.

第18题：

You are designing a web service that will be hosted in Windows Azure.  The web service will accept and store structured and semi-structured data. The web service must meet the following requirements：   - Update all data within a single transaction.  - Enforce the data structure for structured data within the data store.    You need to recommend an approach for storing the data.  What should you recommend？（）

• A、 Use Windows Azure Queues.
• B、 Use a single SQL Azure database.
• C、 Use a single Windows Azure Drive.
• D、 Use Windows Azure Table storage.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：