option
My Daypo

DB462

COMMENTS STADISTICS RECORDS
TAKE THE TEST
Title of test:
DB462

Description:
Test for Skill

Author:
Bar
(Other tests from this author)

Creation Date:
25/07/2019

Category:
Computers

Number of questions: 2
Share the Test:
Facebook
Twitter
Whatsapp
Share the Test:
Facebook
Twitter
Whatsapp
Last comments
No comments about this test.
Content:
You administer a database that has User A, B and C. * User A must be able to create new tables and stored procedures, * User B must be able to select, update, delete and insert data. * User C must be able to provide windows logins to the database To which role or roles should you add to UserB? Select all that apply db_accessadmin db_ddladmin db_datawriter db_datareader db_owner.
A network administrator creates a virtual machine from a template that has SQL Server installed. You need to ensure that you can create SQL Server databases on the new virtual machine. Which two actions should you perform to complete the server configuration? Each correct answer presents part of the solution. Execute the SP_ADDSERVER statement. Edit the Instance Names registry key Execute the SP_SERVER_DIAGNOSTICS statement. Execute the SP_DROPSERVER statement. Run setup.exe and specify the upgrade option.
Report abuse Terms of use
HOME
CREATE TEST
COMMENTS
STADISTICS
RECORDS
Author's Tests