|
INTERVIEW QUESTIONS
ORACLE
SQL PLUS
DETAILS
Question: What are the types of SQL Statement ?
Answer: Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.Data Manipulation Language: INSERT,UPDATE,DELETE,LOCK TABLE,EXPLAIN PLAN & SELECT.Transactional Control: COMMIT & ROLLBACKSession Control: ALTERSESSION & SET ROLESystem Control : ALTER SYSTEM.
|
|
|
Category |
SQL Plus Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 8789 users |
Added on |
10/27/2009 |
Views |
68213 |
Rate it! |
|
|
Question:
What are the types of SQL Statement ?
Answer:
Data Definition Language : CREATE,ALTER,DROP,TRUNCATE,REVOKE,NO AUDIT & COMMIT.Data Manipulation Language: INSERT,UPDATE,DELETE,LOCK TABLE,EXPLAIN PLAN & SELECT.Transactional Control: COMMIT & ROLLBACKSession Control: ALTERSESSION & SET ROLESystem Control : ALTER SYSTEM. Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
What is a transaction ?
|
View Answer
|
|
What is difference between TRUNCATE & DELETE ?
|
View Answer
|
|
What is a join ? Explain the different types of joins ?
|
View Answer
|
|
What is the Subquery ?
|
View Answer
|
|
What is correlated sub-query ?
|
View Answer
|
|
Explain Connect by Prior ?
|
View Answer
|
|
Difference between SUBSTR and INSTR ?
|
View Answer
|
|
Explain UNION,MINUS,UNION ALL, INTERSECT ?
|
View Answer
|
|
What is ROWID ?
|
View Answer
|
|
What is the fastest way of accessing a row in a table ?
|
View Answer
|
|
What is an Integrity Constraint ?
|
View Answer
|
|
What is Referential Integrity ?
|
View Answer
|
|
What are the usage of SAVEPOINTS ?
|
View Answer
|
|
What is ON DELETE CASCADE ?
|
View Answer
|
|
What are the data types allowed in a table ?
|
View Answer
|
|
What is difference between CHAR and VARCHAR2 ? What is the maximum SIZE allowed for each type ?
|
View Answer
|
|
How many LONG columns are allowed in a table ? Is it possible to use LONG columns in WHERE clause or ORDER BY ?
|
View Answer
|
|
What are the pre requisites ?
|
View Answer
|
|
Where the integrity constraints are stored in Data Dictionary ?
|
View Answer
|
|
How will you a activate/deactivate integrity constraints ?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All SQL Plus Interview Questions & Answers - Exam Mode /
Learning Mode
|