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. 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
第2题:
In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table()
第3题:
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()
第4题:
Which client requests to the database can be captured as a part of the workload capture?()
第5题:
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()
第6题:
Which two client requests are captured during database replay Capture?()
第7题:
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?()
第8题:
Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?()
第9题:
Redo is not generated while performing conventional path loads.
Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked.
No exclusive locks are acquired when the conventional path loads are performed.
Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.
INSERT triggers are disabled before the conventional path load and reenabled at the end of the load
第10题:
Use the external table population.
Use the Oracle Data Pump export and import utility.
Use the conventional path data load of the SQL*Loader utility.
Use the INSERT INTO...SELECT command to load the data
第11题:
if a table is not in a cluster
if a table has an active trigger
if a table has an encrypted
if a table has a column of data type LONG defined on it
if a table has a referential integrity constraint defined on it
第12题:
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
第13题:
Which of the following could be used to provide a Layer 3 data path between separate VLANs?()
第14题:
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?()
第15题:
What is the default function of a secondary path in MPLS?()
第16题:
Which two are true regarding direct-path exports?()
第17题:
Which statement is true about loading data using the conventional path of SQL*Loader()
第18题:
Which two client requests are captured during database replay Capture?() (Choose two)
第19题:
Which statement is true about loading data using the conventional path of SQL*Loader()
第20题:
Redo is not generated while performing conventional path loads.
Only PRIMARY KEY, UNIQUE KEY, and NOT NULL constraints are checked.
No exclusive locks are acquired when the conventional path loads are performed.
Instead of performing transactions, SQL*Loader directly writes data blocks to the data files.
INSERT triggers are disabled before the conventional path load and reenabled at the end of the load.
第21题:
Use the external table population.
Use the Oracle Data Pump export and import utility.
Use the conventional path data load of the SQL*Loader utility.
Use the INSERT INTO...SELECT command to load the data.
第22题:
Direct-path export is typically faster.
Direct-path export can be invoked interactively.
Direct-path export is character set independent.
Direct-path export bypasses the SQL-command processing layer.
Direct-path export can be used to export rows containing LOBs and BFILEs.
第23题:
use the external table population
use the Oracle Data Pump export and import utility
use the conventional path data load of SQL*Loader utility
use the direct path data load of Oracle export and import utility
第24题:
to act as an equal-cost path to the primary path
to enable another LSP for load balancing
to act as a diverse backup path to the primary path
to allow the use of explicit path selection via EROs