欢迎来到PP题库网 PP题库官网
logo
全部科目 > Oracle认证考试 > 1z0-043

单项选择题

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?()

    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.

点击查看答案

相关考题

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题