題數：20+53

10月新增

5 examine the details of the uncompressed,non-partitioned heap table cities.
檢查未壓縮、未分區的堆表城市的細節。

examine the command: 檢查命令:
SQL> alter table cities shrink space compact;
SQL> alter表城市縮小空間緊湊;
what must you do before executing it?
在執行它之前你必須做什么?
C) make sure that row movement is enabled.
確保行移動是啟用的。

解釋：參考53題，段收縮前，保證表空間是ASSM，且啟用了行移動

**9 a database runs in noarchivelog mode.
數據庫在noarchivelog模式下運行。**l
backup scheduling for this database must be automated before upgrading to a new version of the database.
在升級到數據庫的新版本之前，必須自動執行該數據庫的備份調度。
which two tools or utilities can do this?
哪兩個工具或實用程序可以做到這一點?
B) database upgrade assistant(DBUA)
數據庫升級助理(DBUA)
C) oracle enterprise manager cloud control
oracle enterprise manager云控制
解釋： DBUA在12的版本中加入特性，可以選擇在升級的過程中執行RMAN備份。

**12 you must create a table, DAILY_ORDERS, for a DSS application.
您必須為DSS應用程序創建一個表DAILY_ORDERS。
date should be compressed when using direct-path insert the table will also be used for occasional Dss queries.
使用直接路徑插入時，日期應該被壓縮，表也將用于偶爾的Dss查詢。 load performance is critical
負載性能至關重要
which compression option satisfies these requirements?
哪種壓縮選項滿足這些需求?
B) row store compress advanced
行存儲壓縮高級

13 examine these comands and output
檢查這些字符和輸出
select open_mode from v$database;從v$database中選擇open_mode;

now examine these steps
現在檢查這些步驟
1 startup nomount
啟動nomount
2 startup mount
啟動
3 startup force
創業力
4 alter database archivelog
更改數據庫archivelog
5 alter database mount
alter數據庫掛載
6 alter database opwen resetlogs
更改數據庫opwen resetlogs
7 shutdown immediate
立即關閉
8 alter database open
alter數據庫打開
identify the required steps in the correct order to change the database to run in archivelog mode.
按照正確的順序確定將數據庫更改為在archivelog模式下運行所需的步驟。
B) 7,2,4,8

39 a database runs in archive log mode.
數據庫在存檔日志模式下運行。
daily full database backups are taken with rman which is configured to perform control file autobackup.
使用rman執行每日的完整數據庫備份，rman被配置為執行控制文件自動備份。
the control file and redo log files are multi-plexed
控制文件和重做日志文件是多叢的
in which two cases is media recovery required?
在哪兩種情況下需要進行媒體恢復?
C) loss of data files that belong to the sysaux tablespace
sysaux表空間中的數據文件丟失
D) physical corruption data
物理損壞數據

47 examine these configuration details:
檢查這些配置細節:
1 a fast recovery area(FRA)has been specified for a database.
為數據庫指定了快速恢復區域(FRA)。
2 the database insta ce is in archivelog mode
數據庫實例處于archivelog模式
3 the default location for archivelog redo log files is the FRA.
archivelog重做日志文件的默認位置是FRA。
which two types of files are removed automatically due to space pressure in the FRA?
哪兩種類型的文件會由于聯邦鐵路局的空格壓力而被自動刪除?
A obsolete spfiles
一個過時的spfiles
F obsolete RMAN database backup sets
過時的RMAN數據庫備份集
解釋：expired是本來RMAN以為存在但是實際上在磁盤或者磁帶上已經被刪除了的文件。

56 examine this configuration for one of your databases:
檢查這個配置為你的數據庫之一:
1 undo_retention parameter is 1000
undo_retention參數為1000
2 retention is not guaranteed
不能保證保留
3 the undo tablespace is fixed size.
undo表空間的大小是固定的。
which two statements are true?
哪兩種說法是正確的?
A) lnactive undo is retained for at least 1000 seconds if free undo space is available.
如果有空閑的撤銷空間，自動撤銷將保留至少1000秒。
E) active undo never becomes expired.
主動撤銷不會過期。

60 you must upgrade your oralce 11g database to oracle 12c r2.
你必須升級你的oralce 11g數據庫到oracle 12cr2。
which method can you use?
你可以使用哪種方法?
D) perform a rolling upgrade.
執行滾動升級。

61
which two statemens are true?
哪兩個火箭人是真的?
A) the tablespace, test1,can have allocated extents of different sizes.
表空間test1可以分配不同大小的區段。
C) allocated and free extent sizes are always multiples of 1M.
已分配的和空閑的區段大小總是1M的倍數。

64 which two can be used to create and populate a table from the contents of a textual flat file?
哪兩個可以用于從文本平面文件的內容創建和填充表?
A) use create table…as select from an oralce dataoump type external table.
使用create table…當從一個口頭數據oump類型外部表中選擇時。
E) use create table… as select from an oralce loader type external table.
使用create table…從一個oralce加載器類型中選擇外部表。
解釋：SQL*LOADER不能創建表。

16 A new database has no RMAN backups yet.
新數據庫還沒有RMAN備份。
Examine these commands:
檢查這些命令:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
將保留策略配置為冗余2;
RMAN> BACKUP TABLESPACE SYSTEM;
RMAN>備份表空間系統;
. .
backup set complete, elapsed time: 00:00:03
備份集完成，運行時間:00:00:03
…
RMAN> BACKUP TABLESPACE SYSTEM, SYSAUX;
RMAN>備份表空間系統;
…
backup set complete, elapsed time:00:00:04
備份集完成，運行時間:00:00:04
RNAN> BACKUP DATABASE
RNAN >備份數據庫
…
backup set complete,elapsed time: 00:00:07
備份集完成，運行時間:00:00:07
…
Which two are true about the execution of the third backup command?
關于第三個備份命令的執行，哪兩個是正確的?
A)A backup is performed for the SYSTEM tablespace.
對系統表空間執行備份。
C) The first backup of the SYSTEM tablespace is considered expledxplired.
系統表空間的第一次備份被認為是expledxplired的。

14.Examine these configuration details
檢查以下配置細節
1.A Fast Recovery Area(FRA) has been specified for a database.
已經為數據庫指定了快速恢復區域(FRA)。
2.The database instance is in ARCHIVELOG mode
數據庫實例處于ARCHIVELOG模式
3.The default location for archived redo log files is the FRA.
存檔重做日志文件的默認位置是FRA。
Which two types of files are removed automatically due to space pressure in the FRA?
哪兩種類型的文件會由于聯邦鐵路局的空格壓力而被自動刪除?
A) obsolete rman database backup sets.
過時的rman數據庫備份集。
F) flashback logs
閃回日志

15.Examine this command:
檢查這個命令:
SQL>ALTER SYSTEM SET ENABLE_DDL_LOGGING=TRUE;
Which two statements are true?
哪兩種說法是正確的?
D) some DDL statements are sritten to a text file in the ADR home.
一些DDL語句被寫入ADR home中的文本文件。
F) Some DDL statements are written to an XM].,file in the ADR home.
一些DDL語句被寫入XM文件在ADR家中。

27.Which two statements are true about Oracle network connections?
關于Oracle網絡連接，哪兩種說法是正確的?
B) The listener can spawn a new server process to deal with a new connection.
偵聽器可以產生一個新的服務器進程來處理一個新的連接。
E)The listener checks a user’s authentication credentials and creates a session if the credentials are valid.
偵聽器檢查用戶的身份驗證憑證，如果憑證有效，則創建會話。

** 一 8月新增：**

Which two statements are true about initialization parameter files?
A. A lost or damaged SPFILE can be re-created by using the parameter values listed in the alert log
B. On startup, by default a database instance always first searches for an SPFILE, and if it does not find any, searches for a PFILE
C. A PFILE must exist for an SPFILE to be created
D. The ALTER SYSTEM command cannot be used to change the value of any parameter if a database instance has started using a PFILE
E. Both the SPFILE and PFILE must always reside on a file system accessible from the database host server

01 Examine this parameter:
檢查這個參數:
NAME TYPE VALUE
名稱類型值
db_create_file_dest string/u01/app/oracle/oradata/prod/
db_create_file_dest字符串/ u01 / app / oracle / oradata /刺激/
Now examine this statement which executes successfully in an Oracle Database version 12c or later.
現在檢查在Oracle數據庫版本12c或更高版本中成功執行的這條語句。
CREATE TABLESPACE data_olap;
創建表空間data_olap;
Which two are true about this tablespace and its attributes?
關于這個表空間及其屬性，哪兩個是正確的?
C) the datafile has an oracle generated name.
數據文件有一個oracle生成的名稱。
D) the initial datafile size ls 100MB.
初始數據文件大小為100MB。

02 which two are true about database table rows?
關于數據庫表行，哪兩個是正確的?
A) they can be stored in a single database block.
它們可以存儲在單個數據庫塊中。
C) they always have a row header.
它們總是有一個行標題。

03 Examine these statements：
檢查這些語句:
Connect /as sysdba
連接/ sysdba
Connected.
連接。
GRANT CREATE USER
格蘭特創建用戶
TO hr
對人力資源
WITH ADMIN OPTION;
管理選項;
Grant succeeded.
授權成功。
conn / as sysdba
conn / as sysdba
Connected.
連接。
REVOKE CREATE USER
撤銷創建用戶
FROM hr;
從人力資源;
Revoke succeeded.
撤銷成功。

Which two are true about the result and effects of executing these commands?
關于執行這些命令的結果和效果，哪兩個是正確的?
C) the revoke statement successfully revokes the system privilege from user HR.
revoke語句成功地從用戶HR撤消系統特權。
D) user aliceis permitted to grant the create user privilage to user hr.
允許用戶alice將create user特權授予用戶hr。

04 Examine these statements: 檢查這些語句:

ALTER SYSTEM SET RESOURCE_LIMIT=FALSE SCOPE=BOTH; ALTER SYSTEM SET
RESOURCE_LIMIT=FALSE SCOPE=BOTH;

Sysyem

altered.

CREATE PROFLLE dev_users LIMIT
創建PROFLLE dev_users限制
SESSIONS_PER_USER 3 SESSIONS_PER_USER 3

IDLE_TIME 10 IDLE_TIME 10

FAILED_LOGIN_ATTEMPTS 3 FAILED_LOGIN_ATTEMPTS 3

PASSWORD_VERIFY_FUNCTION ora12c_verify_function;
Profile altered.
配置文件修改。

ALTER USER hr PROFILE dev_users;
更改用戶hr配置文件dev_users;

User altered.
用戶修改。

Which two are true?
哪兩個是正確的?

B) user HRv session will terminate after ten minutes of continuous inactivity.
用戶HRv會話將在連續10分鐘不活動后終止。

D) password complexity checking is enforced for user HR.
對用戶HR執行密碼復雜性檢查。

05 ln which two situations can you use threshold server-generated alerts to help diagnose and fix problems?
在哪兩種情況下可以使用閾值服務器生成的警報來幫助診斷和修復問題?
D) when free space in a locally managed tablespace falls below a specified percentage.
當本地管理的表空間中的空閑空間低于指定的百分比時。
E) when the number of logons per second exceeds a specific value.
當每秒登錄次數超過某個特定值時。

06 an employee salary in the non-partitioned employees table, has been updataed but the transaction is uncommitted.
已更新未分區employees表中的員工工資，但事務未提交。
which two types of lock are held by the transaction?
事務持有哪兩種類型的鎖?
C) an exclusive lock on the employees table
employees表上的排他鎖
E) a row level lock on the row being updated.
被更新行的行級鎖。

07 which three statements are true about a job chain?
關于作業鏈，哪三個陳述是正確的?
B) it can be executed using event-based schedules.
可以使用基于事件的調度來執行。
D) it can be used to implement dependency-based scheduling.
可用于實現基于依賴的調度。
E) it can be executed using time-based schedules.
可以使用基于時間的時間表來執行。

08 One of your databases runs in ARCHIVELOG mode
其中一個數據庫以ARCHIVELOG模式運行
Examine this command:
檢查這個命令:
SELECT open_mode FROM v$database;從v$database中選擇open_mode;
OPEN_MODE
Now examine these steps executed from RMAN;
現在檢查從RMAN執行的這些步驟;

shutdown immediate
立即關閉

startup database;
啟動數據庫;

backup database;
備份數據庫;

backup archivelog all;
備份archivelog all;

alter database open;
alter database open;

startup
6)啟動
identify the minimum required steps in the correct order neeed to perform a whole consistent database_backup
按照正確的順序確定執行整個一致的database_backup所需的最小步驟
C) 1,2,3,4,5

09 Examine these commands:
檢查這些命令:
connect /as sysdba
連接/ sysdba
create directory dumpdir as ‘/u01/app/’;
創建目錄dumpdir為’/u01/app/’;
dirretory created.
dirretory創建。
grant read,write on directory dumpdir to public;
將目錄dumpdir上的讀、寫授權給public;
grant succeeded.
授權成功。
create user test identified by test;
創建由測試識別的用戶測試;
user created
用戶創建。
grant create session,resource,unlimited tablespace to test;
授予創建會話，資源，無限的表空間來測試;
grant succeeded.
授權成功。
conn test/test
康涅狄格州測試/測試
connectde.
cretae table test_employees(id number(3), name varchar2(20), salary number(7));
表test_employees(id號(3)，姓名varchar2(20)，工資號(7));
table created.
創建表。
SQL> create synonym emp for test_employees;
為test_employees創建同義詞emp;
synonym created.
創建同義詞。
now examine this command;
現在檢查這個命令;
$ expdp test/test DIRECTORY=dumpdir DUMPFILE=test_emp,dmp LOGFILE=test.log TABLES=emp CONTENT=data_only salary=12000”’
which is true?
這是真的嗎?
A) it throws an error as date pump cannot find a table called test.emp
它拋出一個錯誤，因為日期泵無法找到一個名為test.emp的表

10 Which three statements are true about the SQL Tuning Advisor?
關于SQL調優顧問，哪三條語句是正確的?
A)It can run while a maintenance window is open.
它可以在打開維護窗口時運行。
B) It can rebuild indexes
可以重建索引
C)It can get input from the Automatic Workload Repository(AWR)
它可以從自動工作負載存儲庫(AWR)獲取輸入
D)It can get input from SQL Scripts in flat files
它可以在平面文件中從SQL腳本獲取輸入
E) It can recommend creation of SQL plan baselines
它可以建議創建SQL計劃基線
F) It prevents regression of SQL statement performance
防止SQL語句性能的回歸
答案：A C E| 該題答案感覺E不是很對，不過F也大對，沒有更好的選項了

11 Examine this command：
檢查這個命令:
STARTOP PFILE=’D:\Oraclel2c\Oracle\admin\orel\pfile\pfileinitorel.era’
CRACLE instance started.
CRACLE實例開始。
Tctal System Global Area 5117049968 bytes
Tctal系統全球區域5117049968字節
Pixed Sixe 9038960 bytes
字節數為9038960
Variable Sire 922746880 bytes
變量Sire 922746880字節
Database Buffers 4177526784 bytes
數據庫緩沖區4177526784字節
Redo Buffers 7737344 bytes
重做緩沖區7737344字節
Database mounted.
數據庫安裝。
Database opened.
數據庫打開。
Now examine these staterments;
現在檢查一下這些陳述;
SHOW PARAMETER cursor_sharing;
顯示參數cursor_sharing;
NAME TYPE VALUE
名稱類型值
curscr_sharing string EXACT
curscr_sharing字符串精確
ALTER SYSTEM SET cursor_sharing=PORCE;

which three are true bout the result of processing the statement?
關于處理語句的結果，哪三個是真的?
B) the parameter is modified in memmory only.
參數僅在內存中修改。
C) the modification persists across instance checkpoints.
修改在實例檢查點之間持續存在。
F)The modification does not persist across a SHUTDOWN TRANSACTINAL command.
修改不會在SHUTDOWN TRANSACTINAL命令中持久存在。

12 Examine these commands：
檢查這些命令:
SELECT open_mode FRCN V$database;選擇ope{n}_{m}odeFRCNV$database;
OPEN_MOOE
READ WRITE
閱讀寫
ARCRIVE LOG LIST;
ARCRIVE日志列表;
Database log mode No Archive Mode
數據庫日志模式沒有存檔模式
Automatic archival Disabled
禁用自動歸檔
Archive destination USE_DB_RECOVERY_FILE_DEST
歸檔目的地use_db_recovery_file_dest
…
Now examine these steps:
現在檢查一下這些步驟:
1)STARTUP NOMOUNT
啟動NOMOUNT
2)STARTUP MOUNT
啟動山
3)STARTUP FORCE
創業力
4)ALTER DATABASE ARCHIVELOG;
修改數據庫ARCHIVELOG;
5)SHUTDOWN TRANSACTIONAL
關閉事務
6)ALTER DATABASE OPEN;
改變數據庫開放;
7)SHTDOWN ABORT
SHTDOWN中止
8)ALTER DATABASE MOUNT
改變數據庫掛載

Identify the required steos in the correct order to change the database to run in ARCHIVELOG mode.
以正確的順序標識所需的steos，以便將數據庫更改為在ARCHIVELOG模式下運行。
D)5,2,4,6

13 Examine this parameter setting：
檢查此參數設置:
SHOW PARAMETER undo_retention;
顯示參數undo_retention;
NAME TYPE VALUE
名稱類型值
undo_retention integer 900
undo_retention整數900
Now examine these statements:
現在來看看這些說法:
SELECT TABLESPACE_NAME,RETENTION
選擇TABLESPACE_NAME,保留
FROM dba_tablespaces
從dba_tablespaces
WHERE TABLESPACE_NAME=’UNDOTBSI’;
在TABLESPACE_NAME =“UNDOTBSI”;
TABLESPACE_NAME RETENION
tablespace_name retenion
UNDOTBSI GUARANTEE
undotbsi保證
conn hr/hr@PROD
康涅狄格州人力資源/ hr@PROD
Connected.
連接。
INSERT INTO emp(id,name,salary,Depno)
插入emp (id、名稱、工資、Depno)
VALUES(101,’John’,12000,30);
“約翰”值(101年,12000年,30);
1 rowcreated.
COMMIT;
提交;
Commit complete.
提交完成。
Which three are true about the processing of these statements?
關于這些陳述的處理過程，哪三個是正確的?
A） LGWR might write redo generated by the insert statement to the redo log before the commit is executed.
LGWR可能會在執行提交之前將insert語句生成的重做寫入重做日志。
E) undo generated for the transaction will be in an unexpired state immediately after the commit.
事務生成的undo在提交后立即處于未過期狀態。
F) DBWR might write the content of the modified emp table block image to a data file before the commit is executed.
DBWR可能會在執行提交之前將修改后的emp表塊映像的內容寫入數據文件。

14 SELECT TABLESPACE_NAME,RETENION FROM dba_tablespaces WHERE TABLESPACE_NAME=’UNDOTBS1’;
TABLESPACE_NAME RETENTION
UNDOBS1 GUARANTEE
conn hr/hr@PROD
Connected.
連接。
INSERT INTO emp (id,name,salary,Depno)
插入到emp (id，姓名，薪水，Depno)
VALUES(101,’John’,12000,30);
“約翰”值(101年,12000年,30);
1 row created.
1行。
COMMIT;
提交;
Commit complete.
提交完成。
which three are true about the processing of these statements?
關于這些陳述的處理過程，哪三個是正確的?
A） undo generated for the transaction will be in an unexpired state immediately after the commit.
在提交之后，為事務生成的撤銷將立即處于未過期狀態。
D) DBWR might write the content of the modified em table block image to a data file before the commit is executed.
DBWR可能會在執行提交之前將修改后的em表塊映像的內容寫入數據文件。
G) LGWR might write redo generated by the insert statement to the redo log before the commit is executed.
LGWR可能會在執行提交之前將insert語句生成的重做寫入重做日志。

15 examine this command :
15 檢查這個命令:
starup pfile=‘D:\oracle12c\oracle\admin\orcl\pfile\pfileinitorcl.ora’
oracle instance started.
oracle實例開始。
Total System Global Area 5117049968 bytes
總系統全球區域5117049968字節
Fixed Size 9038960 bytes
固定大小9038960字節
Variable Buffers 922746880 bytes
可變緩沖區922746880字節
Database mounted 4177526784 bytes
數據庫裝載了4177526784字節
Redo Buffers 7737344 bytes
重做緩沖區7737344字節
Database mounted.
數據庫安裝。
Databade opened.
Databade打開。
Now examine these statements:
現在來看看這些說法:
SHOW PARAMETBX cursor_shaering;
顯示PARAMETBX cursor_shaering;
NAME TYPE VALUE
名稱類型值
cursor_sharing string EXACT
cursor_sharing字符串精確
ALTER SYSTEM SET cursor_sharing=FORCE;
修改系統設置cursor_sharing=FORCE;

Which three are true about the result of processing the last statement?
關于處理最后語句的結果，哪三個是正確的?
A) the modification persists across instance checkpoints
修改在實例檢查點之間持續存在
B) the parameter modified in memory only
僅在內存中修改的參數
C) the modification does not persist across a shutdown transact lonal command
修改不會在關閉事務處理命令中持久存在

16 which three are true about the oracle job scheduler and its components?
關于oracle作業調度器及其組件，哪三個是正確的?
A) a newly created job is disabled by default.
默認情況下，新創建的作業是禁用的。
E) the create any job privilege permits a user to create a job in any scheme including sys
create any job特權允許用戶在任何方案(包括sys)中創建作業
F) a program can be invoked by multiple jobs.
一個程序可以被多個作業調用。

17 which two statements are true about the database configuration assistantI(DBCA)?
C) it can generate sql database creation scripts.
D) it can be used to create a database template from an existing database.

18 Examine these statements：
檢查這些陳述:
CREATE ROLE dev1;
創建角色dev1;
Role created.
創建角色。
GRANT CREATE SESSION,
格蘭特創建會話,
CREATE USER,CREATE TABLE
創建用戶,創建表
TO dev1;
dev1;
Grant succeeded,
格蘭特成功了,
CREATE USER john
創建用戶約翰
IDENTIFIED BY john;
由約翰;
User created.
用戶創建的。
GRANT CONNECT,dev1
格蘭特連接,dev1
To john;
約翰;
Grant succeeded.
授權成功。
REVOKE CREATE SESSION
撤銷創建會話
FROM dev1;
從dev1;
Revoke succeeded.
撤銷成功。

Which two are true about the result and effects of executing these commands?
關于執行這些命令的結果和效果，哪兩個是正確的?
A) user john is permitted to connect to the database.
用戶john被允許連接到數據庫。
D) create session is only revoked from role dev1.
僅從角色dev1撤消創建會話。

19 which two are true about database table rows?
關于數據庫表行，哪兩個為真?
C) they always have ow.
他們總是有ow。
D) they can be stored in a single database bolck.
它們可以存儲在單個數據庫中。

20 which two categories of segments are analyzed by the automatic
segment advisor?
自動段顧問分析哪兩類段?
A) segments the have the highest growth rate in a database.
數據庫中增長率最高的段。
B) segments in tablespaces that have execeeded a critical or warning
space threshold.
表空間中已超過臨界或警告空間閾值的段。

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

二 62新增題庫

01 which two statements are ture about using SQL*Loader？
關于使用SQL*Loader，哪兩條語句是正確的

A、it can generate unique sequential key values in sppecified columns
它可以在指定的列中生成惟一的順序鍵值
E、it can load data into multiple tables using thesame load statement
它可以使用相同的load語句將數據加載到多個表中

02 you use multiple temporay tables frequently in your database,
which two are benefits of configuring temporary undo?

在數據庫中經常使用多個臨時表，配置臨時撤銷的兩個好處是什么?
C、preformance inproves bacause less redo is written to the redo log;
性能不佳，因為寫入重做日志的重做量更少;
D、emporary undoreduces the amount of undo stored in undo tablespaces;
暫時性撤銷減少了undo表空間中存儲的undo數量;

03 which three are true about the oralce job scheduler and its componente?
關于oralce作業調度器及其組件，哪三個是正確的?
B) a newly create job is disabled by default.
默認情況下，新創建的作業是禁用的。
D) a job can run only when a schedule window is open.
作業只能在調度窗口打開時運行。
E) a program can be invoked by multiple jobs.
一個程序可以被多個作業調用。

04 which two are true about the smon background process?
關于smon后臺進程，哪兩個是正確的?
A) it deletes orphaned temporary segments in permmanent tablespaces.
它刪除永久表空間中的孤立臨時段。
C) it per forms instance reconery,if required , at instance startup.
如果需要，在實例啟動時對每個表單實例進行重新配置。

05 SALES is a valid TNS entry referring to:
SALES是一個有效的TNS條目，指:
Hostname:HOST01 Port:1521 Service_name:SALES_SRV
主機名:HOST01端口:1521 Service_name: SALES_SRV
You issue this command: $tnspingSALES您發出這個命令:$tnsping SALES
Which two are true?
哪兩個是正確的?
A） it validates that SALES is a valid TNSNAMES entry reachable by the configured name resolution method.
它驗證SALES是一個有效的TNSNAMES條目，可通過配置的名稱解析方法訪問。
E) it validates that thre is listener on HOST01 port 1521.
它驗證thre是HOST01端口1521上的偵聽器。

06 you want to distribute a set of srtuctured data to your customers who can integrate this data into their existing databases irrespective of the platform.
您希望將一組結構化數據分發給客戶，客戶可以將這些數據集成到他們現有的數據庫中，而不用考慮平臺。
A）using SQL*Loader
使用SQL *加載程序

07 which statement is true about redo log files during instance recovery?
關于實例恢復期間重做日志文件，哪條語句是正確的?
C) all redo log entries in the current and active logs are applied to data files to reconstruct changes made after the most recent checkpoint.
當前日志和活動日志中的所有重做日志條目都應用于數據文件，以重建最近檢查點之后所做的更改。

08 Examine this parameter setting:
檢查此參數設置:
SHOW PARAMETER INMEMORY_ SIZE NAME TYPE VALUE
顯示參數INMEMORY_ SIZE名稱類型值
inmemory_size big integer 1G
inmemory_size大整數1G
Now examine this command : ALTER TABLE hr.emp INMEMORY ;
現在檢查這個命令:ALTER TABLE hr.emp INMEMORY;
Table altered .
表改變。
Which is true about effects of this command and any subsequent processing on hr.emp?
關于此命令的影響以及對hr.emp的后續處理，哪個是正確的?
A) its data gets loaded into the Im Column store in columnar format.
它的數據以柱狀格式加載到內存列存儲中。

09 you configured the fast recovery area(FRA) for your database.
你為你的數據庫配置了快速恢復區域(FRA)。
the database instance is in archivelog mode and the default location for the archived redolog file is the FRA.
數據庫實例處于archivelog模式，存檔redolog文件的默認位置是FRA。
which two files are removed automatically if space is required in the FRA as per the retention policy?
根據保留政策，如果聯邦鐵路局需要空間，哪兩個文件會被自動刪除?**
C) archived rdao log files that have copies in a different archive location;
存檔的rdao日志文件，備份到不同的存檔位置;
E) obsolete RMAN backups.
過時的RMAN備份。

10 which three statements are true about the SQL Tuning Advisor?
關于SQL調優顧問，哪三條語句是正確的?
C) it can rebuild indexes;
可以重建索引;
D) it can get input from the automatic workload repository(AWR);
可以從自動工作負載存儲庫(AWR)獲取輸入;
E) it can run while a maintenance window is open.
它可以在打開維護窗口時運行。

11 which four are true about the shutdown transactional command and its effects in a single instance oracle database environmment with a single active transaction?
關于關閉事務命令及其在具有單個活動事務的單實例oracle數據庫環境中的影響，哪四個是正確的?
B) an instance shutdown will occur if the transaction issues a rollback.
如果事務發出回滾，實例將關閉。
C) all sessions are terminated when the transaction ends.
事務結束時，所有會話終止。
D) sessions are unable to begin new transactions.
會話無法開始新的事務。
F) an instance shutdown will occur if the transaction issues a commit.
如果事務發出提交，實例將關閉。

12 Examine these parameter settings:
NAME TYPE VALUE db_create_file_dest string /u01/ app/oracle/oradata/prod/ undo_management string AUTO undo_retention integer 900 undo_tablespace string UNDOTBS1 You execute this:
檢查這些參數設置:名稱類型值db_create_file_dest字符串/u01/ app/oracle/oradata/prod/ undo_management字符串AUTO undo_retention integer 900 undo_tablespace字符串UNDOTBS1你執行:

create undo tablespace undotbs2 segment space management auto;
創建undo表空間undotbs2段空間管理自動;
which is ture?
這是真正的嗎?
B) it fails becausr automatic segment space management (ASSM) is not supported for an undo tablespace.
失敗是因為撤銷表空間不支持自動段空間管理(ASSM)。

13 which naming method enables clients to connect to a database instance without any client side configuration in sqlnet.ora or tnsnames.ora?
在sqlnet中，哪一種命名方法使客戶端無需任何客戶端配置即可連接到數據庫實例。
sqlnet.ora還是tnsnames.ora ?
C) the easy connect method
簡易連接法

14 Your databases all run in ARCHIVELOG mode.
您的數據庫都在ARCHIVELOG模式下運行。
A newly created database has no RMAN backups.
新創建的數據庫沒有RMAN備份。
Examine these commands :
檢查這些命令:
CONFIGURE RETENTION POLICY TO REDUNDANCY 2 ;
將保留策略配置為冗余2;
RMAN> BACKUP TABLESPACE SYSTEM;
RMAN>備份表空間系統;
backup set complete, elapsed time :
備份集完成，運行時間:
RMAN > BACKUP TABLESPACE SYSTEM,SYSAUX ;
RMAN >備份表空間系統;
backup set complete, elapsed time: 00: 00: 04
備份集完成，運行時間:00:00:04
RMAN> BACKUP DATABASE ;
RMAN>備份數據庫;
backup set complete, elapsed time: 00:00:07
備份集完成，運行時間:00:00:07
which two are true about the execution of the third backup command?
關于第三個備份命令的執行，哪兩個是正確的?
C) the first back of the system tablespace becomes obsolete.
系統表空間的第一個后端已經過時。
E) A backup is performed for the sysaux tablespace.
對sysaux表空間執行備份。

15 examine this parameter:
檢查這個參數:

now examine this statement which executes successfully in an oralce database version 12c or later.
現在檢查一下在oralce數據庫版本12c或更高版本中成功執行的語句。
oracle tablespace data_olap;
oracle表空間data_olap;
which two are true about this tablespace and its attributres?
關于這個表空間及其屬性，哪兩個是正確的?
D) the initial datafile size is 100M.
初始數據文件大小為100M。
E) the datafile has an oralce generated name.
數據文件有一個口頭生成的名稱。

16 examine these commands:
檢查這些命令:
select open_mode from v$database;從v$database中選擇open_mode;
open_mode
read write
閱讀寫
archive log list;
歸檔日志列表;
database log mode no archive mode
數據庫日志模式沒有存檔模式
automatic archival disabled
禁用自動歸檔
archive destination use_db_recovery_file_dest
歸檔目的地use_db_recovery_file_dest
now examine thses setps:
現在檢查這些設置:
1)startup nomount
啟動nomount
2)startup mount
啟動山
3)startup force
創業力
4)alter database archivelog;
修改數據庫archivelog;
5)shutdown transactional
關閉事務
6)alter database open;
改變數據庫開放;
7)shutdown abort
關閉中止
8)alter database mount
改變數據庫掛載
identify the required setps in the correct order to cgange the database to run in archivelog mode.
以正確的順序標識所需的設置，以便對數據庫進行調整，使其在archivelog模式下運行。

F) 5、2、4、6

17 which two are true about database table rows?
關于數據庫表行，哪兩個是正確的?
C) they always have a row header.
它們總是有一個行標題。
D) they can be stored in a single database block.
它們可以存儲在單個數據庫塊中。

18 which two are true for database running in archivelog mode?
哪兩個對數據庫在archivelog模式下運行是正確的?
A) archived redo log files canonly be muliplexed to a maximum of ten local destinations.
存檔的重做日志文件最多只能混路發送到10個本地目的地。
C) inactive redo log groups must be archived before they can reused.
非活動重做日志組必須存檔后才能重用。

19 in one of your databases, unified auditing is enaled and an sh.salse table exists.
在一個數據庫中，調用了統一審計，并且存在一個sh.salse表。
you successfully execute these commands:
您成功執行了以下命令:
SQL> create audit plicy sales_pol actions select on sh.sales;
SQL>在sh.sales上創建審計plice sales_pol操作選擇;
SQL> audit policy sales_pol;
SQL>審計策略sales_pol;
which statement is true about sales_pol?
關于sales_pol，哪個陳述是正確的?
D) it is enabled for all users having select privilege on sh.sales
D)對所有在sh.sales上擁有選擇特權的用戶啟用

20 examine these statements:
檢查這些語句:
alter system set resource_limit=false scope=both;
system altered.
系統的改變。
create profile dev_users limit
創建配置文件dev_users限制
sessions_per_user 3
idle_time 10
failed_login_attempts 3
password_verfy_function ora12c_verify_function;
profile altered .
配置文件修改。

which two are true?
哪兩個是正確的?
D) user hr sessions will terminate after ten minutes of contiuous inactivity.
用戶hr會話將在持續10分鐘不活動后終止。
E) password complexity checking is enforced for user hr.
對用戶hr執行密碼復雜性檢查。

21 Examine these commands:
檢查這些命令:
CONNECT / AS SYSDBA
連接/作為SYSDBA
CREATE DIRECTORY dumpdir AS '/u01/app/ ‘;
創建目錄dumpdir為’/u01/app/ ';
Directory created.
創建目錄。
GRANT READ, WRITE ON DIRECTORY dumpdir To PUBLIC;
將目錄dumpdir上的讀、寫授權給PUBLIC;
Grant succeeded .
授權成功。
CREATE USER TEST IDENTIFIED BY test ;
創建由測試識別的用戶測試;
User created .
用戶創建的。
GRANT CREATE SESSION, RESOURCE, UNLIMITED TABLESPACE To test;
授予創建會話，資源，無限的表空間來測試;
Grant succeeded.
授權成功。
CONN test/test
康涅狄格州測試/測試
connected .
連接。
CREATE TABLE test_employees (id NUMBER(3) , name VARCHAR2 (20), salary NUMBER(7));
創建表test_employees (id號(3)，name VARCHAR2 (20)， salary NUMBER(7));
Table created .
創建表。
SQL> CREATE SYNONYM emp FOR test_employees ;
為test_employees創建同義詞emp;
synonym created .
創建同義詞。
Now examine this command:
現在檢查這個命令:
$expdp test/test DIRECTORY=dumpdir DUMPFILE=test_emp.dmp LOGFILE=test.log
TABLES=emp CONTENT=data_only query=‘EMP:“WHERE salary=12000”’

Which is true?
這是真的嗎?
A) it throws an error as data pump cannot find a table called test.emp
它拋出一個錯誤，因為數據泵無法找到一個名為test.emp的表

22 ---------
all of your live databases run in archivelog mode.
所有活動數據庫都在archivelog模式下運行。
on the sales database there is no level 0 backup.
在sales數據庫上沒有0級備份。
examine these commands issued against the sales database target:
檢查針對銷售數據庫目標發出的這些命令:
rman> backup as backupset database;
rman>備份為backupdatabase;
backup set complete, elapsed time: 00:00:03
備份集完成，運行時間:00:00:03
rman> backup incremental level 1 database;
rman>增量1級數據庫備份;
what is true about the execution of these commands?
關于這些命令的執行，什么是正確的?
B) A level 0 backup of the database is created instead of the level 1.
創建數據庫的0級備份，而不是1級備份。

23 Examine this command:
檢查這個命令:
STARTUP FORCE
創業的力量
ORACLE instance started .
ORACLE實例啟動。
Total System Global Area 5117049968 bytes
總系統全球區域5117049968字節
Fixed size 9038960 bytes
固定大小9038960字節
Variable size 922746880 bytes
可變大小922746880字節
Database Buffers 4177526784 bytes
數據庫緩沖區4177526784字節
Redo Buffers 7737344 bytes
重做緩沖區7737344字節
Database mounted
數據庫安裝
Database opened .
數據庫打開。
Now examine these steps:
現在檢查一下這些步驟:
1.Oracle instance is started.
Oracle實例啟動。
2.The control file is read.
讀取控制文件。
3.Instance recovery is started.
啟動實例恢復。
4.Datafiles and redo log files are opened.
打開數據文件和重做日志文件。
5.The spfile or pfile is read.
讀取spfile或pfile。
6.The database is available for use .
該數據庫可供使用。
7.The database is mounted .
掛載數據庫。
8.Instance recovery is completed.
實例恢復完成。
Identify the steps that were executed in the correct order to open the database:
確定在打開數據庫時按照正確的順序執行的步驟:

E) 5,1,2,7,4,3,6,8

24 Examine this command.
檢查這個命令。
STARTUP PFILE= 'D:\0racle12c\oracle\admin\orcl\pfile\pfileinitorcl.ora ’
啟動PFILE = ’ D: \ 0 racle12c \甲骨文\ admin \ oracle \ PFILE \ pfileinitorcl.ora
ORACLE instance started .
ORACLE實例啟動。
Total system Global Area 5117049968 bytes
總系統全球區域5117049968字節
Fixed Size 9038960 bytes
固定大小9038960字節
Variable size 922746880 bytes
可變大小922746880字節
Database Buffers 4177526784 bytes
數據庫緩沖區4177526784字節
Redo Buffers 7737344 bytes
重做緩沖區7737344字節
Database mounted .
數據庫安裝。
Database opened .
數據庫打開。
Now examine these statements:
現在來看看這些說法:
SHOW PARAMETER cursor_ sharing;
顯示參數指針共享;
NAME TYPE VALUE
名稱類型值
cursor_sharing string EXACT
cursor_sharing字符串精確
ALTER SYSTEM SET cursor_sharing= FORCE;
修改系統設置cursor_sharing= FORCE;
Which three are true about the result of processing the last statement?
關于處理最后語句的結果，哪三個是正確的?

A) the parameter is modified in memory and in the parameter file.
在內存和參數文件中修改參數。
D) the modification does not persist across a shutdown transactional command.
修改不會在關閉事務命令中持久存在。
E) the modification persist across a shutdown immediate command.
修改在關閉立即命令中持續存在。

25 which three are true about server processes for dedicated server connecatitions?
關于專用服務器連接的服務器進程，哪三個是正確的?
D) they can read data blocks from data files into the default buffer cache.
他們可以從數據文件讀取數據塊到默認的緩沖區緩存。
E) they can parse and execute sql statements.
它們可以解析和執行sql語句。
F) they can write current block images contained in clean buffers to oralce data files.
他們可以寫當前塊圖像包含在干凈的緩沖區口頭數據文件。

26 which naming method enableds clients to connest to a database instance without any client sideconfiguration in sqlnet.ora or tnsnamea.ora?
在sqlnet中，哪個命名方法使客戶端能夠連接到數據庫實例而不需要任何客戶端連接.ora還是tnsnamea.ora ?
C) the easy connect method.
簡易連接法。

27 Examine this parameter setting:
檢查此參數設置:
SHOW PARAMETER undo retention;
顯示參數撤消保留;
NAME TYPE VALUE
undo_retontion integer 900
Now examine these statements:
現在來看看這些說法:
SELECT TABLESPACE_NAME, RETENTION
FROM dba_table_spaces
WHERE TABLESPACE_NAME=“UNDOTHSl” ;
TABLESPACE_NAME RETENTION
UNDOTBS1 GUARANTEE
conn hr/hr@PROD
Connected .
連接。
INSERT INTO emp (id, name, salary, Depno)
插入到emp (id，姓名，薪水，Depno)
VALUES (101, " John’, 12000, 30) ;
值(101，“約翰”，12000,30);
1 row created -
1行創建-
COMMIT ;
提交;
Commit complete .
提交完成。

Which three are true about the processing of these statements?
關于這些陳述的處理過程，哪三個是正確的?
B) lgwr might write redo generated by the insert statement to the redo log before the commit executed.
lgwr可能會在執行提交之前將insert語句生成的重做寫入重做日志。
E) undo generated for the transaction will be in an unexpired state immediately after the commit.
事務生成的undo在提交后立即處于未過期狀態。
F) dbwr must write the content of the modified emp table block image to ‘’ data file before the commit executed.
dbwr必須在執行提交之前將修改后的emp表塊映像的內容寫入“data file”。

28 if your database instance , the undo retention parameter is set to 1000 and undo retention is not guaranteed for the firxed size undo tablespace.
如果您的數據庫實例將undo retention參數設置為1000，并且對于已firxed后的undo表空間，不能保證undo retention。
which statement is not guaranteed for the fixes size undo retention?
哪個語句不能保證修復大小的撤消保留?
A) inactive undo is retalned for at least 1000 seconds if free undo space is available.
如果有空閑的撤銷空間可用，不活動的撤銷被重新記錄至少1000秒。

29 in which two situations can you use threshold server generrated alters to help diagnose and fix problems?
在哪兩種情況下可以使用閾值服務器通用修改來幫助診斷和修復問題?
A) when free space in a locally managed tablespace falls below a specified percentage.
當本地管理的表空間中的空閑空間低于指定百分比時。
D) when the number of logons per second executeds a specific value.
當每秒登錄次數執行一個特定值時。

30 Examine these parameter settings:
檢查這些參數設置:
NAME TYPE VALUE
undo_management string AUTO
undo_retention integer 900
Now examine this statement:
現在來看看這個說法:
AITER TABLESPACE undotbsl RETENTION GUARANTEE;
表空間保持保證;
Tablespace altered .
表空間改變。

Which two are true about undo retention in this configuration?
關于這個配置中的撤消保留，哪兩個是正確的?
D) unexpired undo is retained for 900 seconds, only if free undo space is availabe.
未過期的撤銷保留900秒，只有在空閑的撤銷空間可用的情況下。
F) unexpired undo is retained for at least 900 seconds befi=ore being deleted to free up space even if other transactions fail due to lack of space in the undo tablespace.
未過期的undo被保留至少900秒，befi=ore被刪除以釋放空間，即使其他事務由于undo表空間中的空間不足而失敗。

31 One of your databases runs in ARCHIVELOG mode.
其中一個數據庫以ARCHIVELOG模式運行。
Connect / as syadba
連接/作為syadba
connected .
連接。
GRANT CREATE USER TO hr WITH ADMIN OPTION ;
授予創建用戶到hr與管理選項;
Grant succeeded .
授權成功。
GRANT CREATE USER TO john;
授予創建用戶約翰;
Grant succeeded .
授權成功。
Connect hr/hr @PROD
人力資源/ hr @PROD連接
connected .
連接。
GRANT CREATE USER TO alice WITH ADMIN OPTION;
授予創建用戶alice與管理選項;
Grant succeeded -
格蘭特接替,
conn / as sysdba
conn / as sysdba
connected
連接
REVOKE CREATE USER FROM hr :
從hr撤回創建用戶:
Revoke’ succeeded 。
撤銷成功。

Which two are true about the result and effects of executing these commands?
關于執行這些命令的結果和效果，哪兩個是正確的?
B) The REVOKE statement successfully revokes the system privilege from user HR.
REVOKE語句成功地從用戶HR撤銷系統特權。
D) User HR is permitted to grant the CREATE USER privilege to any other user.
允許用戶HR將CREATE User權限授予任何其他用戶。
F) User ALICE is permitted to grant the CREATE USER privilege to user HR.
允許用戶ALICE將CREATE User權限授予用戶HR。
答案： BDF （題目要求選擇3個答案，應該是題目本身有點問題）

32 One of your databases runs in ARCHIVELOG mode.
其中一個數據庫以ARCHIVELOG模式運行。
Examine this command:
檢查這個命令:
SELECT open mode FROM v$database;選擇打開模式從v$數據庫;
OPEN MODE
開放式
READ WRITE
閱讀寫
Now examine these steps executed from RMAN :
現在檢查從RMAN執行的這些步驟:

SHUTDOWN IMMEDIATE 立即關閉

STARTUP MOUNT 啟動山

BACKUP DATABASE ;備份數據庫;

BACKUP ARCHIVELOG ALL; 備份ARCHIVELOG ALL;

ALTER DATABASE OPEN;

STARTUP 啟動 Identify the minimum

required steps in the correct order needed to perform a whole consistent database backup.
按照執行整個一致數據庫備份所需的正確順序確定所需的最小步驟。
B)1,2,3,5

33 Examine these statements:
檢查這些語句:
CREATE ROLE dev1 ;
創建角色dev1;
Role created
角色創建
GRANT CREATE SESSION ,CREATE USER, CREATE TABLE TO dev1 ;
將創建會話、創建用戶、創建表授予到dev1;
Grant succeeded .
授權成功。
CREATE USER john IDENTIFIED BY john;
創建由john識別的用戶john;
User created .
用戶創建的。
GRANT CONNECT, dev1 TO john;
Grant succeeded .
授權成功。
REVOKE CREATE SESSION FROM dev1 ;
從dev1撤回創建會話;
Revoke succeeded .
撤銷成功。
Which two are true about the result and effects of executing these commands?
關于執行這些命令的結果和效果，哪兩個是正確的?
A）create session is only revoked from role dev1.
僅從角色dev1撤銷創建會話。
C) user john is permitted to connect to the database.
用戶john被允許連接到數據庫。

34 which three are true about the default database buffer cache?
關于默認的數據庫緩沖區緩存，哪三個是正確的?
C) buffers containing block images may be selected for reuse based only on a least recently used(LRU) algorithm.
僅基于最近最少使用(LRU)算法，可以選擇包含塊圖像的緩沖區進行重用。
D) its buffer can contain data block images for blocks that have a corresponding image in a data file.
它的緩沖區可以包含數據塊圖像的塊有一個相應的圖像在一個數據文件。
E) its buffer can contain data block images for blocks that have no corresponding image in a data file.
它的緩沖區可以包含數據塊圖像，對于數據文件中沒有相應圖像的塊。

35 one of your database is open and not managed by oralce restart.
你的數據庫中有一個是打開的，沒有通過口頭重啟來管理。
alter system enable restricted session;
更改系統啟用受限會話;
which two are true?
哪兩個是正確的?
A) no session are terminated.
沒有會話被終止。
E) users with restricted session privilege can log in.
具有受限會話權限的用戶可以登錄。

36 which two types of information are contained in the oralce database data dictionary?
哪兩種類型的信息包含在口頭數據庫數據字典?
B) information about data dictionary base tables and dataa dictionary views.
關于數據字典基表和數據字典視圖的信息。
C) information about object privileges granted to sysdba and syboper roles.
授予sysdba和syboper角色的對象特權的信息。

37 all of your database instances use spfiles.
所有數據庫實例都使用spfiles。
you executed this command in one of them;
你在其中一個里面執行這個命令;
alter system set meory_max_target=1024M;
which statement is true?
哪種說法是正確的?
C) the command returns and error.
命令返回和錯誤。

38 your database has one control file and the instance is started using an spfile.
您的數據庫有一個控制文件，并且實例是使用一個spfile啟動的。
examine these steps:
檢查這些步驟:
1)lssue shutdown immediate
lssue關閉立即
2)lssue startup mount
lssue啟動mount
3)lssue startup nomunt
lssue啟動nomunt
4)copy the existing control file to the new location
將現有的控制文件復制到新的位置
5)lssue alter database open
打開alter數據庫
6)lssue startup
lssue啟動
7)update the control_files initialization parameter in the spfile to include an additional file.
更新spfile中的control_files初始化參數，以包含一個額外的文件。
identify the minimum requored steps in the correct order to multiplex the control file.
按照正確的順序確定要復用控制文件所需的最小步驟。
D) 7,1,4,6

39 examine this backup strategy for the orcl database:
檢查orcl數據庫的備份策略:
1)a level 0 backup is taken every two weeks.
每兩周進行一次0級備份。
2)a cumulative level 1 backup is taken weekly.
每周進行一次累積的1級備份。
3)a differential level 1 backup is taken daily.
每天進行差異1級備份。
whick blocks are backed up in the cumulative level 2 backup?
在累積級別2的備份中備份了哪些塊?
D) the blocks backed up in the last level 0 backup.
上次0級備份中備份的塊。

40 which three are true about the ln-memory column store?
關于ln-memory列存儲，哪三個是正確的?
C) transaction consistency between the database buffer cache and the ln-memory column store is always maintained.
始終維護數據庫緩沖區緩存和ln-memory列存儲之間的事務一致性。
D) segments are always converted to a columnar format when store in the ln-memory column store.
段存儲在ln-memory列存儲時總是轉換為列格式。
E) the compatible parameter must be set to 12.1.0 or higher to use the ln-memory column store.
要使用ln-memory列存儲，兼容參數必須設置為12.1.0或更高。

41 your database is in archivelog mode.
你的數據庫處于存檔模式。
you want to disable archiving for the database.
您希望禁用數據庫的歸檔。
examine these steps:
檢查這些步驟:
1,execute the alter database noarchivelog command.
執行alter database noarchivelog命令。
2,execute shutdown immediant.
執行關機immediant。
3,execute startup mount.
執行啟動安裝。
4,set db_recovery_file_dest parameter to $oracl{e}_{h}ome/dbs/.設置d{b}_{r}ecover{y}_{f}il{e}_{d}est參數為$oracle_home/ dbs/。
5,execute startup nomount.
執行啟動nomount。
6,open the database.
打開數據庫。
7,execute shutdown transactional.
執行關閉事務。
identify the required steps in the correct sequence.
按照正確的順序確定所需的步驟。
B) 2、3、1、6

42 your production database prod uses file system storage.
生產數據庫prod使用文件系統存儲。
you want to migrate storage including the fast recovery area for the prod database to oralce automatic storage management(ASM) by using RMAN.
您希望通過使用RMAN將存儲(包括prod數據庫的快速恢復區域)遷移到oralce自動存儲管理(ASM)。
you back up the entire database.
您備份了整個數據庫。
want should the next step be in this migration process?
下一步應該是遷移過程嗎?
B) disabling oralce flashback database if enabled.
禁用oralce閃回數據庫，如果啟用。

43 in which situations does the database writer process(dbwn) write to data fils?(choose two).
在什么情況下數據庫寫程序(dbwn)寫數據文件?(選擇兩個)。
B) when a user process commits a transaction
當用戶進程提交事務時
D) when PMON cleans up dirty buffers in the database buffer cache.
當PMON清理數據庫緩沖區緩存中的臟緩沖區時。

44 examine the command:
檢查命令:
SQL> connect hr/hr@orcl
which two configurations allow this command to execute successfully?(choose two.)
哪兩種配置允許此命令成功執行?(選擇兩個。)
B) the service_names initialization parameter should contain the name orcl in the database host.
service_names初始化參數應該包含數據庫主機中的名稱orcl。
C) the orcl TNS alias should br defined such that it is resolvable by a client running on the database host.
orcl TNS別名應該被定義為可以被運行在數據庫主機上的客戶端解析。

45 you configured the flash recovery area in the database.
您在數據庫中配置了閃存恢復區域。
which two files would you expect to find in the flash recovery area?(choose two.)
你希望在flash恢復區域找到哪兩個文件?(選擇兩個。)
A) backup pieces.
備份塊。
D) control file autobackups.
控制文件自動備份。

46 which three statements are true about windows?(choose three.)
關于windows，哪三個說法是正確的?(選擇三個)。
A) only one window can be open at any given time.
在任何給定時間只能打開一個窗口。
C) windows work with job classes to control resource allocation.
windows使用作業類來控制資源分配。
E) windows can automatically start job or change resource allocation among jobs for vaeious time periods.
windows可以自動啟動作業或改變不同時間段內作業之間的資源分配。

47 which three statements are true about the pre-upgrade information tool?(choose three)
關于升級前信息工具，哪三種說法是正確的?(選擇三個)
B) it writes a list of invalid sys and system object to the registry$sy{s}_{i}n{v}_{o}bjstable.它將無效的sys和系統對象列表寫入注冊表$sys_inv_objs表。
C) it evaluates the dependencies of network utility packages.
評估網絡實用程序包的依賴關系。
D) it identifies any deprecated and unsupported parameters.
它標識任何不贊成和不支持的參數。

48 which two tasks must you perform before you begin the upgrade process to oralce database 12c?(choose two.)
在開始升級到oralce數據庫12c之前，您必須執行哪兩項任務?(選擇兩個。)
B) recompile all invalid objects.
重新編譯所有無效的對象。
E) empty all user recycle bins.
清空所有用戶回收箱。

49 which two tools can be used to configure static service information in the listener.ora file?(choose two.)
哪兩種工具可用于在偵聽器中配置靜態服務信息.ora文件?(選擇兩個。)
A) oralce Net Manager.
口頭網絡經理。
B) oracle enterprise manager cloud control
oracle enterprise manager云控制

50 which three file types are stored in the fast recovery area by default in a traditional ono-omf file system? (choose three.)
在傳統的ono-omf文件系統中，哪三種文件類型默認存儲在快速恢復區域?(選擇三個)。
A) online redo log files.
在線重做日志文件。
D) archived log files.
歸檔日志文件。
F)flashback logs.
閃回日志。

51 you install oralce grid infrastructure standalone server and issue the following command:
您安裝oralce網格基礎設施獨立服務器，并發出以下命令:
crsctl start has
crsctl開始有
which two exsting components get automatically added to the oralce restart configuration?(choose two)
哪兩個exsting組件自動添加到oralce重啟配置?(選擇兩個)
A) oralce CSSD services.
口頭CSSD服務。
C) oralce notification services.
口頭通知服務。

52 which three factors influence the optimizer’s choice of an execution plan?(choose three.)
哪三個因素會影響優化器對執行計劃的選擇?(選擇三個)。
A) the optimizer_mode initialization parameter.
optimizer_mode初始化參數
C) cardinality estimates.
基數估計值。
D) object statistics in the data dictionary.
數據字典中的對象統計。

53 in a recent automatic workload repository(AWR) report for your database, you notice a high number of buffer busy waits.
在最近針對數據庫的自動工作負載存儲庫(AWR)報告中，您注意到大量緩沖區繁忙等待。
the database consists of locally managed tablespaces with free list managed segments.
數據庫由具有空閑列表管理段的本地管理表空間組成。
on further investigation, you find that buffer busy waits is caused by contention on data blocks.
進一步調查后，您會發現緩沖區繁忙等待是由數據塊爭用引起的。
which option would you consider first to decrease the wait event immediately?
要立即減少等待事件，您會首先考慮哪個選項?
D) using automatic segment space management(ASSM)
使用自動段空間管理(ASSM)

總結

以上是生活随笔為你收集整理的OCP12C题库，62数据库备份与恢复(admin,install and upgrade accelerated, backup and recovery workshop -62)（新增）的全部內容，希望文章能夠幫你解決所遇到的問題。

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