Home

Communicator
Tools
Profile Settings
Loading, please wait ...
Open its course - Database Systems Labs
Advanced DDL and DML By Mukhtiar Zamin
Summary

Summary

4
Teachers with
Mukhtiar Zamin 19
Followers
For Learning All
Visibility
Security Status 1
Contributions
By Teachers
Notes
  1. Students are auto-evaluated against related topics to ensure they learned it.

In this lab you will learn some advanced usage of few DDL and DML commands.

You will have to learn about the following in this lab: 

  • Insert 
  • Update 
  • Delete 
  • Adding comments on tables 
  • Create database 
  • Create tables 
  • Constraints 
  • Not null constraint 
  • Primary key 
  • Foreign key 
  • Alter table 
  • Drop statements 
  • Truncate table

Lab Tasks for All, By Mukhtiar Zamin

Create the table(s) for your semester project. 

  1. Use Insert command to add single and bulk records to the table. 
  2. Use UPDATE to update values for SINGLE and then multiple columns
  3. Use DELETE command to delete specific records from the table.
  4. Use TRUNCATE and DROP COMMANDS and describe the difference between both.
  5. Write examples from your semester project against each constraints below:
    1. NOT NULL 
    2. UNIQUE
    3. PRIMARY KEY
    4. FOREIGN KEY
    5. CHECK
    6. DEFAULT 
  6. Add one or more columns to a table
  7. Delete existing columns from a table
  8. Modify the data type for existing column 

×

Advanced DDL and DML Evaluation

To earn PASS status, system is about to evaluate you using multiple choice questions (MCQs) and True/False type questions.

  • CAREFULLY READ THE FOLLOWING INSTRUCTIONS!
  • Make sure you have learned this lecture along with its topics and tutorials.
  • On first evaluation you get 100% marks on correct answer, then on 2nd you get 95% marks and so on.
  • Answer the questions with a gap NOT MORE THAN A MINUTE, Otherwise it will re-start.

I have read above instrucitons and ready for evaluation.
Your's
Status
Not Registered
Teacher
Mukhtiar Zamin
TODO
Please ask your teacher to link related questions for this lecture.
Alert
Your performance monitoring will start when you register in a class of this course.

Topics
Advanced DDL and DML Lab Tasks

Questions on

No Linked topics!
About Us
Who we are Privacy Policy Terms of Use
Contact Us

support@subexpert.com
Write to Us View Help
Subject Expert Logo

Subject Expert

Learn, Evaluate and Optimize

Products / Utilites
Attendance Mapper Industry Liason Cell (ILC) Smart Secretary
Follow Us
Facebook Switch Display Mode Enable Translation
© 2024 - Subject Expert