Why functions are used in sql?
What is a database event trigger?
what is meant by DML?
What is sql engine in oracle?
What are the sql versions?
What is the use of procedures?
What is left join in sql?
Is the primary key an index?
Is there a way to automate sql execution from the command-line, batch job or shell script?
Write a simple program on cursors
what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?
IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????
how to include comments in sql statements? : Sql dba