Scribd
Upload
8 views4 pages

Database Systems: Dawood University of Engineering and Technology

Uploaded by

syedanshah06
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
8 views4 pages

Database Systems: Dawood University of Engineering and Technology

Uploaded by

syedanshah06
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Dawood University of Engineering and Technology

Database systems
lab:04(task)

30-may-2024

LAJPAT RAI | BSCS-21f-11


DBS
Ma’am Poonam k.k
Roll no: 21F-BSCS-11 Lab: 04(task)
Name: Lajpat rai
Questions:

Solution:
• Create a new table with at least two columns. Select one of the keys to
be the primary key and set it to auto-increment.

• Insert three records. Display them.

Dawood University of Engineering & Technology Karachi 2


Roll no: 21F-BSCS-11 Lab: 04(task)
Name: Lajpat rai
• DELETE records from the table.

• Insert three more records. Display them.

• TRUNCATE the table.

Dawood University of Engineering & Technology Karachi 3


Roll no: 21F-BSCS-11 Lab: 04(task)
Name: Lajpat rai
• Insert three more records. Display them.

• Remove auto-increment from the table.

Dawood University of Engineering & Technology Karachi 4

You might also like