网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
多选题
The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.()
A
BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
B
BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
C
BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
D
BACKUP TABLESPACE TEMP SECTION SIZE 10M;
E
BACKUP TABLESPACE UNDO INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
F
BACKUP SPFILE SECTION SIZE 1M;
G
BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
参考答案
参考解析
解析:
暂无解析
更多 “多选题The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.()ABACKUP TABLESPACE SYSTEM SECTION SIZE 100M;BBACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;CBACKUP ARCHIVELOG ALL SECTION SIZE 25M;DBACKUP TABLESPACE TEMP SECTION SIZE 10M;EBACKUP TABLESPACE UNDO INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;FBACKUP SPFILE SECTION SIZE 1M;GBACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;” 相关考题
考题
多选题Which three are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12cwhen it is enabled?()AReduced logical I/OBReduced virtual memory utilizationCImproved parallel Execution performanceDImproved Serial Execution performanceEReduced physical I/OFReduced CPU utilization
考题
多选题You create a new pluggable database, HR_PDB, from the seed database. Which three tablespaces arecreated by default in HR_PDB?()ASYSTEMBSYSAUXCEXAMPLEDUNDOETEMPFUSERS
考题
单选题You want to capture column group usage and gather extended statistics for better cardinality estimates for the CUSTOMERS table in the SH schema. Examine the following steps: 1. Issue the SELECT DBMS_STATS.CREATE_EXTENDED_STATS (‘SH’, ‘CUSTOMERS’) FROM dual statement. 2. Execute the DBMS_STATS.SEED_COL_USAGE (null, ‘SH’, 500) procedure. 3. Execute the required queries on the CUSTOMERS table. 4. Issue the SELECT DBMS_STATS.REPORT_COL_USAGE (‘SH’, ‘CUSTOMERS’) FROM dual statement. Identify the correct sequence of steps.()A
3,2,1,4B
2,3,4,1C
4,1,3,2D
3,2,4,1
考题
多选题On your Oracle Database, you issue the following commands to create indexes: SQL CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customer_id, sales_rep_id); Which two statements are true?()AOnly the ORD_CUSTOMER_IX1 index created.BBoth the indexes are updated when a row is inserted, updated, or deleted in the ORDERS table.CBoth the indexes are created: however, only ORD_CUSTOMERS_IX1 is used by the optimizer for queries on the ORDERS table.DThe ORD_CUSTOMER_IX1 index is not used by the optimizer even when the OPTIMIZER_USE_INVISIBLE_INDEXES parameters is set to true.EBoth the indexes are created and used by the optimizer for queries on the ORDERS table.FBoth the indexes are created: however, only ORD_CUSTOMERS_IX2 is used by the optimizer for queries on the ORDERS table.
考题
多选题Which three statements are true about using flashback database in a multitenant container database(CDB)?()AThe root container can be flashed back without flashing back the pluggable databases (PDBs).BTo enable flashback database, the CDB must be mounted.CIndividual PDBs can be flashed back without flashing back the entire cdb.DThe DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.EA CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
热门标签
最新试卷