question 1
which three statements are true about automatic workload repository(AWR)?(choose three.)
關于自動工作負載存儲庫(AWR)，哪三條語句是正確的?(選擇三個)。
B) the awr data is stored in memory and in the database.
awr數據存儲在內存和數據庫中。
C) the snapshots collected by awr are used by the self-tuning components in the database.
awr收集的快照由數據庫中的自調優組件使用。
D) awr computes time model statistics based on time usage for activities, which are displayed in the v$SYStimemodelandV$SESS_TIME_MODEL viewa.
awr根據活動的時間使用情況計算時間模型統計信息，顯示在v$SYS時間模型和v$ SESS_TIME_MODEL視圖中。

qustion 2
you upgraded your database from pre-12c to a multitenant container database(CDB) containing pluggable database (PDBs).
您將數據庫從12c之前的版本升級為包含可插入數據庫的多租戶容器數據庫(CDB)。
examine the query and its output:
檢查查詢及其輸出:

which two tasks must you perform to add users with sysbackup, sysdg, and syskm privilege to the password file?
要將具有sysbackup、sysdg和syskm特權的用戶添加到密碼文件中，必須執行哪兩項任務?
(choose two)
(選擇兩個)
B) grant sysbackup, sysdg, and syskm privileges to the intended users.
向目標用戶授予sysbackup、sysdg和syskm特權。
D) re-create the password file eith sysbackup, sysdg, and syskn privilege, and force arguments set to yes.
重新創建密碼文件eith sysbackup、sysdg和syskn特權，并強制參數設置為yes。

question 3
an appplication accesses a small lookup table frequently .you notice that the required data blocks are getting aged out of the default buffer cache.
應用程序經常訪問一個小型查找表。您注意到所需的數據塊從默認緩沖區緩存中過時了。
how would you guarantee that the blocks for the table never age out?
如何保證表的塊永遠不會過期?
A) configure the keep buffer pool and alter the table with the corresponding storage clause.
配置keep緩沖池，用相應的storage子句修改表。

question 4
you conned using sql plus to the root container of a multitenant container database(CDB) with sysdba privilege.
您將sql plus用于具有sysdba特權的多租戶容器數據庫(CDB)的根容器。
the cdb has several pluuggable database(PDBs) open in the read/write mode.
cdb有幾個以讀/寫模式打開的可插入數據庫(PDBs)。
there are ongoing transactions in both the CDB and PDBs.
CDB和PDBs中都有正在進行的事務。
what happens alter issuing the shutdown transaction statement?
發出shutdown事務語句后會發生什么?
B) the shutdown proceeds as soon as all transactions in the CDB are either committed or rolled back.
一旦國開行中的所有事務被提交或回滾，關閉就繼續進行。

question 5
you are planning the creation of a new multitenant container database(CDB) and want to store the root and seed container data files in separate directories.
您正在計劃創建一個新的多租戶容器數據庫(CDB)，并希望將根容器和種子容器數據文件存儲在單獨的目錄中。
you plan to create the database using sql statements.
您計劃使用sql語句創建數據庫。
which three techniques can you use to achive this ?(choose three.)
你可以使用哪三種技巧來達到這個目的?
A) use oralce mananged files(OMF).
使用口頭管理文件(OMF)。
B) specify the seed file_name_convert clause.
指定種子file_name_convert子句。
C) specify the PDB_file_name_convert initialization parameter.
指定PDB_file_name_convert初始化參數。

QUESTION 6
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
您將把一個多tb的非CDB插入到現有的多租戶容器數據庫(CDB)中。
The characteristics of the non-CDB are as follows:
非國家開發銀行的特征如下:
–Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit
-版本:Oracle Database 11g Release 2(11.2.0.2.0) 64位
–Character set: AL32UTF8
個性設置:AL32UTF8
–National character set: AL16UTF16
-國家字符集:AL16UTF16
–O/S: Oracle Linux 6 64-bit
Oracle Linux 6 64位
The characteristics of the CDB are as follows:
國家開發銀行的特點如下:
–Version: Oracle Database 12c Release 1 64-bit
版本:Oracle數據庫12c發布1 64位
–Character Set: AL32UTF8
個性設置:AL32UTF8
–National character set: AL16UTF16
-國家字符集:AL16UTF16
–O/S: Oracle Linux 6 64-bit
Oracle Linux 6 64位
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?
在將非CDB插入CDB時，您應該使用哪種技術來最小化停機時間?
B) transportable tablespace.
移動式表空間。

question 7
your database supports an online transaction processing (OLTP) application.
您的數據庫支持在線事務處理(OLTP)應用程序。
the application is undergoing some major schema changes, such as addittion of new indexes and meterialized views.
應用程序正在進行一些主要的模式更改，比如添加新的索引和數據化視圖。
you want to check the impact of these changes on workload performance.
您希望檢查這些更改對工作負載性能的影響。
D) sql performance analyzer.
sql性能分析器。

question 8
an administrator account is granted the create session and set container system privileges.
管理員帳戶被授予創建會話和設置容器系統特權。
a multitenant container database(CDB) instant has the following parameter set: threaded_execution = false
多租戶容器數據庫(CDB) instant有以下參數設置:threaded_execution = false
which four statements are true about this adminisrator establishing connections to root in a CDB that has been opened in read only mode?(choose four.)
關于這個管理器在只讀模式下打開的CDB中建立到根的連接，哪四個語句是正確的?(選擇四。)
A) you can connect as a common user by using the connect statement.
您可以使用connect語句作為普通用戶進行連接。
C) you can connect by using easy connect.
您可以使用easy connect進行連接。
D) you can connect by using os authentication.
你可以通過操作系統認證進行連接。
E) you cna connect by using a net service name.
你可以使用網絡服務名進行連接。

question 9
examine the following query output:
檢查以下查詢輸出:

which statement is true?
哪種說法是正確的?
C) only create table and alter table statements generated by the import are logged.
只記錄導入生成的create table和alter table語句。

question 10
you notice a performance change in your production oralce database and you want to know which change has made this performance difference.
您注意到生產oralce數據庫中的性能變化，您想知道是哪個變化導致了性能的變化。
you generate the compare period automatic database diagnotic (ADDM) report to further investigation.
您可以生成比較周期自動數據庫診斷(ADDM)報告，以進行進一步的調查。
which three fimdings would you get from the report?(choose three.)
你從報告中得到哪三個信息?(選擇三個)。
A) it detacts any configuretion change that caused a performance difference in both time periods.
它消除了在兩個時間段內導致性能差異的任何配置更改。
B) it dientifies any workload change that caused a performance difference in both time periods.
區分在兩個時間段內導致性能差異的任何工作負載變化。
D) it shows the resource usage for CPM, memoey, and I/O in both time periods.
它顯示了在兩個時間段內CPM、memoey和I/O的資源使用情況。

question 11
examine the parameter for your database instance:
檢查參數為您的數據庫實例:

identify the reason why optimizer chose different execution plans.
確定優化器選擇不同執行計劃的原因。
A) the optimizer used a dynamic plan for the query.
優化器為查詢使用了一個動態計劃。

question 12
which three statements are true about adaptive sql plan management?(choose three.)
關于自適應sql計劃管理，哪三條語句是正確的?(選擇三個)。
A) it automatically performs verification or evolves non-accepted plans, in comprehensive mode when they perform better than existing accepted plans.
當未被接受的計劃執行得比現有的被接受的計劃更好時，以綜合模式自動執行驗證或演進。
D) the non-accepted plans are automatically accepted and become usable by the optimizer if they perform better than 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.
sql計劃基線中不被接受的計劃會在夜間維護窗口中以綜合模式自動發展，并生成一個持久的驗證報告。

question 13
you create a new pluggable database, hr_pdb, from the seed database, which three tablespace are created by default in hr_pdb ?(choose three.)
從種子數據庫中創建一個新的可插拔數據庫hr_pdb，在hr_pdb ?中默認創建了這三個表空間(選擇三個)。
A) system.
系統。
B) sysaux.
E) temp.

question 14
which two statements are about varable size support for large ASM files?(choose two.)
哪兩個聲明是關于可變大小支持大ASM文件?(選擇兩個。)
A) the metadata used to track extents in SGA is reduced.
減少SGA中用于跟蹤區段的元數據。
C) an ASM lnstance automatically allocates an appropriate extent size.
ASM自動分配適當的區段大小。

question 15
you executed a drop user cascade onan oralce 11g release 1 database and immediately and realized that you forgot to copy the oca.exam_results table to the ocp schema.
您在oralce 11g release 1數據庫上執行了一個drop用戶級聯，并立即意識到您忘記了復制oca.ocp模式的exam_results表。
the recycle_bin enabled before the drop user was executed and the ocp user has been granted the flashback any table system privilege.
在執行drop用戶之前啟用了recycle_bin，并且ocp用戶已經被授予flashback any table系統特權。
waht is the quickest way to recover the contents of the oca.exam_results table to the ocp schema?
什么是恢復oca內容物的最快方法?ocp模式的exam_results表?
C) recover the table using automated tablespace point time recovery.
使用自動表空間點時間恢復恢復表。

question 16
in your multitenant container database (CDB) containing pluggable (PDBs), the hr user executes the following commands to create and grant privileges on a procedure:
在包含pluggable (PDBs)的多租戶容器數據庫(CDB)中，hr用戶執行以下命令來創建和授予過程的特權:

How can you prevent users having the EXECUTE privilege on the CREATE_TEST procedure from inserting values into tables on which they do not have any privileges?
如何防止在CREATE_TEST過程中擁有EXECUTE特權的用戶將值插入到他們沒有任何特權的表中?
C) create the create_test procedure with onvoker’s rights.
創建具有onvoker權限的create_test過程。

question 17
you created a new database using the “create database” statement without specifying the "enable pluggable " clause.
您使用“create database”語句創建了一個新數據庫，而沒有指定“enable pluggable”子句。
waht are two effects of not using the " enable pluggable database " clause?
不使用" enable pluggable database "子句的兩個影響是什么?
A) the database is created as a non-cdb and can never contain a pdb.
數據庫創建為非cdb，不能包含pdb。
D) the database is created as a non-cdb but can be plugged into an existing cdb.
數據庫創建為非國家開發銀行，但可以插入到現有的國家開發銀行。

question 18
what is the effect of specifying the " enable pluggable database " clause in a " create database " statement?
在“create database”語句中指定“enable pluggable database”子句會有什么影響?
B) it will create a cdb with root opened and seed read only.
它將創建一個打開根目錄且種子為只讀的cdb。

question 19
you have installed two 64G flash devices to support the database smart flash cache feature on your database server that is running on oralce linux.
您已經在運行在oralce linux上的數據庫服務器上安裝了兩個64G閃存設備來支持數據庫智能閃存緩存特性。
you have set the db_smart_flash_file parameter: db_flash_cache_file= ‘/dev/flash_device_1’ , ’ /dev/flash_device_2’
您設置了db_smart_flash_file參數:db_flash_cache_file= ‘/dev/flash_device_1’， ‘/dev/ flash_device_2’
how should the db_flash_cache_size be configured ro use bith devices?
如何db_flash_cache_size配置ro使用bith設備?
B) set bd_flash_cache_zise = 64G, 64G.
設置bd_flash_cache_zise = 64G, 64G。

question 20
examine the following parameters for a database instance:
檢查數據庫實例的以下參數:
memory_max_target=0
memory_target=0
sga_target=0
pga_aggegate_target=500m
which three initialization parameters are not controlled by automatic shared memory management (ASSM)?(choose three)
哪三個初始化參數不被自動共享內存管理(ASSM)控制?(選擇三個)
A) log_buffer.
E) db_16k_cache_size.
F) db_keep_cacke_size.

question 21
examine the contents of sql loader comtrol file:
檢查sql loader comtrol文件的內容:
load data
加載數據
infile myfile1.dat
infile myfile2.dat
field names first file
第一個文件
append
附加
into table emp
在emp表
fields csv with embedded
嵌入的字段csv
date format ''DD-Month_YYYY"
日期格式“DD-Month_YYYY”
(empno,
ename,
job,
mgr,
hiredate DATE,
sal,
comm,
deptno,
entryda te DATE)
which three statements are true regarding the sqlLoader operation performed using the control file?(choose three.)
關于使用控制文件執行的sql加載器操作，哪三條語句是正確的?(選擇三個)。
A) an emp table is created if a table does not exist.otherwise, if the emp table is appended with the loaded data.
如果emp表不存在，則創建emp表。否則，如果emp表附加了加載的數據。
B) the sqlloader data file myfile1.dat has the colum names for the emp table.
sql加載器數據文件myfile1.dat有emp表的colum名稱。
E) the sqlloader operation that the file must be a stream record format file with the normal carriage return string as the record terminator.
sqlloader操作，該文件必須是一個流記錄格式文件，用普通回車字符串作為記錄終止符。

question 22
examine the contents of sql loader control file:
檢查sql加載器控制文件的內容:
load data
加載數據
infile myfile1.dat
infile myfile2.dat
field names first file
第一個文件
append
附加
info table emp
emp信息表
fielads csv with emmbedded
字段csv與emmbedded
date format “DD-month_YYYY”
日期格式“DD-month_YYYY”
(empno,
Ename,
job,
mgr,
hiredate date,
sal,
comm,
deptno,
entryda te date)
which three statements are true regarding the sqlloader operation performed using the control file?(choose three.)
關于使用控制文件執行的sql加載器操作，哪三條語句是正確的?(選擇三個)。
A) an emp table is created if a table does not exist.otherwise, if the emp table is appended with the loaded data.
如果emp表不存在，則創建emp表，否則，如果emp表附加了加載的數據。
B) the sqlloader data file myfile1.dat has the column names for the emp table.
sql加載器數據文件myfile1.dat包含emp表的列名。
E) the sql*loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.
的sql *裝載機操作假定文件必須與正常的流記錄格式文件回車字符串作為終結者的記錄。

question 23
in your multitenant container database (CDB) containing pluggable database (PDBs), you granted the create table privilege to the common user C## A_ADMIN in root and all PDBs.
在包含可插入數據庫(pluggable database, PDBs)的多租戶容器數據庫(CDB)中，您將create table特權授予了根用戶和所有PDBs中的公共用戶c# # A_ADMIN。
you execute the following command form the root container:
在根容器中執行以下命令:
SQL> revoke create table form C## A_ADMIN;
撤銷創建表形式c# # A_ADMIN;
what is the result?
結果如何?
A) it executes successfully and the create table privilege is revoked from C##A_ADMIN in root only.
它成功執行，并且僅在根用戶中撤銷了c# #A_ADMIN的create table特權。

question 24
which two tatements are true concerning the resource manager plans for individual pluggaable databases(PDB plans) in a multitenant container database (CDB)?(choose two.)
關于多租戶容器數據庫(CDB)中單個可插拔數據庫(PDB計劃)的資源管理器計劃，哪兩種說法是正確的?(選擇兩個。)
A) if on PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that PDB.
如果在PDB計劃上啟用了一個可插拔的數據庫，那么對于該PDB的所有會話將被同等程度地對待該PDB的資源共享。
E) if a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
如果PDB計劃為可插拔數據庫啟用，那么根據CDB計劃中提供給PDB的共享和PDB計劃中提供給消費者組的共享，將資源分配給消費者組。

總結

以上是生活随笔為你收集整理的12C OCP IZO-62 题库（8月以前）的全部內容，希望文章能夠幫你解決所遇到的問題。

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