http://www.oracle.com.cn/archiver/?tid-128913.html[@more@]QUESTION 46:

You work as a database administrator for Certkiller .com. In your transaction
application, you have scheduled a job to update the optimizer statistics at05:00 pm
every Friday. The job has successfully completed. Which three pieces of information
would you check to confirm that the statistics have been collected? Choose three
A.Average row size
B.Last analyzed date
C.Size of table in bytes
D.Size of table in database blocks
E.Number of free blocks in the free list
F.Number of extents present in the table.

Answer: A, B, D

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
这里是问哪三个地方使你能确定已经收集了优化信息？[img]http://bbs.duowan.com/images/smilies/ew14.gif[/img]
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////



QUESTION 47:

You work as a database administrator for Certkiller .com. You want to be notified
when the number of disk I/O increases by 10% of what it was yesterday. You create
a baseline metric for yesterday's disk I/O performance. How do you use the baseline
metrics to achieve your objective?
A.Save the baseline in the database
B.Save the baseline in the Database Control Home Page
C.Create a procedure to read and apply the baseline to disk I/O metrics
D.Apply the baseline to the disk I/O metrics in the Mange Metrics page
E.Alter the disk I/O metrics to include baseline by using the ALTER METRICScommnd

Answer: D

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
为什么选D?其他好象正确？[img]http://bbs.duowan.com/images/smilies/hz%20(2).gif[/img]
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////



QUESTION 48:

You work as a database administrator for Certkiller .com. In the
Certkiller PRODUCTION database you have granted RESUMABLE system
privilege to the CONNECT role.Resumablespace operation has been enabled for all
user session. You want users NOT to be aware of any kind of space-relatedproblems while performing transactions. Instead, you want the problem to be
resolved by a database trigger automatically.
Which combination of triggering time and event would you use to achieve this
objective?
A.AFTER CREATE
B.AFTER SUSPEND
C.BEFORE CREATE
D.AFTER TRUNCATE
E.BEFORE SUSPEND
F.AFTER INSERT OR DELETE OR DELETE
G.BEFORE INSERT OR DELETE OR DELETE

Answer: B

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
看不懂。。。。。[img]http://bbs.duowan.com/images/smilies//tu.gif[/img]
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////




QUESTION 52:

You work as a database administrator for Certkiller .com. You want to create your
database with the automatic undo management feature enable.
Which two tasks must you perform to achieve this? Choose two.
A.Set the UNDO_RETENTION parameter to AUTO.
B.Create an initial undo segment in undotablespace.
C.Set the UNDO_RETENTION parameter to 900 or more
D.Set the initialization parameter UNDO_MANAGEMENT to AUTO
E.Set the UNDO_MANAGEMENT parameter to the name of an undotablespace

Answer: D, E

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
D跟E不是一样的吗？ [img]http://bbs.duowan.com/images/smilies/hz%20(4).gif[/img][img]http://bbs.duowan.com/images/smilies/ew13.gif[/img]
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////




QUESTION 71:

Exhibit
[img]http://photo.store.qq.com/http_imgload.cgi?/rurl2=79c888b1eda7dd0bfa9a677520c36fd3d647fde506c566befed1ca31b68f85ddf48be0e5986b5efc7e625b572029b4f31e5854accdcca2ccc16dd4c4c29df4d9cdc8b3d757569b1616f56a41353a0de3fa2c6f4c[/img]

You work as a database administrator for Certkiller .com. While executing the
command line to create a table, the user gets the following error message and the
CREATE TABLE... command fails.
ERROR at line 1:
ORA-01950: no privileges ontablespace
What could be the possible reason for this error message?
A.Thetablespace Certkiller tbs7 is full.
B.The user is not the owner of the SYSTEMtablespace.
C.The user does have quota on the Certkiller 7tablespace.
D.The user does not have sufficient system privileges to create table in the Certkiller 7
tablespace.
E.The user does not have sufficient privileges to create table on the default permanent
tablespace

Answer: C



/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
这里不是应该是quota不足引起的[img]http://bbs.duowan.com/images/smilies/ew15.gif[/img]吗？
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////






QUESTION 75:

Exhibit, list of privileges.
[img]http://photo.store.qq.com/http_imgload.cgi?/rurl2=7cfcb62e63f6fe2b0bf8e11270db161ba0096dd251cfa0527fc8d4eae520894dbcf93671d3a9525945cfda68181a5f77c5078eca79ccd3f6508f4d21273dcdf95631fe2b636554eee39516d3ad9c0bb27e3087d5[/img]
You work as a database administrator for Certkiller .com. The database user,
Certkiller 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

Answer: D

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
这题确实看不懂。。[img]http://bbs.duowan.com/images/smilies/ew19.gif[/img]
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////



QUESTION 78:

You work as a database administrator for Certkiller .com. 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

Answer: D



/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
FGAC我书上没说到[img]http://bbs.duowan.com/images/smilies//tu%20(1).gif[/img]，谁能帮忙解释一下。/
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////













QUESTION 84:

Exhibit
[img]http://photo.store.qq.com/http_imgload.cgi?/rurl2=e74c85c23048315ca5547a6905aa6576b102191c46773118853aa35f100f039e5478143c3261f063aac7c37554b0883d44d788f559593d3e0944d59d59c62f67e994cb1b12208ff9186521d6a619a18f746a791a[/img]
You work as a database administrator for Certkiller .com. Use the exhibit to see
details about existing tablespaces in the Oracle 10g database.
You want to add a newtablespace to your database. Which three statements
regarding a newtablespaceare true? Choose three.
A.A newtablespacecan be abigfiletablespace.
B.A newtablespacecannot be an undotablespace.
C.A newtablespacecannot be a temporarytablespace.
D.A newtablespacecan be a locally managedtablespace.
E.A newtablespacecan be a dictionary-managedtablespace.
F.A newtablespacecan use automatic segment space management.

Answer: B, D, E






/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
B为什么[img]http://bbs.duowan.com/images/smilies//tb35.gif[/img]不能新建撤消段
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////






QUESTION 87:

Consider the following scenario:
You have a directory, data, under the disk group tdgroup
A. You want to create an
alias for one of the data files and you execute the following command:
ALTER DISKGROUP tdgroupA
ADD ALIAS '+tdgroupA/data/datafile.dbf'
FOR '+tdgroupA.231.45678';
Which task would be accomplished by the command?

A. The command drops the file +tdgroupA.231.45678
B. The command physically relocates the file to +tdgroupA/data and renames the file to
datafile.dbf.
C. The command creates a copy of the +tdgroupA.231.45678 file and places it in+tdgroupA/data after remaining the file to datafile.dbf.
D. The command creates a synonym, datafile.dbf, and places it in +tdgroupA/data and
does not remove the +tdgroupA.231.45678 file.
E. The command creates a file, datafile.dbf, in +tdgroupA/ data and removes the
references for +tdgroupA.231.45678 from the data dictionary views.

Answer: D
Alias names (or just "aliases") are intended to provide a more user-friendly means of
referring to ASM files, rather than using the system-generated filenames. You can create
an alias for a file when you create it in the database, or you can add an alias to an existing
file using the ADD ALIAS clause of the ALTER DISKGROUP statement. You can
create an alias in any system-generated or user-created ASM directory. You cannot create
an alias at the root level (+), however. The following statement adds a new alias name for
a system-generated file name:
ALTER DISKGROUP dgroup1
ADD ALIAS '+dgroup1/mydir/second.dbf'
FOR '+dgroup1/sample/datafile/mytable.342.3';
REF.: Oracle(r) 10g Administrator Guide, 12-28






/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
这题确实不知道它讲[img]http://bbs.duowan.com/images/smilies//hz%20(37).gif[/img]哪个知识点。
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////









QUESTION 88:

Exhibit
[img]http://photo.store.qq.com/http_imgload.cgi?/rurl2=1bde9df968df1d7d1d4f38a40deb8c5812b706f5721ecd5528679e0e7ce34b6159f6d3e9ab4948bd42add6922a1cdac60e69cc47e86a61e9230a291bbf4f226ec4f4c70195fdd3e3125bec82500710e94bb64335[/img]
One the evening of April 22, you are working on a database created using Oracle
Database 10g. This database operates in the ARCHIVELOG mode. You discover
that you need crucial data that was dropped from the database at 8:00 a.m. No full
backup has been taken after April 15.
What would you do?

A. recover the database until April 10
B. recover the database until April 15
C. recover the database until 22 7:59 a.m.
D. recovery is not possible; manually re-create the object

Answer: C
RMAN simplifies recovery operations using backups taken from earlier database
incarnation so that it is easy as recovering a backup from the same incarnation. Thesimplified recovery through RESETLOGS feature is an enhancement to recovery
operations so that previous incarnation backups can be used for recovery of the current
database incarnation. You use this feature when you have performed an incomplete
recovery (or a recovery using a backup control file) and opened the database with the
RESETLOGS option.
To perform incomplete recovery, use the SET UNTIL command to specify the time,
SCN, restore point, or log sequence number at which recovery terminates. Alternatively,
specify the UNTIL clause on the RESTORE and RECOVER commands.
REF.: Oracle(r) Database 10g: New features for Oracle 8i, 18-21 and Oracle(r) 10g Backup and Recovery
Basics, 3-4







/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
具体怎么操做？[img]http://bbs.duowan.com/images/smilies//hz%20(24).gif[/img]
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////








QUESTION 89:

You are unable to move the Unified Job Scheduler occupant from the SYSAUX
tablespace to the USERS tablespace. What could be the reason?

A. None of the SYSAUX occupants can be relocated.
B. The USERS tablespace is a bigfile tablespace (BFT).
C. The united Job Scheduler occupant cannot be relocated.
D. The SYSAUX occupants can be relocated to the SYSTEM tablespace only.

Answer: C
A - Not true. Same off the occupants can be move
B - Not true. The USERS occupant , isn't , by default a BFT tablespace, and even tought,
you should be able to move anything to a BFT tablespace. The point it's about to move,
SYSAUX occupant.
C - True answer, as you con check , by the following query :
SELECT occupant_name, move_procedure,
FROM v$sysaux_occupants;
OCCUPANT_NAME MOVE_PROCEDURE

-------------- ---------------------------------

AO DBMS_AW.MOVE_AWMETA
EM emd_maintenance.move_em_tblspc
JOB_SCHEDULER *** MOVE PROCEDURE NOT APPLICABLE **
LOGMNR SYS.DBMS_LOGMNR_D.SET_TABLESPACE
LOGSTDBY SYS.DBMS_LOGSTDBY.SET_TABLESPACE
ODM MOVE_ODM
ORDIM *** MOVE PROCEDURE NOT APPLICABLE ***
ORDIM/PLUGINS *** MOVE PROCEDURE NOT APPLICABLE ***
ORDIM/SQLMM *** MOVE PROCEDURE NOT APPLICABLE ***
SDO MDSYS.MOVE_SDO
STATSPACK Use export/import (see export parameter file spuexp.par)
STREAMS
TEXT DRI_MOVE_CTXSYS
ULTRASEARCH MOVE_WK
WM DBMS_WM.move_procD - Not true. Can move SYSAUX occupants, whem is possible, to any tablespace that
you want.
REF.: Metalink Note: 243246.1: 10G : SYSAUX Tablespace






/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
转移的是什么？[img]http://bbs.duowan.com/images/smilies//tu%20(1).gif[/img]
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////






QUESTION 90:

You want to enforce a company's business policy on several objects by using a single
policy function.
Which two types of policies can be assigned to the policy_type argument in the
dbms_rls.add_policy procedure to achieve the above objective? (Choose two.)

A. DBMS_RLS.STATIC
B. DBMS_RLS.DYNAMIC
C. DBMS_RLS.SHARED_STATIC
D. DBMS_RLS.CONTEXT_SENSITIVE
E. DBMS_RLS.SHARED_CONTEXT_SENSITIVE

Answer: C, E
DBMS_RLS. SHARED_STATIC
The policy function executes once, Once, then the predicate is cached in the SGA, and
it's Shared Across Multiple Objects, like Hosting environments, such as data warehouses
where the same predicate must be applied to multiple database objects
DBMS_RLS. SHARED_CONTEXT_SENSITIVE
The policy function executes f irst time and the object is reference in a database session
Predicates are cached in the private session memory UGA so policy functions can be
shared among objects.
REF.: Oracle(r) Database Security Guide 10g Release 2 (10.2) - p 15-30




/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
这个包没用过，[img]http://bbs.duowan.com/images/smilies//hz%20(41).gif[/img]功能是？
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////










QUESTION 92:

You are connecting to an Oracle database server from a client by using the
following connect string:
SQL> CONNECT hr/[email]hr@pdserver.us.oracle.com[/email]:1521/proddb
Which naming method is being used in this case?

A. Local Naming
B. Easy Connect
C. External Naming
D. Directory Naming

Answer: B







/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
上述这各种方式的连接 命令 该怎么打？求教[img]http://bbs.duowan.com/images/smilies/ew10.gif[/img]
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////















/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
怎么判断?[img]http://bbs.duowan.com/images/smilies/ew02.gif[/img]
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

请大家指教[img]http://bbs.duowan.com/images/smilies/ew47.gif[/img][img]http://bbs.duowan.com/images/smilies/ew47.gif[/img]看书2遍了,有些地方这书描述的不够详细[img]http://bbs.duowan.com/images/smilies/ew32.gif[/img]好人有好[img]http://bbs.duowan.com/images/smilies/ew38.gif[/img]报