CHANGE CONSTRAINTS

CHANGE CONSTRAINTS USING ALTER COMMAND:

CREATE TABLE PRODUCT1

(

PID NUMBER(4),

PNAME VARCHAR(5),

QTY NUMBER(3),

DESCP VARCHAR(30),

CONSTRAINT PRODUCT1_PK PRIMARY KEY(PID),

CONSTRAINT PRODUCT1_UNIQUE UNIQUE(PNAME),

)

SYSNTAX TO DROP CONSTRAINT:

ALTER TABLE TABLE_NAME

DROP CONSTRAINTS CONSTRAINTS_NAME;

EX:

ALTER TABLE PRODUCT1

DROP CONSTRAINTS PRODUCT1_PK

SYSNTAX TO ADD CONSTRAINT:

ALTER TABLE TABLE_NAME

ADD CONSTRAINTS CONSTRAINTS_NAME(COLUMN_NAME);

EX:

ALTER TABLE PRODUCT1

ADD CONSTRAINT PRODUCT1_PK PRIMARY KEY(PID);

SYSNTAX TO ENABLE CONSTRAINT:

ALTER TABLE TABLE_NAME

ENABLE CONSTRAINTS CONSTRAINTS_NAME;

EX:

ALTER TABLE PRODUCT1

ENABLE CONSTRAINTS PRODUCT1_PK

SYNTAX TO DISABLE CONSTRAINT:

ALTER TABLE TABLE_NAME

DISABLE CONSTRAINTS CONSTRAINTS_NAME;

EX:

ALTER TABLE PRODUCT1

DISABLE CONSTRAINTS PRODUCT1_PK

Difference between Functional and Nonfunctional Testing

Functional Testing:

Functional Testing

Functional testing is performed using the functional specification provided by the client and verifies the system against the functional requirements.

Functional testing is executed first

Manual testing or automation tools can be used for functional testing

Business requirements are the inputs to functional testing

Functional testing describes what the product does

Easy to do manual testing

Types of Functional testing are Unit Testing Smoke Testing Sanity Testing Integration Testing White box testing Black Box testing User Acceptance testing Regression Testing

Non-Functional Testing

Non-Functional testing  checks the  Performance, reliability, scalability and other non-functional aspects of the software system.

Non functional testing should be performed after functional testing

Using tools will be effective for this testing

Performance parameters like speed , scalability are inputs to non-functional testing.

Nonfunctional testing describes how good the product works

Tough to do manual testing

Types of Non functional testing are Performance Testing Load Testing Volume Testing Stress Testing Security Testing Installation Testing Penetration Testing Compatibility Testing Migration Testing