[多项选择]Which three statements about VTP features are true?（）
A. When properly configured,VTP minimizes VLAN misconfigurations and configuration inconsistencies
B. Each broadcast domain on a switch can have its own unique VTP domain
C. VTP works at Layer 3 of the OSI model and requires that a management VLAN IP address be configured.
D. When properly configured,VTP maintains VLAN configuration consistency and accelerates trunk link negotiation.
E. VTP pruning is used to increase available bandwidth in trunk links
F. Client,server,and transparent are valid VTP modes
G. To configure a switch to be part of two VTP domains,each domain must have its own passwords

[多项选择]Which three statements about VTP features are true?（）
A. When properly configured,VTP minimizes VLAN misconfigurations and configuration inconsistencies
B. Each broadcast domain on a switch can have its own unique VTP domain
C. VTP works at Layer 3 of the OSI model and requires that a management VLAN IP address be configured.
D. When properly configured,VTP maintains VLAN configuration consistency and accelerates trunk link negotiation.
E. VTP pruning is used to increase available bandwidth in trunk links
F. Client,server,and transparent are valid VTP modes
G. To configure a switch to be part of two VTP domains,each domain must have its own passwords

[多项选择]Which three statements about the features of SNMPv2 and SNMPv3 are true?（）
A. SNMPv3 enhanced SNMPv2 security features
B. SNMPv3 added the Inform protocol message to SNMP
C. SNMPv2 added the Inform protocol message to SNMP
D. SNMPv3 added the GetBulk protocol messages to SNMP
E. SNMPv2 added the GetBulk protocol message to SNMP
F. SNMPv2 added the GetNext protocol message to SNMP

[多项选择]Which three are true about MPLS LSP establishment using RSVP?（） (Choose three.)
A. Ordered Control
B. Independent Control
C. Down Stream Unsolicited
D. Liberal Label Management
E. Down Stream On Demand

[多项选择]Which three are true about the large pool for an Oracle database instance that supports shared serverconnections?（）
A. Allocates memory for RMAN backup and restore operations
B. Allocates memory for shared and private SQL areas
C. Contains a cursor area for storing runtime information about cursors
D. Contains stack space
E. Contains a hash area performing hash joins of tables

[多项选择]Which three are true?（）
A. A MERGE statement is used to merge the data of one table with data from another.
B. A MERGE statement replaces the data of one table with that of another.
C. A MERGE statement can be used to insert new rows into a table.
D. A MERGE statement can be used to update existing rows in a table.

[多项选择]Which three statements about subqueries are true? （）
A. A main query can have more than one subquery.
B. A subquery can have more than one main query.
C. The subquery and main query must retrieve data from the same table.
D. The subquery and main query can retrieve data from different tables.
E. Only one column or expression can be compared between the subquery and main query.
F. Multiple columns or expression can be compared between the subquery and main query.

[多项选择]Which three statements are true about using flashback database in a multitenant container database(CDB)?（）
A. The root container can be flashed back without flashing back the pluggable databases (PDBs).
B. To enable flashback database, the CDB must be mounted.
C. Individual PDBs can be flashed back without flashing back the entire cdb.
D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.
E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.

[多项选择]Which three statements are true about persistent configuration?（）
A. A user cannot set privileges on the persistent lightweight jobs
B. Persistent lightweight jobs generate a large amount of metadata
C. It is possible to create fully self-contained persistent lightweight jobs
D. The use of a template is mandatory to create persistent lightweight jobs
E. Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time

[多项选择]Which three statements are true about a registration server in a community?（） (Choose three.)
A. It is a hub device installed in the community.
B. A community can have one or more registration servers.
C. It shows the serial numbers of all devices in the community.
D. It stores network and community information for each device.
E. It is required for tunnel formation between different WX devices in the same community.

[多项选择]Which three statements are true about IP multicast configuration?（）
A. PIM sparse - dense mode and PIM dense mode require an RP on the network.
B. PIM sparse mode and PIM dense mode require an RP on the network.
C. PIM sparse mode interfaces are always added to the multicast routing table in a router.
D. PIM sparse mode and PIM sparse - dense mode require an RP on the network.
E. PIM dense mode interfaces are always added to the multicast routing table in a router.
F. PIM sparse - dense mode acts as PIM dense mode if an RP is not known.

[多项选择]Which three statements are true about adaptive SQL plan management?（）
A. It automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.
B. The optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.
C. It adds new, bettor plans automatically as fixed plans to the baseline.
D. The non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.
E. The non-accepted plans in a SQL plan baseline are automatically evolved, in COMPREHENSIVE mode, during the nightly maintenance window and a persistent verification report is generated.

[多项选择]Which three statements are true about the Internet Group Management Protocol (IGMP)? （）
A. There are three IGMP modes: dense mode, sparse mode, and sparse - dense mode
B. IGMP is used to register individual hosts with a multicast group
C. IGMP version 3 enables a multicast receiving host to specify to the router which sources it should forward traffic from
D. IGMP messages a re IP datagrams with a protocol value of 2, destination address of 224.0.0.2, and a TTL value of 1
E. IGMP is a multicast routing protocol that makes packet - forwarding decisions independent of other routing protocols such as EIGRP
F. IGMP snooping ru ns on Layer 3 routers

[多项选择]Which three statements are true about memory buffer allocation by a MySQL Server?（）
A. Global buffers such as the InnoDB buffer pool are allocated after the server starts, and are never freed
B. Thread buffers are allocated when a client connects, and are freed when the client disconnects
C. Buffers that are needed for certain operation are allocated when the operation starts, and freed when it ends
D. User buffers are allocated at server startup and freed when the user is dropped
E. All dynamic buffers that are set with a SET GLOBAL statement immediately get allocated globally, and are never freed

[多项选择]Which three statements are true about Flashback Database?（）
A. Flashback logs are written sequentially, and are archived.
B. Flashback Database uses a restored control file to recover a database.
C. The Oracle database automatically creates, deletes, and resides flashback logs in the Fast Recovery Area.
D. Flashback Database can recover a database to the state that it was in before a reset logs operation.
E. Flashback Database can recover a data file that was dropped during the span of time of the flashback.
F. Flashback logs are used to restore to the blocks' before images, and then the redo data may be used to roll forward to the desired flashback time.