ADV L1

What are Relation-based tables

• 1) To store relation between entities in tables
• 2) To store data in tables
• 3) To store entities in tables
• 4) To define table names

Answer explanation

DBMS allows entities and relations among them to form tables.

What does SQL stand for?

• 1) Structured Question Language
• 2) Standard Query Language
• 3) Structured Query Language
• 4) Simple Query Language

Answer explanation

SQL stands for Structured Query Language.

What is a candidate key?

• 1) A key that is not unique
• 2) A minimal super key
• 3) A foreign key
• 4) A super key with extra attributes

Answer explanation

A minimal super key is called a candidate key.

What is a composite key?

• 1) A simple key
• 2) A key with only one attribute
• 3) A key with multiple attributes
• 4) A foreign Key

Answer explanation

Composite Key - A key that consists of two or more attributes to uniquely identify a record.

What is a constraint in a database?

• 1) A table
• 2) A rule or restriction on data
• 3) A relationship
• 4) An attribute

Answer explanation

Constraints are restrictions placed on the data in order to ensure data integrity.

What is a database?

• 1) A collection of disorganized information
• 2) A structured collection of related data
• 3) A type of computer virus
• 4) A social media platform

Answer explanation

A database is a structured way to store and manage data.

What is a derived attribute?

• 1) That is stored in database
• 2) That is not Stored in Database
• 3) An Key attribute
• 4) A foreign Key

Answer explanation

Derived Attribute - Not stored in the database but calculated from other attributes.

What is a foreign key?

• 1) A primary key in another table
• 2) A key that is not important
• 3) A key used for sorting data
• 4) A key used for encryption

Answer explanation

A foreign key refers to a primary key in another table to establish relationships.

What is a many-to-many relationship?

• 1) One entity relates to one entity
• 2) One entity relates to many entities
• 3) Many entities relate to one entity
• 4) Many entities relate to many entities

Answer explanation

Many-to-Many Relationships (*:*) depict multiple entities having multiple relationships to multiple other entities.

What is a one-to-many relationship?

• 1) One entity relates to one entity
• 2) One entity relates to many entities
• 3) Many entities relate to one entity
• 4) Many entities relate to many entities

Answer explanation

One-to-Many Relationships (1:*) depict one entity having a relationship to multiple entities.