多选题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？（）AData PumpBOracle Net ManagerCOracle Enterprise ManagerDOracle Universal Installer （OUI）EDatabase Configuration Assistant （DBCA）
多选题
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）
参考解析
解析：
暂无解析
相关考题：
You observed the following output for a user session:What do you infer from the preceding output?() A. Resumable set for session with sid 18B. The user session has entered into a deadlockC. The database instance is enabled to use asynchronous commitD. The threshold warning limit is exceeded for the tablespace that is used by the user session
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 fileB. authentication by using certificates over SSLC. authentication by using the Oracle Internet DirectoryD. authentication by using the local OS of the database server
Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?() A.REVOKE ACCESS ON DATABASE FROM USER bobB.REVOKE CONNECT ON DATABASE FROM USER tomC.REVOKE tom FROM ACCESS ON DATABASE BY USER bobD.REVOKE tom FROM CONNECT ON DATABASE BY USER bob
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.
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（））；
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";
Which of the following statements allows BOB to revoke access to the SAMPLE database from user TOM?（）A、REVOKE ACCESS ON DATABASE FROM USER bobB、REVOKE CONNECT ON DATABASE FROM USER tomC、REVOKE tom FROM ACCESS ON DATABASE BY USER bobD、REVOKE tom FROM CONNECT ON DATABASE BY USER bob
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.
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 PumpB、Oracle Net ManagerC、Oracle Enterprise ManagerD、Oracle Universal Installer （OUI）E、Database Configuration Assistant （DBCA）
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 fileB、 authentication by using certificates over SSLC、 authentication by using the Oracle Internet DirectoryD、 authentication by using the local OS of the database server
You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL DROP PROFILE app_user； Which statement describes the result（）A、The command produces an error.B、The profile is dropped and current user sessions use the DEFAULT profile immediately.C、The profile is dropped and only the subsequent user sessions use the DEFAULT profile.D、The profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.
You have two database servers SEMP and SACCT. The database in the SEMP server maintains theemployee information and the database in the SACCT server maintains the accounts payable information.The employees submit the expense reports to the accounts payable department. A user of the accountspayable database wants to extract the employee information from the database in the SEMP server for cross-verification. Which schema object enables the user to access the information from the remote database（）A、ClusterB、Database linkC、Mapping tableD、Materialized view
单选题You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）ASYSDBABSYSOPERCNo system privileges are required for the RMAN user.DOnly SYS user can connect and execute RMAN commands on a target database.
单选题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？（）AUser user = // retrieve the User object from the database session.setDurationInterval（user.getSessionDuration（））；BUser user = // retrieve the User object from the database session.setMaxDuration（user.getSessionDuration（））；CUser user = // retrieve the User object from the database session.setInactiveInterval（user.getSessionDuration（））；DUser user=//retrieve the User object from the database session.setDuration（user.getSessionDuratio（））；EUser user = // retrieve the User object from the database session.setMaxInactiveInterval（user.getSessionDuration（））；
单选题You want the user APP_DBA to administer the Oracle database from a remote machine. APP_DBA is granted the SYSDBA privilege to perform administrative tasks on the database. Which file is used by the Oracle database server to authenticate APP_DBA？（）Acontrol fileBpassword fileClistener controller fileDcontrol file and password file
单选题View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL SELECT substr（component， 0， 10） COMP， current_size CS， user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0；What do you infer from this（）AThe database instance is running with manual PGA management.BThe database instance is running with manual shared memory management.CThe database instance has the MEMORY_TARGET value set to a nonzero value.DAll sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed
多选题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？（）AData PumpBOracle Net ManagerCOracle Enterprise ManagerDOracle Universal Installer （OUI）EDatabase Configuration Assistant （DBCA）
单选题Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client whileconnecting to the database instance from a remote machine（）AHost naming methodBLocal naming methodCExternal naming methodDDirectory naming method
单选题Which statement is true about Oracle Net Listener?（）AIt acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.BA single listener can service only one database instance and multiple remote client connections.CService registration with the listener is performed by the process monitor (PMON) process of each database instance.DThe listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.
单选题You have two database servers SEMP and SACCT. The database in the SEMP server maintains theemployee information and the database in the SACCT server maintains the accounts payable information.The employees submit the expense reports to the accounts payable department. A user of the accountspayable database wants to extract the employee information from the database in the SEMP server for cross-verification. Which schema object enables the user to access the information from the remote database（）AClusterBDatabase linkCMapping tableDMaterialized view
多选题Examine the following impdp command to import a database over the network from a pre-12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?（）AThe import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.BAll the user-defined tablespaces must be in read-only mode on the source database.CThe export dump file must be created before starting the import on the target database.DThe source and target database must be running on the same platform with the same endianness.EThe path of data files on the target database must be the same as that on the source database.FThe impdp operation must be performed by the same user that performed the expdp operation.
单选题In your database instance， the user sessions are connected to the database server from the remotemachines. You want to achieve the following for these users： 1：The user account must be locked after four unsuccessful login attempts.PASSWORD_LOCK_TIME 2：The user must be prompted to change the password at regular intervals.PASSWORD_LIFE_TIME 3：The user may not have more than three simultaneous sessions.SESSIONS_PER_USER 4：The user session must automatically be logged off if more than 10 minutes elapsed time used.CONNECT_TIME How would you accomplish the above（）Aby assigning profiles for the usersBby implementing Fine-Grained Auditing （FGA）Cby granting a secure application role to the usersDby implementing the Database Resource Manager plan
单选题You created a profile APP_USER and assigned it to the users. After a month， you decide to drop theprofile.Some user sessions are currently connected to the database instance and are using the APP_USERprofile. This command is used to drop the profile： SQL DROP PROFILE app_user； Which statement describes the result（）AThe command produces an error.BThe profile is dropped and current user sessions use the DEFAULT profile immediately.CThe profile is dropped and only the subsequent user sessions use the DEFAULT profile.DThe profile is dropped， the sessions are terminated， and the subsequent user sessions use theDEFAULT profile.
单选题In which situation would you use static database registration for a listener（）Awhen multiple databases are to be registered with the listenerBwhen DBAs need to connect remotely to start up the database instanceCwhen users need to connect the database instance using the host naming methodDwhen the database instance that is to be registered with the listener is configured in shared server mode
单选题Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine？（）Ahost naming methodBlocal naming methodCexternal naming methodDdirectory naming method
单选题You work in a company which 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. When you are absent, a user will use a login named Mary to log in and maintain the database snapshots. The user has to delete the database snapshots for DB1, so you have to give the appropriate permissions to the user. So which database permission should you give the user?（）ADELETE BCONTROL CDROP DATABASE DALTER ANY DATASPACE
单选题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（）AThe database user OPS$SKD will be able to administer the database.BThe authentication detail for the database user OPS$SKD is recorded in the password file.CThe local operating system user SKD will be able to access the database instance without specifying the username and password.DThe database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
单选题All the database users are presently connected to the database instance and working. The HR user hasopened three database sessions and executed the following command in one of his sessions：SQL UPDATE persons SET ccode=’U031’ WHERE ccode=’U029’； 123 rows updated.SQL DELETE FROM persons WHERE exp=’Y’；3 rows deleted. The SYS user opens a new session after HR executed the above commands. Which sessions can see theeffect of the UPDATE and DELETE commands（）AAll sessions of the HR user onlyBAll sessions of the HR user and the SYS userCThe session of the HR user that executed the commandsDAll the sessions for which the database users have access privilege to the PERSONS table