2C DBMS Theory Quiz 1

A company is experiencing rapid growth, and they need to store customer information, product data, and sales transactions efficiently. Which system would be more suitable, a database system or a file system?

• Database System

• File System

• Both are equally suitable

• It depends on specific requirements

You are developing a database for a social media platform. You have tables for 'Users' and 'Posts.' Each post is created by a user, and a user can have multiple posts. How would you implement this relationship using foreign keys?

• Create a foreign key in the 'Users' table referencing 'Posts'

• Create a foreign key in the 'Posts' table referencing 'Users'

• Create a separate table for 'UserPosts' with foreign keys referencing 'Users' and 'Posts'

• No need for foreign keys in this scenario

Consider a database table "Students" with the following attributes:

Student_ID (Primary Key), Student_Name, Course_ID (Foreign Key)

 

If there are 100 records in the "Students" table, and each student is enrolled in one of the five available courses, how many unique values can the "Course_ID" column have?

• 5 unique records

• 100 unique records

• 1 unique record

• 500 unique records

A car rental company manages its fleet of vehicles in a database. The vehicles can be categorized as cars, trucks, and vans. Each category has specific attributes, such as maximum cargo capacity for trucks. Which DBMS concept is most appropriate for modeling this scenario?

• Aggregation

• Specialization

• Generalization

• Normalization

Identify the minimum number of tables required for the following ER diagram in relational model:

• 3

• 2

• 5

• 4

You are designing a database for an e-commerce platform. Each customer has a unique email address, and you want to ensure that this email address is used as a unique identifier for customer accounts.

Which key should you use?

• Primary Key

• Candidate Key

• Partial Key

• Foreign Key

A University wants to model its student information system. Students have a unique ID, name, date of birth, and email address. Students are also enrolled in courses, and each course has a name and a unique course code.

What entities and relationships are involved?

• Entity: Student; Relationship: Enrolls In; Entity: Course

• Entity: University; Relationship: Manages; Entity: Student

• Entity: Student; Relationship: Attends; Entity: University

• Entity: Course; Relationship: Teaches; Entity: Professor

A small local library wants to keep track of its book inventory. They have a limited budget and don't require complex querying capabilities. Which system would be more cost-effective, a database system or a file system?

• Database System

• File System

• Both are equally cost-effective

• It depends on the library's future growth

The ability to query data, as well as insert, delete, and update tuples, is offered by ____________.

• TCL (Transaction Control Language)

• DCL (Data Control Language)

• DDL (Data Definition Language)

• DML (Data Manipulation Language)

You are designing an ER diagram for a university database. There are two main entities: "Student" and "Course." Students can enroll in multiple courses, and each course can have multiple students.

What type of relationship exists between Student and Course?

• Many-to-Many relationship.

• One-to-Many relationship.

• Many-to-One relationship.

• One-to-One relationship.