C2090-611

C2090-611 practice questions, page 5 of 5, with answer review and explanations.

Question 21

Which of the following table types is NOT supported by the load utility?

  1. A Temporal table
  2. A Range Partitioned table
  3. A Global Temporary table
  4. A Multidimensional Clustering table

Question 22

Which data movement utility is suitable for moving and processing large amounts of real-time data without affecting availability?

  1. INGEST
  2. REPLICATION
  3. LOAD WITH READ ACCESS
  4. IMPORT WITH BUFFERED INSERT

Question 23

What does the FLUSH PACKAGE CACHE statement do?

  1. It removes all dynamic SQL statements from the package cache.
  2. It removes only inactive SQL statements from the package cache.
  3. It saves dynamic SQL stored in the package cache to an external file.
  4. It causes all SQL statements in the package cache that are currently in use to be recompiled.