You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader directpath load method to perform this task. The table in which you plan to load data is an important tablehaving various integrity constraints defined on it

题目

You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader directpath load method to perform this task. The table in which you plan to load data is an important tablehaving various integrity constraints defined on it.  Which constraints will remain enabled by default during this operation（）

  • A、CHECK
  • B、UNIQUE
  • C、NOT NULL
  • D、PRIMARY KEY
  • E、FOREIGN KEY
相似考题

1.Some of you may have finished unitone, _______, you can move onto unit two.A、if you mayB、if you doC、if notD、if so

2.During REM, ______.A. your eyes move quicklyB. you dreamC. you are restlessD. both A and B

3.What do you plan_________(be) in the future?

4.Cindy: if you don't like where you're living, why don't just move?Joe: ______

更多“You plan to move”相关问题

  • 第1题：

    You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）

    A. The tuned plan is not added to the SQL plan baseline.

    B. The tuned plan is added to the fixed SQL plan baseline as a fixed plan.

    C. The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.

    D. The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.


    参考答案：C

  • 第2题：

    Building a house costs quite a lot of money. Suppose you plan to build a house. Your first step will be to find a right piece of land. Your choice will depend on many different things. You will probably try to find a sunny place, with pleasant surroundings near shops and bus stops, not too far from your friends and the place where you work.
    Next you will find a good builder, and together with the builder you will work out a plan. The builder will draw the plan. It will show the number of rooms, their position and size, and other parts, which must be noticed, such as windows, doors, and electric outlets. The builder will work out how much money is needed to build your house. He will work out the cost of the wood, bricks, the glass, and everything else that must be used in building the house. Later on, when he starts to build, this estimate must be corrected and revised. His estimate is based on existing prices, but prices of such things may change, and many other things may happen between the time when he makes the estimate and the time when he builds the house.
    When the builder gives his estimate, you may wish to change your plan. (You may also wish to change your builder, if his estimate is too high! ) You may find that the house you wanted at first costs too much, or that you can spend a little more and add something to your plan. The builder's estimate depends on the plan, but the final plan depends on the builder's estimate.
    What is the relationship between the estimate and the plan?

    A.The plan depends on the estimate
    B.The estimate depends on the plan
    C.The plan has nothing to do with the estimate
    D.The estimate and the plan depend on each other

    答案：D
    解析：
    本题考查的仍是对短文个别段落和中心意思的理解。短文第三段集中讲的就是和建房方案之间的关系。A项只说出了建房方案对预算的依赖关系；B项只说出预算对建房方案的依赖关系，而忽略它们相互作用的一面，因此都是片面的。而c项说的是建房方案与预算毫不相干，这与短文交代的事实背道而驰．故予以排除。

  • 第3题：

    不要随意地移动稳索。（）

    • A、Don’t shift the guy as you like.
    • B、Don’t shift the stay as you like.
    • C、Don’t move the derrick as you like.
    • D、Don’t move the crane as you like.

    正确答案:A

  • 第4题：

    Which service components develops a plan that identifies the necessary steps to move from an existing system to the Cisco Unified Communications system（）

    • A、Migration Plan Development
    • B、Detailed Design Development
    • C、Staging Plan Development
    • D、Implementation Plan Development

    正确答案:A

  • 第5题：

    Using Oracle Scheduler you have scheduled two jobs， JOB_A and JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）

    • A、 A window must have been created with the WEEKEND_PLAN resource plan.
    • B、 A program must have been created with the WEEKEND_PLAN resource plan.
    • C、 A job class must have been created with the WEEKEND_PLAN resource plan.
    • D、 A windows group must have been created with the WEEKEND_PLAN resource plan.

    正确答案:A

  • 第6题：

    You have an Exchange Server 2010 Service Pack 1 （SP1） server that hosts a public folder database named PUBLIC.You need to move the transaction log files of PUBLIC. Which cmdlet should you run？（）

    • A、Move-DatabasePath
    • B、Move-StorageGroupPath
    • C、Set-PublicFolderDatabase
    • D、Set-MailPublicFolder

    正确答案:A

  • 第7题：

    单选题
    The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement：       SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’；  What will be the outcome of this statement？（）
    A

     The statement will deactivate DAY_PLAN.

    B

     The statement will activate DAY_PLAN as the top plan.

    C

     The statement will activate MANAGERS_PLAN as the top plan.

    D

     The statement will return an error because MANAGERS_PLAN is not the top plan.


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

  • 第8题：

    单选题
    Move Plan are experts at organizing both large and small moves.
    A

    Right.

    B

    Wrong.

    C

    Doesn’t say.


    正确答案： A
    解析：
    文中第二段第一句提到“…Move Plan…organizes relocation for firms from two to 6,000 people”，由此可知本题“Move Plan在组织大规模和小规模的搬家方面十分专业”的说法是正确的。

  • 第9题：

    单选题
    Using Oracle Scheduler you have scheduled two jobs， JOB_A and JOB_B， to run at 9：00 p.m. every Friday. You want both the jobs to use a single resource plan， WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective？（）
    A

     A window must have been created with the WEEKEND_PLAN resource plan.

    B

     A program must have been created with the WEEKEND_PLAN resource plan.

    C

     A job class must have been created with the WEEKEND_PLAN resource plan.

    D

     A windows group must have been created with the WEEKEND_PLAN resource plan.


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

  • 第10题：

    单选题
    You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan？（）
    A

     assign users to consumer groups

    B

     set the resource plan for the instance

    C

     configure a simple resource plan and specify plan directives

    D

     configure a complex resource plan and specify plan directives


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

  • 第11题：

    单选题
    The servers on your network run Windows Server 2008 R2. You are planning a two-node Hyper-V failover cluster with SAN storage， and 16 virtual machines （VMs）.  You plan to use quick migration. You need to place the maximum number of VMs on each logical unit number （LUN）. You need to ensure that you can move individual VMs between cluster nodes without affecting other VMs.  How many VMs should you place on each LUN？（）
    A

    one

    B

    two

    C

    four

    D

    eight


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

  • 第12题：

    单选题
    You have created a resource plan， DB_PLAN， using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users.   Which step must be performed before you can start using the resource plan？（）
    A

    assign users to consumer groups

    B

    set the resource plan for the instance

    C

    configure a simple resource plan and specify plan directives

    D

    configure a complex resource plan and specify plan directives


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

  • 第13题：

    Your Windows 2000 Professional computer contains a single hard disk configured as a single partition.

    You want to move a folder named Sales under a folder named Corp on your computer.

    You want the files in the Sales folder to remain compressed after moving the folder. You want the files in the Corp folder to remain uncompressed. You want to ensure that the files are recoverable in case of any disk problems. You also want to move the files with the least amount of administrative effort.

    What should you do?

    A．Copy the Sales folder to the Corp folder. Do nothing further.

    B．Backup the Sales folder. Move the Sales folder to the Corp folder.

    C．Compress the Corp folder. Then copy the Sales folder to the Corp folder.

    D．Move the Sales folder to a second computer. Then move the Sales folder to the Corp folder.


    正确答案：B
    解析：Explanation: The contents of the Sales folder should be backed up so that files would be recoverable in case of disk problems. You could move the Sales folder to the CORP folder, as the files will remain compressed since the folder is moved within a single partition. The general rules on copying and moving compressed files and folder are: files and folders copied within a NTFS volume and between NTFS volumes inherit the compression state of the target folder; files and folders moved between NTFS volumes inherit the compression state of the target folder; and files and folders moved within an NTFS volume retain the original compression state of the file or folder.

    Incorrect Answers:
    A: A folder copied within an NTFS partition will inherit the compression state of the target folder. This will result in the Sales folder inheriting the uncompressed state of the CORP folder since the target folder is uncompressed. Furthermore, you are also required to ensure that the folder contents are recoverable in the event of a system failure. This solution does not make provision for the recovery of the folder.

    C: A folder copied within an NTFS partition will inherit the compression state of the target folder. This will result in the Sales folder losing its compressed state since the target folder is uncompressed. Compressing the CORP folder is also not a viable solution, as the scenario explicitly requires you to retain the uncompressed state of the files in the CORP folder. Furthermore, you are also required to ensure that the folder contents are recoverable in the event of a system failure. This solution does not make provision for the recovery of the folder.

    D: Files and folders that are moved between NTFS partitions inherit the compression state of the target folder. Therefore the Sales folder might lose its compression state. Furthermore, moving the Sales folder twice is unnecessary as this will not ensure recoverability of the files in the Sales folder.

  • 第14题：

    Do you have any plan this year?（）

    AHow about you?

    BI plan to go to the United States for further studies.  

    CYes, I will. 

    DI'm certainly not going to do that kind of thing.


    B
    略

  • 第15题：

    You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）

    • A、Use the external table population.
    • B、Use the Oracle Data Pump export and import utility.
    • C、Use the conventional path data load of the SQL*Loader utility.
    • D、Use the INSERT INTO...SELECT command to load the data

    正确答案:C

  • 第16题：

    The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement：       SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’；  What will be the outcome of this statement？（）  

    • A、 The statement will deactivate DAY_PLAN.
    • B、 The statement will activate DAY_PLAN as the top plan.
    • C、 The statement will activate MANAGERS_PLAN as the top plan.
    • D、 The statement will return an error because MANAGERS_PLAN is not the top plan.

    正确答案:C

  • 第17题：

    You have an Exchange Server 2010 server that has a single mailbox database named DB1.You need to move the transaction log files of DB1.Which cmdlet should you run？（）

    • A、Move-DatabasePath
    • B、Move-Mailbox
    • C、Set-ExchangeServer
    • D、Set-MailboxDatabase

    正确答案:A

  • 第18题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. You put forward a database maintenance plan. The maintenance plan rebuilds indexes, checks database integrity, writes a report to a text file. Now the company requires that when the maintenance plan executes abnormally, the operators can be notified by an e-mail message. You've been assigned this task. So you have to make modifications on the SQL Server instance. What should you do?（）

    • A、For the SQL Server Agent, you should enable a fail-safe operator 
    • B、You should modify the database maintenance plan, making it send an e-mail to the appropriate operators 
    • C、You should modify the database maintenance plan, making it include a Notify Operator task that e-mails the appropriate operators. 
    • D、You should modify the SQL Server Agent job. The job executes the database maintenance plan to notify the appropriate operators.

    正确答案:D

  • 第19题：

    单选题
    You execute the following block of code：   SQL>BEGIN   DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN   （ SIMPLE_PLAN => ’DEPARTMENTS’，   CONSUMER_GROUP1 => ’PAYROLLL’，   GROUP1_CPU => 50，   CONSUMER_GROUP2 => ’SALES’，   GROUP2_CPU => 25，   CONSUMER_GROUP3 => ’MARKETING’，   GROUP3_CPU => 25）；   END；   SQL>/   What is a prerequisite for using the simple resource plan created by executing the above code？（）
    A

     You must assign users to consumer groups.

    B

     You must grant the switch privilege to the users.

    C

     You must create a resource plan directive.

    D

     You must specify the complex resource plan.


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

  • 第20题：

    多选题
    You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it.  Which constraints will remain enabled by default during this operation（）
    A

    CHECK

    B

    UNIQUE

    C

    NOT NULL

    D

    PRIMARY KEY

    E

    FOREIGN KEY


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

  • 第21题：

    单选题
    You run the SQL Tuning Advisor (STA) to tune a SQL statement that is part of a fixed SQL plan baseline. The STA generates a SQL profile for the SQL statement, which recommends that you accept the profile. Which statement is true when you accept the suggested SQL profile?（）
    A

    The tuned plan is not added to the SQL plan baseline.

    B

    The tuned plan is added to the fixed SQL plan baseline as a fixed plan.

    C

    The tuned plan is added to the fixed SQL plan baseline as a nonfixed plan.

    D

    The tuned plan is added to a new nonfixed SQL plan baseline as a nonfixed plan.


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

  • 第22题：

    单选题
    You create a virtual machine （VM） on a Windows Server 2008 R2 Hyper-V server. You plan to use this VM as the base image for new VMs. You need to ensure that you can import the base image multiple times on the original host server. In the Import Virtual Machine Wizard，which settings should you configure during each import process？（）
    A

    Select the Copy the virtual machine option and the Duplicate all files check box.

    B

    Select the Copy the virtual machine option. Clear the Duplicate all files check box.

    C

    Select the Move or restore the virtual machine option and the Duplicate all files check box. 

    D

    Select the Move or restore the virtual machine option. Clear the Duplicate all files check box.


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

  • 第23题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）
    A

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


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

  • 第24题：

    单选题
    Thank you for the______ you did me to move the sofa upstairs.
    A

    favor

    B

    good

    C

    offer

    D

    aid


    正确答案： D
    解析：

相关内容