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

  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

  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

  1. Functions and Parenthesis

  2. Multiplication, Division and Exponents

  3. Addition and Subtraction

  4. Logical Operations

Answer: Answer is a
Further Reading:

Useful resources, Operator Precedence (Transact-SQL)

  1. Character

  2. Binary

  3. Logical

  4. Date

  5. Numeric

  6. All are supported

Answer: Answer is c
Further Reading:

Useful resources, Data Types

  1. IN
  2. NOT
  3. AND
  4. OR
  1. 1,2,3,4

  2. 2,3,4,1

  3. 1,2,4,3

  4. 1,4,3,2

  5. 4,3,2,1

  6. 4,1,2,3

  7. 4,2,1,3

  8. 3,2,1,4

Answer: Answer is b
Further Reading:

Useful resources, Operator Precedence

  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.

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


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.