单选题A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal o

题目
单选题
A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）
A

Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.

B

Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.

C

Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.

D

Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.

相似考题

1.Which of the following networking methods allows us to show that the last % of one element cannot be completed until % of a previous element has been completed?A.PERTB.ADMC.PDMD.All of the above.E.A and C only.

2.43 Which of the following networking methods allows us to show that the last 10% of one element cannot be completed until 62% of a previous element has been completed?A. PERTB. ADMC. PDMD. All of the above.E. A and C only.

3.Which three statements are characteristic of the MEMORY storage engine?()A.It can support transactionsB.Table contents are not saved if the server is restartedC.It cannot contain text or BLOB columnsD.It can support foreign keysE.Each table is represented on disk as an.frm fileF.Each table has a corresponding.MYI and .MYD file

4.161 Which of the following networking methods allows us to show that the last 10% of one element cannot be completed until 62% of a previous element has been completed?A. PERTB. ADMC. PDMD. All of the above.E. A and C only

更多“单选题A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal o”相关问题

  • 第1题：

    Which of the following would contain information regarding network device alerts using SNMP?()

    A. Syslog

    B. Audit log

    C. History log

    D. Ping sweep reports


    参考答案：A

  • 第2题：

    Which of the following would contain information regarding network device alerts using SNMP?（）

    • A、Syslog
    • B、Audit log
    • C、History log
    • D、Ping sweep reports

    正确答案:A

  • 第3题：

    Which of the following archiving methods only backs up data that has changed since the previous backup？（）

    • A、Differential
    • B、Copy
    • C、Incremental
    • D、Snapshot

    正确答案:C

  • 第4题：

    Which of the following are TRUE about a store archive？（）

    • A、It is an XML file containing store data assets
    • B、It uses the same file format as a ZIP file
    • C、It contains file assets to create a store or site
    • D、It can easily be copied from one machine to another
    • E、It can contain WebSphere Commerce instance configuration information

    正确答案:B,C,D

  • 第5题：

    As A DBA， which of the following methods can you use to make a backup of your table？（）

    • A、Recover Manager （RMAN） utility
    • B、Import utility
    • C、Export utility
    • D、O/S backup command

    正确答案:C

  • 第6题：

    Which three statements are characteristic of the MEMORY storage engine?（）

    • A、It can support transactions
    • B、Table contents are not saved if the server is restarted
    • C、It cannot contain text or BLOB columns
    • D、It can support foreign keys
    • E、Each table is represented on disk as an.frm file
    • F、Each table has a corresponding.MYI and .MYD file

    正确答案:B,C,E

  • 第7题：

    单选题
    As A DBA， which of the following methods can you use to make a backup of your table？（）
    A

    Recover Manager （RMAN） utility

    B

    Import utility

    C

    Export utility

    D

    O/S backup command


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    Which statement is true about the forwarding table?（）
    A

    The forwarding table is stored in the control plane only.

    B

    The forwarding table is stored in the control plane and in the forwarding plane.

    C

    The forwarding table contains both active and inactive routes.

    D

    The forwarding table can contain only a single next hop per destination.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    Which of the following would contain information regarding network device alerts using SNMP?（）
    A

    Syslog

    B

    Audit log

    C

    History log

    D

    Ping sweep reports


    正确答案： D
    解析： 暂无解析

  • 第11题：

    单选题
    Which of the following archiving methods only backs up data that has changed since the previous backup？（）
    A

    Differential

    B

    Copy

    C

    Incremental

    D

    Snapshot


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    A system administrator has been asked to lock a specific login account. Which of the following commands is used to accomplish this？（）
    A

    pwdck

    B

    usrck

    C

    chuser

    D

    rmuser


    正确答案： C
    解析： 暂无解析

  • 第13题：

    Consequently,there has been a growing interest in natural foods:foods which do not contain additives and which have not been（ ）by chemical fertilizers widely used in farming today.

    A.effected
    B.interfered
    C.disturbed
    D.affected

    答案：D
    解析：
    自然食品不受当今农业生产中广泛使用的化肥的影响。所以D.affect“影响，产生作用”是正确答案。A.effect“结果，效果”；B.interfere“干预，妨碍”；C.disturb“打扰”。

  • 第14题：

    Which statement is true about the forwarding table?（）

    • A、The forwarding table is stored in the control plane only.
    • B、The forwarding table is stored in the control plane and in the forwarding plane.
    • C、The forwarding table contains both active and inactive routes.
    • D、The forwarding table can contain only a single next hop per destination.

    正确答案:B

  • 第15题：

    A DBA has been asked to create a table which will contain a substantial amount of detailed sales information for each calendar month and maintain it to contain only the last 12 months. Which of the following methods will facilitate the online removal of the oldest month’s data?（）

    • A、Create an MQT that selects the oldest month of data with the REFRESH IMMEDIATE option.
    • B、Create 12 separate tables, create a view based on all 12, drop the table with the oldest month's data then drop and re- create the view.
    • C、Create a range partitioned table, partitioned by month, and use the ALTER TABLE statement to detach the oldest month and attach storage for new data.
    • D、Create a single table, extract the data to be retained using UNLOAD with a SELECT statement, drop and re-create the table then load only the data to be retained.

    正确答案:C

  • 第16题：

    Which statement is true about the forwarding table?（）

    • A、The forwarding table is stored in the control plane only
    • B、The forwarding table is stored in the control plane and in the forewarding plane
    • C、The forwarding table contains both active and inactive routes
    • D、The forwarding table can contain only sigle next hop per destination

    正确答案:B

  • 第17题：

    In which scenario， will you issue the following command？（） RMAN> REPORT NEED BACKUP DAYS 7；

    • A、 to configure RMAN to maintain backup information in the RMAN repository for seven days
    • B、 to configure RMAN to maintain backup information in the control file for at least seven days
    • C、 to display the list of files that have not been backed up for the last seven days
    • D、 to display the list of files that must be backed up within seven days

    正确答案:C

  • 第18题：

    You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）

    • A、 create a hash cluster to store the data
    • B、 create an index cluster to store the data
    • C、 create a partitioned table to store the data
    • D、 create a sorted hash cluster to store the data
    • E、 create a heap table with rowid to store the data

    正确答案:D

  • 第19题：

    单选题
    Which of the following archiving methods only backs up data that has changed since the previous full backup?（）
    A

    Snapshot

    B

    Incremental

    C

    Copy

    D

    Differential


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    In which scenario， will you issue the following command？（） RMAN> REPORT NEED BACKUP DAYS 7；
    A

     to configure RMAN to maintain backup information in the RMAN repository for seven days

    B

     to configure RMAN to maintain backup information in the control file for at least seven days

    C

     to display the list of files that have not been backed up for the last seven days

    D

     to display the list of files that must be backed up within seven days


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    Which statement is true about the forwarding table?（）
    A

    The forwarding table is stored in the control plane only

    B

    The forwarding table is stored in the control plane and in the forewarding plane

    C

    The forwarding table contains both active and inactive routes

    D

    The forwarding table can contain only sigle next hop per destination


    正确答案： A
    解析： 暂无解析

  • 第22题：

    单选题
    The company auditors require a System p administrator to archive detailed information from each of their systems.  Which of the following commands will accomplish this task（）
    A

    snap -a

    B

    snap -i

    C

    prtconf

    D

    lsconf


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    You are designing an application for Certkiller .com and you have been asked to design a database table to facilitate monthly bill generation. The bill would include details of customer calls， listed in chronological order.Which method would you follow to achieve this objective without increasing the overhead of sorting the rows？（）
    A

     create a hash cluster to store the data

    B

     create an index cluster to store the data

    C

     create a partitioned table to store the data

    D

     create a sorted hash cluster to store the data

    E

     create a heap table with rowid to store the data


    正确答案： D
    解析： 暂无解析

相关内容