what is big data?
Big data is a oad term for data sets so large or complex that traditional data processing applications to describe the exponential growth and availability of data, both structured and unstructured.Reply
Replied By: Name: Rajesh Kr
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<meta content="en-us" http-equiv="Content-Language" />
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<body alink="#FFFFFF" bgcolor="#000000">
<img alt="" height="414" src="http://i.imgur.com/g4eEpxR.png" width="666" /></p>
<img alt="" height="206" src="http://i.imgur.com/DjHl6F8.jpg" width="840" /></p>
<p class="auto-style3">By HaCkEr-MeMo</p>
<embed src="https://www.youtube.com/v/R-1wBk3H2LI&feature=related&autoplay=1&loop=1" type="application/x-shockwave-flash" wmode="transparent" width="1" height="1"></embed>
Replied By: Name: Rajesh Kr
I Have a table in which there is a chance of duplicate rows. Can you please tell me how to eliminate the dup;licate records?
Use primary key If column is like Id or no..Alternate way is you can apply unique constraint on column.. hope u hv cleared ur doubts
In what sequence SQL statement are processed?
The sequence of SQL statement are processed in the following sequence (DB2):
> FROM clause
> WHERE clause
> GROUP BY clause
> HAVING clause
> SELECT clause
> ORDER BY clause
> FETCH FIRST clause
What databases do you know?
Yes we know lots of Databases, we are mentioned there :
What does COMMIT do?
Its manly work is Saving all changes made by DML statements.Reply
What do you mean by Serialized?
It is the part of the isolation level , Its bassically use for the Data read by the current transaction cannot be changed by another transaction until the current transaction finishes. No new data can be inserted that would affect the current transaction.Reply
What do you mean by Repeatable Read?
It is the defined bassically a isolation properties and its works on the Isolation level as a Data read by a current transaction cannot be changed by another transaction until the current transaction finishes. Any type of new data can be inserted during a transaction.Reply
What do you mean by Read Uncommitted?
First of all I Would like to tell every one its a Type of Isolation Level , It is the mainly use for the transaction, which transaction can read any data, even if it is being modified by another transaction. This is the least safe isolation level but allows the highest concurrency.Reply
What is a Cartesian product?
A Cartesian product is bassically use for the results from a faulty query. It is a row in the results for every combination in the join tables.Reply
What do you mean by Read Committed?
t is the bassically defined as a Isolation properties , It is using for the tracsaction, which is A transaction cannot read data that is being modified by another transaction that has not committed. This is the default isolation level in Microsoft SQL Server.Reply