1) What is the commonly fixed database role of a db_datawriter?
a) Add, change or delete data from all the tables
b) Assign statement and object permissions
c) Backup and restore databases
d) Read data from any table
2) ). How would you add a country field to your database to ensure that your Argentinean subsidiary does business only with other Argentinean companies?
a) CHECK constraint
b) PRIMARY KEY constraint
c) FOREIGN KEY constraint
d) DEFAULT constraint
3) You want to set up replication between two databases, so the financial data and the sales data will be the same. You want the data to replicate at 1:00 a.m. every morning. You would like to completely remove all data from the financial database each night and overwrite data from the sales database. Which database replication model would you choose?
a) Transactional replication
b) DTC replication
c) Subscriber replication
d) Snap shot replication
e) Merge replication
4) You start SQL-Server with the -f option. Unfortunately now you can't establish a connection to your SQL-Server. What should you do?
a) Edit regsitry
b) Restore registry from backup
c) Rebuild master database
d) Reinstall SQL -Server
e) Run regrebuld.exe
5). You define full-text indexing on the ProductName column in the Products table. You then execute a full-text query on the column. You specify a word that you know is present in the column, but the result set is empty. What is the most likely cause?
a) The Microsoft Service is not running
b) The SQL ServerAgent Service is not running
c) The catalog is not populated
d) You did not create a unique SQL Server index on the ProductName column
6) Exchange and SQL 7.0 are running on the same server. You notice the performance in exchange is degraded. The Min server memory, Maximum server memory and set working area are set as they were automatically in the installation. What do you do to free memory for exchange?
a) Increase Min server memory
b) Set working area to 0
c) Set working area to 1
d) Increase memory allocated to the procedure cache option
e) Reduce Min server memory
7) What functions are performed by the SQL Server Agents?
(Choose all that apply)
a) Notification
b) Job execution
c) User security managment
d) Replication management
e) Alert management.
8) The SQL server that Michael manages crashed. The disk drives were not damaged but there was data that had not been written to some databases. Which transactions will be rolled forward in each database when his SQL server starts the automatic recovery process?
a) All committed transactions that are in the transaction log between the last checkpoint and the failure
b) All committed transactions that are in the transaction log
c) All committed transactions that are in the transaction log between the last two checkpoints
d) All uncommitted transactions that are in the transaction log