ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291
全部博文(487)
发布时间:2019-09-30 14:01:41
Which two actions must you take?B)Grant access to the Oracle software owner O/S account to all database administrators.D)Assign different O/S groups to the OSOPER and OSDBA credentials.Answer: CD题译:你已经决定实行最少权限和职责分离的原则。principle 原则。D 译:向 OSOPER 和 OS.........【阅读全文】
发布时间:2019-09-30 13:31:08
The database default tablespace is EXAMPLE.Examine these commands;User created.User alteredA)USER1 can create tables in EXAMPLE tablespaceC)USER1 can create tables in the EXAMPLE tablespaceE)USER1 can login to the database instance.赵:AC 错,没有授权表空间的.........【阅读全文】
发布时间:2019-09-29 14:38:45
DEFERRED_SEGMENT_CREATION IS FALSE.SQL.>CREATE USER user1 IDENTIFIED BY oracle_4U password expire;SQL>ALTER USER user1 ACCOUNT UNLOCK;SQL>GRANT CREATE SESSION TO user1;SQL>GRANT CREATE TABLE TO user1 WITH ADMIN OPTION;Which three are true?B)USER1 can grant the CREATE TABLE .........【阅读全文】
发布时间:2019-09-26 17:17:57
1.USER1 and USER2 have no system privileges.?CREATE SESSION?CREATE VIEWSQL> conn / as sysdbaSQL> GRANT create table, role1 TO user1 WITH ADMIN OPTION;SQL> conn user1/oracle_4USQL> GRANT role1 TO user2;Which command would you execute and as which user, to revoke the crea.........【阅读全文】
发布时间:2019-09-25 10:19:54
1.USER1 and USER2 have no system privileges.?CREATE SESSION?CREATE VIEWSQL> conn / as sysdbaSQL> GRANT create table, role1 TO user1 WITH ADMIN OPTION;SQL> conn user1/oracle_4USQL> GRANT role1 TO user2;Which command would you execute and as which user, to revoke the crea.........【阅读全文】