QUESTION 50-upgraded your database to a multitenant container database (CDB)

You upgraded your database from pre-12c to a multitenant container database (CDB) containing pluggable databases (PDBs).
Examine the query and its output:
SQL> SELECT name, force_logging FROM V$DATABASE;
NAME FORCE_LOGGING
------------------ ----------------------------
PROD NO
Which two tasks must you perform to add users with SYSBACKUP, SYSDG, and SYSKM privilege to the password file?
A. Assign the appropriate operating system groups to SYSBACKUP, SYSDG, SYSKM.
B. Grant SYSBACKUP, SYSDG, and SYSKM privileges to the intended users.
C. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege and the FORCE argument set to No.
D. Re-create the password file with SYSBACKUP, SYSDG, and SYSKM privilege, and FORCE arguments set to Yes.
E. Re-create the password file in the Oracle Database 12c format.
Correct Answer: BD

* orapwd
/ You can create a database password file using the password file creation utility, ORAPWD. The syntax of the ORAPWD command is as follows:
orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}] [DBUNIQUENAME=dbname]
[FORMAT={12|legacy}] [SYSBACKUP={y|n}] [SYSDG={y|n}] [SYSKM={y|n}] [DELETE={y|n}]
[INPUT_FILE=input-fname]
force - whether to overwrite existing file (optional),
* v$PWFILE_users
/ 12c: V$PWFILE_USERS lists all users in the password file, and indicates whether the user has been
granted the SYSDBA, SYSOPER, SYSASM, SYSBACKUP, SYSDG, and SYSKM privileges.
/ 10c: sts users who have been granted SYSDBA and SYSOPER privileges as derived from the password file.
ColumnDatatypeDescription
USERNAMEVARCHAR2(30)The name of the user that is contained in the password file SYSDBAVARCHAR2(5)If TRUE, the user can connect with SYSDBA privileges SYSOPERVARCHAR2(5)If TRUE, the user can connect with SYSOPER privileges
Incorrect Answers:
E: The format of the v$PWFILE_users file is already in 12c format.

 

您将数据库从前12c版本升级为包含可插入数据库(pdb)的多租户容器数据库(CDB)。

检查查询及其输出:

SQL> SELECT name, force_logging FROM V$DATABASE;
NAME FORCE_LOGGING
------------------ ----------------------------
PROD NO

要将具有SYSBACKUP、SYSDG和SYSKM权限的用户添加到密码文件中，必须执行哪两个任务?

A.为“SYSBACKUP”、“syssdg”、“sysmm”分配适当的操作系统组。

B.为用户授予SYSBACKUP、SYSDG和SYSKM权限。

C.重新创建具有SYSBACKUP、SYSDG和SYSKM权限的密码文件，并将FORCE参数设置为No。

D.重新创建具有SYSBACKUP、SYSDG和SYSKM权限的密码文件，强制参数设置为Yes。

E.重新创建Oracle 12c格式的密码文件。

正确答案:B D

 

* orapwd

/您可以使用密码文件创建工具ORAPWD创建数据库密码文件。ORAPWD命令的语法如下:

orapwd FILE=filename [ENTRIES=numusers] [FORCE={y|n}] [ASM={y|n}] [DBUNIQUENAME=dbname]

[格式={12 |遗留}][SYSBACKUP = {y | n}] [SYSDG = {y | n}] [SYSKM = {y | n}][删除= {y | n}]

[INPUT_FILE = input-fname]

force -是否覆盖现有文件(可选)，

* v $ PWFILE_users

/ 12c: V$PWFILE_USERS列出密码文件中的所有用户，表示该用户是否已登录

4 .使用“SYSDBA”、“SYSOPER”、“SYSASM”、“SYSBACKUP”、“SYSDG”和“SYSKM”权限。

/ 10c:从密码文件中获得SYSDBA和SYSOPER特权的sts用户。

ColumnDatatypeDescription

USERNAMEVARCHAR2(30)密码文件SYSDBAVARCHAR2(5)中包含的用户名。如果为真，则该用户可以连接到SYSDBA权限

不正确的答案:

v$PWFILE_users文件的格式已经是12c格式了。