What is SQL? What are different types of query statements a user can write using SQL in Oracle9i?
What will be an ideal response?
SQL (also pronounced as ‘Sequel’) is an acronym for Structured Query Language,
which is a non-procedural query language to work with relational databases. It is
standardized by ANSI, but each relational database package has its own flavor
added to it.
There are five types of SQL statements:
Data Definition Language (DDL) – these statements are used to manipulate
entire table or its structure. For example, CREATE, ALTER, TRUNCATE,
RENAME and DROP.
Data Manipulation Language (DML) – these statements are used to add,
remove and update data in a table. For example, INSERT, DELETE and
UPDATE.
Data Retrieval – The SELECT statement is used to retrieve data from one or
more tables.
Transaction Control - COMMIT, ROLLBACK and SAVEPOINT statements
are used to manage and change DML transactions.
Data Control Language (DCL) – GRANT and REVOKE statements are used
for giving and removing object privileges.
You might also like to view...
Which of the following is not a floating point data type in C?
a. float b. double c. long d. long double e. none of the above
Supply chain management software
A. is typically under the control of external partners in the chain. B. links all of the partners in the chain, including vendors, carriers, third-party firms, and information systems providers. C. cannot be integrated into an overall ERP. D. none of the above