[多项选择]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 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 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 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 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 EIGRP operation?（）
A. When summarization is configured, the router will also create a route to null 0.
B. The summary route remains in the route table, even if there are no more specific routes to the network.
C. Summarization is configured on a per- interface level.
D. The maximum metric for the specific routes is used as the metric for the summary route.
E. Automatic summarization across major network boundaries  is enabled by default.

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

[多项选择]Which three statements are true about EIGRP route summarization?（）
A. When manual summarization is configured, the router immediately creates a route that points to null0 interface
B. Manual route summarization  is configured in router configuration mode when the router is configured for EIGRP routing
C. Manual route summarization is configured on the interface
D. The ip summary - address eigrp command generates a default route with an administrative distance  of 5
E. When manual summarization is configured, the summary route will use the metric of the largest specific metric of the summary routes
F. The ip summary - address eigrp command generates a default route with an administrative distance of 90

[多项选择]Which three statements are true about windows?（）
A. Only one window can be open at any given time
B. Consumer groups are associated with windows
C. Windows work with job classes to control resource allocation
D. The database service name must be provided during windows creation
E. Windows can automatically start job or change resource allocation among jobs for various time periods.

[多项选择]Which three statements are true about terms in a policy?（）
A. The order of the terms in a policy is irrelevant.
B. The action is specified in a then statement.
C. Terms are optional in a policy.
D. The match condition can be identified with a from statement.
E. A from statement is mandatory in a term.

[多项选择]Which three statements are true about SQL plan directives?（）
A. They are tied to a specific statement or SQL id.
B. They instruct the maintenance job to collect missing statistics or perform dynamic sampling to generate a more optimal plan.
C. They are used to gather only missing statistics.
D. They are created for a query expression where statistics are missing or the cardinality estimates by the optimizer are incorrect.
E. They instruct the optimizer to create only column group statistics.
F. Improve plan accuracy by persisting both compilation and execution statistics in the SYSAUX tablespace.