1Z0-031
单选题Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?（）A One runs faster than the otherB A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct pa
题目
One runs faster than the other
A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct path load is a high-speed version of the SQL INSERT
A direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERT
The conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE
参考答案和解析
相似问题和答案
第1题：
A. flashback query
B. distributed transactions
C. logging in and logging out of sessions
D. all DDL statements having bind variables
E. direct path load of data from external files
第2题：
A. to act as an equal-cost path to the primary path
B. to enable another LSP for load balancing
C. to act as a diverse backup path to the primary path
D. to allow the use of explicit path selection via EROs
第3题：
A. Flashback queries
B. Shared server requests
C. Login and logoff activities of sessions
D. Direct path load of data from external files by using utilities such as SQL *loader
E. Data definition language (DDL) and data manipulation language (DML) operations
第4题：
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
第5题：
In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）
- A、if a table is not in a cluster
- B、if a table has an active trigger
- C、if a table has an encrypted
- D、if a table has a column of data type LONG defined on it
- E、if a table has a referential integrity constraint defined on it
正确答案:B,C,E
第6题：
A. Flashback queries
B. Shared server requests
C. Login and logoff activities of sessions
D. Direct path load of data from external files by using utilities such as SQL *loader
E. Data definition language (DDL) and data manipulation language (DML) operations
第7题：
Which of the following could be used to provide a Layer 3 data path between separate VLANs？（）
- A、 VLAN trunking
- B、 An external router
- C、 An internal route processor
- D、 VLAN capable bridge
- E、 EtherChannel
正确答案:B,C
第8题：
A. 1 - Oracle Loader, 2 - Oracle Data Pump, 3 - Direct Path API
B. 1 - Oracle Data Pump, 2 - Direct Path API, 3 - Oracle Loader
C. 1 - Direct Path API, 2 - Oracle Loader, 3 - Oracle Data Pump
D. 1 - Oracle Loader, 2 - Direct Path API, 3 - Oracle Data Pump
第9题：
SQL*Loader reads a set of records from a file， generates INSERT commands， and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario？（）
- A、direct-path load
- B、conventional path load
正确答案:A
第10题：
What is the default function of a secondary path in MPLS?（）
- A、to act as an equal-cost path to the primary path
- B、to enable another LSP for load balancing
- C、to act as a diverse backup path to the primary path
- D、to allow the use of explicit path selection via EROs
正确答案:C