- Oracle OCP認(rèn)證考試題庫(kù) 推薦度：
- 相關(guān)推薦
2017年Oracle認(rèn)證考試題庫(kù)
Oracle認(rèn)證證書(shū)只是讓雇主了解到來(lái)應(yīng)聘的人通過(guò)了Oracle數(shù)據(jù)庫(kù)方面的技術(shù)考試。下面是關(guān)于Oracle認(rèn)證考試題庫(kù)，歡迎大家參考!
QUESTION 19
You executed the following command to create a password file in the database server:
$ orapwd file = orapworcl entries = 5 ignorecase=N
Which statement describes the purpose of the above password file?
A. It records usernames and passwords of users when granted the DBA role
B. It contains usernames and passwords of users for whom auditing is enabled
C. It is used by Oracle to authenticate users for remote database administrator
D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups
Correct Answer: C
【考點(diǎn)分析】sys用戶身份驗(yàn)證,口令文件
【題意簡(jiǎn)述】創(chuàng)建口令文件的目的是?
【原理概念】
sysdba身份遠(yuǎn)程連接數(shù)據(jù)庫(kù)時(shí),使用口令文件來(lái)驗(yàn)證授權(quán)用戶.
【答案剖析】
A: 錯(cuò)誤,授予用戶sysdba身份時(shí),用戶口令記錄在口令文件,不是dba角色.
B: 錯(cuò)誤,審計(jì)用戶的密碼不會(huì)記錄在口令文件.
C: 正確, sysdba身份遠(yuǎn)程連接數(shù)據(jù)庫(kù)時(shí),使用口令文件來(lái)驗(yàn)證授權(quán)用戶.
D: 錯(cuò)誤,把用戶添加到操作系統(tǒng)OSDBA 或OSOPER組不會(huì)把口令記錄到口令文件.
QUESTION 20
SQL> CREATE BIGFILE TABLESPACE MRKT
DATAFILE '/u01/app/oracle/oradata/orcl/mrkt.dbf' size 10M LOGGING 3 EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;
Tablespace created.
SQL> ALTER DATABASE DEFAULT TABLESPACE MRKT;
Database altered.
Which two statements are true regarding the MRKT tablespace? (Choose two.)
A. No more data files can be added to the tablespace.
B. Segment space is managed by free lists in the tablespace.
C. A user created without being assigned a default tablespace uses this tablespace.
D. The tablespace can be dropped with the current setting with segments present in it.
Correct Answer: AC
【考點(diǎn)分析】大文件和小文件表空間區(qū)別, 數(shù)據(jù)默認(rèn)表空間,段空間管理方式
【題意簡(jiǎn)述】創(chuàng)建大文件表空間MRKT為數(shù)據(jù)庫(kù)的默認(rèn)表空間,哪個(gè)描述是正確的?
【原理概念】
創(chuàng)建BIGFILE時(shí),oracle自動(dòng)創(chuàng)建本地管理和自動(dòng)段空間管理(ASSM)的表空間.
Oracle Database automatically creates a locally managed tablespace with automatic segment space management.
Use this clause to determine whether the tablespace is a bigfile or smallfile tablespace.
This clause overrides any default tablespace type setting for the database.
· A bigfiletablespace containsonly one datafile or tempfile, which can contain up to approximately 4 billion(232) blocks.大文件表空間只能包含一個(gè)數(shù)據(jù)文件或臨時(shí)文件.
· A smallfiletablespace is atraditional Oracle tablespace, which can contain 1022 datafiles or tempfiles,each of which can contain up to approximately 4 million (222)blocks.
使用大文件表空間的好處:
大文件表空間可以化最小表空間文件數(shù)量,從而簡(jiǎn)化DBA管理,在大型數(shù)據(jù)庫(kù)中的表空間可能包含幾十或幾百個(gè)數(shù)據(jù)文件,隨著文件數(shù)據(jù)的增加,一些數(shù)據(jù)庫(kù)參數(shù)需要做出相應(yīng)的調(diào)整比如db_files,這個(gè)靜態(tài)參數(shù)還要重啟數(shù)據(jù)庫(kù)才能生效,這都給數(shù)據(jù)庫(kù)的維護(hù)帶來(lái)不便,大文件表空間可以解決這個(gè)問(wèn)題.由于文件數(shù)量減少,控制文件的空間使用也隨之減少,檢查點(diǎn)等數(shù)據(jù)庫(kù)內(nèi)部操作需要同步的文件頭數(shù)量也大大減少.
【實(shí)驗(yàn)參考】
(1)創(chuàng)建大文件表空間mrkt
SYS@ENMOEDU> create bigfile tablespace mrkt datafile '/u01/app/oracle/oradata/ENMOEDU/mrkt.dbf' size 10m;
Tablespace created.
(2)查看表空間類型
SYS@ENMOEDU>select tablespace_name,bigfile from dba_tablespaces;
TABLESPACE_NAME BIG
--------------------- ---
SYSTEM NO
SYSAUX NO
TEMP NO
USERS NO
EXAMPLE NO
UNDOTBS2 NO
MRKT YES
(3)添加文件或刪除數(shù)據(jù)庫(kù)默認(rèn)表空間會(huì)報(bào)錯(cuò)
SYS@ENMOEDU> alter tablespace mrkt add datafile '/u01/app/oracle/oradata/ENMOEDU/mrkt01.dbf' size 10m;
alter tablespace mrkt add datafile '/u01/app/oracle/oradata/ENMOEDU/mrkt01.dbf' size 10m
*
ERROR at line 1:
ORA-32771: cannot add file to bigfile tablespace
SYS@ENMOEDU> alter database default tablespace mrkt;
Database altered.
SYS@ENMOEDU> drop tablespace mrkt including contents and datafiles;
drop tablespace mrkt including contents and datafiles
*
ERROR at line 1:
ORA-12919: Can not drop the default permanent tablespace
(4)查看數(shù)據(jù)庫(kù)默認(rèn)創(chuàng)建表空間類型
SYS@ENMOEDU> col PROPERTY_NAME for a20
SYS@ENMOEDU> col PROPERTY_VALUE for a15
SYS@ENMOEDU> col DESCRIPTION for a30
SYS@ENMOEDU>select * from database_properties where property_name='DEFAULT_TBS_TYPE';
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
------------------------- --------------------- ------------------------------
DEFAULT_TBS_TYPE SMALLFILE Default tablespace type
(5)修改默認(rèn)表空間類型:
SYS@ENMOEDU> alter database set default bigfile tablespace;
Database altered.
SYS@ENMOEDU> select * from database_properties where property_name='DEFAULT_TBS_TYPE';
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
------------------------- --------------------- ------------------------------
DEFAULT_TBS_TYPE BIGFILE Default tablespace type
SYS@ENMOEDU> alter database set default smallfile tablespace;
Database altered.
SYS@ENMOEDU> select * from database_properties where property_name='DEFAULT_TBS_TYPE';
PROPERTY_NAME PROPERTY_VALUE DESCRIPTION
------------------------- --------------------- ------------------------------
DEFAULT_TBS_TYPE SMALLFILE Default tablespace type
【答案剖析】
A: 正確,大文件表空間只能包含一個(gè)文件;
B: 錯(cuò)誤,段空間是用位圖方式自動(dòng)管理的不是通過(guò)free lists手工管理;
C: 正確,MRKT是數(shù)據(jù)庫(kù)默認(rèn)表空間,創(chuàng)建用戶時(shí)不指定默認(rèn)表空間,則使用數(shù)據(jù)庫(kù)默認(rèn)的;
D: 錯(cuò)誤,正在使用的或是數(shù)據(jù)庫(kù)默認(rèn)表空間不能被刪除.
【Oracle認(rèn)證考試題庫(kù)】相關(guān)文章：
Oracle OCP認(rèn)證考試題庫(kù)12-31
Oracle認(rèn)證考試技巧09-21
oracle認(rèn)證考試詳情01-22
Oracle認(rèn)證考試指南09-23
Oracle認(rèn)證作用07-31
Oracle最新認(rèn)證07-13
Oracle認(rèn)證途徑09-11