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 ASP.NET with SQL Server

  1. Document-centric workflows

  2. Human workflows

  3. User-interface page flows

  4. Builtin support for communications across multiple applications and/or platforms

Answer: Answer is a, b, c
Further Reading:

Useful resources, Windows Workflow Foundation


  1. Create table Pers
  2. (EmpNo Int not null,
  3. EName Char not null, 
  4. Join_dt Datetime not null,
  5. Pay Int)

Which line contains an error?

  1. 1

  2. 2

  3. 3

  4. 4

  5. 5

  6. None

Answer: Answer is f
Further Reading:

Useful resources, creating a table


Employee

---------

Empno

Employeename

Salary

Deptno

Department

---------

Deptno

Departname

  1. Select departname from department where deptno in (select deptnofrom employee group by deptno having count(*) > 100);

  2. Select departname from department where deptno in (select count(*)from employee group by deptno where count(*) > 100);

  3. Select departname from department where count(deptno) > 100;

  4. Select departname from department where deptno in (select count(*)from employee where count(*) > 100);

Answer: Answer is a
Further Reading:

Other option (except a) will not execute due to error in the statement. Useful resources, SQL basic queries, query fundamental, HAVING Clause, COUNT, SQL IN


  1. Between..and..

  2. Like

  3. In

  4. Is null

  5. Having

  6. Not in

  7. All of the above are valid

Answer: Answer is g
Further Reading:

Useful resources, SQL Operators, Operator Precedence


SELECT name     

FROM Student     

WHERE name LIKE '_a%';

Which names will be displayed?

  1. Names starting with "a"

  2. Names containing "a" as the second letter

  3. Names starting with "a" or "A"

  4. Names containing "a" as any letter except the first

Answer: Answer is b
Further Reading:

Useful resources, LIKE operator


SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000

Which of the following statements is correct with regard to this code?

  1. It returns employees whose salary is 50% more than $23,000

  2. It returns employees who have 50% commission rate or salary greater than $23,000

  3. It returns employees whose salary is 50% less than $23,000

  4. None of the above

Answer: Answer is b
Further Reading:

Useful resources, SQL basic queries, query fundamental


  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. Select
  2. order by
  3. where
  4. having
  5. group by
  1. 1,2,3,4,5

  2. 1,3,5,4,2

  3. 1,3,5,2,4

  4. 1,3,2,5,4

  5. 1,3,2,4,5

  6. 1,5,2,3,4

  7. 1,4,2,3,5

  8. 1,4,3,2,5

Answer: Answer is b
Further Reading:

The order should be like this select>where>group by>having>order by. Useful resources, SQL basic queries, query fundamental, HAVING Clause


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. SELECT * FROM Persons WHERE LastName > 'Hansen', LastName < 'Pettersen'

  2. SELECT LastName > 'Hansen' AND LastName < 'Pettersen' FROM Persons

  3. SELECT * FROM customers WHERE LastName > 'Hansen' AND LastName > 'Pettersen'

  4. SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'

Answer: Answer is d
Further Reading:

Useful resources, BETWEEN


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.

;