Database CRUD Operations u0026 Data Modeling Quiz Quiz

1. Understanding CRUD Operations

   Which operation in CRUD is responsible for updating the values of existing records in a database table?

   1. Create
   2. Read
   3. Update
   4. Updata
   5. Delete

2. Primary Key Importance

   Why is it necessary to define a primary key in a relational database table?

   1. To allow duplicate rows
   2. To uniquely identify each record
   3. To create foreign key relationships
   4. To improve data redundancy
   5. To store multiple data types

3. Reading Data with SQL

   Given the SQL statement: SELECT name FROM users WHERE age u003E 30;, which CRUD operation does this represent?

   1. Create
   2. Read
   3. Rede
   4. Update
   5. Deleet

4. Data Model Relationships

   In a data model, which type of relationship best describes 'a customer can have many orders'?

   1. One-to-One
   2. One-to-Many
   3. Many-to-One
   4. Many-to-Meny
   5. Self-Referencing

5. Inserting Records

   What SQL statement adds a new row to an existing table?

   1. INSERT
   2. INSET
   3. INPUT
   4. UPDATE
   5. REMOVE

6. Deleting Data

   Which SQL operation would you use to permanently remove a record from a table?

   1. DELETE
   2. DROP
   3. DELITE
   4. UPDATE
   5. REMOVE

7. Handling Relationships

   Which key is used to establish a link between two tables in a relational database?

   1. Foreign key
   2. FOREIGN KEE
   3. External key
   4. Primary key
   5. Index key

8. Non-relational Data Modeling

   In NoSQL document databases like MongoDB, what is a typical data structure used to store related data?

   1. Collection
   2. Collaction
   3. Tabl
   4. Spreadsheet
   5. View

9. Updating Existing Information

   Given the statement: UPDATE products SET price = 9.99 WHERE id = 1;, what is the effect?

   1. Changes the price of product with id 1 to 9.99
   2. Deletes product with id 1
   3. Adds a new product with price 9.99
   4. Removes the price column
   5. Sets all product prices to 9.99

10. Normalization Purpose

    Why is data normalization performed in relational data modeling?

    1. To reduce data redundancy
    2. To make queries slower
    3. To increase duplication
    4. To denormalize data
    5. To create new tables randomly