[Q][031]Discuss Together

AlanFang

大家讨论的这么激烈, 请保证都是用testking 031-V3.0的答案。

另，请问有人在多伦准备考031的吗？ 可以交流，交流经验。。

AlanFang

QUESTION NO: 117
Anne issued this SQL statement to grant Bill access to the CUSTOMERS table in Anne's
schema:
GRANT SELECT ON customers TO bill WITH GRANT OPTION;
Bill issued this SQL statement to grant Claire access to the CUSTOMERS table in Anne's
schema:
GRANT SELECT ON anne.customers TO claire;
Later, Anne decides to revoke the select privilege on the CUSTOMERS table from Bill.
Which statement correctly describes both what Anne can do to revoke the privilege, and
the effect of the REVOKE command?
A. Anne can run the REVOKE SELECT ON customers FROM bill statement. Both Bill and
Claire lose their access to the CUSTOMERS table.
1z0-031
B. Anne can run the REVOKE SELECT ON customers FROM bill statement. Bill loses
access to the CUSTOMERS table, but Claire will keep her access.
C. Anne cannot run the REVOKE SELECT ON customers from BILL statement unless Bill
first revokes Claire's access to the CUSTOMERS table.
D. Anne must run the REVOKE SELECT ON customers FROM bill CASCADE statement.
Both Bill and Claire lose their access to the CUSTOMERS table.
Answer: A
Anne can run the REVOKE SELECT ON customers FROM bill statement. Both Bill and Claire
lose their access to the CUSTOMERS table because of cascade revoking of privilege.
Incorrect Answers
B: Both Bill and Claire lose their access to the CUSTOMERS table, not only Bill.
C: Anne can run the REVOKE SELECT ON customers FROM bill statement. There is no
limitation in Oracle that Bill needs first to revoke Claire's access to the CUSTOMERS table
if Anne granted this privilege to Bill WITH GRANT OPTION.
D: Anne can revoke the privilege from the Bill and Claire just with REVOKE command. There
is no CASCADE clause in the REVOKE command. But the CASCADE CONSTRAINTS
optional clause requires if you are revoking the REFERENCES privilege. In our case it is not
required.

xmzw

QUESTION NO: 117
我觉得答案是A
原因题目下面的解释已经有了

你为什么会认为是B呢？

AlanFang

我错了, 是A.

我把system privilege , object privilege 搞混了。。。  

supexplorer

Somebody had posted all correct answers.(TK3)
If you doubt them, we can discuss them

liu

http://www.itpub.net/showthread.php?s=&threadid=57927

Hope the post  "[031] Discuss together"  can be the one stop collection for any info related to 031, and make life easier for whose who take this exam later.

neocene

最初由 xmzw 发布
[B]QUESTION NO: 74
You set the value of the OS_AUTHENT_PREFIX initialization parameter to OPS$ and created a user account by issuing this SQL statement:
CREATE USER OPS$smith
IDENTIFIED EXTERNALLY;
Which two statements are true? (Choose two.)
A. Oracle server assigns the DEFAULT profile to the user.
B. You can specify the PASSWORD EXPIRE clause for an external user account.
C. The user does not require CREATE SESSION system privilege to connect to the database.
D. If you query the DBA_USERS data dictionary view the USERNAME column will contain the value SMITH.
E. The user account is maintained by Oracle, but password administration and user authentication are performed by the operating system or a network service.
Answer: C, D

我选择A,D [/B]

Should be A,B

D is incorrect. The value in DBA_USERS is OPS$SMITH, not SMITH,
B is correct, please check the 031 student guide page 15-10.

ufohj

Any new question in test?!

ufohj

UP!!!

shyu1

I passed the exam by using TK V4
http://www.itpub.net/showthread.php?s=&threadid=61532
and
http://itpub.net/showthread.php? ... hlight=%D0%DE%D5%FD
Five new qestions for me.
Thank you for everyone here.