Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command: ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the outcome of this command?（）A、It produces an error because data already exists in the table.B、It produces an error because compression can be enabled at table creation only.C、It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.D、It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.
Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command: ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the outcome of this command?（）
- A、It produces an error because data already exists in the table.
- B、It produces an error because compression can be enabled at table creation only.
- C、It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
- D、It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.
相关考题：
We hope to receive your quotation with details ( ) the earliest date of shipment. A.includingB.to be includedC.being includedD.include
听力原文：W: What is function of the sale slip? It is so small that it is not always considered important.M: It is small, of course, but it contains the details of the card and they also show the details and amount of the sale.Q: What can we learn from the conversation?(20)A．The sales slips are not important.B．The sales slips show the amount of the sale.C．The sales slips perform. important functions in the bankcard transactions.D．The sales slips contain the details of the card.
Pressed for further details, the chairman confessed _______ that profits would show a further fall.A. such being likelyB. that being likelyC. they to be likelyD. it to be likely
You create a large, n-tier Web application that has a custom event tracking system. You need to create a custom event type that enables your event tracking system to record all relevant event details for all types of events. The events must be stored in Microsoft SQL Server.From which base type should your custom event type inherit? （）A. IWebEventCustomEvaluatorB. WebEventProviderC. WebBaseEventD. WebAuditEvent
Which four actions are possible during an Online Data file Move operation?() A. Creating and dropping tables in the data file being movedB. Performing file shrink of the data file being movedC. Querying tables in the data file being movedD. Performing Block Media Recovery for a data block in the data file being movedE. Flashing back the databaseF. Executing DML statements on objects stored in the data file being moved
In computing.a device driver (commonly referred to as simply a driver) is acomputerprogram that operates or controls a particular type of device that is attached to a computer.Adiver provides (71) to hardware devices,enabling operating systems and other computerprograms to access hardware functions without needing to know precise details of thehardware being used.A.a software interfaceB.a programming languageC.a functionD.an Internal Bus
In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command： SQLSELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales GROUP BY sale_category； Where would the result of this query be stored（）？ A、 database buffer cacheB、 shared poolC、 PGAD、 large pool
Which four actions are possible during an Online Data file Move operation?（）A、Creating and dropping tables in the data file being movedB、Performing file shrink of the data file being movedC、Querying tables in the data file being movedD、Performing Block Media Recovery for a data block in the data file being movedE、Flashing back the databaseF、Executing DML statements on objects stored in the data file being moved
Which two types of information might be found at the Small Business Partner Central website？ （）A、 sales program informationB、 online product orderingC、 technology partner products and servicesD、 product information on the Data Center productsE、 specialization and certification details
the goods which have entered the territory,approved by the Customs as items for which no formalities are performed in the way of duty payment,and will be reshipped out of the territory after being stored,processed or assembled in the territory are defined as （）A、bonded，goodsB、Through，goodsC、Transshipment，goodsD、Transit，goods
A pSeries server is being used as a file server and all data is stored on a non-root volume group and resides on mounted filesystems. Which of the following commands provides the quickest way to backup all of the data and filesystem definitions？（）A、tarB、cpioC、savefsD、savevg
What IBM pre-sale resource has technical information and general configuration details for System x， BladeCenter， Intellistation， System x storage products and options in both Adobe PDF， and online HTML？（）A、ServerProvenB、System x Sales Configuration Aid （xSCA）C、Configuration Options Guide - （COG）D、Standalone Solutions Configuration Tool （SSCT）
You design a SQL Server 2008 Reporting Services （SSRS） solution. You create a report by using Microsoft Visual Studio .NET 2008. The report contains the following components： A dataset named Customer that lists all active customers and their details. The dataset accepts no parameters. A dataset named SalesHistory that lists all sales transactions for a specified time period and accepts year and month as parameters. You need to ensure that a summary of sales transactions is displayed for each customer after the customer details. Which component should you add to the report？ （）A、 ListB、 TableC、 MatrixD、 Subreport
You create a large, n-tier Web application that has a custom event tracking system. You need to create a custom event type that enables your event tracking system to record all relevant event details for all types of events. The events must be stored in Microsoft SQL Server. From which base type should your custom event type inherit? （）A、IWebEventCustomEvaluatorB、WebEventProviderC、WebBaseEventD、WebAuditEvent
You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）A、 Use a subreport.B、 Use a bookmark link.C、 Use the drilldown functionality.D、 Use a drillthrough report link.
单选题During sales shoppers should _____.Afind the best bargains at every opportunityBbeware of being cheatedCbuy things that are necessaryDpay more attention to the price
单选题You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）A Use a subreport.B Use a bookmark link.C Use the drilldown functionality.D Use a drillthrough report link.
单选题According to Hancock, the telephone is a preferable medium for promoting sales because _____.Asalesmen can talk directly to their customersBsalesmen may feel less restrained to exaggerateCsalesmen can impress customers as being trustworthyDsalesmen may pass on instant messages effectively
单选题You design a SQL Server 2008 Reporting Services （SSRS） solution. You create a report by using Microsoft Visual Studio .NET 2008. The report contains the following components： A dataset named Customer that lists all active customers and their details. The dataset accepts no parameters. A dataset named SalesHistory that lists all sales transactions for a specified time period and accepts year and month as parameters. You need to ensure that a summary of sales transactions is displayed for each customer after the customer details. Which component should you add to the report？ （）A ListB TableC MatrixD Subreport
多选题Which four actions are possible during an Online Data file Move operation?（）ACreating and dropping tables in the data file being movedBPerforming file shrink of the data file being movedCQuerying tables in the data file being movedDPerforming Block Media Recovery for a data block in the data file being movedEFlashing back the databaseFExecuting DML statements on objects stored in the data file being moved
单选题Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command: ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the outcome of this command?（）AIt produces an error because data already exists in the table.BIt produces an error because compression can be enabled at table creation only.CIt compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.DIt immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.
单选题A sales analyst reviews the first draft on your Sales application, and requests that the application graphically represent revenue generated for each sales representative, in addition to the textual data currently displayed for the ORDER block. How would you incorporate this graphic in your form? （）AInvoke the Chart Wizard and create a chart based on the ORDER block. BCreate a chart using Graphics Builder and then select File Import Chart in Form Builder, positioning the new chart with the text items in the ORDER block. CInvoke the Data Block Wizard in reentrant mode, select the Charts tab, and specify the chart type and column sources for the X and Y axes. DSelect the Chart node in the Object Navigator, Click the Create icon, and specify the details of the chart in the chart's Property Palette.
多选题Examine the details of the Top 5 Timed Events in the following Automatic Workloads Repository (AWR)report:What are three possible causes for the latch-related wait events?（）AThe size of the shared pool is too small.BCursors are not being shared.CA large number COMMITS are being performed.DThere are frequent logons and logoffs.EThe buffers are being read into the buffer cache, but some other session is changing the buffers.
单选题The EMPLOYEES table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table’s primary key is stored in the INDX tablespace. Out of 12 partitions， only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which object will be exported by this command？（） exp system/manager tablespaces=SAMPLEAOnly the EMPLOYEES table.BOnly the EMPLOYEES table and its corresponding primary key index.CThe EMPLOYEES table and partition P1.DThe EMPLOYEES table， IPK_EMP index， and the SALES table.
单选题In your database， the RESULT_CACHE_MODE parameter has been set to MANUAL in the initialization parameter file. You issued the following command： SQLSELECT /*+ RESULT_CACHE */ sale_category， sum（sale_amt） FROM sales GROUP BY sale_category； Where would the result of this query be stored（）？A database buffer cacheB shared poolC PGAD large pool
单选题You are responsible for maintaining a SQL Server 2005 database. Business analysts in the company routinely use a view named v CustomerSales to join the Customers and Sales tables in the database. They use the view to aggregate total sales by customer by month. You need to increase the performance of the view. What should you do？（）AUpdate the view to use an outer join between the Customers and Sales tables.BCreate a clustered index on the v CustomerSales view.CCreate two separate views that do not contain any joinsone view named Customers for the Customers table and another one named v Sales for the Sales table.DCreate a stored procedure for the business analysts that uses the v CustomerSales view.
问答题Practice 2 ●You are the secretary of the manager of the Sales Department. A recent decline in sales volume worried the manager deeply and he wanted to hold a meeting to discuss the reasons at 4 p.m. today in the 2nd Meeting Hall. ●Write a note to all the staff of the Sales Department: ● informing them of the time, place and content of the meeting, ● asking them to sum up the reasons before hand, ● telling them to prepare to discuss in details. ●Write 30-40 words.