DBMS QUIZZ

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

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

• 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

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

• 100 unique values

• 50 unique values

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

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

1.  Identify the minimum number of tables required for the following ER diagram in relational model-

• 3

• 2

• 1

• 4

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?

• Primary Key

• Composite Key

• Candidate Key

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

• 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

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

• Image oriented data

• Text, files containing data

• Data in the form of audio or video

• All of the above

The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system.

• Data and the DBMS

• Application and SQL

• Database application and the database

• The user and the software

The primary purpose of creating a VIEW in DBMS is:

 

• To provide a physical copy of the data for backup purposes.

• To simplify complex queries and hide underlying table structures.

• To optimize data storage and reduce database size.

• To enforce referential integrity constraints among tables.