ocp考試052最新考試題庫原題-10-20xx0810【整理版】(參考版)
2025-03-27 05:01本頁面
【正文】 UNDO39。UNDO39。undo%39。UNDO39。UNDO39。undo%39。UNDO39。UNDO39。undo%39。UNDO39。UNDO39。undo%39。
SQL CREATE TABLE (c1 number)。
Grant succeeded. SQL conn / as sysdba Connected.SQL REVOKE CREATE TABLE FROM USER1。 Grant succeeded. SQL conn user1/oracleConnected.SQL GRANT CREATE TABLE TO USER2 WITH ADMIN OPTION。 Grant
succeeded.SQL GRANT CREATE MATERIALIZED VIEW TO USER1 WITH ADMIN OPTION。
User alteredWhich two are true?A) USER1 can create tables in EXAMPLE tablespace
B) USER1 must change their password at ?rst login
C) USER1 can create tables in the EXAMPLE tablespace
D) USER1 can be granted access to tables in other schemas
E) USER1 can log in to the database instance.
Answer：DE54. You have decided to implement the principle of least privilege and
separation of duties. Which two actions must you take?
A) Grant SYSOPER to application schema owners.
B) Grant access to the Oracle software owner O/S account to all database
administrators. C) Assign the OSOPER and OSDBA groups to the Oracle software owner
O/S account. D) Assign different O/S groups to the OSOPER and OSDBA credentials.
E) Assign the DBA role to application schema owners.Answer：CD55. Examine these facts about a database:1. USERS is the database default tablespace.2. USER1 and USER2 have the CREATE SESSION privilege.3. They also have UNLIMITED QUOTA on the USERS tablespace.
Examine these mands:SQL conn / as sysdba Connected.SQL GRANT CREATE TABLE TO USER1 WITH ADMIN OPTION。SQL CREATE USER user1 IDENTIFIED BY oracle_4U。
Grant succeeded.Which three are true?A) USER1 can create indexes in EXAMPLE tablespace
B) USER1 can grant the CREATE TABLE privilege to other users
C) USER1 can log into the database instanceD) USER1 must change it’s password at ?rst loginE) USER1 can create tables in the EXAMPLE tablespace Answer：BCD53. IN one of your databases。
Grant succeeded。 User created.
SQLALTER USER user1 ACCOUUNT UNLOCK。The database default tablespace is EXAMPLE.
DEFERRED_SEGMENT_CREATION IS FALES.
Examine these mands。
Grant succeeded.SQLGRANT CREATE TABLE TO user1 WITH ADMIN OPTION。 User created.SQLALTER USER user1 IDENTIFIED BY oracle。 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。
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
研究報(bào)告相關(guān)推薦
鄂ICP備17016276號(hào)-1