网友您好， 请在下方输入框内输入要搜索的题目：

题目内容 （请给出正确答案）
多选题
Which three statements are true concerning the multitenant architecture?（）
A

Each pluggable database (PDB) has its own set of background processes.

B

A PDB can have a private temp tablespace.

C

PDBs can share the sysaux tablespace.

D

Log switches occur only at the multitenant container database (CDB) level.

E

Different PDBs can have different default block sizes.

F

PDBs share a common system tablespace.

G

Instance recovery is always performed at the CDB level.

参考答案

参考解析
解析： 暂无解析
更多 “多选题Which three statements are true concerning the multitenant architecture?（）AEach pluggable database (PDB) has its own set of background processes.BA PDB can have a private temp tablespace.CPDBs can share the sysaux tablespace.DLog switches occur only at the multitenant container database (CDB) level.EDifferent PDBs can have different default block sizes.FPDBs share a common system tablespace.GInstance recovery is always performed at the CDB level.” 相关考题
考题 单选题You wish to enable an audit policy for all database users, except SYS, SYSTEM, and SCOTT.You issue the following statements: SQL AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYS;SQL AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SYSTEM; SQL AUDIT POLICY ORA_DATABASE_PARAMETER EXCEPT SCOTT; For which database users is the audit policy now active?（）A All users except SYSB All users except SCOTTC All users except sys and SCOTTD All users except sys, system, and SCOTT
查看答案
考题 单选题Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?（）A By default, EM express is available for a database after database creation.B You can use EM express to manage multiple databases running on the same server.C You can perform basic administrative tasks for pluggable databases by using the EM express interface.D You cannot start up or shut down a database Instance by using EM express.E You can create and configure pluggable databases by using EM express.
查看答案
考题 多选题You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly. You lost an ASM disk group DG1 due to hardware failure. In which three ways can you re-create the lost disk group and restore the data?（）AUse the MD_RESTORE command to restore metadata for an existing disk group by passing the existing disk group name as an input parameter and use RMAN to restore the data.BUse the MKDG command to restore the disk group with the same configuration as the backed-up disk group and data on the disk group.CUse the MD_RESTORE command to restore the disk group with the changed disk group specification, failure group specification, name, and other attributes and use RMAN to restore the data.DUse the MKDG command to restore the disk group with the same configuration as the backed-up disk group name and same set of disks and failure group configuration, and use RMAN to restore the data.EUse the MD_RESTORE command to restore both the metadata and data for the failed disk group.FUse the MKDG command to add a new disk group DG1 with the same or different specifications for failure group and other attributes and use RMAN to restore the data.
查看答案
考题 多选题Which three statements are true about adaptive SQL plan management?（）AIt automatically performs verification or evolves non-accepted plans, in COMPREHENSIVE mode when they perform better than existing accepted plans.BThe optimizer always uses the fixed plan, if the fixed plan exists in the plan baseline.CIt adds new, bettor plans automatically as fixed plans to the baseline.DThe non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than the existing accepted plans.EThe 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.
查看答案
考题 多选题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.
查看答案
考题 多选题You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format. Which three storage options support the use of HCC?（）AASM disk groups with ASM disks consisting of Exadata Grid Disks.BASM disk groups with ASM disks consisting of LUNS on any Storage Area Network arrayCASM disk groups with ASM disks consisting of any zero padded NFS-mounted filesDDatabase files stored in ZFS and accessed using conventional NFS mounts.EDatabase files stored in ZFS and accessed using the Oracle Direct NFS featureFDatabase files stored in any file system and accessed using the Oracle Direct NFS featureGASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays
查看答案
考题 单选题Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache. What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?（）A Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.B Run the Automatic Workload Repository Monitor (ADDM).C Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.D Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
查看答案
考题 单选题You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8ISO8859P15 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character set: AL32UTF8 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）A Transportable databaseB Transportable tablespaceC Data Pump full export / importD The DBMS_PDB packageE RMAN
查看答案
热门标签
最新试卷