ocp考試052最新考試題庫(kù)原題-10-20xx0810【整理版】(已修改)
2025-04-05 05:01 本頁(yè)面
【正文】 052題庫(kù)解析最新15道題052題庫(kù)解析1020180810題庫(kù)新特點(diǎn)：l 最新052題庫(kù)，按知識(shí)點(diǎn)分類(lèi)，方便大家學(xué)習(xí)每周五晚8點(diǎn)直播地址：ocp考試討論群：836361015 驗(yàn)證：ocpCUUG整理，官網(wǎng)：?47. USER1 grants SELECT, INSERT, and UPDATE privileges on to
USER2. Sys executes this mand:SQL REVOKE UPDATE ON FROM user1。 What will be the oute?A) It will fail because USER1 is the owner of .
B) It will succeed but neither USER1 nor USER2 will be able to perform
SELECT, INSERT, or UPDATEon .C) It will succeed and only USER1 will be unable to perform SELECT,
INSERT, or UPDATE on.D) It will succeed and neither USER1 nor USER2 will be able to perform
INSERT or UPDATE on , but both will be able to query .
E) It will succeed and only USER2 will be unable to perform SELECT,
INSERT, or UPDATE on. Answer：A49. Examine these facts about a database: 1. USER is the database default tablespace.2. USER1, USER2, and USER3 have the CREATE SESSION privilege.3. They also have UNLIMITED QUOTA on the default tablespace USERS.4. They have no other privileges.Examine these mands:SQL conn / as sysdba Connected.SQL GRANT CREATE TABLE TO user1 WITH ADMIN OPTION。 Grant succeeded.
SQL conn user1/oracle_4UConnected.SQL GRANT CREATE TABLE TO user2。
Grant succeeded.SQL GRANT CREATE TABLE TO user3 WITH ADMIN OPTION。
Grant succeeded.Which two are true?A) If SYS revokes CREATE TABLE from USER1, it is not revoked from
USER2 and USER3.B) Only SYS can revoke CREATE TABLE from USER1.
C) If SYS revokes CREATE TABLE from USER1, it is revoked from USER2
but not from USER3.D) Any user with CREATE TABLE WITH ADMIN OPTION can revoke
CREATE TABLE from USER1.E) Only SYS and USER1 can revoke CREATE TABLE from USER3.(為什么錯(cuò) 了？）Answer： AD49. In one of your databases:1. USER1 and USER2 have no system privileges.
2. ROLE1 only has these privileges:
? CREATE SESSION? CREATE TABLE ? CREATE VIEWExamine these mands: SQL conn / as sysdbaConnected.SQL GRANT create table, role1 TO user1 WITH ADMIN OPTION。
Grant succeeded.SQL conn user1/oracle_4U Connected.SQL GRANT role1 TO user2。 Grant succeeded.Which mand would you execute and as which user, to revoke the create table
privilege from USER2? A) REVOKE CREATE TABLE FROM user2 as SYS
B) REVOKE CREATE TABLE FROM role1 as SYS
C) REVOKE CREATE TABLE FROM role1 as USER1
D) REVOKE CREATE TABLE FROM user1 as SYS
Answer: B只有sys用戶才能夠從role中revoke權(quán)限，而user1只能把role授權(quán)給其它用戶，或者
從其它用戶回 收role。51. Examine these facts about a database: ? The database default tablespace to EXAMPLE.? DEFERRED_SEGMENT_CREATION is TRUE （原來(lái)為FALSE，題目有錯(cuò)） Examine these mands:
SQL CREATE USER user1 IDENTIFIED BY oracle_4U PASSWORD
EXPIRE。 User created.SQLALTER USER user1 IDENTIFIED BY oracle。
User altered.SQLGRANT CREATE SESSION TO user1。
Grant succeeded.SQLGRANT CREATE TABLE TO user1 WITH ADMIN OPTION。
Grant succeeded.Which four are true?A) User1 can connect to the database in
研究報(bào)告相關(guān)推薦
鄂ICP備17016276號(hào)-1