What two statements are true regarding the recommendations received from the SQL Access Advisor?（）(Choose two.)

A .  The bus is limited to 32 devices B .  It is a full duplex serial standard C .  It is a half-duplex serial standard D .  It allows up to 320 MB/s of shared channel bandwidth

A . Zoning increases security. B . DNS queries are used for software zoning. C . Software zoning is more secure than hardware zoning. D . When using zones and VSANs together, the zone is created first. E . Zoning requires that VSANs be established before it becomes operational.

A . The source and target platforms must be the same B . Redo logs, control files and temp files are also transported C . The transported database must have the same database identifier (DBID) as the source database and cannot be changed D . The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported E . Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

A . A single row subquery can retrieve data from only one table. B . A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause. C . A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause. D . A single row subquery can retrieve data from more than one table. E . A single row subquery cannot be used in a condition where the LIKE operator is used for comparison. F . A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.

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 . WRED can selectively discard lower priority traffic when the interface becomes congested and can provide differentiated performance characteristics for different classes of service. B . Resource Reservation Protocol （RSVP） and WRED cannot be configured on the same interface. C . WRED will throttle back voice traffic only as a last resort. D . If the average queue length is greater than the minimum threshold but less than the maximum threshold， then based on the drop probability， WRED will either queue the packet or perform a random drop. E . WRED statistically drops more packets from low-bandwidth users than high-bandwidth users. Therefore， traffic sources that generate the least traffic are more likely to be slowed down than traffic sources that generate the most traffic. F .  WRED treats non-IP traffic as precedence 4.

A . Clearing an alert sends the alert to the alert history. B . Response actions cannot be specified with server-generated alerts. C . The nonthreshold alerts appear in the DBA_OUTSTANDING_ALERTS view. D . Server-generated alerts notify the problems that cannot be resolved automatically and requireadministrators to be notified.

A . The checkpoint frequency decreases with the smaller redo log file size. B . It ensures that all committed data is written to the data files during normal shutdown. C . The frequent full checkpoint in a database can cause the overall degradation of the database performance. D . It prompts the Checkpoint （CKPT） process to write data to the data files and redo information to the online redo log files.

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 UNIQUE constraint does not permit a null value for the column. B . A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints. C . The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index. D . The NOT NULL constraint ensures that null values are not permitted for the column.

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 .  Zoning increases security. B .  DNS queries are used for software zoning. C .  Software zoning is more secure than hardware zoning. D .  When using zones and VSANs together， the zone is created first. E .  Zoning requires that VSANs be established before it becomes operational.

A . It is possible for more than two threads to deadlock at once. B . The JVM implementation guarantees that multiple threads cannot enter into a deadlocked state. C . Deadlocked threads release once their sleep（） method’s sleep duration has expired. D . Deadlocking can occur only when the wait（）， notify（）， and notifyAll（） methods are used incorrectly. E . It is possible for a single-threaded application to deadlock if synchronized blocks are used incorrectly. F . If a piece of code is capable of deadlocking， you cannot eliminate the possibility ofdeadlocking by insertinginvocations of Thread.yield（）.

A . The IP address of the backup designated router （BDR） is FE80：：205：5FFF：FED3：5808 B . This is the designated router （DR） on the FastEthernet 0/0 link C . Interface FastEthernet 0/0 was configured with the ipv6 ospf 1 area 1 command D . OSPF version 2 has been enabled to support IPv6 E . The output was generated by the show ip interface command

A . This is the designated router (DR) on the FastEthernet 0/0 link. B . The output was generated by the show ip interface c ommand. C . The router was configured with the commands:r outer ospf 1 network 172.16.6.0 0.0.0.255 area 1 D . The IP address of the backup designated router (BDR) is FE80::205:5FFF:FED3:5808. E . Interface FastEthernet 0/0 was configured with the ipv6 o spf 1 area 1 command. F . OSPF version 2 has been enabled to support IPv6.

A . Partitions of PURCHASE_ORDER_ITEMS have system-generated names. B . Both PURCHASE_ORDERS and PURCHASE_ORDER_ITEMS tables are created with four partitions each. C . Partitions of the PURCHASE_ORDER_ITEMS table exist in the same tablespaces as the partitions of the PURCHASE_ORDERS table. D . The PURCHASE_ORDER_ITEMS table inherits the partitioning key from the parent table by automatically duplicating the key columns. E . Partition maintenance operations performed on the PURCHASE_ORDER_ITEMS table are automatically reflected in the PURCHASE_ORDERS table.

A .  Dense mode multicast requires explicit join messages from their members. B .  Dense mode multicast uses a push model to flood traffic throughout the network and then prunes the  unwanted traffic. C .  Sparse mode multicast uses a pull model to send multicast traffic to where it is requested.   D .  Sparse mode uses reverse path forwarding （RPF） to prune off redundant flows. E .  The primary use of sparse mode multicast is for test labs and router performance testing.

A . Do not fragment has been configured on PE11. B . MPLS has been disabled on routers P11 and P12. C . An access list has been created on P11 to block traceroutes from PE11. D . The no mpls ip propgate-ttl local command has been configured on PE11 E . ICMP has been disabled on the intermediary routers between PE11 and PE12.

A . It is possible for more than two threads to deadlock at once. B . The JVM implementation guarantees that multiple threads cannot enter into a deadlocked state. C . Deadlocked threads release once their sleep() method's sleep duration has expired. D . Deadlocking can occur only when the wait(), notify(), and notifyAll() methods are used incorrectly. E . It is possible for a single-threaded application to deadlock if synchronized blocks are used incorrectly. F . If a piece of code is capable of deadlocking, you cannot eliminate the possibility of deadlocking by inserting invocations of Thread.yield().

A . It is possible to synchronize static methods. B . When a thread has yielded as a result of yield（）， it releases its locks. C . When a thread is sleeping as a result of sleep（）， it releases its locks. D . The Object.wait（） method can be invoked only from a synchronized context. E . The Thread.sleep（） method can be invoked only from a synchronized context. F . When the thread scheduler receives a notify（） request， and notifies a thread， that thread immediately releases its lock.

A．Generate revenue B．Develop key assumptions C．Building and integrating the three statements D．Predict expenditures 此题为多项选择题。