更多"Which three statements are true abo"的相关试题:
[多项选择]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.
[多项选择]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 two statements about the Adaptive Services PIC are true? （）
A. The Adaptive Services PIC supports the Layer 3 service package by default.
B. The Adaptive Services PIC is required when using the secure shell to access an M-series router.
C. The Adaptive Services PIC can be configured for the Layer 2 and Layer 3 service packages simultaneously.
D. The Adaptive Services PIC can be configured for either the Layer 2 or the Layer 3 service package but not both at the same time.
[多项选择]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 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.
