Sgraphinfotech - Training Institutes in Bangalore

  http://www.sgraphinfotech.com/blog/oracle-sql-interview-questions-and-answers.html  Q1.) What is the difference between DML and DDL? Ans: DDL (Data Definition Language) is used mainly for defining the database schema. It consists of SQL statements which give an idea about the structure of the database. Some examples of DDL statements are: CREATE: Used to create new database objects ALTER: Used to alter characteristics of already existing database objects DROP: Used to remove database objects TRUNCATE: Used to remove all records including all spaces allocated to record from the table RENAME: Used to rename any database object DML (Data Manipulation Language) are responsible for managing and manipulating various data schemas or database objects. They cannot alter the characteristics of a database object unlike DDL statements. Most common examples are: SELECT: Used to retrieve data from the database INSERT: Used to insert new data/records into the database

Oracle SQL and PLSQL are easy to learn database management and programming language. Owing to the recent technological advancements the demand for Oracle SQL DBAs, PLSQL Developers and Oracle SQL Experts have soared. It has become a most sought after job profile by many technology enthusiasts and university students. However, it is not easy to master Oracle SQL. One must delve deep into the advanced concepts for clearly understanding the language effectively.   http://www.sgraphinfotech.com/oracle-plsql-training-institute-in-bangalore.html There are various ways in which one can learn Oracle SQL/PLSQL. From books to training institutes to online training portals. One can find a variety of choices to learn from given their preference and ability. Some of those are as follows: W3Schools The most popular and common web platform for learning and developing your SQL skills is W3Schools. Not only does it provide extensive guide in learning elementary SQL concepts