Skip to main content

Posts

Showing posts with the label Interview Questions on SQL and PL/SQL

Frequent Interview Questions on SQL and PL/SQL #DOTC_Mdb

                       Frequent Interview Questions on SQL and PL/SQL Today we will discuss Frequent interview questions and answers of SQL and PL/SQL which is mostly asked in interview if you are looking for job in IT industry as Database Developer. This Blog is important for freshers as well as experience candidates who is preparing for interview in IT company as Database SQL and PL/SQL developer. Let's start with Interview Questions and Answers .  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:    W