DBMS Quiz 2023

Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?

• 1. DML(Data Manipulation Language)

• 1. Query

• 1. Relational Schema

• 1. DDL(Data Definition Language)

Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?

• 1. DML(Data Manipulation Language)

• 1. DDL(Data Definition Language)

• 1. Query

• 1. Relational Schema

In E-R Diagram Ellipses represent?

• Relationship sets

• Attribute

• Derived attributes

• Multi-values attributes

What command is used to create a new table in SQL?

• Create table

• Build table

• Generate table

• None of the above

What does the following statement in SQL do?

• Deletes a table called student

• Creates a table called student

• Check if there is a table called student

• None of the above

Which of the following commands is used to delete all rows and free up space from a table?

• Truncate

• Drop

• Delete

• Alter