|
|
Authorized user can see question and answers.
Please log in or sign up. 
|
#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.
Show comments for this question (0)
Add comments
Link to this question
|
|
#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?
Show comments for this question (0)
Add comments
Link to this question
|
|
#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?
Show comments for this question (0)
Add comments
Link to this question
|
|
#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)
Show comments for this question (0)
Add comments
Link to this question
|
|
#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?
Show comments for this question (0)
Add comments
Link to this question
|
|
#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?
Show comments for this question (0)
Add comments
Link to this question
|
|
|
|
 gen. 0.132
|
Server date 07:27 22-11-2008
|
Developed by Zip © 2006
|
|
|
|
|
Forum
Master braindump