What is true regarding direct-load insert？（）

A . It can have a maximum of five expressions in a list  B . It returns the highest NOT NULL value in the list for all rows  C . It requires that all expressions in the list must be of the same data type  D . It requires that at least one of the expressions in the list must have a NOT NULL value

A . A value of 4 represents the "Implicit NULL Label." B . A value of 0 represents the "IPv4 Explicit NULL Label." C . A value of 1 represents the "Router Alert Label". The use of this label is analogous to the use of the"Router Alert Option" in IP packets （for example， ping with record route option） D . A value of 2 represents the "IPv6 Explicit NULL Label" E . A value of 1 represents the "IPv1 Explicit NULL Label" F . A value of 3 represents the "Implicit NULL Label&quot

A . The LIKE operator cannot be used with single-row subqueries  B . The NOT IN operator is equivalent to IS NULL with single-row subqueries  C . =ANY and =ALL operators have the same functionality in multiple-row subqueries  D . The NOT operator can be used with IN, ANY, and ALL operators in multiple-row subqueries&e

A . A dispatcher can support multiple client connects concurrently while a shared server process can be dedicated to only one dispatcher.  B . Under the Oracle Shared Server architecture, client-user processes connect to shared user processes. C . Each dispatcher has its own request queue, which is monitored every three seconds by the dispatcher.  D . Oracle Shared Server required Oracle Net Service even if the client and shared server processes reside on the same machine.

A . Configuration changes made on the port-channel interface apply to all physical ports assigned to the portchannel interface. B . Configuration changes made on a physical port that is a member of a port-channel interface apply to the port-channel interface. C . Configuration changes are not permitted with Port Aggregation Protocol； instead， the standardized Link Aggregation Control Protocol should be used if configuration changes are required. D . The physical port must first be disassociated from the port-channel interface before any configuration changes can be made.

A . 802.1X is simple to implement on any workstation. B . 802.1X requires access-lists to allow IP voice traffic across. C . Authentication is initiated when the workstation connects to an Ethernet port. D . 802.1X requires HTTP access to initiate authentication.

A . A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script. B . The virtual private catalog owner cannot create and modify the stored scripts. C . The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner. D . To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database

A . They acknowledge receipt of TCP segments. B . They guarantee datagram delivery. C . They can provide hosts with information about network problems. D . They are encapsulated within IP datagrams. E . They are encapsulated within UDP datagrams.

A . It ignores NULL values  B . Reversing the order of the intersected tables alters the result  C . The names of columns in all SELECT statements must be identical  D . The number of columns and data types must be identical for all SELECT statements in the query&e

A . A virtual private catalog owner can create a local stored script, and have read/write access to a global stored script.  B . The virtual private catalog owner cannot create and modify the stored scripts.  C . The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner.  D . To perform most of the RMAN operations, the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.&e

A .  They are created automatically and stored on the FI B .  They are created manually and exported to a remote server C .  They are automatically scheduled to run every 24 hours D .  They are manually scheduled and stored on the FI

A .  It cannot generate recommendations that support multiple workload queries. B .  It can recommend partitioning on tables provided that the workloads have some predicates and joins on the columns of the NUMBER or DATE type. C .  It can recommend partitioning only on tables that have at least 10，000 rows. D .  It can recommend only B-tree indexes and not bitmap or function-based indexes.

A . Each target database requires its own recover catalog.  B . RMAN scripts can be stored in the recovery catalog or the target control file.  C . A channel is a stream of data to a device type and corresponds to one server session.  D . The RMAN executable interprets sever session commands and establishes connections to the target database.

A . A priority of 0 will prevent a router from becoming a DIS. B . If the DIS becomes unavailable the backup DIS is promoted to DIS. C . Adding a router with a higher priority than the current DIS will result in the new router becoming DIS. D . Separate L1 and L2 election processes are held on a brodcast network. E . L1 routers on a broadcast network only establish adjacencies with the DIS. F . If there is a tie based on priority，the router whose attached interface has the lowest MAC address becomes the DIS.

A .  It returns versions of rows only within a transaction. B .  It can be used in subqueries contained only in a SELECT statement. C .  It will return an error if the undo retention time is less than the lower bound time or SCN specified. D .  It retrieves all versions including the deleted as well as subsequently reinserted versions of the rows.

A . Synonyms can be created only for a table  B . Synonyms are used to reference only those tables that are owned by another user  C . A public synonym and a private synonym can exist with the same name for the same table  D . The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid

A .  A virtual private catalog owner can create a local stored script， and have read/write access to a global stored script. B .  The virtual private catalog owner cannot create and modify the stored scripts. C .  The set of views and synonyms that make up the virtual private catalog is stored in the schema of the RMAN recovery catalog owner. D .  To perform most of the RMAN operations， the virtual catalog owner must have the SYSDBA or SYSOPER privilege on the target database.

A . A checkpoint defines the highest system change number （SCN）. B . All redo entries higher or at the SCN are known to be written to the data files. C . Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery. D . The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.

A .  The minimum configurable capacity allocation is 1.0 core and the minimum increment is 0.1 core. B .  The minimum configurable capacity allocation is 0.1 core and the minimum increment is 0.01 core. C .  The minimum configurable capacity allocation is 1.0 core and the minimum increment is 0.01 core. D .  The minimum configurable capacity allocation is 0.1 core and the minimum increment is 0.001

A . InnoDB uses row and table-level locks, but row locks are not escalates B . InnoDB locks only those rows that are updated C . InnoDB only uses row locks, not page or table-level locks D . InnoDB row locks may be escalated to page or table-level locks E . InnoDB uses row-level or table-level locks depending on the number of rows affected

A . It drops the connection after the specified number of login attempts fail for any user. B . It is enforced only if the password profile is enabled for the user.  C . It locks the user account after the specified number of attempts.  D . It drops the connection after the specified number of login attempts fail only for users who have the SYSDBA privilege.

A . A B . B C . C D . D

A . A B . B C . C D . D

A . AS numbers are assigned by the IANA B . AS numbers are used by BGP （Border Gateway protocol ） to exchange IP routing information with neighboring AS C . In the internet， an Autonomous System （AS） is a collection of IP networks and routers under the control D . All of the Above