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

  2. dayofweek

  3. dayofyear

  4. weekday

Answer: Answer is a

  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


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.

;