多选题You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size.  The data should be spread across two data files.  A bitmap should be used to record the free space within the allocated exten

第1题：

You are creating a locally managed tablespace to meet the following requirements： All the extents should be of the same size.  The data should be spread across two data files.  A bitmap should be used to record the free space within the allocated extents. Which three options would you choose？（）

• A、set PCTFREE and PCTUSED to 50
• B、specify extent allocation as Uniform
• C、specify extent allocation as Automatic
• D、create the tablespace as bigfile tablespace
• E、create the tablespace as smallfile tablespace
• F、set segment space management to Automatic
• G、use the RESIZE clause while creating the tablespace

第2题：

You issued the following statement in your SQL*Plus session：   SQL>ALTER SESSION ENABLE RESUMABLE TIMEOUT 600；   Which operation is neither suspended nor resumed using the Automatic Resumable Allocation feature in your database？（）

• A、 creating a table in your schema and you exceed your allocated space quota on the tablespace
• B、 executing a long query that involves a sort operation and the statement runs out of temporary space
• C、 loading data into tables by using the SQL*Loader and the number of extents in the table reaches the maximum limit
• D、 creating a table in a dictionary-managed tablespace with an explicit MAXEXTENTS setting which results in an out of space error

第3题：

You executed the following command to create a tablespace called SALES_DATA：  > CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO；  Which two statements are true about the SALES_DATA tablespace （）

• A、The database automatically determines the extent-sizing policy for the tablespace.
• B、The segments are automatically shrunk when the contents are removed from them.
• C、The allocation of extents within the tablespace is managed through the dictionary tables.
• D、The space utilization description of the data blocks in segments is recorded inbitmapblocks.
• E、The space utilization description of the data blocks in segments is managed through free lists.MANUAL

第4题：

You specified extent management as local for a tablespace. How will it affect space management in the tablespace？（）

• A、All the extents will be of the same size.
• B、Bitmap will be used to record free and allocated extents.
• C、Free extents will be managed by the data dictionary tables.
• D、The tablespace will be system managed and the users cannot specify the extent size.

第5题：

You are a professional level SQL Server 2005 database administrator in an international corporation named Wiikigo. You are experienced in implementing high-availability solutions， monitoring the database server， and design deployment. In the company， you major job is the deployment， maintenance and support of Microsoft SQL Server 2005. You work as a database administrator for your company. There is a user in the Windows SalesManagers group， and he is called Simon. A Reporting Services report is required by Simon to have annual sales information displayed by territory. There is another user in the Windows Sales group， and he is called Jack. He is responsible to report to Simon. A report is required by Jack， and the report is limited to his sales territory， but the same detailed sales data is still displayed， and the detailed sales data is on Simon’s report. A secure solution should be designed to meet the requirements of the users listed above， and the least amount of server resources should be utilized.  Which action should be performed？（）

• A、First， all territory information should be contained by a parameterized report which is designed for Simon. Second， a linked report that links to Simons report should be designed for Jack.
• B、First， two data regions should be contained by a report which is designed for Simon. Second， one data region should be utilized for summary sales data. Third， the other data region should be utilized for the detailed sales data for each sales representative. Four， a report that displays the detailed sales data should be designed for Jack.
• C、First， two reports should be designed for Simon. Second， the territory information should be contained by one， and the detailed sales data should be contained by another. At last， a report that displays the detailed sales data for Jack’s territories should be designed for Jack.
• D、First， the territory information should be contained by a report which is designed for Simon. Second， a report which detailed sales data for Jack’s territories is contained should be designed for Jack. Third， Simon’s report should be set to have the data in Jacks report contained.

第6题：

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.

第7题：

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.

第8题：

You need to meet the requirements of the accounts team. What should you do?（）

• A、Set the Dimension type to Currency.
• B、Set the Currency member name as a unique attribute.
• C、Hide non-leaf data within the Currency dimension key attribute.
• D、Disable the All member of the Currency dimension key attribute.

第9题：

第10题：

第11题：

第12题：

第13题：

You specified segment space management as automatic for a tablespace. What effect would this have on space management？（）

• A、Extents would be managed by the freelists.
• B、The segment would be managed by bitmaps.
• C、The segment would be managed by the freelists.
• D、Free space would be managed by the data dictionary.

第14题：

You executed the following command to create a tablespace called SALES_DATA： SQL> CREATE TABLESPACE sales_data DATAFILE SIZE 100M SEGMENT SPACE MANAGEMENT AUTO； Which two statements are true about the SALES_DATA tablespace（）

• A、The database automatically determines the extent-sizing policy for the tablespace.
• B、The segments are automatically shrunk when the contents are removed from them.
• C、The allocation of extents within the tablespace is managed through the dictionary tables.
• D、The space utilization description of the data blocks in segments is recorded in bitmap blocks.
• E、The space utilization description of the data blocks in segments is managed through free lists.

第15题：

You are using Oracle Enterprise Manager to estimate the size of a table to be created. You have typed data regarding the column names， data types， sizes of the columns， and the projected number of rows in the table. Which additional information does the Oracle Enterprise Manager return？（）

• A、 space allocated in the tablespace
• B、 space required for the bitmap index on a column of the table
• C、 space remaining in the tablespace after creating the table
• D、 estimated value of the PCTFREE storage parameter

第16题：

You are a professional level SQL Sever 2008 Database Administrator in an international  corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. SQL Server 2008 instances at five sites are managed by you.A mission-critical database is shared by the five sites. According to the business requirements, the users at each site should be enabled to access and change data on all sites with minimal latency.In addition, data loss should be minimized if a server fails. A high-availability solution should be designed, and the business requirements should be satisfied.    Which action should be included in your solution?（）

• A、Failover clustering should be included. 
• B、Asynchronous database mirroring without a witness server should be included.
• C、Peer-to-Peer replication should be included. 
• D、Log shipping to servers at two of the sites to offer read-only replications of data should be included.

第17题：

Your data recovery strategy must meet the following requirements： Back up all data files and folders in C:///Data.  Restore individual files and folders in C:///Data.  Ensure that data is backed up to and restored from external media.  What should you do？（）

• A、Use the Previous Versions feature to restore the files and folders.
• B、Use the System Restore feature to perform backup and restore operations.
• C、Use the NTBackup utility to back up and restore individual files and folders.
• D、Use the Backup and Restore Center to back up and restore files.

第18题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. At present about 90 GB of data is stored in DB1. You made some rough calculations that every day about 1 GB of data is modified or inserted. You set the recovery model of DB1 to Simple. According to the company requirements, during business hours, data loss of more than 120 minutes worth of transactions is unacceptable. You have to choose a backup strategy which must comply with the following two requirements: Using as little disk space as possible Complying with the company requirements. So what action should you perform to achieve this goal?（）  

• A、A full database backup should be performed once daily. During business hour, a transaction log backup should be performed every two hours. 
• B、A full database backup should be performed once daily 
• C、A full database backup should be performed once daily. During business hours, a differential backup should be performed every two hours 
• D、Perform a full database backup should be performed once every week. A differential backup should be performed once daily. During business hours a transaction log backup should be performed every two hours.

第19题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You are going to use the data collector to gather performance data periodically on all instances. You must store all collected data in the same database. This database is hosted on a single instance. Every five hours, you have to collect and load performance data in the management data warehouse. Which data collection process should you implement? （） 

• A、You should create a cached data collection 
• B、You should create an on-demand non-cached data collection 
• C、You should create a scheduled non-cached data collection. 
• D、You should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.

第20题：

第21题：

第22题：

第23题：

第24题：