Top 50 Interview Questions On SQL and PL/SQL. Today we will Discuss Top 50 interview questions and answers of SQL and PL/SQL which is frequently asked in interview. Question 1: What is SQL and Classification of SQL? Answer SQL is a Structure Query Language which is vastly used in RDBMS database like Oracle, Sybase, DB2 , Microsoft SQL server etc. Classification of SQL is as below: DDL (Data Definition Language): Commands are create , alter , drop , truncate etc DML (Data Manipulation Language) : Commands are insert,update and delete . TCL (Transaction Control Language ) : Commands are Commit , Rollback and Save point. DCL (Data Control Language) : Commands are Grant , Revoke Question 2: What is meant by Joins? What are the types of join? Answer Joins are basically used to extract/get data from multiple tables using some common columns or conditions and also by using alias to fulfill the condition. There are various types of Joins as li
Diksha Oracle Training Centre is a platform for IT Graduate as it provides both offline and online training to IT graduate to excel/his her carrier in IT industry.