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 SQL

  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


  1. 1

  2. 2

  3. 3

  4. 4

  5. 5

  6. 6

  7. None of the above

Answer: Answer is g
Further Reading:

Useful resources, Maximum Capacity Specifications 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

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.

;