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

Questions 11–15

1. 11application · easy

   A database has a 'Departments' table with 'DeptID' as the primary key. A new 'Employees' table is created, and each employee must belong to a department. Which column should be included in the 'Employees' table to enforce this relationship?

   • ADeptName
   • BEmployeeID
   • CManagerID
   • DDeptID
   Reveal Solution Discussion Select an answer first
2. 12application · medium

   A startup is building a catalog for a large collection of books. Each book has a fixed set of attributes: ISBN, Title, Author, and Publication Year. They expect to perform complex queries that join book data with author and publisher data. Which type of database is most appropriate for this scenario?

   • ARelational database, because the data has a fixed structure and requires complex queries with joins.
   • BNon-relational database, because it handles large datasets better.
   • CNon-relational database, because it does not require a predefined schema.
   • DRelational database, because it is always faster than non-relational databases.
   Reveal Solution Discussion Select an answer first
4. 13foundation · easy

   Which of the following best describes the fundamental difference between relational and non-relational databases?

   • ARelational databases are always faster than non-relational databases for all types of queries.
   • BRelational databases can only store text data, while non-relational databases can store any data type.
   • CRelational databases store data in tables with predefined relationships, while non-relational databases use flexible data models like documents or key-value pairs.
   • DRelational databases are used only for small datasets, while non-relational databases are required for large datasets.
   Reveal Solution Discussion Select an answer first
5. 14application · easy

   A database table 'Employees' has columns: EmployeeID, FirstName, LastName, and JobTitle. The company wants to add a new attribute to store each employee's office phone number. What is the correct action to take?

   • AModify the 'EmployeeID' column to store the phone number.
   • BCreate a new table for phone numbers.
   • CAdd a new column named 'OfficePhone' to the table.
   • DAdd a new row to the table for the phone number.
   Reveal Solution Discussion Select an answer first
6. 15foundation · easy

   In a relational database table, what does a single row represent?

   • AA single record or entity instance.
   • BA single attribute of an entity.
   • CA relationship between two tables.
   • DA database query result.
   Reveal Solution Discussion Select an answer first