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.

Path	csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!post01.iad.highwinds-media.com!newsfe14.iad.POSTED!95f1e2f4!not-for-mail
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)
Lines	39
X-Complaints-To	abuse@AltBinaries.com
NNTP-Posting-Date	Sat, 31 Dec 2011 06:15:31 UTC
Organization	http://www.AltBinaries.com - Uncensored, Un-logged, Secure.
Date	Sat, 31 Dec 2011 06:15:31 GMT
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:889

Show key headers only | 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