Sunday, 5 August 2018
Wednesday, 22 November 2017
Sunday, 13 August 2017
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
Saturday, 12 August 2017
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
|
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
|
Friday, 30 June 2017
Java interview questions on programming
1. Write a program to print even no.
2. Write a program to print odd no.
3. Write a program for infinite "for" loop.
4. Write a program to print the numbers from 1-10
5. Write a program to print the numbers from 10-1.
6. Write a program to find the Factorial of a number.
7. Write a program to check whether a given number is
Prime or not.
8. Write a program to reverse a given String using
toCharArray().
9. Write a program to reverse a given String using
charAt().
10. Write a program to reverse a sentence.
11. Write a program to Reverse a number.
12. Write a
program to check whether a given String is palindrome or not.
13. Write a
program to swap 2 numbers using 3rd
variable.
14. Write a
program to swap 2 numbers without using 3rd variable.
15. Write a program to swap 2 Strings.
16. Write a program to swap 2 Strings without using 3rd
String.
17. Write a program to convert
decimal to binary.
18. Write a program to convert
binary to decimal.
19. Write a program to check a
given number consists of only 1’s and 0’s.
(or) Write a program to print binary number or not.
20. Write a program to check given number is Hexa-Decimal
or not.
21. Write a program to check given number is Arm-Strong
number or not.
22. Write a program to find Sum of cubes of each digit in
given number.
23. Write a program to find the given number is Strong
number or not. (Strong numbers are the numbers whose sum of factorial of digits
is equal to the original number. )
24. Write a program to find the sum of the factorial of digits
of given number. (Find the factorial of each number and calculate the sum of
those numbers)
25. Write a program to find the sum of digits of a given
number.
26. Write a program to count how many vowels are present
in given String.
27. Write a program to print 1-20 without using for loop.
28. Write a program to print A-Z.
29. Write a program to find the factorial of given number
without using for loop.
Sunday, 25 June 2017
Subscribe to:
Posts (Atom)