Technology-News

 

Google said Friday it will cut 1,200 more jobs at its Motorola Mobility division, following the announcement of 4,000 layoffs in 2012.

The new job cuts represent 10% of the struggling mobile device maker's staff.

"These cuts are a continuation of the reductions we announced last summer," a Google spokeswoman said in a statement. "It's obviously very hard for the employees concerned, and we are committed to helping them through this difficult transition."
Google (GOOG, Fortune 500) has preached patience in its turnaround effort of Motorola. When the search giant completed its $12.5 billion purchase of Motorola in May 2012, it inherited a product pipeline of about 18 months. That means Google hasn't yet been able to release Motorola-branded smartphones of its own design.
Meanwhile, Motorola's mobile business continues to bleed red ink. It lost $353 million in the fourth quarter of 2012, and Google's Chief Financial Officer Patrick Pichette has said he expects Motorola's financial results will be volatile "for quite awhile."

Edith Ramirez tapped to lead FTC

(Jon Elswick / AP)

Hayley Tsukayama

Ramirez has served as an FTC commissioner since 2010.

A talking shoe in Google’s ‘Playground’

Emi Kolawole

SXSW 2013 | The company let attendees play with new technologies at their SXSW event space.

MakerBot introduces Digitizer

Emi Kolawole

SXSW 2013 | The company introduced a 3D scanner as part of its 3D maker “ecosystem.”

ISO: The future of TV

Vijay Ravindran

SXSW 2013 | The Post’s Vijay Ravindran chronicles his hunt for the future of television.

FTC charges people with sending millions of unwanted text messages

Hayley Tsukayama

The agency said the defendants sent over 180 million spam texts in total.

Ideas@Innovations

SXSW 201: Will it be objects over apps?

Emi Kolawole

Will this be the year when the maker movement trumps apps and makes its mark?

The fate of the modern ideas festival

Dominic Basulto

When it comes to today’s ideas festivals, it’s much like the film industry: there are indies and blockbusters.

SpaceX Dragon capsule rendezvous with ISS delayed

Emi Kolawole

At least two of the capsules thrusters are back online, but its scheduled berthing with the space station has been delayed.

Interview: Should your doctor be a robot?

Ezra Klein

An interview with Jonathan Cohn, author of a fascinating new story on whether IBM's Watson -- or its successor -- will eventually be your doctor.

Bill and Mark’s excellent coding adventure

Emi Kolawole

Bill Gates and Mark Zuckerberg, along with other big names in tech, call for more students to learn code.

 

 

The unlikely star of SXSW: Grumpy Cat

Forget Elon Musk or Al Gore. The biggest star of the South by Southwest Interactive festival is less than a year old, sleeps all day and looks like she just swallowed a hairball. FULL STORY

Beyond the DMZ: Tweeting from North Korea

"North Korean social media." In the famously restrictive country, where people have almost no Internet contact with the outside world, it sounds like an oxymoron. 

Google cuts another 1,200 Motorola jobs CNNMoney.com

Google said Friday it will cut 1,200 more jobs at its Motorola Mobility division, following the announcement of 4,000 layoffs in 2012.

What to watch for at South by Southwest

It's a spring break with a purpose: Ten days in Texas when the entertainment and tech worlds collide on the neo-bohemian streets of this Texas party town.

Bill Gates' classroom of the future CNNMoney.com

If you fast-forward a decade, classrooms and lessons might look a little different, according to Microsoft Chairman Bill Gates.

Pandora up 20%, CEO steps down CNNMoney.com

Pandora's stock soared after the company surprised Wall Street investors on Thursday with better-than-expected quarterly sales and an announcement that its CEO will be stepping down. 

Apple and Google's huge streaming music gamble 

If Apple and Google debut streaming music services, they won't be guaranteed success. The tech giants will be entering a field already saturated with dozens of players, and industry experts say not everyone will survive.

Gates, Zuckerberg: Kids, learn to code

Hey kids! Forget trying to become a doctor or rapper or a football star, not to mention all the teasing you may get in school for being a nerd -- computers are where it's at. 

Gates: More kids should learn to program

Microsoft Chairman Bill Gates talks about computer coding, working from home and the future of technology.

The biggest announcement Facebook didn't make CNNMoney.com

Facebook on Thursday unveiled a News Feed revamp that will make content more personalized and engaging. But the reason behind the redesign -- advertising -- barely got a mention. 

Facebook to announce new look for News Feed

Facebook is rolling out a fresh design for its central page, the News Feed, at an event Thursday. 

SXSW may have peaked, and that's not a bad thing

In South by Southwest Interactive, the tech-geek festival that begins here Friday, some see a five-day spring break of sorts: a chance to discover some buzzy new apps, catch a few panels and party alongside Web celebrities, futurists and many, many bloggers. 

Game for students aims to make Congress serious fun

These days, both violent video games and Congress have come under fire in the media and the court of public opinion, albeit for different reasons.

By John Gaudiosi, Special to CNN

Yahoo's Mayer gets $1.1 million bonus 

Yahoo CEO Marissa Mayer received a $1.12 million cash bonus for her half-year on the job in 2012 and restricted stock worth another $13.3 million, according to company filings.

Samsung buys stake in struggling Sharp  

Samsung agreed Wednesday to take an equity stake in embattled Japanese tech company Sharp, which has been under pressure to improve its financial position.

Charles Riley

Read More

internet marketing strategy

Customer Centricity

• User experience
• Customer experience management
• Voice of the customer

Channel Diversification

• Mobile app vs. mobile web
• Mobile as the ‘glue’ connecting channels
• Mobile commerce

Data

• Measuring the value of social media
• Social CRM
• Attribution management

Social Media

• Social for search engine optimization
• Social commerce
• Social media management

Content Strategy

• From bought media to earned media
• From impression to expression
• Enriched content: video, games, apps, metadata etc.

SOCIAL MEDIA

• 30% of Top Brands Have Dedicated Twitter Feeds for Customer Service
• What Brands Need to Know About Facebook's News Feed Redesign
• Facebook May Charge Users to Remove Ads, Patent Application Reveals

MOBILE MARKETING

• FTC Files Suits Against Mobile Marketers Accused of Sending Spammy Texts
• Marketers Push to Take Email Mobile
• YouTube App Update Suggests Paid Channels Are on the Way

INTERNET MARKETING

• YouTube to Launch Music Streaming Service, Take on Spotify
• Which Content Marketing Tactics Get the Best ROI?
• 5 Ways You Pay More for Google Clicks

Read More

dvd

Upcoming DVDs

 

Wreck-It Ralph on DVD
Released March 05, 2013
Wreck-It Ralph (John C. Reilly) longs to be as beloved as his game's perfect Good Guy, Fix-It Felix (Jack McBrayer). Problem is, nobody loves a Bad Guy. But…
read more....

The Master on DVD
Released March 05, 2013
Set in America in the years following World War II, a charismatic intellectual by the name of Lancaster Dodd (Philip Seymour Hoffman), who…
read more....

Red Dawn on DVD
Released March 05, 2013
When North Korea invades the United States, a group of young men and women from a small town arm themselves and flee into the wilderness. When they…
read more....

The Bay on DVD
Released March 05, 2013
The quaint seaside town of Chesapeake Bay thrives on water; it is the lifeblood of the community. When two biological researchers from France find a staggering…
read more....

Collaborator on DVD
Released March 05, 2013
Successful playwright Robert Longfellow (Martin Donovan) decides to return to his childhood home in the San Fernando Valley to visit his mother, Irene…
read more....

The Intouchables on DVD
Released March 05, 2013
When Driss, an ex-con from the projects, is hired to take care of an eccentric French aristocrat named Philippe, his newfound job quickly becomes an unpredictable…
read more....

Foreverland on DVD
Released March 05, 2013
A young man with cystic fibrosis is given the task of taking his friend's ashes to a shrine in Mexico. He is joined by his late friend's sister as they adventure down the…
read more....

The Twilight Saga: Breaking Dawn - Part 2 on DVD
Released March 02, 2013
Bella (Kristen Stewart) has given birth to a baby girl she names Renesmee, after her mother Renée, and Edward's…
read more....

 

17 Elaborate Revenge Schemes

Moviefone presents some of the most complex movie revenge plots to grace the big screen.

TV Shows Inspired by Movies

From Clueless to Indiana Jones, the title says it all.

Good Girls Gone Bad

HitFix offers up 16 actresses who shed their wholesome images on the big screen.

30 Greatest Rock & Roll Movie Moments

Rolling Stone boldly proclaims the rockin'-est moments in cinema.

63 Things To Look Forward To

AV Club lists their most anticipated entertainments of 2013, including movies, TV, and music.

Promos

Follow RT on Twitter!

Spice up your feed with hourly Tomatometer updates!

Read More

Social Brands

Speaking at Maketing's Social Brands conference in February, Silberbauer explained that the 'nervousness around the room when they see they need to communicate with customers' is palpable. 'But when they get 500 likes, that's when they realise what social media is all about.'

No department should lay claim to 'owning' social media, explains Danny Whatmough, director of digital strategies at technology PR agency EML, in our other social-media management feature this week.
Completely decentralising responsibility is not the answer because it could lead to inconsistencies, he warns. Instead, an approach whereby the social-media team sets the strategy, with implementation then left to the needs of different departments, is a model worth considering.

Last week, corporate reputation firm Portland launched a social-media crisis simulator to allow brands to 'stress test' their response strategy in case they ever found themselves at the centre of a social storm.
Corporate communications sits at the heart of Portland's simulator. However, the firm envisages situations involving the chief executive, business continuity teams, the legal department, operations and HR as core players in the social-media strategy.

Read More

Social media marketing

Social media marketing is all about creating relationships with your customers through a variety of online media channels. From Facebook to Twitter, blogs to video production, connecting with your customers on a more sociable level has become a driving-force behind the success of many companies currently flourishing online and we’re here to help!
Our team of internet marketing experts are dedicated to creating social media marketing campaigns that work for you and your business, whatever your goal.


Facebook Social Media Marketing Strategy   
Facebook fans want coupons and discounts.
Limit your updates to 90 characters.
Images on updates have the most shares.
Ask questions in your updates and engage.
Optimize posts to be seen on a mobile phone.


The experiment compared the cost and effectiveness of social-media marketing against pay-per-click
advertising over the span of one year. And the results? Social-media marketing cost the company
$3,600 — the salary ($10 an hour) for an employee to become a part of and market to social networks.
That investment drew 93,207 visitors to the site over the course of the year (which works
out to be just under $.04 per visitor).
The PPC application was a little faster. Instead of having to wait weeks or months to get involved
in a community, the PPC ads could be started almost immediately. The company spent $1,250 on
PPC ads over the course of the year, and those ads drew 2,057 visitors to the site for a total cost of
almost $.61 per visitor.
Social media had much more impact, and ultimately cost the company less money on a per-visit
basis. In fact, the social-media optimization yielded a 1,578 percent better return on investment
than the PPC ads did.
The value of social media is there. But so are the difficulties that you may face as you try to implement
a social-media optimization effort. For example, you can’t rush headlong into a new social network
and expect to be able to post your ads anywhere you want. That will get you banned from the community
fairly quickly. It will also create animosity between you and the very people you’re trying to
reach.


With LinkedIn, we are helping our clients increase the overall number of high value connections Our clients are connected with the most influential users on LinkedIn, which allows them to contact virtually any key decision maker.

Read More

All HTML Interview Questions And Answers

What is HTML?
Hyper Text Markup Language,which allows an individual special code to
create web pages to be viewed on the Internet.It’s the default markup language used for displaying web pages.

What is a DOCTYPE?
<!DOCTYPE> is used to inform the browser as to which version of HTML the current web page is using.
The doctype declaration refers to a Document Type Definition (DTD) which specifies the rules for the markup language,


What are meta tags and why it is used?
The <meta> tag always goes inside the head element. They can be used by browsers, search engines or other web services.


What is SPAN?
The SPAN having notation as:<SPAN> </SPAN>is used for highlighting text
of any color desired for adding colored text for adding background image to text.
 SPAN does not cause a line break.

 What is the format for commenting in a HTML document?
 <!-- comment here -->
 It must be noted that comments are not displayed in the browser and is visible only if we view the code.

 How can you make images clickable?
 image tag by the “a tag”.
 <a href=”http://test.com”>
 <img src=”http://test.com/some-image.jpg” alt=”some text” />
  </a>

what is Hyperlinks?
<a href="http://www.kumquat.com/archive.html">
Kumquat Archive</a>
The anchor (<a>) tag is the HTML/XHTML feature
for defining both the source and the destination of a hyperlink

What is <hr> Tag?
The <hr> tag tells the browser to insert a horizontal rule across the display window.

Read More

find the number of parameters passed into function in PHP?

func_num_args() function returns the number of parameters/arguments passed to a function in PHP.

Read More

difference between include and require?

Answer: It"s how they handle failures. If the file is not found by require(), it will cause a fatal error and halt the
execution of the script. If the file is not found by include(), a warning will be issued, but execution will
continue.

Read More

Use mysqldump to create a copy of the database?

mysqldump -h mysqlhost -u username -p mydatabasename > tgdbdump.sql

Read More

What is SERIAL data type in MySQL?

BIGINT NOT NULL PRIMARY KEY AUTO_INCREMENT

Read More

What’s the default port for MySQL Server?

3306

Read More

Conditional Functions mysql

The IF() Function

The IF() function provides a way to return a value based on a condition within a query.

The first argument is a condition that is evaluated for each row of the query. The value in the second is returned if the condition is trUE, and the third argument is returned if it is FALSE.

The following example is a very simple shipping rate calculator. If the product weight is less than 5 pounds, shipping costs $1.99; otherwise, it costs $2.99.

mysql> SELECT code, weight, IF(weight < 5, 1.99, 2.99)
    -> FROM products;
+------+--------+------------------------------+
| code | weight |    IF(weight <5, 1.99, 2.99) |
+------+--------+------------------------------+
| MINI |   1.50 |                         1.99 |
| MIDI |   4.50 |                         1.99 |
| MAXI |   8.00 |                         2.99 |
+------+--------+------------------------------+
3 rows in set (0.00 sec) 

The CASE Statement

The CASE statement is a multiple-valued conditional construct. Suppose you wanted to set three or more shipping rates based on weight. This would require a complex series of nested IF() functions.

The following example uses a CASE statement to determine the shipping rate based on three different weight bands:

mysql> SELECT code, weight,
    ->        CASE WHEN weight < 2 THEN 1.99
    ->             WHEN weight < 5 THEN 2.99
    ->             ELSE 4.99 END as shipping
    -> FROM products; 
+------+--------+----------+
| code | weight | shipping |
+------+--------+----------+
| MINI |   1.50 |     1.99 |
| MIDI |   4.50 |     2.99 |
| MAXI |   8.00 |     4.99 |
+------+--------+----------+
3 rows in set (0.00 sec)

Read More

Combined Queries-UNION

Mosy SQL queries contain just one SELECT statement that can return data from one table, or several tables using a join. The technique of combining two or more independent queries into a single data set is usually known as a union or a compound query.

You might want to use this technique to retrieve records from two tables that have a similar structure in a single query. For instance, suppose you have archived off some data so that you have a customers table that contains your current customers and another table called old_customers.

These tables would have the same structureor at least would share many common columns if new columns had been added to the customers table since the archive took place. Therefore, you could perform a query on this table that takes into account both current and archived customers. This would look something like the following:

SELECT name, telephone, email
FROM customers
UNION
SELECT name, telephone, email
FROM old_customers;

You can also use UNION to perform two different queries on the same table and combine the two results into a single data set.

mysql> SELECT first_name, last_name
    -> FROM customer_contacts
    -> WHERE customer_code = 'SCICORP'
    -> UNION
    -> SELECT first_name, last_name
    -> FROM customer_contacts
    -> WHERE customer_code = 'PRESINC';
+------------+-----------+
| first_name | last_name |
+------------+-----------+
| Albert     | Einstein  |
| Charles    | Darwin    |
| Marie      | Curie     |
| Benjamin   | Franklin  |
| Abraham    | Lincoln   |
| Richard    | Nixon     |
| Franklin   | Roosevelt |
| Theodore   | Roosevelt |
+------------+-----------+
8 rows in set (0.01 sec)

Read More

What is SQL Injection?

SQL Injection is the hacking technique which attempts to pass SQL commands (statements) through a web application for execution by the backend database.

it can be prevented by mysql_real_escape_string() function of PHP.

Such features as login pages, support and product request forms, feedback forms, search pages, shopping carts and the general delivery of dynamic content, shape modern websites and provide businesses with the means necessary to communicate with prospects and customers.

Read More

keep your session secure php

1. Use SSL when authenticating users or performing sensitive operations.
2. Regenerate the session id whenever the security level changes (such as logging in). You can even regenerate the session id every request if you wish.
3. Have sessions time out
4. Don't use register globals
5. Store authentication details on the server. That is, don't send details such as username in the cookie.
6. Check the $_SERVER['HTTP_USER_AGENT']. This adds a small barrier to session hijacking. You can also check the IP address. But this causes problems for users that have changing IP address due to load balancing on multiple internet connections etc (which is the case in our environment here).
7. Lock down access to the sessions on the file system or use custom session handling
8. For sensitive operations consider requiring logged in users to provide their authenication details again.

Read More

send images to mail box

<?php 

$message = "<html><head></head><body>";

$message .= "<img src='http://exp.com/images/logo.jpg' alt='' />

</body>

</html>";

$cleanedFrom="admin@abfdgd.com";
$headers = "From: $cleanedFrom";
$headers .= 'MIME-Version: 1.0' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";

$to="snmurty99@gmail.com"; 
$subject="sample images";

mail($to, $subject, $message, $headers);

?> 

Read More

Checking if a Host Is Alive

Use PEAR's Net_Ping package:

require 'Net/Ping.php';

$ping = new Net_Ping;
if ($ping->checkhost('www.oreilly.com')) {
    print 'Reachable';
} else {
    print 'Unreachable';
}

$data = $ping->ping('www.oreilly.com');

The ping program tries to send a message from your machine to another.

 If everything goes well, you get a series of statistics chronicling the transaction. An error means that ping can't reach the host for some reason.

On error, Net_Ping::checkhost( ) returns false, 

and Net_Ping::ping( ) returns the constant PING_HOST_NOT_FOUND. If there's a problem running the ping program (because Net_Ping is really just a wrapper for the program), PING_FAILED is returned.

Read More

Opening a Remote File

You want to open a file that's accessible to you via HTTP or FTP.

Pass the file's URL to fopen( ): 

$fh = fopen('http://www.example.com/robots.txt','r') or die($php_errormsg);

When fopen( ) is passed a filename that begins with http://, it retrieves the given page with an HTTP/1.0 GET request (although a Host: header is also passed along to deal with virtual hosts). Only the body of the reply can be accessed using the file handle, not the headers. Files can be read, not written, via HTTP.

When fopen( ) is passed a filename that begins with ftp://, it returns a pointer to the specified file, obtained via passive mode FTP. You can open files via FTP for either reading or writing, but not both.

To open URLs that require a username and a password with fopen( ), embed the authentication information in the URL like this: 

$fh = fopen('ftp://username:password@ftp.example.com/pub/Index','r'); 

$fh = fopen('http://username:password@www.example.com/robots.txt','r');

Opening remote files with fopen( ) is implemented via a PHP feature 
called the URL fopen wrapper. It's enabled by 
default but is disabled by setting allow_url_fopen to off in 
your php.ini or web server configuration file. If 
you can't open remote files with fopen( ), check your server 
configuration.  

Read More

Changing File Permissions by php

Use chmod( ) to change the permissions of a file: 

chmod('/home/user/secrets.txt',0400);

Use chown( ) to change a file's owner and chgrp( ) to change a file's group:

<?php 

chown('/tmp/myfile.txt','sklar');           // specify user by name
chgrp('/home/sklar/schedule.txt','soccer'); // specify group by name

chown('/tmp/myfile.txt',5001);              // specify user by uid
chgrp('/home/sklar/schedule.txt',102); 

 // specify group by gid

?> 

The permissions passed to chmod( ) must be specified as an octal number.

The superuser can change the permissions, owner, and group of any file. Other users are restricted. They can change only the permissions and group of files that they own, and can't change the owner at all. Nonsuperusers can also change only the group of a file to a group they belong to.

The functions chmod( ), chgrp( ), and chown( ) don't work on Windows.

Read More

XML file using the DOM API

//Use PHP's DOM XML extension. Here's how to read XML from a file:

$dom = domxml_open_file('books.xml');

//Here's how to read XML from a variable:

$dom = domxml_open_mem($books);

//You can also get just a single node. Here's how to get the root node:

$root = $dom->document_element( );

//Here's how to do a depth-first recursion to process all the nodes in a document:

function process_node($node) {
    if ($node->has_child_nodes( )) {
        foreach($node->child_nodes( ) as $n) {
            process_node($n);
        }
    }

    // process leaves
    if ($node->node_type( ) =  = XML_TEXT_NODE) {
        $content = rtrim($node->node_value( ));
        if (!empty($content)) {
            print "$content\n";
        }
    }

}
process_node($root);

The W3C's DOM provides a platform- and language-neutral method that specifies the structure and content of a document. Using the DOM, you can read an XML document into a tree of nodes and then maneuver through the tree to locate information about a particular element or elements that match your criteria. This is called tree-based parsing . In contrast, the non-DOM XML functions allow you to do event-based parsing.

Read More

convert time in php

<?php

     $thishour = time() + (4*60*60);

     $newTime = date("d m Y H:i:s",$thishour);

     echo $newTime;

   ?>);

Read More

what is ob_start?

ob_start turns on output buffering,

Read More

Scope Resolution Operator?

::  is the scope operator it is used to call methods of a class that has not been instantiated.

Read More

What is MVC?

MVC- Model, View, Controller - is simply
Model -  contains data access code and all of you business logic code.
View - Contains markup/design code, generally html,xml, json.
Controller -  contains very little code, just whatever is needed to call the Model code and render the View code.

Read More

What is SEO Writing?

Article Writing
press release writing
blog writing
web page writing
product description writing

Read More

eCommerce Tips

start SEO if you own an eCommerce store. eCommerce shopping is expected to rise
higher than ever before this holiday season.The series of algorithm updates from
Google staring very early this year has made everyone think if they should really focus on
SEO anymore.Social signals have huge importance because the links obtained in social media are mostly natural. Facebook and twitter are without doubt the best social networks available today and when Google says social media links are important for ranking, it is quite natural for everyone to start posting regular tweets and facebook wall updates to get social links.

Read More

How to big Your Online Marketing Technologies

For marketers looking to bust out of individual channel silos and reap the advantages of integrated marketing, this makes it even more critical to plan ahead for growth and change.
The first step is being able to understand the benefits of simplifying the chaos that is multichannel online marketing.
Integrating your online marketing tools can be difficult, but the benefits are sizeable. Done correctly, not only does it allow for a more efficient use of time and resources, but also offers the potential for deeper insights and greater returns on marketing investments.

Read More

Top Google SEO Tips Video Surpasses 5000 Views

The JM Internet Group (web: jm-seo.org), a leader in providing Google SEO tips for small business marketers, is proud to announce that their 'Quick Google SEO Tips Video' has surpassed 5000 views on YouTube. This video focuses on top SEO tricks and tips for Google; that is, the top ten easy SEO tips a small business owner or marketer can use to determine how to get to the top of Google. SEO, or Search Engine Optimization, is all about getting to the top of Google's no cost, organic listings. In this quick tutorial, Jason McDonald explains the ten most important SEO tips to begin to understand how search engine optimization works.
"Getting to the top of Google is a key marketing objective for most businesses and marketers," said Jason McDonald, Senior SEO director of the JM Internet Group. "We released this video in August, 2012, and are amazed at how many people have not only watched the SEO tips video but taken it to heart. The feedback has been impressive from small business owners and marketers across the USA, Canada, and the world."
To watch this informative small business video on Google SEO tips,
  
SEO Courses Begin April 9, 2013, with a focus on SEO Tips for Small Business
    Top Ten: Top Ten No Charge Tools for SEO / Search Engine Optimization

    Keywords: How to Generate Great Keywords for Great Google Rank

    Page Tags - Quick Boost - Use Page Tags to Improve your Google Rank

    Link Strategies: The Who, What, Where, When and How of Getting Good Links for SEO

    News: News You Can Use - Using News as an SEO Opportunity -

    Google Rank: Monitoring Your Google Rank, and Leveraging it for SEO and PPC

    Website Structure: Creating the Best Topology for Google Rank

Read More

Data Control Language (DCL) statements ?

• Data Control Language (DCL) statements  Allow you to change the permissions on database structures. There are two DCL statements:
  • GRANT  Allows you to give another user access to your database structures, such as tables.
  • REVOKE  Allows you to prevent another user from accessing to your database structures, such as tables.

Read More

Data Definition Language (DDL) statements?

• Data Definition Language (DDL) statements  Allow you to define the data structures, such as tables, that make up a database. There are five basic types of DDL statements:
  • CREATE  Allows you to create a database structure. For example, CREATE TABLE is used to create a table; another example is CREATE USER, which is used to create a database user.
  • ALTER  Allows you to modify a database structure. For example, ALTER TABLE is used to modify a table.
  • DROP  Allows you to remove a database structure. For example, DROP TABLE is used to remove a table.
  • RENAME  Allows you to change the name of a table.
  • TRUNCATE  Allows you to delete the entire contents of a table.

Read More