单选题
You are part of the DBA team working for a multinational bank. The team is responsible for performing administrative tasks on the database server located at the home office. The database server at the home office has a production database and a test database named TESTDB. The test database is primarily used for testing database commands and configuration settings befor implementing these settings on the production database. The test database is also used for the development of database applications. You have been asked by the senior DBA to grant the SYSDBA privilege to a new team member， John， so that he can perform some administrative tasks， such as shutdown and startup operations， on TESTDB. You use the password file to configure remote authentication on the TESTDB database. You execute the following statement to grant the SYSDBA privilege to John： SQL>GRANT SYSDBA TO john； However， you receive the following error： ORA-01996： GRANT failed： password file ’c：/oracle/ora9i/dbs/testdb.pwd’ is full Which action should you take to add the user john to the password file without removing any of the existing users？（）
发布日期：2020-04-10
A
Create another password file and then re-execute the GRANT statement.
B
Re-create the password file， specifying a larger number of allowed entries， and then re-execute the GRANT statement.
C
Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in theinitialization parameter file to NONE and then re-execute the GRANT statement.
D
Change the value of the REMOTE_LOGIN_PASSWORDFILE initialization parameter in the initialization parameter file to SHARED and then re-execute the GRANT statement.
标签： part dba team working multinational
题王网让考试变得更简单
扫码关注题王，更多免费功能准备上线！
此试题出现在
CMS专题
CMS专题
其他考试