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)It calculates the results of the group functions of each group

2)It groups those rows together based on the group by clause

3)It orders the groups based on the results of the group functions in the order by clause

4)It chooses and eliminates groups based on the having clause

5)It chooses rows based on the where clause

Arrange the above steps in the correct order of execution:

  1. 4,3,5,1,2

  2. 4,5,3,2,1

  3. 5,2,1,4,3

  4. 5,2,3,4,1

  5. 2,3,1,4,5

  6. 2,3,1,5,4

  7. 1,2,3,4,5

  8. 3,2,1,4,5

Answer: Answer is c

  1. CONCAT()

  2. SUBSTR()

  3. UPPER()

  4. LOWER()

  5. REPLACE()

Answer: Answer is c
Further Reading:

Useful resources, CONCAT, SUBSTR, UPPER, LOWER, REPLACE


  1. Query Parser

  2. The Database Manager

  3. Query Optimization

  4. Database Administrator

Answer: Answer is a

  1. Select * from A.Sales join B.Sales

  2. Select * from A.Sales union all B.Sales

  3. Select * from A.Sales, B.Sales

  4. None of the above

Answer: Answer is b

  1. Group of users

  2. Group of indexes

  3. Method of storing tables that are intimately related and often joined together into the same area of the disk

  4. Compressed datafile

  5. Segment of a partitioned table

  6. Group of constraints

  7. Group of databases

  8. Group of roles/p>

Answer: Answer is c
Further Reading:

Useful resources, cluster


  1. Methods to resolve integrated domain names (IDNs), such domain names are special embedded names

  2. Methods to swap bytes between network byte order and host byte order

  3. Methods to convert internationalized domain names (IDNs) between a normal Unicode representation and an ASCII Compatible Encoding (ACE) representation

  4. This class does not exist

  5. None of the above

Answer: Answer is c
Further Reading:

Useful resources,Class IDN


  1. File

  2. DataOutput

  3. Directory

  4. FileDescriptor

  5. FileOutputStream

Answer: Answer is c
Further Reading:

Useful resources, Directory Class


  1. With DDL, you can create and remove tables, schemas, domains, indexes and views.

  2. SELECT, INSERT and UPDATE are DCL commands.

  3. GRANT and REVOKE are DML commands.

  4. COMMIT and ROLLBACK are DCL commands.

Answer: Answer is a

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. It checks the allocation of all the objects in the specified database.

  2. It checks the structural integrity of all the objects in the specified database.

  3. It checks for consistency in and between system tables in the specified database.

  4. It checks the consistency of disk space allocation structures of a specified database.

Answer: Answer is a, b, d
Further Reading:

DBCC CHECKALLOC - Checks the consistency of disk space allocation structures for a specified database.

DBCC CHECKTABLE- Checks the integrity of all the pages and structures that make up the table or indexed view.

DBCC CHECKCATALOG-Checks for catalog consistency within the specified database. The database must be online.

Useful resources,DBCC CHECKDB, DBCC CHECKDB


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.

;