Scribd
Upload
2 views1 page

Class Xic1 Rdbms Assignment

The document contains a series of SQL commands related to database management for a database named 'XIC'. It includes commands to create, access, list, display the current database, and delete the database. Each command is followed by its corresponding output or expected result.

Uploaded by

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

Class Xic1 Rdbms Assignment

The document contains a series of SQL commands related to database management for a database named 'XIC'. It includes commands to create, access, list, display the current database, and delete the database. Each command is followed by its corresponding output or expected result.

Uploaded by

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

CLASS XIC RDBMS ASSIGNMENT

ASSIGNMENT-1
Q.1 WRITE A SQL COMMAND TO CREATE A DATABASE “XIC”.

Ans: - CREATE DATABASE XIC;

Q.2 WRITE A SQL COMMAND TO ACCESS/OPEN THE DATABASE “XIC”.

Ans- USE XIC;

OUTPUT: Database changed

Q.3 WRITE A SQL COMMAND TO SHOW THE LIST OF ALL DATABASES IN YOUR COMPUTER.

ANS : SHOW DATABASES;

OUTPUT:

XIC

Q.4 WRITE A SQL COMMAND TO DISPLAY THE NAME OF CURRENT DATABASE.

ANS: SELECT DATABASE ();

OUTPUT:

XIC

Q.5 WRITE A SQL COMMAND TO DELETE THE DATABASE XIC;

ANS: DROP DATABASE XIC;

You might also like