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 2000

  1. True

  2. False

Answer: Answer is b
Further Reading:

Useful resources, Logical Operators


  1. Avg

  2. Select

  3. Order By

  4. Sum

  5. Union

  6. Group by

  7. Having

Answer: Answer is a, d
Further Reading:

Useful resources, Aggregate Functions


  1. Purchased before November 11, 2002
  2. Price is less than $500 or greater than $900

You want to sort the result by the date of purchase, starting with the most recently bought book.

Which of the following statements should you use?

  1. SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '11/11/2002' ORDER BY purchase_date;

  2. SELECT book_title FROM books WHERE price IN (500, 900) AND purchase_date< '11/11/2002' ORDER BY purchase date ASC;

  3. SELECT book_title FROM books WHERE price < 500 OR>900 AND purchase_date DESC;

  4. SELECT Book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '11/11/2002' ORDER BY purchase date DESC

Answer: Answer is d
Further Reading:

Useful resources, WHERE Clause


  1. BINARY

  2. VARBINARY

  3. BIT

  4. IMAGE

  5. TESTAMP

Answer: Answer is e

select (age + 3 * 4 / 2 - 8) from emp
  1. +

  2. -

  3. /

  4. *

Answer: Answer is d
Further Reading:

Useful resources, Operator Precedence (Transact-SQL)


A column that allows NULLs requires more space to store a value

  1. True

  2. False

Answer: Answer is b

SELECT getdate()
  1. It will print the current date

  2. It will generate an 'Undefined Function' error message

  3. It will generate an 'Incorrect Syntax' error message because you cannot write a function name after SELECT

Answer: Answer is a
Further Reading:

Useful resources, GETDATE


  1. A select clause

  2. A where clause

  3. A from clause

  4. A group by clause

  5. A having clause

  6. An order by clause

Answer: Answer is a, c
Further Reading:

Useful resources, SQL Queries


SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales WHERE e.employee_id = s.emp_id;

What will happen if all the parentheses are removed from the calculation?

  1. The value displayed in the CALC_VALUE column will be lower

  2. The value displayed in the CALC_VALUE column will be higher

  3. There will be no difference in the value displayed in the CALC_VALUE column

  4. An error will be reported

Answer: Answer is d
Further Reading:

But if we use “SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id” then result will be displayed. Notice that s is missing after sales in the original query. Useful resources, SQL basic queries, query fundamental, Using Table Aliases


  1. if...else

  2. if exists

  3. do...while

  4. while

  5. begin...end

Answer: Answer is e

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.

;