Which users are created and can be used for database and host management of your DBaaS database servers?B) root, oracle and cloud usersD) opc and oracle usersAnswer:B用户对云计算的交付能力已经不再满足于单纯的基础设施(IaaS)交付,他们希望数据中心中的更多传统 IT 服务能以云服务模式进...【阅读全文】
choose twoYou plan to upgrade your Oracle Database 9i to Oracle Database 12c.Which two methods can you use?A) Perform a direct upgrade by manually running the catctl.pl and catupgrd.sql scripts before issuing the STARTUPUPGRADE command.B) Upgrade your current database to Oracle Database release ...【阅读全文】
症状: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...【阅读全文】
今天在做看OCP的时候有道题是关于应用安全角色的,不是很明白,在网上找了个例子按照步骤验证了下.QUESTION 48You want to create a role to meet these requirements:1. The role is to be protected from unauthorized usage.2. The password of the role is not to be embedded in the application source code or sto...【阅读全文】
oracle数据库默认的密码有效期是180,可以修改配置,改成无限制。1、进入sqlplussqlplus / as sysdba;2、查看目前密码有效期SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';PROFILE &nbs...【阅读全文】
1、构造测试环境SYS@vbox66in>create table test1 ( 2 id number not null, 3 num number, 4 val varchar2(100));表已创建。SYS@vbox66in>SYS@vbox66in>create table test2 ( 2 id number not null, 3 t1_id number not null, 4 num number, 5 val varchar2(100));表已创建。SYS@vbox66in> SYS@vbox66in>exec...【阅读全文】
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...【阅读全文】