OCP-052考试题库汇总(5)-CUUG内部解答版

简介:   Examine these attributes for the profile assigned to USER1 whose password is oracle_4U.  • PASSWORD_REUSE_MAX is 5.

  Examine these attributes for the profile assigned to USER1 whose password is oracle_4U.

  • PASSWORD_REUSE_MAX is 5.

  • PASSWORD_REUSE_TIME is 10.

  • PASSWORD_GRACE_TIME is 15.

  Which two conditions must be met for USER1 to reuse oracle_4U?

  A)At least 5 days must have passed since oracle_4U was last used.

  B)The password must have changed 5 times since oracle_4U was last used.

  C)At least 10 days must have passed since oracle_4U was last used.

  D)The password must have changed 10 times since oracle_4U was last used.

  E)At least 15 days must have passed since oracle_4U was last used.

  Answer: BC

  赵:

  B 译:自上次使用 Oracle_4U 以来,密码必须更改了 5 次。

  C 译:自最后一次使用 oracle_4U 以来,至少已经过去了 10 天。

  MAX 是次数,TIME 是天数。

  password_reuse_time 指定了密码不能重用前的天数

  password_reuse_max 则指定了当前密码被重用之前密码改变的次数

  PASSWORD_REUSE_TIME 和 PASSWORD_REUSE_MAX:这两个参数必须互相关联设置。

  总结两者之间的规律:

  (1)都为 UNLIMITED,密码可以随意重用,没有任何限制。

  (2)均为指定值时,必须满足这两者的条件时才可以重用密码。

  (3)当 PASSWORD_REUSE_MAX,PASSWORD_REUSE_TIME 两个有其中一个不为 UNLIMITED,则密码永远不能重用。

  如果密码过期了并且 PASSWORD_GRACE_TIME 设置为 15 天,那么在 15 天在之内如果不变更密码账号就会被锁定。Grace time 宽限期。

目录
相关文章
OCP-052考试题库汇总(58)-CUUG内部解答版
In one of your databases: 1.USER1 and USER2 have no system privileges. 2.ROLE1 only has these privileges: ?CREATE SESSION ?CREATE TABLE ?CREATE VIEW ...
783 0
OCP-052考试题库汇总(57)-CUUG内部解答版
Examine these facts about a databases: 1.USERS is the database default tablespace. 2.USER1,USER2,and USER3 have the CREATE SESSION privilege 3.
755 0
|
数据库 存储
OCP-052考试题库汇总(48)-CUUG内部解答版
Which is true about the Automatic Diagnostic Repository (ADR) ? A) It is used only if the DIAGNOSTIC_DEST parameter is manually configured.
760 0
|
SQL
OCP-052考试题库汇总(44)-CUUG内部解答版
Which two are true about external tables? A)They can be stored in an ASM Cluster File System(ACFS). B)They can always be updated using SQL.
8267 0
|
XML SQL 数据库
OCP-052考试题库汇总(41)-CUUG内部解答版
Examine this session output: SQL> connect scott/tiger Connected. SQL>select name,value 2 from v$parameter 3 where name='audit_trail'; NAME VALUE ----...
905 0
|
数据库 关系型数据库 Oracle
OCP-052考试题库汇总(39)-CUUG内部解答版
Which three are true about auditing? A)Auditing is active only when the database is OPEN. B)Audit records are always stored in the database.
751 0
OCP-052考试题库汇总(34)-CUUG内部解答版
Where is an expdp operation tracked? A)dump files B)control file C)log files D)Automatic Diagnostic Repository(ADR) E)master table (MT) Answer: E 赵: 题译:哪里有一个 Exdp 操作跟踪? Master table 是一个临时 table,专门为 import pump 和 export pump 创建的,一旦完成就会自动被 drop。
614 0
|
数据库 关系型数据库 Oracle
OCP-052考试题库汇总(32)-CUUG内部解答版
Which state must a database be to enable ARCHIVELOG ? A)NOMOUNT B)OPEN IN READ WRITE mode C)OPEN IN READ ONLY mode D)OPEN IN RESTRICTED mode E)MOUNT ...
727 0
|
Oracle 关系型数据库
OCP-052考试题库汇总(29)-CUUG内部解答版
When does an incremental checkpoint occur ? A)when an online redo log switch occurs. B)when DBWn writes dirty buffers as part of its normal processing.
1052 0
|
机器学习/深度学习 Oracle 关系型数据库
OCP-052考试题库汇总(25)-CUUG内部解答版
Which four database objects never have any segments? A)A partitioned index B)A view selecting from a populated table C)An empty index D)An Oracle Loader type external table E)An empty table F)A view selecting from an empty table G)An Oracle Data Pump type external table Answer: BDFG 赵:视图和外部表不存在段。
746 0