Explore topic-wise InterviewSolutions in .

Yes. A column alias could be used in the ORDER BY clause.

Following are various DCL or Data Control Language commands in SQL −

• GRANT − it gives a privilege to user.

• REVOKE − it takes back privileges granted from user.

Following are various DML or Data Manipulation Language commands in SQL −

• SELECT − it retrieves certain records from one or more tables.

• INSERT − it creates a record.

• UPDATE − it modifies records.

• DELETE − it deletes records.

Following are various DDL or Data Definition Language commands in SQL −

• CREATE − it creates a new table, a view of a table, or other object in database.

• ALTER − it modifies an existing database object, such as a table.

• DROP − it deletes an entire table, a view of a table or other object in the database.

PL/SQL is a dialect of SQL that adds procedural features of programming languages in SQL. It was developed by Oracle Corporation in the early 90's to enhance the capabilities of SQL.

SQL or Structured Query Language is a language; language that communicates with a relational database thus providing ways of manipulating and creating databases. MySQL and Microsoft’s SQL Server both are relational database management systems that use SQL as their standard relational database language.