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

题目

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.

相似考题

1.Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?()A. PLSQL_BLOCKB. JAVA_STORED_PROCEDUREC. STORED_PROCEDURED. EXECUTABLEE. None of the above are invalid settings.

2.WhichscriptmustyoutoquerytodisplaythecodeassociatedwithRMANstoredscripts?()A.RC_STORED_SCRIPTB.RC_STORED_SCRIPT_LINEC.RC_SCRIPTSD.RC_STORED_LINE_SCRIPTE.Noneoftheotheralternativesapply

3.有下列程序:includeUsing namespace std;Class Amount{ int amount;public; Amount(i有下列程序： #include＜iostream＞ Using namespace std; Class Amount{ int amount; public; Amount(int n=O):amount(n){} Int getAmount()const{return amount;} Amount &operator+=(AmountA) {A．*thisB．thisC．&amountD．amount

4.Which of the following are valid program types for a lightweight job?()A. PLSQL_BLOCK PLSQLB. EXECUTABLEC. JAVA_STORED_PROCEDURED. STORED_PROCEDUREE. EXTERNAL

参考答案和解析
参考答案：C
更多“Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of ”相关问题

  • 第1题：

    WhatarethedirectorydetailsofRelationalDatabasebackupfilescreatedbyIBMTivoliAccessManagerforEnterpriseSingleSign－OnV8.0.1housekeeping?()

    A.Thedirectorymustexistwithonesubdirectory（general）.

    B.Thedirectorymustexistwithtwosubdirectories（daily，weekly）.

    C.Thedirectorymustexistwiththreesubdirectories（daily，weekly，monthly）.

    D.Thedirectorymustexistwithfoursubdirectories（general，daily，weekly，monthly）.


    参考答案：C

  • 第2题：

    Evaluate this SQL statement:e.employee_id, (.15* e.salary) + (.5 * e.commission_pct)+ (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUEFROM employees e, sales sWHERE e.employee_id = s.emp_id;What will happen if you remove all the parentheses from the calculation?（）

    A.The value displayed in the CALC_VALUE column will be lower.

    B.The value displayed in the CALC_VALUE column will be higher.

    C.There will be no difference in the value displayed in the CALC_VALUE column.

    D.An error will be reported.


    参考答案：C

  • 第3题：

    7、BookStore数据库中有销售明细表OrderDetail（OrderCode, BookCode, Amount) 查询销售总量前20%的图书，并按总销量降序排列。SQL语句： SELECT TOP 20 PERCENT Bookcode As 书号, SUM（Amount)As总销量 ROM OrderDetail GROUP BY Bookcode ORDER BY ________

    A．Amount DESC

    B．SUM(Amount) DESC

    C．COUNT(Amount) DESC

    D．ADD(Amount) DESC


    SUM(Amount) DESC

  • 第4题：

    The operation of removing an element from the stack is said to（ ）the stack.

    A. pop B. push C. store D. fetch


    正确答案：A

  • 第5题：

    Techniques to harness such energy are yet to be developed.

    A:convert
    B:utilize
    C:store
    D:receive

    答案：B
    解析：
    本句意思：目前还没有利用这种能量的技术。convert的意思为“转变，使改变信仰”;uti- lize的意思为“利用”;store作动词的意思为“储存”;receive的意思为“收到”。harness的意思为 “利用，治理”，和utilize的意思接近。

  • 第6题：

    BookStore数据库中有销售明细表OrderDetail（OrderCode, BookCode, Amount) 查询销售总量前20%的图书，并按总销量降序排列。SQL语句： SELECT TOP 20 PERCENT Bookcode As 书号, SUM（Amount)As总销量 ROM OrderDetail GROUP BY Bookcode ORDER BY ________

    A．Amount DESC

    B．SUM(Amount) DESC

    C．COUNT(Amount) DESC

    D．ADD(Amount) DESC


    INSERT INTO OrderDetail(OrderCode, Amount, BookCode) VALUES('08110801',3, '0701');INSERT INTO OrderDetail(OrderCode, BookCode, Amount) VALUES('08110801', '0701', 3);INSERT INTO OrderDetail VALUES('08110801', '0701', 3)

相关内容