35.You executed the command to create a password file in the database server:
来源:互联网 发布:淘宝店铺4钻能卖多少 编辑:程序博客网 时间:2024/04/29 18:00
35.You executed the command to create a password file in the database server:
$ orapwd file=orapworcl entries=5 ignorecase=N
Which statement describes the purpose of the above password file?
A.It records usernames and passwords of users when granted the DBA role.
B.It contains usernames and passwords of users for whom auditing is enabled.
C.It is used by Oracle to authenticate users for remote database administration.
D.It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating system groups.
答案:C
解析:这里是选择C
这个命令是创建密码文件的
--首先我们删除密码文件
[oracle@wahaha3 dbs]$ ls | grep orapw$ORACLE_SID
orapwwahaha3
[oracle@wahaha3 dbs]$ rm orapwwahaha3
[oracle@wahaha3 dbs]$ ls | grep orapw$ORACLE_SID
[oracle@wahaha3 dbs]$
SQL> select * from v$pwfile_users;
no rows selected
[oracle@wahaha3 dbs]$ sqlplus sys/oracle@wahaha3 as sysdba
ERROR:
ORA-01031: insufficient privileges
[oracle@wahaha3 dbs]$ orapwd file=/u01/oracle/11g/dbs/orapwwahaha3 password=oracle
[oracle@wahaha3 dbs]$ ls | grep orapw$ORACLE_SID
orapwwahaha3
[oracle@wahaha3 dbs]$ sqlplus sys/oracle@wahaha3 as sysdba
SQL>
$ orapwd file=orapworcl entries=5 ignorecase=N
Which statement describes the purpose of the above password file?
A.It records usernames and passwords of users when granted the DBA role.
B.It contains usernames and passwords of users for whom auditing is enabled.
C.It is used by Oracle to authenticate users for remote database administration.
D.It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating system groups.
答案:C
解析:这里是选择C
这个命令是创建密码文件的
--首先我们删除密码文件
[oracle@wahaha3 dbs]$ ls | grep orapw$ORACLE_SID
orapwwahaha3
[oracle@wahaha3 dbs]$ rm orapwwahaha3
[oracle@wahaha3 dbs]$ ls | grep orapw$ORACLE_SID
[oracle@wahaha3 dbs]$
SQL> select * from v$pwfile_users;
no rows selected
[oracle@wahaha3 dbs]$ sqlplus sys/oracle@wahaha3 as sysdba
ERROR:
ORA-01031: insufficient privileges
[oracle@wahaha3 dbs]$ orapwd file=/u01/oracle/11g/dbs/orapwwahaha3 password=oracle
[oracle@wahaha3 dbs]$ ls | grep orapw$ORACLE_SID
orapwwahaha3
[oracle@wahaha3 dbs]$ sqlplus sys/oracle@wahaha3 as sysdba
SQL>
0 0
- 35.You executed the command to create a password file in the database server:
- 149.You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESP
- 116.Your database instance is started using the server parameter file (SPFILE). You executed a comma
- 13.You have executed this command to change the size of the database buffer cache:
- 126 You executed the following commands in a database session: SQL> SELECT object_name, original_nam
- 77.You executed the following command to perform a backup of the USERS tablespace: SQL> ALTER TABLES
- 176.You executed this command to create a temporary table: SQL> CREATE GLOBAL TEMPORARY TABLE report
- 126.Identify the two situations in which you use the alert log file in your database to check the de
- 37.You execute the following command to audit database activities:
- 92 Examine the output of the query that you executed to list the objects in the recycle bin: SQL> SE
- 124.You executed the following commands to find the location of the alert log file: SQL> SHOW PARAME
- 145.Examine the commands executed in a DBA session: SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE '
- 170.A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER T
- 92.You executed the following commands in an RMAN session for your database instance that has failur
- After logging in to the Lotus Notes Client, you are prompted for a password in DOS-like window (Viru
- How To Trace The Remote File Server (RFS) Process In Physical Standby Database (Doc ID 1481125.1)
- 62 You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a
- you must specify a way to create the tab indicator.
- a标签的target指向iframe的name和id的区别
- 读取项目里含指定注解的方法 @interface妙用
- gluLookAt 函数详解
- 多态
- sudo保持前用用户的env环境变量
- 35.You executed the command to create a password file in the database server:
- CodeForces 447A DZY Loves Hash
- SVM再次总结 - 3 - 线性支持向量机
- 搞了个miniblink的github站点
- 继承
- BIOS中断大全:“INT 14H ~ INT 1AH”
- deepin配置vsftp(仅配置篇)
- mysql开放允许远程连接权限
- EQ——音频处理的利器