症状:standby_file_management 在MANUAL模式下添加数据文件报错处理:1.standby_file_management为MANUAL,主库添加数据文件,从库发现如下报错:Errors in file /u01/app/oracle/diag/rdbms/slnngkdg/slnngkdg/trace/slnngkdg_pr00_16209.trc:ORA-01111: name for data file 11 is unknown - rename to correct fileORA...【阅读全文】
36、Which two are true about roles?A) A role can be granted a combination of system and object privileges and other roles.B) The CONNECT role Is granted automatically to a user when It Is created.C) Roles are owned by SYSTEM.D) The RESOURCE role Is granted the CREATE SESSION priv...【阅读全文】
27、Examine these facts about a database:1. USERS 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 commands:SQL> c...【阅读全文】