Tag: technology

Factory Pattern

Abstract Factory Pattern

Builder Pattern

Prototype Pattern

Flyweight Pattern

Façade Pattern

Composite Pattern

Decorator Pattern

Adapter Pattern

Observer Pattern

Chain of Responsibility Pattern

Strategy Pattern

Visitor Pattern

Notifier Pattern

Observer Pattern

Template Pattern

The pattern that creates many instances of a single class in one shot

This pattern is to have only a single constructor to a class

Provides a class of which there can be no more than an instance, and provides a single global point of access to that instance

Creates and maintains a pool of objects, using which a single object can used and returned to the pool

Façade Pattern

Adapter Pattern

Bridge Pattern

Proxy Pattern

Having Clause

Where clause

Distinct

Exists

Work as primary key

Uniquely identify the records

show a relation between the primary key and unique key

All of the above

None of these

DML Trigger

Instead of Trigger

DDL Trigger

Nested Trigger

Change the primary key index to clustered and create a nonclustered index on the address

Create a nonclustered index on the address.

Create a clustered index on the address.

Change the primary key to the address and make the index clustered.