Lot of Questions- Please give appropriate answer. I don't know answer of any question,but I want to have them.

[jey jain]

When designing a database table, how do you avoid missing column values for non-primary key columns?

* Use UNIQUE constraints
* Use PRIMARY KEY constraints
* Use DEFAULT and NOT NULL constraints
* Use FOREIGN KEY constraints
* Use SET constraints

Which of the following is the syntax for creating an Index?

* CREATE [UNIQUE] INDEX index_name OF tbl_name (index_columns)
* CREATE [UNIQUE] INDEX OF tbl_name (index_columns)
* CREATE [UNIQUE] INDEX ON tbl_name (index_columns)
* CREATE [UNIQUE] INDEX index_name ON tbl_name (index_columns)


Which of the following is not a valid character datatype in SQL Server?

* BLOB
* VARTEXT

Which of the following constraints can be used to enforce the uniqueness of rows in a table?

* DEFAULT and NOT NULL constraints
* FOREIGN KEY constraints
* PRIMARY KEY and UNIQUE constraints
* IDENTITY columns
* CHECK constraints


Which of the following are not date parts?

* quarter
* dayofweek
* dayofyear
* weekday

[Erland Sommarskog]

Looks like you are preparing for some type of MCP exam. The questions are
all very basic can be answered with a minimum knowledge about relational
database, or by looking them up in Books Online.

It would be pointless to give you the answer of these questions. The purpose
of these exams is that you by answering sufficiently many questions
correctly shows that you understand the product. Unfortunately, these exams
have a fairly small set of questions, and many people takes these exams by
getting braindumps and learning the answers to the specific questions by
heart without gaining any actual understanding at all.

Maybe by learning these answers, you may be able to pass a test that will
give you a job. But since you would not be able to function in that job, it
would only be bad both for you and your prospective employer.