DDL & DML commands
Date: Sep 2014
Level: Basic


INTERVIEW QUESTIONS

Question Title: DDL & DML commands
QUESTION DETAILS:

Write test cases for the following commands:
1. DDL command
2. DML command


Following are some of the test cases for the two commands:

For create command (DDL):
-whether the table and/or database is created or not.
-whether all the columns are created with specified type or not.
-whether create command returned any error message.
-whether any constraint is violated or not.

For insert command (DML):
-whether the insert command hasn't returned any error message.
-whether it retains all the constraints.
-whether command does not violates the unique,primary and foreign key constraints.
All Questions