首页计算机考试Oracle认证
(多选题)

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()

ACHECK

BUNIQUE

CNOT NULL

DPRIMARY KEY

EFOREIGN KEY

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    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?()

    答案解析

  • (多选题)

    You are managing an Oracle Database 11g database. The database is open, and you plan to  performRecovery Manager (RMAN) backups.  Which three statements are true about these backups()

    答案解析

  • (单选题)

    Click the Exhibit(s) button to view the DEPARTMENTS plan.    After analyzing the Exhibit, what conclusion will you draw?()  

    答案解析

  • (多选题)

    You are managing an Oracle Database 11g database. The database is open, and you plan to perform Recovery Manager (RMAN) backups.  Which three statements are true about these backups()

    答案解析

  • (单选题)

    You create two resource plans,one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.  How would you achieve this?()  

    答案解析

  • (多选题)

    When executing a SQL workload,you choose to generate execution plans only, without collecting execution statistics.  Which two statements describe the implications of this?()

    答案解析

  • (单选题)

    You want to access employee details contained in flat files as part of the EMPLOYEE table. You plan to add anew column to the EMPLOYEE table to achieve this.  Which data type would you use for the new column()

    答案解析

  • (多选题)

    You plan to use SQL Performance Analyzer to analyze the SQL workload. You created a SQL Tuning Set as a part of the workload capturing.  What information is captured as part of this process?()

    答案解析

  • (多选题)

    In your production database, you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager.  For which three resources can you enable usage restrictions by using Resource Manager?()

    答案解析

  • (多选题)

    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()

    答案解析

快考试在线搜题