[单项选择]Which is true about the three countries

[多项选择]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 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 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.

[多项选择]Which three statements are true about Oracle Data Pump export and import operations?（）
A. You can detach from a data pump export job and reattach later.
B. Data pump uses parallel execution server processes to implement parallel import.
C. Data pump import requires the import file to be in a directory owned by the oracle owner.
D. The master table is the last object to be exported by the data pump.
E. You can detach from a data pump import job and reattach later.

[多项选择]Which three statements are true about Automatic Workload Repository (AWR)?（）
A. All AWR tables belong to the SYSTEM schema.
B. The AWR data is stored in memory and in the database.
C. The snapshots collected by AWR are used by the self-tuning components in the database
D. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.
E. AWR contains system wide tracing and logging information.

[多项选择]Which three statements are true about persistent configuration?（） (Choose three.)
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 the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）
A. System privileges apply only to the PDB in which they are used.
B. Local users cannot use local system privileges on the schema of a common user.
C. The granter of system privileges must possess the set container privilege.
D. Common users connected to a PDB can exercise privileges across other PDBs.
E. System privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.