DBMS Module 1

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 the 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?

In the social media database scenario, how would you establish the relationship between the 'Users' and 'Posts' tables using foreign keys?

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

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

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

• D) 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?

• A) 5 unique values

• B) 100 unique values

• C) 50 unique values

• D) It depends on the number of records in the "Courses" table.

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?

• A)  Aggregation

• B)  Specialization

• C)  Generalization

• D)  Normalization

1.     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?

• A)  Primary Key

• B)  Candidate Key

• C)  Composite Key

• D)  Foreign Key

1.     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?

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

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

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

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

The type of data can be stored in the database is:

• A) Image oriented data
  

• B) Text, files containing data
  

• C) Data in the form of audio or video
  

• D) All of the above

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

• A) TCL (Transaction Control Language)
  

• B) DCL (Data Control Language)
  

• C) DDL (Data Definition Langauge)
  

• D) DML (Data Manipulation Langauge)

In a university database, student records are stored. Each student is assigned a unique student ID, and they also have a unique email address. However, email addresses can change over time.

What is the candidate key for the "Students" table in this scenario?

• A)  Student ID

• B)  Email Address

• C)  Both Student ID and Email Address

• D)  Neither Student ID nor Email Address

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

• A) TCL (Transaction Control Language)
  

• B) DCL (Data Control Language)
  

• C) DDL (Data Definition Langauge)
  

• D) DML (Data Manipulation Langauge)