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 t

题目

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

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

You have been asked to establish reachability between Router 1‘s and Router 2‘s loopback addresses as shown in the exhibit. Which two steps will accomplish this task?()

A. Create a static route on Router 1 to 172.17.28.1 with a next hop of 10.10.10.2.

B. Create a static route on Router 1 to 172.17.28.1 with a next hop of 10.10.10.1.

C. Create a static route on Router 2 to 172.17.25.1 with a next hop of 10.10.10.1.

D. Create a static route on Router 1 to 172.17.25.1 with a next hop of 10.10.10.2.

参考答案：A, C

第2题：

Refer to the exhibit. Switch port FastEthernet 0/24 on AlSwitch1 will be used to create an IEEE 802.1Q- complaint trunk to another switch. Based on the output shown, What is the reason the trunk does not form, even thought the proper cabling has been attached?（）

A.VLANs have not been created yet

B.An IP address must be configured for the port

C.The port is currently configured for access mode

D.The correct encapsulation type has not been configured

E.The no shutdown command has not been entered for the port

参考答案：C

第3题：

A new internal auditor, Daisy Rosepetal, has recently joined Bluebell Co. She has been asked by management to

establish and to monitor a variety of social and environmental Key Performance Indicators (KPIs). Daisy has no

experience in this area, and has asked you for some advice. It has been agreed with Bluebell Co’s audit committee

that you are to provide guidance to Daisy to help her in this part of her role, and that this does not impair the

objectivity of the audit.

performance, and outline the nature of evidence that should be available to provide assurance on the

accuracy of the KPIs recommended. Your answer should be in the form. of briefing notes to be used at a

meeting with Daisy Rosepetal. (10 marks)

Note: requirement (c) includes 2 professional marks.

正确答案：

第4题：

You have been asked to use a 28 bit subnet mask to segment the following network block: 108.12.5.0. How many usable hosts per sub-net could you create?（）

A、10 hosts
B、14 hosts
C、12 hosts
D、16 hosts

正确答案:B

第5题：

A large sum of money has been allocated ated for buying new books for the library.

A:assigned
B:persuaded
C:asked
D:ordered

答案：A

解析：

本句意思：一大笔款项被拨给了图书馆来购买新书。allocate意思是“分配，分派，把……拨给”，与assign（分配，选派）意思相近。persuade说服，劝说；ask要求，询问；order命令，订购。

第6题：

Certkiller .com has asked you to create a file management application to monitor the hosts file.Certkiller .com has instructed you to change the hosts file if it has been changed.You, therefore, need to display the size and whether the hosts file is set to read-only.What should you do?（）

参考答案：A

第7题：

It has always been our company's ( ) to encourage employeesto use their talents and create more wealth.

A. policy
B. procedure
C. campaign
D. Plan

答案：A

解析：

我们公司的政策一直是鼓励员工发挥他们的才能，创造更多的财富。.

第8题：

You have been asked to create a static route with a next hop that is not directly connected to the router. Which configuration parameter enables the static route to accomplish this scenario?()

A. resolve

B. indirect

C. next-hop

D. recursive

参考答案：A

第9题：

Management has asked the server technician to deploy fourteen new servers with newly-released operating systems in the virtual environment for testing purposes. Which of the following is the FASTEST way to do this？（）

A、Create a template of an existing server and deploy the fourteen images from that server.
B、Create a server template， and deploy all fourteen servers from this template.
C、Create one server， create a backup image， and restore thirteen servers from the image.
D、Create each server individually.

正确答案:B

第10题：

You are designing an application for a telecom company 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

A DBA has been asked to create a

题目

参考答案和解析

相似问题和答案

更多相关问题

相关内容