ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：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.........【阅读全文】
发布时间：2019-09-25 09:25:03
1.USERS is the database default tablespace.3.They also have UNLIMITED QUOTA on the default tablespace USERS.Examine these commands:Connected.Grant succeededConnected.Grant succeeded.Grant succeeded.A)If sys revokes CREATE TABLE from USER1,it is not revoked from USER.........【阅读全文】
