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

  2. No

Answer: Answer is b
Further Reading:

In the SELECT statement, the FROM clause is required except when the select list contains only constants, variables, and arithmetic expressions (no column names). Useful resources, FROM

  1. No

  2. Yes

Answer: Answer is b

  1. productChanges = productInfo.GetChanges(DataRowState.Detached)

  2. productChanges = productInfo.GetChanges()

  3. productChanges.Merge(productInfo, true)

  4. productChanges.Merge(productInfo, false)

Answer: Answer is b
Further Reading:

Useful resources, DataSet.GetChanges Method

You are creating an ASP.NET application that will record each customer's entry. It is possible that thousands of entries could be posted at any given time. Your application will be hosted on twenty Web servers. As customers enter information into your application, maintaining state information will be important. This information should be stored securely and should be capable of being restored in the event that a Web server is restarted. Customers will enter data into three separate pages in your application.

  1. View State

  2. Hidden fields

  3. State Server

  4. Application state

  5. SQL Server

Answer: Answer is e
Further Reading:

Only the SQL Server data will remain save after restarting the server.

  1. select * from employee where department LIKE "[^F-M]%";
  2. Select * from employee where department = "[^F-M]%";

Select the correct option:

  1. Query 2 will return an error

  2. Both the queries will return the same set of records

  3. Query 2 is perfectly correct

  4. Query 2 would return one record less than Query 1

Answer: Answer is c

select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)

  1. In the sub query, '*' should be used instead of 'OrderID'

  2. The sub query can return more than one row, so, '=' should be replaced with 'in'

  3. The sub query should not be in parenthesis

  4. None of the above

Answer: Answer is b

  1. select * from orders where sum(amount) > 20000

  2. select * from orders where sum(amount) > 20000 order by OrderDate

  3. select * from orders group by OrderDate having sum(amount)>20000

  4. select * from orders group by OrderDate where sum(amount) > 20000

Answer: Answer is c
Further Reading:

Useful resources, HAVING clause

STD_ID                INT
COURSE_ID        VARCHAR (10) 

The aggregate functions valid on the START_DATE column are:

  1. SUM(start_date)

  2. AVG(start_date)

  3. COUNT(start_date)

  4. AVG(start_date, end_date)

  5. MIN(start_date)

Answer: Answer is c, e
Further Reading:

Useful resources, Use Aggregate Functions

  1. DataAdapter

  2. DataReader

  3. Command

  4. Connection

Answer: Answer is a

Marketing, Designing, production, Packing

What will be the result of the following query?

select * from table where department < 'marketing';
  1. The query will return "Designing, Packing"

  2. The query will return "Designing, production, Packing"

  3. The query will return "packing"

  4. Strings cannot be compared using < operator

  5. The query will return "Designing"

Answer: Answer is e


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.