Which four are true regarding the Workspace Manager in Oracle9i？ （）

A . The use of discontiguous subnets is not allowed B . The use of variable length subnet masks is permitted C . RIP v1 is a classless routing protocol D . IGRP supports classless routing within the same autonomous system E . RIP v2 supports classless routing

A . NetFlow records bidirectional IP traffic flow. B . NetFlow export can be implemented over IPv4. C . NetFlow export can be implemented over IPv6. D . NetFlow records multicast IP traffic flow. E . NetFlow records ingress traffic. F . NetFlow records egress traffic.

A . Only a single partitioning key column can be specified. B . All DML statements must use partition-extended syntax. C . The same physical attributes must be specified for each partition. D . Unique local indexes cannot be created on a system-partitioned table. E . Traditional partition pruning and partitionwise joins are not supported on these tables.

A . Tables with BLOB and TEXT columns cannot be partitioned B . Partitioning allows easier management of smaller data sets for certain queries C . Partitioning allows different columns to be stored in separate files D . The partitioning expression is an integer or function that returns an integer value or NULL value E . Partitioning is only available for those storage engines that implements it natively

A . EXPDP and IMPDP are the client components of Oracle Data Pump. B . DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients. C . Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege. D . Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions. E . EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.

A . A subquery that defines a view cannot include the GROUP BY clause  B . A view that is created with the subquery having the DISTINCT keyword can be updated  C . A view that is created with the subquery having the pseudo column ROWNUM keyword cannot be updated  D . A data manipulation language (DML) operation can be performed on a view that is created with the subquery having all the NOT NULL columns of a table

A . Each B channel can transmit up to 64 kbps B . The ISDN B channel carries voice or data C . The ISDN D channel transmits control information. D . The D channel transmission rate varies depending on the service used. E . HDLC or PPP can be used to encapsulate D channel information.

A . They accept only a single argument  B . They can be nested only to two levels  C . Arguments can only be column values or constants  D . They always return a single result row for every row of a queried table  E . They can return a data type value different from the one that is referenced

A . Has-a relationships should never be encapsulated. B . Has-a relationships should be implemented using inheritance. C . Has-a relationships can be implemented using instance variables. D . Is-a relationships can be implemented using the extends keyword. E . Is-a relationships can be implemented using the implements keyword. F . An array or a collection can be used to implement a one-to-many has-a relationship.

A .  Has-a relationships should never be encapsulated. B .  Has-a relationships should be implemented using inheritance. C .  Has-a relationships can be implemented using instance variables. D .  Is-a relationships can be implemented using the extends keyword. E .  Is-a relationships can be implemented using the implements keyword. F .  An array or a collection can be used to implement a one-to-many has-a relationship. G .  The relationship between Movie and Actress is an example of an is-a relationship.

A . It is built by Automatic Tuning Optimizer. B . It cannot be stored persistently in the data dictionary. C . It can be used by the query optimizer automatically. D . It can be created manually by using the CREATE PROFILE command.

A .  It requires relinking of the Oracle binary. B .  It does not require database instance shutdown. C .  It can detect conflicts between two online patches. D .  It is available for installing all patches on all platforms.  E .  It works only in a single database instance environment.

A . Subqueries can contain GROUP BY and ORDER BY clauses  B . Main query and subquery can get data from different tables  C . Main query and subquery must get data from the same tables  D . Subqueries can contain ORDER BY but not the GROUP BY clause  E . Only one column or expression can be compared between the main query and subquery F .  Multiple columns or expressions can be compared between the main query and subquery

A . Listeners use only the TCP/IP protocol. B . Multiple listener processes can run simultaneously on a host. C . Multiple database instances can be registered with a single listener. D . The listener-related errors can be traced only at the administrative level. E . Only one database instance can be registered with a single listener at any time

A . Listeners use only the TCP/IP protocol. B . Multiple listener processes can run simultaneously on a host. C . Multiple database instances can be registered with a single listener. D . The listener-related errors can be traced only at the administrative level. E . Only one database instance can be registered with a single listener at any time.

A . The database can have more than one undo tablespace. B . The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management. C . Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions. D . An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.

A . Passive routes are in the process of being calculated by DUAL. B . EIGRP supports VLSM，route summarization，and routing update authentication. C . EIGRP exchanges full routing table information with neighboring routers with every update. D . If the feasible successor has a higher advertised distance than the successor route，it becomes theprimary route. E . A query process is used to discover a replacement for a failed route if a feasible successor is not identified from the current routing information.

A . External tables can be updated.  B . External tables are read-only tables.  C . Indexes can be created on external tables.  D . Indexes cannot be created on external tables.

A . A subquery can retrieve zero or more rows  B . Only two subqueries can be placed atone level  C . A subquery can be used only in SQL query statements  D . A subquery can appear on either side of a comparison operator  E . There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement&e

A . It requires relinking of the Oracle binary. B . It does not require database instance shutdown. C . It can detect conflicts between two online patches. D . It is available for installing all patches on all platforms. E . It works only in a single database instance environment.

A .  indexes are maintained by cache entry ownes B .  an application should not suggest an index that another aplication had suggested C .  indexes cannot be sorted D .  each application using Coherence may suggest the same set of indexes when it start

A .  It saves disk space and reduces memory usage. B .  It saves disk space but has no effect on memory usage. C .  It incurs extra CPU overhead during DML as well as direct loading operations. D .  It incurs extra CPU overhead during DML but not direct loading operations. E .  It requires uncompress operation during I/O.

A . Passiveroutes are in the process of being calculated by DUAL. B . EIGRP supports VLSM, route summarization, and routing update authentication. C . EIGRP exchanges full routing table information with neighboring routers with every update. D . If the feasible successor has a higher advertised distance than the successor route, it becomes the primary route. E . A query process is used to discover a replacement for a failed route if a feasible successor is not identified from the current routing information.

A .  The amount of undo retained is user controlled. B .  SecureFile LOBs can be used only for nonpartitioned tables. C .  Fragmentation is minimized by using variable-sized chunks dynamically. D .  SecureFile encryption allows for random reads and writes of the encrypted data. E .  It automatically detects duplicate LOB data and conserves space by storing only one copy.