itgle.com

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.
相似考题

1.A new internal auditor, Daisy Rosepetal, has recently joined Bluebell Co. She has been asked by management toestablish and to monitor a variety of social and environmental Key Performance Indicators (KPIs). Daisy has noexperience in this area, and has asked you for some advice. It has been agreed with Bluebell Co’s audit committeethat you are to provide guidance to Daisy to help her in this part of her role, and that this does not impair theobjectivity of the audit.(c) Recommend EIGHT KPIs which could be used to monitor Bluebell Co’s social and environmentalperformance, and outline the nature of evidence that should be available to provide assurance on theaccuracy of the KPIs recommended. Your answer should be in the form. of briefing notes to be used at ameeting with Daisy Rosepetal. (10 marks)Note: requirement (c) includes 2 professional marks.

2.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.

3.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.B.C.D.

4.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. resolveB. indirectC. next-hopD. recursive

更多“A DBA has been asked to create a”相关问题

  • 第1题：

    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

  • 第2题：

    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命令，订购。

  • 第3题：

    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

  • 第4题：

    A technician has been given a task to create a separate location for disaster recovery. Thecompany has very high uptime requirements and will lose money if there is any downtime. Whichof the following deployments should the technician consider？（）

    • A、Hot site
    • B、Warm site
    • C、Fault tolerant site
    • D、Cold site

    正确答案:A

  • 第5题：

    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

  • 第6题：

    Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）

    • A、The table created by SKD is not accessible and SKD cannot create new tables.
    • B、The tables created by SKD and HR remain， but both cannot create new tables.
    • C、The table created by HR remains and HR still has the CREATE TABLE system privilege.
    • D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.

    正确答案:C

  • 第7题：

    TestKing.com has a SQL Server 2005 computer. You have been assigned the task of retrieving information about a user who is currently logged in. You need to create a function that returns scalar information about the activity time for a particular user. What are two possible ways to achieve this goal？（）

    • A、Create a function that returns a list of values that represent the login times for the given user.
    • B、Create a function that returns a list of values that represent the people who have logged more hours than the current user has logged.
    • C、Create a function that returns a numeric value that represents the number of hours that a user has logged for the current day.
    • D、Create a function that returns a numeric value that represents the number of hours that a user has logged for the current month.

    正确答案:C,D

  • 第8题：

    单选题
    Mr. Sanders has been asked to（）the next meeting of the committee.
    A

    manage

    B

    chair

    C

    listen

    D

    think


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

  • 第9题：

    单选题
    Examine the following steps performed on a database instance：  1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION.  2：The SKD usercreates a table.  3：The SKD user grants theCREATETABLE system privilege to the HR user.  4：The HR user creates a table.  5：The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 is performed（）
    A

    The table created by SKD isnot accessibleand SKD cannot create new tables.

    B

    The tables created by SKD and HR remain， but both cannot create new tables.

    C

    The table created by HR remains and HR still has the CREATE TABLE system privilege.

    D

    The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.


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

  • 第10题：

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


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

  • 第11题：

    单选题
    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
    解析： 暂无解析

  • 第12题：

    单选题
    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
    解析： 暂无解析

  • 第13题：

    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
    解析：
    我们公司的政策一直是鼓励员工发挥他们的才能，创造更多的财富。.

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    A system administrator has been asked to install an APAR but wants to be able to easily remove it. Which install option should be used？（）

    • A、apply
    • B、cleanup
    • C、commit
    • D、reject

    正确答案:A

  • 第17题：

    A system administrator has been asked to document the hardware configuration of a system. Which command can be used to assist in this task？（）

    • A、lscfg
    • B、mkdev
    • C、lslpp
    • D、cfgmgr

    正确答案:A

  • 第18题：

    You define an alert to be raised when the USERS tablespace usage has reached 80% of the total space. Which area would you refer to， in order to confirm that the alert has been raised due the event？（）

    • A、the alert.log file
    • B、the DBA_ALERTS view
    • C、the Database Control Home page
    • D、the Database Control performance page
    • E、the Database Control Maintenance page

    正确答案:C

  • 第19题：

    单选题
    You work as an application developer at Certkiller .com. You have been asked by you superiors at Certkiller .com to create a child application domain.  The new child application domain has to specify a different assembly path than that of the parent application domain.You need to ensure that your solution meets Certkiller .com’s requirements.What should you do？（）
    A

    A

    B

    B

    C

    C

    D

    D


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

  • 第20题：

    单选题
    The company’s ______ regarding casual dress has been revised in order to create a friendly working environment.
    A

    policy

    B

    preparation

    C

    symbol

    D

    customs


    正确答案： C
    解析：
    句意：公司已经修改了关于着便装的规定，以创造一个轻松友好的工作氛围。根据上下文，此处意为“公司政策”，因此选择A。preparation准备。customs进口税；海关。

  • 第21题：

    填空题
    What has been done by the heating system supplier?____ has been asked to find out the cause of the accident.

    正确答案： A surveyor
    解析：
    从第二封信第一段的最后一句“We have asked a surveyor to find out the cause of the explosion”可知，此处应填写A surveyor。

  • 第22题：

    多选题
    As the DBA， you run the following query on your ASM instance. What is the implication of the results of the query？（） SQL> select group_number， name， state from v$ASM_DISKGROUP；  GROUP_NUMBER NAME STATE  0 DGROUP1 DISMOUNTED  2 DGROUP2 MOUNTED  3 DGROUP3 MOUNTED
    A

    The DGROUP1 disk group was unmounted by another DBA.

    B

    A datafile has been lost， causing the ASM disk group DGROUP1 to go into the DISMOUNTED state

    C

    One of the redundant disks （DGROUP1） has been lost in a disk group.

    D

    This query has no meaning in an ASM instance.

    E

    A disk associated with a disk group was discovered after the ASM instance initially opened.


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

  • 第23题：

    单选题
    Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD.  Which statement is true after step 5 isperformed（）
    A

    The table created by SKD is not accessible and SKD cannot create new tables.

    B

    The tables created by SKD and HR remain， but both cannot create new tables.

    C

    The table created by HR remains and HR still has the CREATE TABLE system privilege.

    D

    The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.


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

相关内容