>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!

- If table_a has an insert trigger that performs an update on table_b, in which case will the update trigger on table_b be fired?
   If the 'nested triggers' server option is set to '1'.
- If the logic within a trigger determines that the data change would be undesirable, what actions are available to the trigger to prevent the action from occurring?
   Use ROLLBACK TRANSACTION to undo the data change.
- If you want to trace all of the exact commands that are being sent to SQL Server from a particular connection, which event category would you use?
   TSQL
- In building several new objects in a SQL Server 2000 database, you develop and submit the following script: CREATE TABLE table1 ( id bigint identity (45, 17), field01 varchar(300) unique, field02 char(300), field03 char(300), field04 char(300), field05 char(300), field06 char(300), field07 char(300), field08 char(300), field09 char(300), field10 char(300) ) CREATE TABLE table2 ( id int, fk varchar(300) foreign key references table1(field01), tally int ) What elements in this script would you expect to raise errors?   There is no evidence the script should encounter problems.
- In building several new objects in a SQL Server 2000 database, you develop and submit the following script:

CREATE TABLE table1 ( id bigint identity (45, 17), field01 varchar(300) unique, field02 char(300), field03 char(300), field04 char(300), field05 char(300), field06 char(300), field07 char(300), field08 char(300), field09 char(300), field10 char(300) ) CREATE TABLE table2 ( id int, fk varchar(300) foreign key references table1(field01), tally int )

What elements in this script would you expect to raise errors?   There is no evidence the script should encounter problems.

- In order for her new application to process a sales record, Kim has to make sure that the application has collected enough information. For sales over $500, she needs to have a valid account manager's ID number. For sales over $1000, she needs to have a valid zip code for delivery to determine who gets commission. For sales over $10,000, she needs to make sure that enough stock is available. Which of the following would be a good way to check the data prior to inserting it?
   A multi-statement table-valued function
- In the SET portion of an UPDATE statement, where may the new value for a column come from?

Select all that apply.   Another table by way of a single-column sub-query or table join in the FROM clause
- In the SET portion of an UPDATE statement, where may the new value for a column come from?

Select all that apply.   An arithmetic expression or constant value
- In the SET portion of an UPDATE statement, where may the new value for a column come from?

Select all that apply.   Another column within the table itself
- In the SET portion of an UPDATE statement, where may the new value for a column come from?

Select all that apply.   An explicit NULL value may be specified.
- In what circumstance is denormalizing a data model appropriate?

Choose 2.   Only after fully normalizing the database
- In what circumstance is denormalizing a data model appropriate?

Choose 2.   If performance is slow because of excessive joins
- In your database you have an Address table for storing the addresses of your customers. You need to ensure that the zip code field contains exactly 5 digits. Which of the following will work to accomplish your goal?
   Use a CHECK constraint.
- Insensitive cursors provider what functionality?
   They ensure an unchanging view of the data as it was when the cursor was opened.