Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

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

Back to article view | Back to comp.databases.ms-sqlserver

Contents

  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

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

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

[toc] | [next] | [standalone]

#890

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.

[toc] | [prev] | [standalone]

Back to top | Article view | comp.databases.ms-sqlserver

csiph-web