ocp考試052最新考試題庫原題-10-20xx0810【整理版】-wenkub
2023-04-08 05:01:54 本頁面
【正文】 n.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.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.SQLGRANT CREATE TABLE TO user1 WITH ADMIN OPTION。 User created.
SQLALTER USER user1 ACCOUUNT UNLOCK。
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。
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。 Grant succeeded. SQL conn user1/oracleConnected.SQL GRANT CREATE TABLE TO USER2 WITH ADMIN OPTION。
SQL CREATE TABLE (c1 number)。UNDO39。undo%39。UNDO39。UNDO39。undo%39。UNDO39。UNDO39。UNDO39。undo%39。UNDO39。UNDO39。undo%39。
Grant succeeded. SQL conn / as sysdba Connected.SQL REVOKE CREATE TABLE F
研究報告相關(guān)推薦
鄂ICP備17016276號-1