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...
When invoking a method with an object argument, ___________ is passed.
a. the contents of the object b. a copy of the object c. the reference of the object d. the object is copied, then the reference of the copied object
Which of the following is a threat to privacy and is sometimes installed when you visit a website?
A. Windows Defender B. EFS C. Macro script D. Spyware
________ text is used in documents and web pages to provide a text description of an object, such as an image
Fill in the blank(s) with the appropriate word(s).
To display the navigation pane, click the ____________________ tab and click Navigation Pane from the Show group.
Fill in the blank(s) with the appropriate word(s).