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";
您可能感兴趣的试卷
你可能感兴趣的试题
A.You should execute the GRANT SELECT ON dbo.Table01 TO User1 Transact-SQL statement.
B.You should execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement.
C.You should alter Procedure01 and add the WITH EXECUTE AS OWNER option to its header
D.You should alter Procedure01 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure.
A.You should check SQL1.log
B.You should check SQLAGENT.OUT
C.You should check log_xx.trc
D.You should check ERRORLOG
A.ServiceGreatUser should be added to the appropriate fixed database roles.
B.You should assign the appropriate object-level permissions to ServiceGreatUser
C.You should assign the appropriate server-level permissions to ServiceGreatLogin
D.You should assign the appropriate database-level permissions to ServiceGreatUser
A.You should create policies based on the appropriate facets. Apply the policies against a server group. The server group includes the database servers that need to be configured
B.You should create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to run the script against a server group that includes the database servers that need to be configured
C.You should edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured
D.You should analyze your database servers by using the SQL Server Best Practices Analyzer (BPA). Implement the recommendations of the BPA
A.For both the CustomerDB database and the master database, enable Transparent Database Encryption.
B.You should use the built-in encryption functions to encrypt the sensitive data at the cell level.
C.You should make the CustomerDB database accessible only through stored procedures and functions.
D.For the CustomerDB database, enable Transparent Database Encryption and back up the transaction log.
A.In the cluster quorum drive, install the encryption certificate
B.In the SQL Server shared disk, install the encryption certificate
C.in the cluster group, install the encryption certificate.
D.On each individual node, install the encryption certificate
A.You should recreate the publication
B.You should upload unsynchronized changes.
C.You should reinitialize the publication and generate a new snapshot at once.
D.You should upload unsynchronized changes, and then reinitialize the publication
A.You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by.
B.You should identify whether the SQL Server Agent is started on the primary server.
C.You should identify whether the AdventureWorks database uses the Simple recovery model.
D.You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server
A.You should allow failback only during non-business hours
B.You should immediately allow failback
C.You should prevent automatic failback
D.You should allow failback only during business hours
A.You should configure the database for Read Committed Snapshot isolation.
B.You should modify the stored procedure to use the Snapshot isolation level
C.You should configure the database for Auto Update Statistics asynchronously
D.You should modify the stored procedure to use the Repeatable Read isolation level
最新试题
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 which contains a database. According to the company requirement， you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features. These features will be discontinued. What should you do？ （）
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 on the same physical computer. Now users report that they are unable to connect to the named instances. You check and verify that they can only connect to the default instance. You also ensure that all SQL Server instances run normally. You have to start the service which is required to connect to the named instances. Which service should you start?（）
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. You create a SQL Server Agent job that execute every 2 minutes. There istext file named SQL.log On the E：drive. The job logs information to the text file. You get a report from users saying that the server doesn'；t make response. You check and find that the SQL Server Agent service does not run and the Agent job doesn'；t function any loner. As the IT support， you have to identify the reason for the failure of the SQL Server Agent service. Which log should you check？ （）
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. The instance has databases for a finance application and a manufacturing application. You want to put some limitation on the maximum CPU query time allowed by the applications, so you configure the Resource Governor to achieve this. But you notice that certain reports do not execute successfully any longer on the manufacturing application. You have to allow the manufacturing application to consume more CPU time, so you have to change the Resource Governor configuration. Which Resource Governor component should you configure?（）
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 text file which is named SQL01.log on the E: drive. A SQL Server Agent job executes every 2 minutes and logs information to the text file. You get a report from users saying that the sever doesn't make response. As the technical support, you check and find that the SQL Server Agent service does not run and the SQL Server Agent job no longer functions. You have to identify the reason why the SQL Server Agent service is unresponsive. In the options below, which log should you check? （）
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. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database snapshots were created at 16:30 and at 17:30. The backups and the database snapshots are stored on a different disk from the database files. At 17:05, the hard disk containing the database files fails at 17:02 hours. You must restore DB1 while reduce data loss to the least. So what action should you perform to achieve this goal?（）
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 named Dworks in the instance. The Dworks database has a table named Bills which contains several indexes and a great amount of rows. An enterprise Web environment is supported by the database. Onthe Bills table 28% of the indexes have been fragmented. You have to defragment the indexes， making sure that you reduce the effect on database availability to the least. In the ALTER INDEX statement， which option should be included？（）
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. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible. In the options below, which strategy should you use?（）
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 which is named Instance01. Instance01 contains a database which is named SellingHelp. There isthe Products table in the SellingHelp database. Now according to the company requirement, the Products table has to be replicated to the SQL Server instances installed in laptopscomputers. You have to create a Replication topology to perform this. The Products table is updated from Instance01 when the laptops reconnect to the corporate network. The Products table on Instance01 is frequently updated between reconnections. You must make sure that you can implement the Replication topology along with the Subscription type successfully and meanwhile reduce the bandwidth usage to the least. So what action should you perform to achieve this goal?（）
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. In the Services schema， There is a table named Service.Table. The Services.Table has to be moved from the Sales schema to a new schema named Costs.In the options below， which Transact-SQL statement should you execute？（）