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