none
MCAD free online test RRS feed

  • Question

  • 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
    Thursday, July 13, 2006 8:56 AM

Answers

  • 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
    ---
    Thursday, July 13, 2006 2:32 PM
    Moderator

All replies

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

    Thanks
    Thursday, July 13, 2006 9:23 AM
  • 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

    Thursday, July 13, 2006 9:59 AM
  • 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
    ---

    Thursday, July 13, 2006 2:12 PM
    Moderator
  • 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
    Thursday, July 13, 2006 2:28 PM
  • 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
    ---
    Thursday, July 13, 2006 2:32 PM
    Moderator
  • Sorry, I did not care the 'customized' meaning.
    Sorry again,
    Thanks,
    Mert
    Thursday, July 13, 2006 2:35 PM