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

  2. Database name

  3. LIMIT clause

  4. WHERE clause

  5. Column Names

Answer: Answer is a

  1. CHANGE TABLE

  2. MODIFY TABLE

  3. ALTER TABLE

  4. UPDATE TABLE

Answer: Answer is c

  1. SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC

  2. SELECT * FROM Persons SORT REVERSE ‘FirstName’

  3. SELECT * FROM Persons ORDER BY ‘FirstName’

  4. SELECT * FROM Persons ORDER BY FirstName DESC

  5. SELECT * FROM Persons ORDER BY DESC FirstName

Answer: Answer is d

  1. Dec 31, 9999

  2. Jun 6, 2079

  3. Jan 1, 2753

  4. Jan 1, 2100

Answer: Answer is a

  1. desc myTable

  2. desc table myTable

  3. sp_columns myTable

  4. None of the above

  5. Using either option a or c

Answer: Answer is c

  1. Loss of data from employee sabotage

  2. Loss of data from any one corrupted table

  3. Recursive joins

  4. One-to-many or many-to-many relationships between columns in a table

  5. Data redundancy

Answer: Answer is d

  1. @@colcount

  2. @@error

  3. @@rowcount

  4. @@version

  5. All are valid global variables

Answer: Answer is e
Further Reading:

Useful resources, Global Variables in SQL Server


  1. BINARY

  2. VARBINARY

  3. BIT

  4. IMAGE

  5. TESTAMP

Answer: Answer is e

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.

;