Questions on Database Concepts and Standards
A. Database concepts
1
Basic SQL Command:
SQL commands which are worth knowing :
TRIM
(for stripping spaces)
LEFT
(for fetching the data from left side of string)
RIGHT
(for fetching the data from right side of string)
REPLACE (for replacement in string)
CONVERT (for converting data from one type to another)
LEN
(for fetching length of string)
STUFF (way to insert one string into another)
DIFFERENCE (diff between two strings return 4 represents no diff or strong similarity)
2
What is normalization and why do we need denormalization ?
3
What are indexes in database ?
4
What is difference between clustered index and nonclustered index ?
5
Should a condition be used in where clause or “having by” clause ?
6
What is CASCADE in SQL?
7
What is the use of DEFAULT?
8
Two tables Employee(ID, name, Dept ID) and Department(ID,Name). Print all the departments with the number of employees in it.
9
Write a query to get the employee with second highest salary
B. Java Questions
1
Java 7 have some issue with code optimization. Prior to java 7, optimizers were not enabled by default but now with this release they have been enabled by default.
Although optimization issues occur when looping is for more than 10,000 iterations.
2
Write a program to test if given string is a palidrome
3
Write a program to print the given statement in the reverse order of words. (Part2: try the same without using any library function)
4
What is SIngleton?
5
Differentiate Inheritence and Composition
6
Write a program to test if two given strings are anagrams
7
Program to replace all spaces with %20 in a given string
8
a) Write a program to find duplicate elements in a given array and print them. b) Write a program to find unique elements in a given array and print them.
9
What is Runtime Polymorphism
10
C. Testing
1
Difference between
1
Basic SQL Command:
SQL commands which are worth knowing :
TRIM
(for stripping spaces)
LEFT
(for fetching the data from left side of string)
RIGHT
(for fetching the data from right side of string)
REPLACE (for replacement in string)
CONVERT (for converting data from one type to another)
LEN
(for fetching length of string)
STUFF (way to insert one string into another)
DIFFERENCE (diff between two strings return 4 represents no diff or strong similarity)
2
What is normalization and why do we need denormalization ?
3
What are indexes in database ?
4
What is difference between clustered index and nonclustered index ?
5
Should a condition be used in where clause or “having by” clause ?
6
What is CASCADE in SQL?
7
What is the use of DEFAULT?
8
Two tables Employee(ID, name, Dept ID) and Department(ID,Name). Print all the departments with the number of employees in it.
9
Write a query to get the employee with second highest salary
B. Java Questions
1
Java 7 have some issue with code optimization. Prior to java 7, optimizers were not enabled by default but now with this release they have been enabled by default.
Although optimization issues occur when looping is for more than 10,000 iterations.
2
Write a program to test if given string is a palidrome
3
Write a program to print the given statement in the reverse order of words. (Part2: try the same without using any library function)
4
What is SIngleton?
5
Differentiate Inheritence and Composition
6
Write a program to test if two given strings are anagrams
7
Program to replace all spaces with %20 in a given string
8
a) Write a program to find duplicate elements in a given array and print them. b) Write a program to find unique elements in a given array and print them.
9
What is Runtime Polymorphism
10
C. Testing
1
Difference between
References: RESTful Services and SOAP : http://geeknizer.com/restvssoapusinghttpchoosingtherightwebserviceprotocol/ http://spf13.com/post/soapvsrest