MCAD free online test

Hi everyone,
I am searching for free online MCAD exam test.
I could only find ucertify online free test.
If you know any link about this, would you please inform me ?

Thanks

and also I am searching for 70-229 exam online test.

Thanks

|||

Hi, I encounter a question which make me confused.

You are a database developer for an insurance company. The insurance company has a multi-tier application that is used to enter data about its policies and the owners of the policies. The policyowner information is stored in a table named Owners. The script that was used to create this table
is shown below:
CREATE TABLE Owners
(
OwnerID int IDENTITY (1, 1) NOT NULL,
FirstName char(20) NULL,
LastName char(30) NULL,
BirthDate date NULL,
CONSTRAINT PK_Owners PRIMARY KEY (Owner ID)
)
When information about policy owners is entered, the owner’s birth date is not included; the database needs
to produce a customized error message that can be displayed by the data entry application. You need to
design a way for the database to validate that the birth date is supplied and to produce the error message if
it is not. What should you do?
A. Add a CHECK constraint on the BirthDate column.
B. Create a rule, and bind the rule to the BirthDate column.
C. Alter the Owners table so that the BirthDate column does not allow null.
D. Create a trigger on the Owners table that validates the BirthDate column
Answer:D

So I think that the answer ccan also be 'C', is not it ?

Would you please explain this to me ?

Thanks

|||

The key sentence is :

"the database needs to produce a customized error message that can be displayed by the data entry application."

You won′t get a customized error message (Because you won′t be able to create one) if you set the column no to allow NULL values.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

Hi,
While inserting a record to the table, since we modified the BirtDate not to allow null, does not it also create an error ?

Thanks

|||Sure but it will only create Error Number 515, you won′t be able to customize that message. In a trigger you can catch the error and throw a custom one with raiserror.

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

Sorry, I did not care the 'customized' meaning.
Sorry again,
Thanks,
Mert

Maximum connections for SQL 2000 Developer Edition

I can't seem to find this info online anywhere. What's
the maximum connections for SQL 2000 Developer Edition?
We have a server running several instances of Developer
edition so does they have the share these connections or
is it a max connections per instance?
Thanks,
Van
Hi
Technically 32 737 per instance, but you will run out of TCP ports long
before a multi-instance installation can max out.
Developer Edition is Enterprise Edition with licensing limitations.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Van Jones" <anonymous@.discussions.microsoft.com> wrote in message
news:129201c55266$1fbd2b00$a601280a@.phx.gbl...
>I can't seem to find this info online anywhere. What's
> the maximum connections for SQL 2000 Developer Edition?
> We have a server running several instances of Developer
> edition so does they have the share these connections or
> is it a max connections per instance?
> Thanks,
> Van