#2. Joe uses a Windows 95 computer and sometimes a UNIX computer to connect to SQL Server 7.0. You have created a login for Joe's NT user account and also a SQL Server login that has the same name and password as his NT username and password. If Joe uses a trusted connection to access the SQL server what are his effective permissions.
#3. Maria preceded you as administrator for Microsoft Windows NT Server and SQL Server. Maria created SQL Server logins and passwords matching users Windows NT accounts. When users logon to the Windows NT Server domain they obtain access to the SQL Server. Which permissions do users receive to access SQL Server by using a trusted connection?
#4. You are a member of fixed server role serveradmin. You create a job which backup up the database and then copies the backup file on a network drive. When you do the individual steps, they run okay. However, when executed as a job, it backs up the database but fails to copy to the network drive. Why?
#8. Three Users ANITA, CARMEN, PHILIPPE all have db_owner roles currently for the FINANCE database. You want PHILIPPE to continue to manage the Db as before, Anita to ONLY create users accounts and grant permissions for users, Carmen should be ONLY able to create tables, views, indexes and other objects, (choose 2)
#9. Arbor Shoes has 100 store. Their Pricing database resides on the corporate server. The pricing database server has limited space. The pricing database contains a price table. The price table has a high frequency of updates. The in-store checkout application requires an up-to-date local price table in order to ensure accurate pricing which type of SQL Server replication should you use to replicate the price table to the in-store computers?
#10. You company has five call centers that are located worldwide. These call centers manage the reservations for an airline. The reservation application has a customer table on the corporate server. The customer table is read locally and can be updated locally but the updates must maintain consistency across all five locations. Which type of SQL Server replication should you implement?
ген. 0.078
Форум
Главный бреиндамп