Enter your keyword


SQL Interview Questions

What’s SQL SQL is an English like language consisting of commands to store, retrieve, maintain & regulate access to your database. What’s SQL*Plus SQL*Plus is an application that recognizes & executes SQL commands & specialized SQL*Plus commands that can customize reports, provide help & edit facility & maintain system variables. What’s JOIN JOIN is the […]

JAVA Interview Questions-1

1.What is a transient variable ? Ans: A transient variable is a variable which may not be either serialized or deserialized i.e neither saved nor restored during the process of serialization. if a variable is declared as transient in a Serializable class and the class is written to an ObjectStream, the value of the variable […]

JAVA Interview Questions-2

1.What is the use of static import? Ans:If you use static imports we can access static methods and static variables without the reference of class name. 2.Relation between List and LinkedList? Ans:List is an interface , LinkedList is a class which implements it 3. Why Set interface contains unique elements, what internally is Ans:implemented for […]


Definition Internet Protocol version 6 (IPv6) is the most recent version of the Internet Protocol (IP), the communications protocol that provides an identification and location system for computers on networks and routes traffic across the Internet. IPv6 was developed by the Internet Engineering Task Force (IETF) to deal with the long-anticipated problem of IPv4 address exhaustion. IPv6 is intended to replace IPv4. Commonly asked interview […]


Definition Subnetting is the strategy used to partition a single physical network into more than one smaller logical sub-networks (subnets). An IP address includes a network segment and a host segment. Subnets are designed by accepting bits from the IP address’s host part and using these bits to assign a number of smaller sub-networks inside […]


Definition UDP (User Datagram Protocol) is an alternative communications protocol to Transmission Control Protocol (TCP) used primarily for establishing low-latency and loss tolerating connections between applications on the Internet. Both UDP and TCP run on top of the Internet Protocol (IP) and are sometimes referred to as UDP/IP or TCP/IP. Both protocols send short packets […]


Definition MySQL is an open source relational database management system (RDBMS) based on Structured Query Language (SQL). MySQL runs on virtually all platforms, including Linux, UNIX, and Windows. Although it can be used in a wide range of applications, MySQL is most often associated with web-based applications and online publishing and is an important component […]

Database Design And Normalization

Definition Database normalization, or simply normalisation, is the process of organizing the columns (attributes) and tables (relations) of a relational database to minimize data redundancy. Normalization involves decomposing a table into less redundant (and smaller) tables without losing information, and then linking the data back together by defining foreign keys in the old table referencing […]


Definition A primary key, also called a primary keyword, is a key in a relational database that is unique for each record. It is a unique identifier, such as a driver license number, telephone number (including area code), or vehicle identification number (VIN). A relational database must always have one and only one primary key. […]


Definition According to the SQL Standard, a key is a subset of columns in a table that allow a row to be uniquely identified. So, a key can be more than just one column. And, every row in the table will have a unique value for the key – or a unique combination of values […]