題數：13+12

8 月 新增63題庫：

01 which thre statements are true about unlugging a pluggable database(PDB)?
關于卸載可插拔數據庫(PDB)，哪三句話是正確的?
A) an unplugged PDB can be plugged into the same or abother container database(CDB).
一個未插入的PDB可以插入到相同的或不同的容器數據庫(CDB)中。
C) a pdb must have been opened at leasr once after creation.
一個pdb必須在創建后至少被打開過一次。
D) a pdb must be in closed state before it can be unplugged.
pdb必須在關閉狀態下才能被拔下。

02 you plan to create a new pdb by copying pdb$eed.你計劃通過復制pdb$eed創建一個新的pdb.
which two requirements ensure a successful creation?
哪兩個需求確保了成功的創建?
A) the cdb must use oralce managed files.
cdb必須使用口頭管理的文件。
C) a pdb local administrative user musts be specified when creating the pdb.
創建pdb時必須指定一個pdb本地管理用戶。

03 which two statements are true about scheduling operations in a pluggable database(pdb)?
關于在可插拔數據庫(pdb)中調度操作，哪兩條語句是正確的?
A) a job defined ina a pdb runs only if that pdb is open.
在pdb中定義的作業只有在pdb打開時才運行。
B) scheduler objects created by users can be exported or imported using data pump.
用戶創建的調度器對象可以使用data pump導出或導入。

04 which thre are about unified auditing in full mode?
哪三條是關于全模式統一審核的?
A) audit records are created for commit,rollback, and savepoint statements.
審計記錄是為提交、回滾和保存點語句創建的。
B) the unified audit trail is written to a read-only table.
將統一審計跟蹤寫入只讀表。
D) audit records are created for non-sys users.
為非系統用戶創建審計記錄。

05 which two componeents are contained only in CDB$ROOT?哪兩個組件只包含在CDB$ROOT中?
D) PDB service names.
PDB服務名稱。
E) resouce manager plans for each PDB in the CDB.
資源經理為國開行的每個PDB制定計劃。

06 identify three reasons for using a recovery catalog with recovery manger(RMAN)?
確定使用恢復管理器(RMAN)恢復目錄的三個原因?
A) to report on the database schema at an earlier point in time.
在較早的時間點報告數據庫模式。
B) to store backup metadata that would cause the controlfile to bacome too large.
存儲可能導致控制文件過大的備份元數據。
C) to store backups that would cause the controlfile to bacome too large.
存儲會導致控制文件過大的備份。

07 which four are true about consolidated replay?
關于合并重賽，哪四個是正確的?
A) Multiple workload captures from multiple databases can be replayed simultaneously
可以同時重放來自多個數據庫的多個工作負載捕獲
B)The number of captured workloads must be the same as the number of PDBS in a multitenant CDB
捕獲的工作負載數量必須與多租戶CDB中的pdb數量相同
C)A superset of the captured workload can be replayed
可以重播捕獲的工作負載的超集
D)A single replay schedule can be defined for a consolidated replay.
可以為統一的重播定義單一的重播調度。
E) The workload capture and replay servers must run the same operating system(os)
工作負載捕獲和重播服務器必須運行相同的操作系統
F) Multiple replay schedules can be defined for a consolidated replay
多個重播調度可以定義為一個統一的重播
G)A subset of the captured workload can be replayed
可以重播捕獲的工作負載的一個子集

08 in an oralce 12c database, you attempt to load data into the Hr.
在oralce 12c數據庫中，嘗試將數據加載到Hr中。
EMPLOYEES tabvle in a pluggable database(PDB):
員工在可插拔數據庫(PDB)表:
$> sqlldr hr/he@pdb table=employees

$> sqlldr hr/he@pdb表=員工
which three are true?
哪三個是正確的?
B) it succeeds if HR is a common user.
如果HR是普通用戶，則成功。
C) it succeeds if HR is a local user in the PDB to which HR connects.
如果HR是HR連接到的PDB中的本地用戶，則成功。
D) it loads data into REMPLOYEES if the table exists in the PDB to which HR connects.
如果表存在于HR連接到的PDB中，則將數據加載到REMPLOYEES中。

09 which two statements are true about recovering logically corrupted tables or table partitions from an RMAN backup?
關于從RMAN備份中恢復邏輯損壞的表或表分區，哪兩條語句是正確的?
B) tables or table partitions from the system and system tablespaces cannot be recovered.
系統和系統表空間中的表或表分區無法恢復。
E) tables or table partitions can be recovered by using an auxiliary instance only.
表或表分區只能通過使用一個輔助實例來恢復。

10 in cdb$root of your multitenant container database（cdb), you create a common user, c##a_admin, and then execute the command; 在多租戶容器數據庫(cdb)的cdb$root中，創建一個通用用戶c##a_admin，然后執行命令; SQL> grant create tablespace to c##a_admin; SQL>授予創建表空間給c##a_admin; which statement is true? 哪種說法是正確的?A) the command executes successfully, enabling the c##a_admin user to create tablespaces in root database, as well as in the pluggable databases(PDB). 命令成功執行，使c##a_admin用戶能夠在根數據庫和可插入數據庫(PDB)中創建表空間。

11 your multitenant container database(cdb) cdbl that is running in archivelog mode contains two pluggable databases(PDBs), pdb2_1 and pdb2_2.
在archivelog模式下運行的多租戶容器數據庫(cdb) cdbl包含兩個可插拔數據庫(PDBs): pdb2_1和pdb2_2。
rman is connected to the target database pdb2_1.
rman連接到目標數據庫pdb2_1。
examine the command executed to back up pdb2_1;
檢查為備份pdb2_1而執行的命令;
rman> backup database plus
rman>備份數據庫加
archivelog;
archivelog;
which statement is true about the execution of this command?
關于這個命令的執行，哪個陳述是正確的?

B) it succeeds and data files belonging to pdb2_1 are backed up along with the archive log files.
成功，屬于pdb2_1的數據文件與歸檔日志文件一起備份。
C) it succeeds but only the data files belonging to the pdb2_1 pluggable databases are backed up .
它成功了，但是只備份了屬于pdb2_1可插拔數據庫的數據文件。

12 you are administering a multitenant container database(cdb) cdb1 that has multiple pluggable databases(pdbs).
您正在管理一個多租戶容器數據庫(cdb) cdb1，它具有多個可插拔數據庫(pdbs)。
as the sys user on cdb$root,youesecutethecommands;作為cdb$root上的sys用戶，您可以執行命令;
sql> create user c##admin identified by orcl123;
創建由orcl123標識的用戶c##admin;
sql> grant create session to c##admin container=all;
sql>授予c##管理容器創建會話=all;
sql> grant create user to c##admin container=all;
sql> 授予創建用戶到c##管理容器=所有;
which two statements are true about the c##admin user that is created in all pdbs?
關于在所有pdbs中創建的c##admin用戶，哪兩條語句是正確的?

A) it can be granted only common roles in the pdbs.
它只能被授予pdbs中的公共角色。
C) it can create only local users in the cdb.
只能在cdb中創建本地用戶。

13 which two statements are true about resourece manager plans for individual pluggable databases(pdb pians) in a multitenant container database(cdb)?
關于多租戶容器數據庫(cdb)中的單個可插拔數據庫(pdb pians)的資源管理器計劃，哪兩種說法是正確的?
B) if on pdb plan is enabled for pluggable database, all for that pdb are treated to an equal share of resources.
如果對可插拔的數據庫啟用on pdb計劃，那么對于該pdb的所有資源都將被同等對待。
D) if a pdb plan is enabled for pluggable database , resources are allocated to consumer groups based on the provided to the pdb in the cdb plan and the shares provided to the consumer groups in the pdb plan.
如果pdb計劃啟用了可插拔數據庫，則根據cdb計劃中提供給pdb的資源和pdb計劃中提供給消費者組的共享，將資源分配給消費者組。

==================================================================================================================================================================

以前題型

01 which three are true about transparent data encryption(TDE)? 關于透明數據加密(TDE)，哪三個是正確的?

02 Rman is connected to the target database prod1 and an auxiliary instance in nomount state, examine the command to create a duplicate
database: Rman連接到目標數據庫prod1和一個處于nomount狀態的輔助實例，檢查命令來創建一個重復的數據庫:
ramn> duplicate target database to dup1 from active database nofilenamecheck password file spfile;
ramn>復制目標數據庫到dup1從活動數據庫nofilenamecheck密碼文件spfile;

B、the duplicate database has the same directory structre as the source
database. 重復數據庫與源數據庫具有相同的目錄結構。
E、the duplicate database is created by using the backups created during the execution of the duplicate command.
通過使用在執行duplicate命令期間創建的備份創建復制數據庫。

03 you take your database backups by using the RMAN media management interface(MMI) . 您可以使用RMAN媒體管理接口(MMI)進行數據庫備份。 which two are about theuse of the RMAN MMI?
哪兩個是關于RMAN MMI的使用的?
A) you can use it to crate proxy copies for database files;
您可以使用它來板條箱代理副本的數據庫文件;
D) you can useit to create image copies for entire file systems.
您可以使用它為整個文件系統創建映像副本。

04 examine this parameter in a database’s pfile:
在數據庫的pfile中檢查這個參數:
DB_create_file_dest = ‘/u01/app/oracle/oradata/’
you execute this command:
您執行以下命令:
sql> create database cdb1 default tablespace users default temporary tablespace temp undo tablespace undotbs1 enable pluggable database
sql>創建數據庫cdb1默認表空間用戶默認臨時表空間臨時表空間撤銷表空間undotbs1啟用可插拔數據庫
seed
種子
system datafiles size 125M autoextend on next 10M maxsize unlimited
系統數據文件大小為125M，在接下來的10M中自動擴展
sysaux datafiles size 100M;
sysaux數據文件大小為100M;
which three are true after successful database creation?
成功創建數據庫后，哪三個為真?
B) the files created for both the root and seed databases use oralce managed files(OMF).
為根數據庫和種子數據庫創建的文件使用oralce管理文件(OMF)。
D) CDB$ROOTisopenread/write.CDB$ROOT打開讀/寫。
E) PDB$SEEDisopenread?only.PDB$SEED是只讀打開的。

** 05 you plan create a new PDB by copying PDB$SEED.??您計劃通過復制PDB$SEED創建一個新的PDB。
which two requirements ensure a successful creation?
哪兩個需求確保了成功的創建?
B) a default service for the new PDB name must already exist.
新PDB名稱的默認服務必須已經存在。
E) a CDB, which will contain the PDB,must be granted the DBA role when creating the PDB.
在創建PDB時，包含PDB的CDB必須被授予DBA角色。

06 which two are true about RMAN image copies?
關于RMAN映像副本，哪兩個是正確的?
D) they can only be written to disk.
它們只能寫入磁盤。
E) they can be used as a level 0 incremental backup.
它們可以用作0級增量備份。

07 which two parameters must be set to configure the fast recovery area?
配置快速恢復區必須設置哪兩個參數?
C) DB_RECOVERY_FILE_DEST_SIZE
E) DB_RECOVERY_FILE_DEST

08 your multitenant container database(CDB) cdb1, has no startup triggers and contains multiple pluggable database(PDBs).
你的多租戶容器數據庫(CDB) cdb1，沒有啟動觸發器和包含多個可插拔數據庫(PDBs)
it was started up by using the command which executed successfully with no errors:
使用執行成功且沒有錯誤的命令啟動:
sql> startup mount
sql >啟動山
which two statements are true?
哪兩種說法是正確的?
A) all control files are opend.
所有控制文件都已打開。
D) the spfile is opened.
打開spfile。

09 examine this command:
檢查這個命令:
sql> creatae pluggable database pdb2 from pdb1
sql>從pdb1創建可插入數據庫pdb2
file_name_convert = (’/disk1/oralce/pdb1/’, ‘/disk2/oralce/pdb2/’ )
path_prefix = ‘/disk2/oralce/pdb2/’ ;
which two statements are true after successful execution?
成功執行后，哪兩個語句為真?
B) PDB2 will use shared undo.
PDB2將使用共享撤銷。
D) a meteadata description of PDB2 is stored in an XML file in ‘/disk2/oracle/pdb2/’;
PDB2的meteadata描述存儲在一個XML文件’/disk2/oracle/ PDB2 /'中;

10 you wish to create a guaranteed restore point for one of your database by executing this command:
你希望通過執行這個命令為你的一個數據庫創建一個有保證的恢復點:
sql> create restore point dbrsp1 guarantee flashback database;
sql>創建恢復點dbrsp1保證閃回數據庫;
which two are required for successful execution?
成功執行需要哪兩個?
E) the database must be in archivelog mode.
數據庫必須處于archivelog模式。
F) the databse must be mounted.
必須掛載數據庫。

11 which three methods can be used to create a pluggable database(PDB) in an existing multitenant container database(CDB)?
哪三種方法可以用于在現有的多租戶容器數據庫(CDB)中創建可插入數據庫(PDB) ?
A) use enterprise manager database express to create a PDB in an existing CDB.
使用enterprise manager database express在現有的CDB中創建PDB。
C) use the DBMS_PDB package to plug a non CDB into an existing CDB.
使用DBMS_PDB包將一個非CDB插入到現有的CDB中。
E) use the DBMS_PDB package to plug a pre-oracle 12c database into an existing CDB.
使用DBMS_PDB包將預oracle 12c數據庫插入到現有的CDB中。

12 you wish to create a guaranteed restore point for one of your database by executing this commmand:
你希望為你的一個數據庫創建一個有保證的恢復點，執行以下命令:
sql> create restore point dbrsp1 cuarantee flashback database;
創建恢復點dbrsp1 cuarantee閃回數據庫;
which two are required for successful execution?
成功執行需要哪兩個?
D) flashback database must be enabled.
必須啟用閃回數據庫。
E) the database must be in archivelog mode.
數據庫必須處于archivelog模式。

總結

以上是生活随笔為你收集整理的OCP12C题库，63数据库管理( Administration Workshop- 63)（新增）的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。