单选题Which of the following parameters would you use to record the errors that might be generated during the import operation?()A LOGB HELPC BUFFERD PARFILEE INCTYPE

题目
单选题
Which of the following parameters would you use to record the errors that might be generated during the import operation?()
A

LOG

B

HELP

C

BUFFER

D

PARFILE

E

INCTYPE


相似考题
更多“单选题Which of the following parameters would you use to record the errors that might be generated during the import operation?()A LOGB HELPC BUFFERD PARFILEE INCTYPE”相关问题
  • 第1题:

    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

  • 第2题:

    Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run?()

    • A、 use DBMS_IJOB package
    • B、 use Oracle Scheduler
    • C、 use DBMS_JOB package
    • D、 use Oracle Data Pump Export and Import

    正确答案:B

  • 第3题:

    You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEES table. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area.  Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()

    • A、perform point-in-time recovery
    • B、perform a Flashback Table operation to restore the table to the state it was in two days ago
    • C、perform a Flashback Database operation to restore the database to the state it was in two days ago
    • D、perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery

    正确答案:D

  • 第4题:

    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

    正确答案:C

  • 第5题:

    Which two statements are true regarding the Oracle Data Pump export and import operations()

    • A、You cannot export data from a remote database.
    • B、You can rename tables during an import operation.
    • C、You can overwrite existing dump files during an export operation.
    • D、You can compress the data during export but not the metadata because it is not supported.

    正确答案:B,C

  • 第6题:

    Which of the following dynamic view would you query to identify the online CURRENT redo log group?()

    • A、V$LOG
    • B、V$LOFHIST
    • C、V$LOGFILE
    • D、V$LOG_HISTORY

    正确答案:A

  • 第7题:

    The ORACLE_SID environment variable is set to +ASM. ASMLIB is not used in the configuration. You executed the following command to startup the Automatic Storage Management (ASM) instance. SQL> STARTUP; Which two activities are performed during a successful start up operation?()

    • A、The databases configured to use the ASM instance are mounted
    • B、The disk groups are mounted as per the ASM_DISKGROUPS initialization parameter
    • C、ASM starts the Oracle Cluster Synchronization Services (CSS) daemon if it is not started
    • D、ASM discovers and examines the contents of all files that are in the paths specified in the ASM_DISKGROUPS initialization parameters

    正确答案:B,C

  • 第8题:

    单选题
    In which situation would you use the Oracle Shared Server configuration?()
    A

    when performing export and import using Oracle Data Pump

    B

    when performing backup and recovery operations using Oracle Recovery Manager

    C

    when performing batch processing and bulk loading operation in a data warehouse environment 

    D

    in an online transaction processing (OLTP) system where large number of client sessions are idle most of the time


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

  • 第9题:

    单选题
    Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record the status of the operation?()
    A

     ADD DIRECTORY

    B

     DROP DISK

    C

     RESIZE DISK

    D

     REBALANCE

    E

     ADD FAILGROUP


    正确答案: E
    解析: 暂无解析

  • 第10题:

    单选题
    You are developing a client application that consumes a Windows Communication Foundation (WCF) service. You use the svcutil.exe utility to create a proxy for the service. You use the svcutil.exe switches that generate asynchronous calls. GetFlight is a service operation that takes no parameters and returns a string. The GetFlightCallback method must be called when the service operation returns.You create an instance of the client proxy with the following code:var client = new TranvelServiceClient( );You need to ensure that a callback is received when the GetFlight operation is called asynchronously. Which code segment should you use?()
    A

    client.BeginGetFlight(GetFlightCallback, null); client.GetFlight();

    B

    client.GetFlight(); client.BeginGetFlight(GetFlightCallback, null);

    C

    client.GetFlightCompleted += new EventHandler(GetFlightCallback); client.GetFlightAsync();

    D

    IAsyncResult asyncResult = client.BeginGetFlight(GetFlightCallback, client); client.EndGetFlight(asyncResult);


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

  • 第11题:

    单选题
    Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()
    A

    Because row IDs may change during the flashback operation

    B

    Because the object number changes after the flashback operation

    C

    Because the rows are retrieved from the recycle bin during the flashback operation

    D

    Because the table is moved forward and back to a temporary during the flashback operation


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

  • 第12题:

    单选题
    Which of the following parameters would you use to record the errors that might be generated during the import operation?()
    A

    LOG

    B

    HELP

    C

    BUFFER

    D

    PARFILE

    E

    INCTYPE


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

  • 第13题:

    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

  • 第14题:

    Which  statements are true regarding the Oracle Data Pump export and import operations()

    • A、You cannot export data from a remote database.
    • B、You can rename tables during an import operation.
    • C、You can overwrite existing dump files during an export operation.
    • D、You can compress the data during export but not the metadata because it is not supported

    正确答案:B,C

  • 第15题:

    You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance, you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data, you want to have minimal impact on the database performance and optimize thedata load 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 production database has been functional for the last seven days. Because of application requirements, some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information?()

    • A、fixed views
    • B、the alert log file
    • C、the parameter file
    • D、the server parameter file
    • E、dynamic performance views

    正确答案:B

  • 第17题:

    You work as a database administrator at Certkiller .com. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEEStable. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()

    • A、 perform point-in-time recovery
    • B、 perform a Flashback Table operation to restore the table to the state it was in two days ago
    • C、 perform a Flashback Database operation to restore the database to the state it was in two days ago
    • D、 perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery

    正确答案:D

  • 第18题:

    Which of the following parameters would you use to record the errors that might be generated during the import operation?()

    • A、LOG
    • B、HELP
    • C、BUFFER
    • D、PARFILE
    • E、INCTYPE

    正确答案:A

  • 第19题:

    单选题
    You work as a database administrator at Certkiller .com. You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEEStable. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()
    A

     perform point-in-time recovery

    B

     perform a Flashback Table operation to restore the table to the state it was in two days ago

    C

     perform a Flashback Database operation to restore the database to the state it was in two days ago

    D

     perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery


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

  • 第20题:

    单选题
    The production database has been functional for the last seven days. Because of application requirements, some of the initialization parameters were changed during run time without any comments. You have asked to find out the value of the parameters when the instance was started.Which source would you use to locate this information?()
    A

     Fixed views

    B

     The alert log file

    C

     The parameter file

    D

     The server parameter file

    E

     Dynamic performance views


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

  • 第21题:

    单选题
    Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?()
    A

    Because row IDs may change during the flashback operation

    B

    Because the object number changes after the flashback operation

    C

    Because the rows are retrieved from the recycle bin during the flashback operation

    D

    Because the table is moved forward and back to a temporary during the flashback opertion


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

  • 第22题:

    单选题
    Very soon you will be performing maintenance operations. You would have several jobs to run as soon as the maintenance period starts. Which method would you use to create jobs without specifying the time period when the job should be run?()
    A

     use DBMS_IJOB package

    B

     use Oracle Scheduler

    C

     use DBMS_JOB package

    D

     use Oracle Data Pump Export and Import


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

  • 第23题:

    单选题
    Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to record thestatus of the operation?()
    A

    ADD DIRECTORY

    B

    DROP DISK

    C

    RESIZE DISK

    D

    REBALANCE

    E

    ADD FAILGROUP


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

  • 第24题:

    单选题
    You are working in an online transaction processing (OLTP) environment. You realize that the salary for an employee, John, has been accidentally modified in the EMPLOYEES table. Two days ago, the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area.  Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected?()
    A

    perform point-in-time recovery

    B

    perform a Flashback Table operation to restore the table to the state it was in two days ago

    C

    perform a Flashback Database operation to restore the database to the state it was in two days ago

    D

    perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery


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