Which statement is true about loading data using the conventional path of SQL*Loader()
第1题:
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?()
第2题:
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()
第3题:
A. It contains only SQL profiles generated by SQL Tuning Advisor.
B. It stores plans generated by the optimizer using a stored outline.
C. It is part of the data dictionary and stored in the SYSAUX tablespace.
D. It is part of the data dictionary and stored in the SYSTEM tablespace.
E. It contains the statement log, the plan history, plan baselines, and SQL profiles.
第4题:
Which two statements about the SQL Management Base (SMB) are true? ()(Choose two.)
第5题:
Which two statements are true about the primary key constraint in a table? ()
第6题:
Which statement is true about a routing table?()
第7题:
Which statement is true about a routing table?()
第8题:
A. It contains routes learned dynamically only.
B. It finds the best path to each destination by using a modified shortest-path-first calculation.
C. It contains only active BGP routes.
D. It contains all accepted routes to all destinations.
第9题:
Which two statements are true about constraints? ()
第10题:
Which two statements are true about a bitmap index? ()