SELECT* FROM customers;
SELECT name, address FROM customers;
SELECT id, name, address, phone FROM customers;
SELECT cust_name, cust_address FROM customers;
SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
第1题：
You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: CUST_ID NUMBER(4) NOT NULL CUST_NAME VARCHAR2(100) NOT NULL CUST_ADDRESS VARCHAR2(150) CUST_PHONE VARCHAR2(20) Which SELECT statement accomplishes this task?（）
第2题：
You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true？（）
第3题：
A、needn't have written
B、needn’t write
C、didn't need write
D、didn’t need to write
第4题：
You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. You create reports by using Microsoft Visual Studio .NET 2008. The development team of your company must create 50 SSRS reports. You need to ensure that the company logo and the company name are included in the page header of all the reports. What should you do？（）
第5题：
You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to design the report strategy for a new report project that will be used by a financial application. The application uses five calculations that are implemented in Microsoft .NET Framework 3.5 assemblies. The assemblies are written in the C# language and use the static methods. You need to ensure that the calculations can be used by the expressions in all reports. You also need to ensure consistency within the reports by using the least amount of development effort. What should you do？（）
第6题：
You design a Business Intelligence （BI） solution by using SQL Server 2008. The solution includes a SQL Server 2008 Reporting Services （SSRS） infrastructure in a scale-out deployment. All reports use a SQL Server 2008 relational database as the data source. You implement row-level security. You need to ensure that all reports display only the expected data based on the user who is viewing the report. What should you do？（）
第7题：
Which report style would you use to create a report listing each department and including a listing of employees beneath their respective department?（）
第8题：
A.A
B.B
C.C
D.D
第9题：
Your network has a single domain with 1，000 client computers that run Windows Vista. All client computers are members of the domain. You are planning to deploy Windows 7. You need to create a report that shows hardware and device compatibility on all client computers. You need to perform this action without installing any additional software on the client computers. Which tool should you use？（）
第10题：
You need to generate a report that lists all of the computers in the domain that can be converted to Hyper-V hosts. The solution must meet the company’s business requirements. What should you use to generate the report？（）