A user wants to connect to the database instance from an app

第1题：

第2题：

Users of your web application have requested that they should be able to set the duration of their sessions.So for example， one user might want a webapp to stay connected for an hour rather than the webapp’sdefault of fifteen minutes； another user might want to stay connected for a whole day. Furthermore， youhave a special login servlet that performs user authentication and retrieves the User object from the database. You want to augment this code to set up the user’s specified session duration. Which codesnippet in the login servlet will accomplish this goal？（）

• A、User user = // retrieve the User object from the database session.setDurationInterval（user.getSessionDuration（））；
• B、User user = // retrieve the User object from the database session.setMaxDuration（user.getSessionDuration（））；
• C、User user = // retrieve the User object from the database session.setInactiveInterval（user.getSessionDuration（））；
• D、User user=//retrieve the User object from the database session.setDuration（user.getSessionDuratio（））；
• E、User user = // retrieve the User object from the database session.setMaxInactiveInterval（user.getSessionDuration（））；

第3题：

第4题：

A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance？（）

• A、Data Pump
• B、Oracle Net Manager
• C、Oracle Enterprise Manager
• D、Oracle Universal Installer （OUI）
• E、Database Configuration Assistant （DBCA）

第5题：

Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?（）

• A、REVOKE ACCESS ON DATABASE FROM USER bob
• B、REVOKE CONNECT ON DATABASE FROM USER tom
• C、REVOKE tom FROM ACCESS ON DATABASE BY USER bob
• D、REVOKE tom FROM CONNECT ON DATABASE BY USER bob

第6题：

The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE  REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0  You have a local operating system user SKD. You create a database user OPS$SKD， and then  assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege.  What would youachieve by the above process（）

• A、The database user OPS$SKD will be able to administer the database.
• B、The authentication detail for the database user OPS$SKD is recorded in the password file.
• C、The local operating system user SKD will be able to access the database instance without specifying the username and password.
• D、The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.

第7题：

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in the instance. DB1 is available to a Windows group which is named WIIKIGO/Supervisors. A Windows user named User1 is a member of the WIIKIGO/Supervisors group. WIIKIGO/Supervisors is a member of the db_owner role in the DB1 database. You must make sure that the SQL Server instance is available to User1. In the DB1 database, which Transact-SQL statement(s) should you execute?（）  

• A、 DROP LOGIN "WIIKIGO/User1"; 
• B、 EXEC dbo.sp_droprolemember 'db_owner', 'WIIKIGO/User1';
• C、 EXEC dbo.sp_revokedbaccess 'WIIKIGO/User1';EXEC dbo.sp_revokelogin 'WIIKIGO/User1'; 
• D、 CREATE LOGIN "WIIKIGO/User1" FROM Windows;DENY CONNECT SQL TO "WIIKIGO/User1";

第8题：

第9题：

How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual private catalog？（）  

• A、 Issue the grant command from the SYS user （or equivalent） of the target database.
• B、 Issue the grant command from the SYS user （or equivalent） of the recovery-catalog database.
• C、 Issue the grant command from the recovery catalog-owning schema user account in the recovery catalog.
• D、 Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
• E、 Issue the grant command from RMAN when connected to the target database.

第10题：

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