march 17, 2015
Java: Check given string is a palindrome?
import java.util.Scanner; class ChkPalindrome{ public static void main(String args[]) { String str, rev = ""; Scanner sc = new Scanner(System.in); System.out.println("Enter a string:"); str = sc.next...
Q) What is database ACID property?
Acid Property of Database ACID (an acronym for Atomicity, Consistency Isolation, Durability) is a concept that Database Professionals generally look for when evaluating databases and application arch...
Q)- Difference between Stored Procedure and Function in SQL Server?
-- Stored Procedures are pre-compile objects which are compiled for first time and its compiled format is saved which executes (compiled code) whenever it is called. But Function is compiled and execu...
Q) Describe database keys.
Primary Key: 1-Primary key is a set of one or more fields/columns of a table that uniquely identify a record in database table. 2-It can't accept null, duplicate values. Only one Candidate Key can b...
Q) How could you manage MySQL from command prompt?
MySql start/ restart/ stop commands - On Linux start/stop/restart from the command line: sudo /etc/init.d/mysql start;sudo /etc/init.d/mysql stop;sudo /etc/init.d/mysql restart; Some ...
Describe Index in Database?
Index In Sql? An index is a data structure (most commonly a B- tree) that stores the values for a specific column in a table. An index is created on a column of a table. So, the key points to remember...
