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

ProductID
ProductName
CurrentStock
MinimumStock

Two possible queries are: (a)select * from products where currentStock > MinimumStock + 50

(b)select * from products where currentStock - 50 > MinimumStock

  1. (a) is correct

  2. (b) is correct

  3. (a) and (b) both are correct

  4. (a) and (b) both are incorrect

Answer: Answer is d

  1. if...else

  2. if exists

  3. do...while

  4. while

  5. begin...end

Answer: Answer is e

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

Which of the following Subqueries will execute without any error?

  1. SELECT distinct department_id FROM employees Where salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);

  2. SELECT distinct department_id 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 distinct department_id FROM employees Where salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);

  5. SELECT distinct department_id FROM employees Where salary < (SELECT AVG(salary) FROM employees GROUP BY department_id);

Answer: Answer is c, d

  1. CREATE [UNIQUE] INDEX index_name OF tbl_name (index_columns)

  2. CREATE [UNIQUE] INDEX OF tbl_name (index_columns)

  3. CREATE [UNIQUE] INDEX ON tbl_name (index_columns)

  4. CREATE [UNIQUE] INDEX index_name ON tbl_name (index_columns)

Answer: Answer is d
Further Reading:

Useful resources, SQL CREATE INDEX 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

  1. Begin a transaction

  2. Create a connection to the database

  3. Create a data set using an adapter object

  4. Use the data set to display data or to change items in the database

  5. Update the database from the data set

  6. Close the database connection

  7. Check for transaction errors

Answer: Answer is b, c, d, e, f

  1. Populate the data objects with data from the database. Populate the controls with values retrieved from the data objects.

  2. Populate the business objects with data from the database. Populate the controls with values retrieved from the business objects.

  3. Populate the data objects with data from the database. Populate the business objects with data from the data objects. Populate the controls with values retrieved from the business objects

  4. Bind the controls directly to the database.

Answer: Answer is c

  1. BLOB

  2. VARCHAR

  3. TEXT

  4. VARTEXT

Answer: Answer is d

  1. /* … */ are used for multiline comments

  2. // is used for single line comments

  3. – is used for single line comments

  4. Nested comments are allowed i.e. /* comment 1 /* comment 2 */ comment 1*/

  5. ‘ is used for single line comments

Answer: Answer is b, c, e

  1. Quarter

  2. dayofweek

  3. dayofyear

  4. weekday

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.

;