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. Use UNIQUE constraints

  2. Use PRIMARY KEY constraints

  3. Use DEFAULT and NOT NULL constraints

  4. Use FOREIGN KEY constraints

  5. Use SET constraints

Answer: Answer is c

  1. Set conn = New connection ; With conn ; .Provider = "SqlOleDB" ; ConnectionString ="User ID=sa;"&& "Data Source= Neptune;"&& "Initial Catalog=ClassList"

  2. Set conn = New connection ; With conn ; .Provider = "Neptune" ; ConnectionString ="User ID=sa;"&& "Data Source= Neptune;"&& "Initial Catalog=ClassList"

  3. Set conn = New connection ; With conn ; .Provider = "SqlOleDB" ; ConnectionString ="User ID=sa;"&& "Data Source= Neptune;"

Answer: Answer is a

  1. Select * from students where marks > avg(marks);

  2. Select * from students order by marks where subject = 'SQL';

  3. Select * from students having subject ='SQL';

  4. Select name from students group by subject, name;

  5. Select group(*) from students;

  6. Select name,avg(marks) from students;

  7. g. None of the above

Answer: Answer is d

  1. MyAdapter.Fill(MyDataSet,"Customer")

  2. MyAdapter.Fill("MyDataSet",Customer).

  3. MyAdapter.Fill(MyDataSet)

  4. MyAdapter.Fill("MyDataSet")

Answer: Answer is a
Further Reading:

Useful resources, Populating a DataSet from a DataAdapter


  1. Commit

  2. Terminate

  3. Save

  4. Close

  5. Rollback

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

Useful resources, SqlTransaction Class


select (2/2/4) from tab1; where tab1 is a table with one row.

This would give a result of:

  1. 4

  2. 2

  3. 1

  4. 5

  5. 25

  6. 0

  7. 8

  8. 24

Answer: Answer is f

  1. 0

  2. NULL

  3. It will generate an error message

  4. Can't be determined

Answer: Answer is b

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

  1. +

  2. -

  3. /

  4. *

Answer: Answer is d
Further Reading:

Useful resources, Operator Precedence


SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC

SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC

What is true about them?

  1. The two statements produce identical results

  2. The second statement returns an error

  3. There is no need to specify DESC because the results are sorted in descending order by default

  4. None of the above

Answer: Answer is a

LAST_NAME  DEPTARTMENT_ID     SALARY
ALLEN                10                      3000
MILLER              20                     1500
King                   20                      2200
Davis                 30                      5000

Which of the following Subqueries work?

 

  1. SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);

  2. SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);

  3. SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);

  4. SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);

  5. SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

Answer: Answer is a

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.

;