Groups > comp.databases.ms-sqlserver > #889

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

From	jey jain <jain.jayesh1260@yahoo.in>
Subject	Lot of Questions- Please give appropriate answer. I don't know answer of any question,but I want to have them.
Newsgroups	comp.databases.ms-sqlserver
Message-ID	<2011123111511usenet@terrranews.com> (permalink)
Organization	http://www.AltBinaries.com - Uncensored, Un-logged, Secure.
Date	2011-12-31 06:15 +0000

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Lot of Questions- Please give appropriate answer. I don't know answer of any question,but I want to have them. jey jain <jain.jayesh1260@yahoo.in> - 2011-12-31 06:15 +0000
  Re: Lot of Questions- Please give appropriate answer. I don't know answer of any question,but I want to have them. Erland Sommarskog <esquel@sommarskog.se> - 2011-12-31 11:24 +0100

csiph-web