• The best way of learning interview questions is to give it a shot.

    Here's the relevant syntax from Books Online (from the article on CREATE TABLE):

    [ CONSTRAINT constraint_name ]

    { { PRIMARY KEY | UNIQUE }

    [ CLUSTERED | NONCLUSTERED ]

    [

    WITH FILLFACTOR = fillfactor

    | WITH ( < index_option > [ , ...n ] )

    ]

    [ ON { partition_scheme_name ( partition_column_name )

    | filegroup | "default" } ]

    | [ FOREIGN KEY ]

    REFERENCES [ schema_name . ] referenced_table_name [ ( ref_column ) ]

    [ ON DELETE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ]

    [ ON UPDATE { NO ACTION | CASCADE | SET NULL | SET DEFAULT } ]

    [ NOT FOR REPLICATION ]

    | CHECK [ NOT FOR REPLICATION ] ( logical_expression )

    }

    Here's another fun question - what's the difference between a primary key and any other unique key, regardless of whether it's clustered or not?