201. You work as a database administrator for Supportcenter.cn. Your database is opened in NOARCHIVEKLOG mode. You decide to place the database in ARCHIVELOG mode. How would you do this? (Select two)
A. Execute the ALTER DATABASE ARCHIVELOG statement
B. Select ARCHIVELOG option in the database control and restart the database to apply the changes.
C.Shut down and start the instance, and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement.
D.Shut down and start the instance, mount the database, then execute the ALTER DATABASE ARCHIVELOG statement.
Editor’s notes:Answer B means that you can change the ARCHIVELOG option in OEM first.
203. Exhibit
You work as a database administrator for Supportcenter.cn. While creating a new user or changing the password for existing users, the password must adhere to the restrictions specified in the exhibit. Which option would you use to achieve this objective?
A. Use a trigger to validate the password
B. Use a user defined PL/SQL block to validate the password
C.Use a profile to include the password verify function to validate the password
D.Use Oracle's default password verification procedure to validate the password
E.Use a procedure name in the CREATE USER command to validate the password
Editor’s notes:Profile has a parameter “PASSWORD_VERIFY_FUNCTION” to theck the user passwd.The verify function must be created by yourself.
Hong yong has give us a good example of verify function. See that:
I'd like to create one password_verify_function for multiple profiles. In the function, I'd like to check what profile this "alter user" or "create user" action is acted on. For example,
CREATE OR REPLACE FUNCTION verify_function (username varchar2, password
varchar2, old_password varchar2)
...
select profile into prof from dba_users where username =
verify_function.username;
IF prof = 'APPLICATION' THEN
IF length(password) < 16 THEN
raise_application_error(-20002, 'Password length less than 16 for
APPLICATION user');
END IF;
ELSE
IF length(password) < 8 THEN
raise_application_error(-20002, 'Password length less than 8 for regular
user');
END IF;
END IF;
It works fine for "alter user". But for "create user", dba_users obviously doesn't have him yet and 'No data found' is thrown. So I add code to check the existence of the user first. The problem is, if it's a new user, there's no way to capture the profile in the "create user ... profile ..." statement to apply my specific rule to. I don't think there's a workaround other than creating two verification functions, one for APPLICATION and one for the rest. Comments are appreciated.
Web site associated:
http://space.itpub.net/694276/viewspace-514298
http://www.freelists.org/post/oracle-l/Check-new-users-profile-in-password-verify-function
210. You work as a database administrator for Supportcenter.cn. Because of space constraints, you decided to manually shrink the table. You executed the ALTER TABLE ....SHRINK SPACE statement to shrink the space and you receive an error as follows:
ERROR at Line 1:
ORA-10635: Invalid segment or tablespace type
What could be the reason?
A. The table is partitioned
B. The table name is wrong.
C.It is an index-Organized table (IOT)
D.The table is stored in locally managedtablespace.
E.The table is stored in atablespacewhere segment space is managed manually.
Editor’s notes:You can see the explaination of the oerr-10635:
ORA-10635: Invalid segment or tablespace type
Cause: Cannot shrink the segment because it is not in auto segment space managed tablespace or it is not a data, index or lob segment.
Action: Check the tablespace and segment type and reissue the statement
212. You work as a database administrator for Supportcenter.cn. In your organization, you have four databases,
SupportCenter DB01, SupportCenter DB02, SupportCenter DB03, and SupportCenter DB04, which are located in
Berlin, Frankfurt,Rammstein, andMunichrespectively, and which were created using Database Configuration
Assistant (DBCA). You want to perform. administrative tasks on these databases that include startup and shutdown,
taking regular backups, and so on, fromFrankfurtusing Oracle tools. Which Oracle file would you enable to perform
this task?
A. Control file
B. Password file
C.Parameter file
D.Online redo log file
E.Listener controller file
F.Server parameter file
Editor’s notes:I do not know what does this question want to tell us
218.
You work as a database administrator for Supportcenter.cn. While setting up the database for your production environment, you want to create a user according to the requirements in the exhibit. Which three options of the CREATE USER command would you use to achieve this objective? Choose three
A. Profile
B. Account lock
C.Account unlock
D.Password expire
E.Quota 10MB on SupportCenter TBS1
F.Password never expire
G.Defaulttablespace SupportCenter TBS1
H.Quota unlimited on SupportCenter TBS1
I.TemporarytablespaceTEMP
J.TemporarytablespaceSYSTEM
Editor’s notes:the rule of create user can see in the document followed:
225. You work as a database administrator for Supportcenter.cn. One of the database users accidentally deleted all the rows of a critical table and committed the delete at 1:30 p.m. You senior database administrator, SupportCenter, asks you to retrieve the lost data. Which two actions would you use to ensure that there is no impact on other connected users while retrieving the deleted rows? Choose two.
A. Use a flashback query to retrieve the rows that were deleted
B. Useconventialincrementalexportand then import the affected object
C.Shutdown the database inNORMALmode and restart the database instance
D.Use DBMS_META. package to reconstruct the object using undo segments
E.Use Tablespace Point in Time Recovery (TSPITR) method to recover the table and the data
F.Use Oracle DataPumptwithflashback_timeoption toentableflashback export and then import the affected object.
Editor’s notes:I do not know why answer A is wrong.And, answer B may be right.You can see the method of using convential incremental export.
2.备份策略和综合应用举例：
(1).做全数据库增量备份和恢复的方法：
全数据库Export至dmp文件（如sidfull0701.dmp）：
$ exp sys/manager file= sidfull0701.dmp Full=y inctype=complete
第一天增量备份Export至dmp文件（如sidincr1.dmp）：
$ exp sys/manager file= sidincr1.dmp inctype=incremental
第二天增量备份Export至dmp文件（如sidincr2.dmp）：
$ exp sys/manager file= sidincr2.dmp inctype=incremental
第三天增量备份Export至dmp文件（如sidincr3.dmp）：
$ exp sys/manager file= sidincr3.dmp inctype=incremental
现假设Oracle数据库在第三天被破坏了重新建一个Oracle数据库，先把最后的一个dmp文件imp至数据库中：
$ imp sys/manager file= sidincr3.dmp full=y ignore=y inctype=system
把整个数据库备份的dmp文件imp至数据库中：
$ imp sys/manager file= sidfull0701.dmp ignore=y full=y inctype=restore
把第一天增量备份的dmp文件imp至数据库中：
$ imp sys/manager file= sidincr1.dmp ignore=y full=y inctype=restore
把第二天增量备份的dmp文件imp至数据库中：
$ imp sys/manager file= sidincr2.dmp ignore=y full=y inctype=restore
把第三天增量备份的dmp文件imp至数据库中
$ imp sys/manager file= sidincr3.dmp ignore=y full=y inctype=restore
(2).数据库逻辑备份策略的制定:
数据库管理员可以排定一个备份日程表，结合数据导出的三个不同方式合理、高效、可靠地完成。比如数据库的备份任务可作如下安排：
星期一：完全导出（A）
星期二：增量导出（B）
星期三：增量导出（C）
星期四：增量导出（D）
星期五：累计导出（E）
星期六：增量导出（F）
星期日：增量导出（G）
如果在星期日，数据库遭到意外破坏，数据库管理员可按以下步骤来恢复数据库：
第一步：用命令CREATE DATABASE重新生成数据库结构；
第二步：创建一个足够大的附加回滚段。
第三步：完全增量导入A：
$ imp system/manager inctype=RECTORE FULL=Y FILE=A
第四步：累计增量导入E：
$ imp system/manager inctype=RECTORE FULL=Y FILE =E
第五步：最近增量导入F：
$ imp system/manager inctype=RESTORE FULL=Y FILE=F
注：备份文件的命名最好加上日期，这样便于以后的恢复工作。
操作如下：
$ tar -cvf full'date +%Y-%m-%d-%H-%M'.dmp abc
$ tar -cvf full'date +%Y-%m-%d-%H-%M-%S'.dmp abc
230. Your boss at Supportcenter.cn wants you to clarify Oracle10g. Which statement is true about the analysis of the Automatic Database Diagnostic Monitor (ADDM)?
A. The analysis does not provide the output for the performance of SQL statements.
B. The results of analysis are stored in tables, belonging to SYS user, in the SYSAUX tablespace.
C.The results of analysis are stored in tables, belonging to SYS user, in the SYSTEM tablespace.
D.The analysis runs automatically after each Automatic Workload Repository (AWR) snapshots.
E.The ADDM analysis is done manually after each Automatic Workload Repository (AWR) snapshots.
F.The results of analysis are stored in tables, belonging to SYSMAN user, in the SYSTEM tablespace.
Editor’s notes:why answer B is wrong?because addm belong to sysman.
ADDM并不是核心的东西，所以不可能交给“总裁”去管理（SYS, SYSTEM）,所以是由“副总”来管（AUX就是辅助的意思）
229. You work as a database administrator for Supportcenter.cn. Your listener process, L1, is currently listening to three databases: CertK INDB04, SupportCenter DB05 and SupportCenter DB06. Using Database Configuration Assistant (DBCA) you create one more database, SupportCenter DB07, and enable dynamic registration. Which two commands of Listener Control Utility (lsnrct1) would you use to determine whether the dynamic registration occurred for the database, SupportCenter DB07, with the L1 listener process? Choose two
A. SHOW L1
B. SPAWN L1
C.STATUS L1
D.SERVICES L1
E.STATUS LISTENER
F.SERVICES LISTENER
G.SHOWcurrent_listener
Editor’s notes:I have tried that.it’s right.
231. Exhibit, list of privileges.
You work as a database administrator for Supportcenter.cn. The database user, SupportCenter USER07, has the CONNECT role assigned. You want this user to be able to:
A)connect to the database when the database is in restricted modeAND
B)querythe tables created by other users.
Which minimal set of privileges and roles would you select from the list in the exhibit to grant to the user?
A. 1 only
B. 6 only
C.1, 2 and 4
D.3 and 4
E.1 and 6
Editor’s notes:The answer is wrong. Resource role here has nothing usefull here. Sysoper privilege can not see user data. The right answer is C
233. You work as a database administrator for Supportcenter.cn. You suspect that in one of your applications the customer table is being accessed by some unauthorized users. Which option would you use to monitor the queries being executed on the customer table?
A. Monitor thealert.logfile
B. Enable server-side SQL tracing for user sessions
C.Enable fine-grained auditing for the customer table
D.Enable Fine-Grained Access Control (FGAC) for the customer table
E.Write a database trigger on the customer table on the SELECT event
Editor’s notes:why answer C is wrong? If you motitor the queries,C must be right.
May be the words followed can be tell you why:
对于开放的环境来说，存取控制是十分必要的，必须要防患于未然。
A. Monitor the alert.logfile
B. Enable server-side SQL tracing for user sessions
C.Enable fine-grained auditing for the customer table
--监视日志文件、使用跟踪会话、审计用户表，均为事后诸葛亮，不能有效地阻止别人的误操作或使坏。
E.Write a database trigger on the customer table on the SELECT event
--insert、update、delete才使用trigger,select是不行的。
D.Enable Fine-Grained Access Control (FGAC) for the customer table
--关键是Access Control,如网上银行的三次密码出错当日锁定，取大量现金的报警系统等。
事实上FGAC和FGA是两个不同的概念，FGAC是Control(控制),而一个是审计，FGA可以对访问进行记录，而不能限制访问，但FGAC可以。
Now,what’s the fgca?
Web site associated:
http://www.itpub.net/viewthread.php?tid=1037232&extra=&page=1
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:259415261270
235. You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the
listener is not responding. You want to forward client connect requests to another listener if one listener is not
responding. How do you achieve this?
A. Enable instance failover
B. Configure shared server
C.Enable database failover
D.Enable connect-time failover
E.Enable Transparent Application Failover (TAF)
240. Exhibit
You work as a database administrator for Supportcenter.cn. While trying to access Enterprise Manager Database Control by using a browser, you get an error. See exhibit. On further investigation, you find that the Oracle database10ginstallation has just finished and your colleague, SupportCenter who installed the software, has not noted down all the port numbers. How do you determine the port number of the HTTP listener that is being used by Enterprise Manager DatabaseConrol?
A. From thesqlnet.orafile
B. From thetsnames.orafile
C.From thelistener.orafile
D.From the portlist.orafile
E.By using Operating Systemutlities
Editor’s notes:In a default installation, the port number is 1158. If you are unsure of the correct port number to use, look for the following line in theORACLE_BASE\ORACLE_HOME\install\portlist.inifile.
Enterprise ManagerConsoleHTTPPort(db_name) = port
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22598114/viewspace-677801/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/22598114/viewspace-677801/
扫一扫
1302
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
