Database Concepts: Relational vs. Non-Relational, Tables, Rows, Fields, Primary/foreign Keys. IT-FUNDAMENTALS-ITF-CERTIFICATION Practice Questions (Page 2)

Questions 6–10

1. 6application · medium

   A social media startup needs to store user posts. Each post can have a different set of metadata (e.g., some have location, some have tags, some have reactions). They also need to query posts by the user who created them. The development team is debating between a relational and a non-relational database. What is the most significant advantage of choosing a non-relational database for this use case?

   • AIt allows each post document to store only the metadata that is relevant to it.
   • BIt requires the use of foreign keys to link posts to users.
   • CIt enforces a strict schema, ensuring all posts have the same fields.
   • DIt guarantees that all queries will be faster than in a relational database.
   Reveal Solution Discussion Select an answer first
2. 7foundation · easy

   A company wants to store information about its employees, including name, department, and hire date. How should this data be organized in a relational database?

   • AAs a separate table for each employee.
   • BAs a single table with columns for name, department, and hire date.
   • CAs a single field containing all the information in a text string.
   • DAs a key-value pair for each employee.
   Reveal Solution Discussion Select an answer first
4. 8application · medium

   A database designer is creating a table for a library's book collection. They want to use the ISBN (International Standard Book Number) as the primary key. What is the most important reason this is a good choice?

   • AISBNs are always numeric and easy to sort.
   • BISBNs are guaranteed to be unique for each book edition.
   • CISBNs are assigned by the library, ensuring control over the data.
   • DISBNs are short and use minimal storage space.
   Reveal Solution Discussion Select an answer first
5. 9foundation · easy

   What is the purpose of a primary key in a relational database table?

   • ATo store large amounts of text data.
   • BTo sort the table in alphabetical order.
   • CTo establish a relationship with another table.
   • DTo uniquely identify each row in the table.
   Reveal Solution Discussion Select an answer first
6. 10application · easy

   A database table 'Products' has columns: ProductID, ProductName, Price, and QuantityInStock. A query returns the following result: (101, 'Laptop', 999.99, 15). What does this result represent?

   • AA single row in the table
   • BA single field in the table
   • CThe primary key of the table
   • DA single column in the table
   Reveal Solution Discussion Select an answer first