>Concorsi
>Forum
>Bandi/G.U.
 
 
 
 
  Login |  Registrati 
Elenco in ordine alfabetico delle domande di 70-229: SQL Server 2000 database design and implementation

Seleziona l'iniziale:
A   B   C   D   E   F   G   H   I   J   K   L   M   N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

> Clicca qui per scaricare l'elenco completo delle domande di questo argomento in formato Word!


Easton Design Corporation is creating a web-based application collecting customer contact information. They need to create a view to return rows from the Customer table and the associated Address table. Which of the following are valid view creation scripts?
   CREATE VIEW CustomerInfo AS
Eddie needs to have a database that is replicated to other locations. They have highly redundant network connectivity to all of the other locations, and a very large central server. Changes to the database need to be made at every site, and need to be done instantaneously at every site, with no delay. Which type of replication would work best for Eddie?
   Transactional replication
Eric needs to build a stored procedure to count the number of snack food vendors within his zip code. Which of the following strategies would be the easiest to implement for passing and returning values?
   Pass the zip code in as a parameter; pass the number of vendors out as a return value.