23-24 Database Systems Quiz

CLASS

• TY A
• TY B

Roll

Name

MOBILE

EMAIL

An attribute that is not part of any candidate key is known as

• A. sub-prime attribute
• B. non-prime attribute
• C. sub-candidate key
• D. non-candidate key

Which one is the type of Conceptual Data Model?

• A.Entity-Relationship diagram
• B.Relational Data Model
• C.Class diagram
• D.None of the above

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?

• DML(Data Manipulation Language)
• DDL(Data Definition Language)
• Query
• Relational Schema

What do you mean by one to many relationships?

• One class may have many teachers
• One teacher can have many classes
• Many classes may have many teachers
• Many teachers may have many classes

In SQL, which command is used to add new columns to a table?

• (A) ALTER TABLE
• (B) ADD ROW
• (C) INSERT
• (D) APPEND