FeedBack Form

Your Name :
Your Email :
Your Location :
Your Message :
   
FeedBack

SQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
26. What is DDL?
  The Data Definition Language is used to create, remove and alter the structure of database objects. The DDL is used for table definition and can be classified into four categories :
  • Create table command
  • Alter table command
  • Truncate table command
  • Drop table command
  Posted by Aziz. (Jan 23, 2014)
 

Automatic commit occur when ddl statement execute. No rollback operation perform.

  Posted by Dhanu. (Dec 16, 2013)
 

DDL commands are used by Entittes.

Your Name Your Email-ID
Your Answer
 
27. What is DML?
  Data Manipulation Commands are used to query and manipulate existing database objects.Following are some DML commands :
  • Insert
  • Select
  • Update
  • Delete
Your Name Your Email-ID
Your Answer
 
28. What is DCL?
  Data Control Language is used to control the kind of a data access to the database and Transaction Control. The owner can allow other database users access to the database objects as per his/her direction.
  • Grant
  • Revoke are used for data access control
  • Commit
  • Rollback and
  • Save point are transaction control commands
Your Name Your Email-ID
Your Answer
 
29. What are the types of oracle file structure?
  Oracle file has two representations are :
  • Logical file structure and
  • The Physical file structure
Your Name Your Email-ID
Your Answer
 
30. What is the difference between formal and actual parameter?
  The parameters, which are used in implementation or definition of subprograms, are called formal parameters. The parameters, which are used in call of the subprograms, are called actual parameters.
Your Name Your Email-ID
Your Answer