FeedBack Form

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

SQL INTERVIEW QUESTION & ANSWERS

Databases
Follow Us
 
TAGS
11. What are the four transactional control commands?
 
  • COMMIT
  • ROLLBACK
  • SAVEPOINT
  • SET TRANSACTIONS
Your Name Your Email-ID
Your Answer
 
12. What are the differences between a DDL statement and a DML statement?
  DDL statements are used to create, modify, and delete database objects such as tables, views, schemas, domains, triggers, and stored procedures.
DML statements are used to view, add, modify, or delete data stored in the database objects.
Your Name Your Email-ID
Your Answer
 
13. What is a schema?
  A schema is a set of related objects that are collected under a common namespace. The schema acts as a container for those objects, which in turn store the SQL data or perform other data–related functions.
Your Name Your Email-ID
Your Answer
 
14. What is embedded SQL?
  Embedded SQL refers to SQL statements that are interspersed in some type of application programming language. The SQL statements are blended into the host language to allow the source program to be able to access and modify SQL data and the underlying database structure.
Your Name Your Email-ID
Your Answer
 
15. What are the data types available in SQL?
 
  • STRING
  • CHAR
  • CHAR (n)
  • VARCHAR2
  • VARCHAR
  • Int
  • NUMBER
  Posted by Sudarshan. (Oct 20, 2013)
 

Date
Your Name Your Email-ID
Your Answer