Answer / swapnareddy

Type of sql statments are:
DDL:Data Defintion Language:create,alter,drop,truncate & rename
DML:Data Manipulation Language:insert,update,delete & merge
DRL/DQL:Data retrive/query Language:select
DCL:Data Contol Language:grant,revoke
DTL:Data Transition Language:commit,savepoint & rollback

Answer / sam kolta

SQL statements are classified into 6 categories:
1. Data Definition Language (DDL) Statements are:
- ALTER
- ANALYZE
- ASSOCIATE STATISTICS
- AUDIT
- COMMENT
- CREATE
- DISASSOCIATE STATISTICS
- DROP
- FLASHBACK
- GRANT
- NOAUDIT
- PURGE
- RENAME
- REVOKE
- TRUNCATE
- UNDROP
2. Data Manipulation Language (DML) statements are:
- CALL
- DELETE
- EXPLAIN PLAN
- INSERT
- LOCK TABLE
- MERGE
- SELECT
- UPDATE
3. Transaction Control Language (TCL) statements are:
- COMMIT
- ROLLBACK
- SAVEPOINT
- SET TRANSACTION
4. Session Control Language (SSCL) statements are:
- ALTER SESSION
- SET ROLE
5. System Control Language (SCL) Statements are:
- ALTER SYSTEM

6. EMBEDED SQL STATEMENTS

Answer / anil_abbireddy

DDL :data definition language
DML :data manuplation language
DCL :data control language
TCL :transaction control language
SCL :session control language

how can we optimize or increase the speed of a mysql select query? : Sql dba

0 Answers  

---

give the syntax of grant and revoke commands? : Sql dba

0 Answers  

---

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

0 Answers  

---

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---

What is the maximum number of triggers,can apply to a single table?

2 Answers  

---

---

Why function is used in sql?

0 Answers  

---

How to select 10 records from a table?

0 Answers  

---

What are the topics in pl sql?

0 Answers  

---

Why stored procedure is better than query?

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

What does “select count(*) from tab” result?

15 Answers   IBM, Student, Wipro,

---

Is natural join and inner join same?

0 Answers  

---