dbms quiz

An organization wants to ensure data integrity and enforce strict data security measures.

Which system would be more appropriate, a database system or a file system?

•   Database System

•   File System

• Both are equally appropriate

• It depends on the organization's size

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

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.

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

• TCL (Transaction Control Language)
  
  

• DCL (Data Control Language)
  
  

• DDL (Data Definition Langauge)
  
  

• DML (Data Manipulation Langauge)

5.  An e-commerce platform wants to store information about products, including both physical goods and digital downloads. Physical goods have attributes like weight and dimensions, while digital downloads have attributes like file size and format. Which database design approach should be used in this case?

• Aggregation

• Specialization

• Generalization

• Indexing

Find the minimum number of tables required to represent the given ER diagram in relational model-

• 5

• 6

• 3

• 4

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?

• Student ID

• Email Address

• Both Student ID and Email Address

• Neither Student ID nor Email Address

. In a university database, you have a table that stores information about courses. Each course has a unique course code, and there are no other attributes that can uniquely identify courses. What type of key should you use for the course code?

•   Super key

• Candidate Key

• Primary Key

• Foreign Key

A library needs to keep track of its books, authors, and borrowing history. Each book has a title, ISBN, and is written by one or more authors. Each author has a name and a unique author ID.

What entities and relationships should be represented?

• Entity: Book; Relationship: Authored By; Entity: Author

• Entity: Library; Relationship: Borrows; Entity: Book

• Entity: Book; Relationship: Belongs To; Entity: Library

• Entity: Author; Relationship: Writes; Entity: Book

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.