单选题Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus?()A The user must be granted the database administrator (DBA) privilege.B The user must be listed in the password file for the authentication.

题目
单选题
Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus?()
A

The user must be granted the database administrator (DBA) privilege.

B

The user must be listed in the password file for the authentication.

C

No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.

D

Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager,and grant the webDba role to the user.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You are the domain administrator for . Active Directory domain. All client computers run Windows XP Professional.A user reports that she attempted to log on six times unsuccessfully. She reports that she logged on successfully yesterday. You discover that the user reset her password three days ago to comply with a new security policy that requires strong passwords.The account policies that are applied in the Domain Security Group Policy object (GPO) as shown in the following table.You need to ensure that the user can log on to the domain.What should you do?()

A. Reset the password for the computer account.

B. Unlock the user account.

C. In the user account properties, select the Password never expires check box for the user account.

D. In the user account properties, select the User must change password on next logon check box for the user account.


参考答案:B

第2题:

A user is successfully authenticating to the network but is unable to access protected resources behind a ScreenOS enforcer. You log in to the ScreenOS enforcer and issue the command get auth table infranet and you do not see the user listed.Which two event log settings on the Junos Pulse Access Control Service must you enable to troubleshootthis issue?()

  • A、Connection Requests
  • B、System Errors
  • C、Enforcer Events
  • D、Enforcer Command Trace

正确答案:C,D

第3题:

In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:Which authentication method would be used first?()

A. authentication by password file

B. authentication by using certificates over SSL

C. authentication by using the Oracle Internet Directory

D. authentication by using the local OS of the database server


参考答案:A

第4题:

You are working as a Database Administrator. Despite having a password in the data dictionary as change_on_install, you always log on to the database MYNEWDB using operating system authentication. Your organization is planning to recruit two junior-level DBAs. You decide to enable remote authentication in your database so that the new DBAs can log on to the database from their workstations to carry out administrative tasks.   To allow the new DBAs to perform the administrative tasks, you create a password file on the database server using the following command:   ORAPWD file=d:/oracle/ora9i/orapwU01 password=admin entries=4   After creating the password file, you remove the operating system authentication and change the value of the  REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE. You also create a net service name as MYNEWDB that allows the new DBAs to connect to the database server from their workstations using this net service name. Which command must you use to connect to the database to start it?()  

  • A、 CONNECT / AS SYSDBA
  • B、 CONNECT sys/admin AS SYSDBA
  • C、 CONNECT sys/admin@mynewdb AS SYSDBA
  • D、 CONNECT sys/change_on_install AS SYSDBA

正确答案:D

第5题:

In your database,the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:$ SQLPLUS scott/tiger@DB01 AS SYSDBA   where DB01 is the net service name.   Which authentication method would be used first?()  

  • A、 authentication by password file
  • B、 authentication by using certificates over SSL
  • C、 authentication by using the Oracle Internet Directory
  • D、 authentication by using the local OS of the database server

正确答案:A

第6题:

Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus?()

  • A、The user must be granted the database administrator (DBA) privilege.
  • B、The user must be listed in the password file for the authentication.
  • C、No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.
  • D、Set up a user in the Oracle Application Server Containers for J2EE (OC4J) user manager,and grant the webDba role to the user.

正确答案:D

第7题:

Which are the prerequisites for performing flashback transactions on your database?()

  • A、 Undo retention guarantee for the database must be configured.
  • B、 Supplemental log must be enabled for the primary key.
  • C、 Supplemental log must be enabled.
  • D、 Execute permission on the DBMS_FLASHBACK package must be granted to the user.

正确答案:B,C,D

第8题:

A user is successfully authenticating to the network but is unable to access protected resources behind a ScreenOS enforcer. You log in to the ScreenOS enforcer and issue the command get auth table infranet and you do not see the user listed.Which two event log settings on the Junos Pulse Access Control Service must you enable to troubleshootthis issue?()

A. Connection Requests

B. System Errors

C. Enforcer Events

D. Enforcer Command Trace


参考答案:C, D

第9题:

Manually, you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective?()

  • A、 The user must have been granted the DBA role.
  • B、 The user must have been granted the switch privilege as a part of a role.
  • C、 The user must have been granted the Resource Manager administrator privilege.
  • D、 The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.

正确答案:D

第10题:

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.

正确答案:B

更多相关问题