News:

SQL Table To C# Entity Model ConverterEntity Model (Class Properties) to SQL Table ConverterIf you encounter any trouble visiting our site, please contact us.

Online Test MS SQL Server 2005

  1. 1GB

  2. 2GB

  3. 4GB

Answer: Answer is b
Further Reading:

Useful resources,xml (Transact-SQL)


The plus (+) and minus (-) operators cannot be used to perform increment/decrement operations on datetime and smalldatetime values.

  1. True

  2. False

Answer: Answer is b
Further Reading:

Useful resources, Datetime arithmetic in SQL


  1. A view has a data of its own

  2. Data can be inserted into the table using its own view

  3. Data can be updated in the table using its own view

  4. A table can be altered by altering its corresponding view

  5. A View is derived from another table

Answer: Answer is a, d

  1. sp_helptext salary

  2. sp_define salary

  3. sp_help salary

  4. define salary

Answer: Answer is c
Further Reading:

Useful resources, sp_help


Many-to-One is a type of relationship in RDBMS.

  1. False

  2. True

Answer: Answer is a

Select (salary+40^2*30/5) from employees

  1. +

  2. *

  3. /

  4. ^

Answer: Answer is b
Further Reading:

Useful resources, Operator Precedence (Transact-SQL)


Students
- - - - - -
Name                Hobbies

John                Driving
Miller                Fishing
David               Writing
Robert              Singing

What will be the output of the following query?
Select Substring(Hobbies,3) From students Where name= "john"

  1. Dri

  2. ivi

  3. iving

  4. ving

  5. It will give an error

Answer: Answer is e

  1. Join

  2. Group By

  3. Order By

  4. Union All

  5. Where

Answer: Answer is d

The "text" and "ntext" data type can store character based data. These data types can be used in joins.

  1. True

  2. False

Answer: Answer is b
Further Reading:

Useful resources,ntext, text, and image (Transact-SQL)


  1. Tuples

  2. Elements

  3. Objects

  4. Attributes

  5. Constraints

Answer: Answer is d

Advertisement

BCS Preparation now even more easy. ReadBD is the place where you can find all kind of resources to be successful in BCS,Bank,Islami Bank exam and interview.

Looking for job. Try JobLoader- First ever job search engine in Bangladesh. All open bd jobs now a single mouse click away.

;