Which of the following fixed database roles can add or remove user IDs?

You are the administrator of a SQL Server 2000 computer. The server contains a database named FinanceData that is used by a client/server application. Each employee has a SQL Server login that the application uses to access the server.Your company hires a new employee named Andrew. You create a SQL Server login named Andrew. You also create a database user named Andrew in the database and grant the database user full permissions in the database.Whenever Andrew runs the client/server application, he receives the following error message: "Invalid object name." Andrew also reports that he cannot access the database by using the application.You need to ensure that Andrew can use the application. Which Transact-SQL statement should you execute?

A

EXEC sp_defaultdb 'Andrew','FinanceData'

B

GRANT ALL ON FinanceData TO Andrew

C

EXEC sp_addlogin 'Andrew'

D

EXEC sp_grantdbaccess 'FinanceData','Andrew'GOsp_addrolemember 'db_datareader','Andrew'

Arrange the steps of succession planning in the correct sequence.
1. Define competencies required to perform roles.
2. With future orientation, assess people against criteria.
3. Identify roles for succession or replacement planning.
4. Develop employees to be ready for future key roles.
5. Identify pool of talent that can potentially perform highly in key roles.

A

1, 2, 3, 4, 5

B

2, 1, 3, 4, 5

C

3, 2, 1, 4, 5

D

3, 1, 2, 5, 4

The user IDs can be added or removed using which of the following fixed roles?

A

db_sysadmin

B

db_accessadmin

C

db_securityadmin

D

db_setupadmin

You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information.BULK INSERT finance.dbo.customersFROM 'd:bulkaccts143_10142000.txt'WITH DATAFILETYPE = 'char', FIELDTERMINATOR = 't', ROWTERMINATOR = 'n', TABLOCK You want to ensure that response times do not slow when new account information is added to the database. What should you do?

A

Add the BATCHSIZE option to the BULK INSERT statement, and then set the option equal to 10 percent of the number of rows to be loaded.

B

Add the ROWS_PER_BATCH option to the BULK INSERT statement, and then set the option equal to 10 percent of the number of rows to be loaded.

C

Drop the indexes for the Customers table before the data load, and then re-create the indexes after the data load is complete.

D

Remove the TABLOCK option from the BULK INSERT statement.

Created: 1 month ago | Updated: 1 month ago Options Edit Question Add Description Add Bookmark Add Tag Add Video Error Report

A

অপুষ্টি

B

অটিজম

C

নিরক্ষরতা

D

বেকারত্ব

Created: 4 weeks ago | Updated: 4 weeks ago Options Edit Question Add Description Add Bookmark Add Tag Add Video Error Report

A

i ও ii

B

i ও iii

C

ii ও iii

D

i, ii ও iii

Created: 3 weeks ago | Updated: 3 weeks ago Options Edit Question Add Description Add Bookmark Add Tag Add Video Error Report

A

ক. তাপের সমতা রক্ষা

B

খ. রোগ প্রতিরোধ করা

C

গ. বর্জ্য পদার্থ নিষ্কাশন

D

ঘ. কার্বন ডাইঅক্সাইড অপসারণ

Created: 1 week ago | Updated: 1 week ago Options Edit Question Add Description Add Bookmark Add Tag Add Video Error Report

A

Horizon A

B

Horizon B

C

Horizon C

D

Horizon D

User can remove any role from any user from any database in the system through _________

A

grantRole

B

viewRole

C

killCursors

D

revokeRole

User can grant any role in the database to any user from any database in the system through _________ action.

A

grantRole

B

viewRole

C

killCursors

D

unlock

Which of the following fixed database roles can add or remove user IDs?

Related Questions