多选题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

第1题：

Which of the following should a technician instruct a user to do to initiate Remote Assistance for a user running Windows XP Professional？（）

• A、Network Neighborhood > navigate to the users computer > right click > select Offer Remote Assistance
• B、Go to Help and Support Center > Pick a Task > Use Tools > Offer Remote Assistance
• C、Run Remote Desktop Connection > Select Connect to User Enter the IP address
• D、Start > Programs > Administrative Tools > Remote Assistance

第2题：

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?（）  

• A、DELETE 
• B、CONTROL 
• C、DROP DATABASE 
• D、ALTER ANY DATASPACE

第3题：

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

第4题：

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（）

• A、Host naming method
• B、Local naming method
• C、External naming method
• D、Directory naming method

第5题：

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）

第6题：

Identify two situations in which you can use Data Recovery Advisor for recovery.（） 

• A、 The user has dropped an important table that needs to be recovered.
• B、 The database files are corrupted when the database is open.
• C、 You are not able to start up the database instance because the required database files are missing.
• D、 The archived log files are missing for which backup is not available.

第7题：

Identify two situations in which you can use Data Recovery Advisor for recovery. （）(Choose two.)

• A、The user has dropped an important table that needs to be recovered.
• B、The database files are corrupted when the database is open.
• C、You are not able to start up the database instance because the required database files are missing.
• D、The archived log files are missing for which backup is not available.

第8题：

ou 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. According to the company requirement, you intend to perform an installation of an instance of SQL Server Reporting Services (SSRS) to the same machine. Now your company CIO wants version histories of all deployed reports can be kept. As a technical support, what should you do to ensure this?（）

• A、You should use the http.sys listener to install the SSRS instance. 
• B、You should configure the SSRS database, make it use Native mode 
• C、You should configure the SSRS database, make it use SharePoint integrated mode 
• D、You should use the Internet Information Services default Web site to install the SSRS instance 

第9题：

Your network contains a server named Server1 that runs Windows Server 2008 R2.  On Server1， you create an Active Directory Lightweight Directory Services （AD LDS） instance named Instance1.   You connect to Instance1 by using ADSI Edit.   You run the Create Object wizard and you discover that there is no User object class.   You need to ensure that you can create user objects in Instance1.   What should you do（）

• A、Run the AD LDS Setup Wizard.
• B、Modify the schema of Instance1.
• C、Modify the properties of the Instance1 service.
• D、Install the Remote Server Administration Tools （RSAT）.

第10题：

第11题：

第12题：

第13题：

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.

第14题：

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";

第15题：

our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

• A、Oracle Net Manager
• B、Listener Control utility
• C、Database Configuration Assistant
• D、Oracle Net Configuration Assistant

第16题：

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？（）

• A、SYSDBA
• B、SYSOPER
• C、No system privileges are required for the RMAN user.
• D、Only SYS user can connect and execute RMAN commands on a target database.

第17题：

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 assign external authentication. The user OPS$SKD has theCREATE SESSION privilege.  What would you achieve 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 theusername and password.
• D、The database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.

第18题：

In which situation would you use static database registration for a listener（）

• A、when multiple databases are to be registered with the listener
• B、when DBAs need to connect remotely to start up the database instance
• C、when users need to connect the database instance using the host naming method
• D、when the database instance that is to be registered with the listener is configured in shared server mode

第19题：

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？（）

• A、control file
• B、password file
• C、listener controller file
• D、control file and password file

第20题：

You are planning the migration of an existing application to Windows Azure and SQL Azure.  The original application includes a Microsoft SQL Server 2008 database.   You need to recommend an approach for ensuring that the database migrates successfully toSQL Azure.  Which two actions should you recommend？（）

• A、 Remove all clustered indexes from the database.
• B、 Remove all dependencies on the Microsoft Distributed Transaction Coordinator （MSDTC） from the application.
• C、 Use SSL and SQL authentication to connect to the database.
• D、 Use SSL and Windows authentication to connect to the database.

第21题：

ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? （） 

• A、You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance 
• B、You should upgrade the SQL Server 2005 application to use SQL Server 2008 
• C、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance 
• D、You should install SQL Server 2008 as a named instance, and make the new application use the new instance. 

第22题：

第23题：

第24题：