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. logical

  2. arithmetical

  3. assignment

  4. unary

Answer: Answer is d
Further Reading:

Useful resources, Unary Operators


  1. between

  2. any

  3. some

  4. like

  5. with

Answer: Answer is e
Further Reading:

Useful resources, Logical Operators


The 'Having' clause can not be used when there is a 'Where' clause in the statement already

  1. True

  2. False

Answer: Answer is b

  1. Triggers are fired manually and Stored Procedures are fired automatically

  2. Triggers can call Stored Procedures but Stored Procedures cannot call Triggers

  3. Both Stored Procedures and Triggers can pass parameters

  4. None of These

Answer: Answer is b
Further Reading:

Useful resources, Stored Procedures and Triggers, Stored Procedure vs Trigger


You can send emails through the Database engine

  1. False

  2. True

Answer: Answer is b
Further Reading:

Useful resources, Database Mail


  1. Instance

  2. Cluster

  3. Metadata

  4. Schema

  5. None of the above

Answer: Answer is d
Further Reading:

Useful resources, Schemas


  1. A Foreign key is a column or a set of columns that uniquely identifies rows in a table

  2. A Foreign key checks the number of columns in a table which have non-null values

  3. A Foreign key is used to match columns in other tables

  4. A Foreign key checks the number of rows in a table which have non-null values

Answer: Answer is c
Further Reading:

A foreign key (FK) is a column or combination of columns that is used to establish and enforce a link between the data in two tables. You can create a foreign key by defining a FOREIGN KEY constraint when you create or modify a table. Useful resources, FOREIGN KEY


  1. real

  2. rowversion

  3. type_var

  4. sql_variant

  5. monetary

Answer: Answer is d
Further Reading:

Useful resources, sql_variant


empid                int(4)
deptname            varchar(50)
salary                int(4)

The following select query is executed on this table:

SELECT * FROM employees ORDER BY deptname DESC, salary DESC

What will be the output of the above query?

  1. The above SQL query will give an error

  2. Records will be shown with the salary field displayed in the descending order

  3. Records will be shown with the deptname field in the ascending order and salary in the descending order

  4. Records will be shown with the deptname field and the salary field in the descending order

  5. Records will be shown in a jumbled manner

Answer: Answer is d

  1. Select 'Customer id is' + customerid From Customer
  2. Select 'Customer id is' + CAST(customerid AS varchar) From Customer
  3. Select 'Customer id is' + CAST(customerid AS integer) From Customer
  4. Both a and b

  5. None of these

Answer: Answer is b

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.

;