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.

Mcq Answers for SQL Server

  1. DataAdapter

  2. DataReader

  3. Command

  4. Connection

Answer: Answer is a

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


  1. 0

  2. NULL

  3. It will generate an error message

  4. Can't be determined

Answer: Answer is b

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

  1. A primary key should be created for the customer_id field in the customer table and also for the customer_id field in the order table.

  2. A primary key should be created for the order_id field in the customer table and also for the customer_id field in the order table

  3. A primary key should be created for the customer_id field in the customer table and a foreign key should be created for the customer_id field in the order table

  4. A primary key should be created for the customer_id field in the customer table and a foreign key should be created for the order_id field in the order table

  5. None of these  

Answer: Answer is c

  1. DataRow

  2. DataSet

  3. DataTable

  4. DataReader

Answer: Answer is d

  1. UPDATE Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'

  2. UPDATE Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen'

  3. SAVE Persons SET LastName = 'Nilsen' WHERE LastName = 'Hansen'

  4. SAVE Persons SET LastName = 'Hansen' INTO LastName = 'Nilsen'

Answer: Answer is a
Further Reading:

Useful resources, SQL UPDATE Statement


  1. Use Microsoft SQL Server indexes to optimize the data calculations

  2. Implement the calculations in a business layer class

  3. Implement the calculations in a data layer class

  4. Use Microsoft SQL Server stored procedures for the data calculations

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.

;