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

Questions 1–5

1. 1foundation · easy

   A database has a 'Customers' table with a primary key CustomerID, and an 'Orders' table that needs to link each order to a customer. Which column should be added to the Orders table?

   • ACustomerID as a foreign key referencing Customers.CustomerID.
   • BCustomerName as a text field.
   • COrderID as a primary key.
   • DA new table with both CustomerID and OrderID.
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   A library database has a table named 'Books' with columns for ISBN, Title, Author, and Year. How many rows would the table have if it contains data for 500 books?

   • A500 columns, one for each book.
   • BIt depends on the database software used.
   • C4 rows, one for each column.
   • D500 rows, one for each book.
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   A table named 'Products' has columns: ProductID, ProductName, Price, and QuantityInStock. Which of the following is a field in this table?

   • AA specific product, like 'Widget'.
   • BThe entire table structure.
   • CA query that selects products with a price over $10.
   • DProductName
   Reveal Solution Discussion Select an answer first
5. 4application · easy

   A university database has a 'Students' table with columns: StudentID, FirstName, LastName, Email, and Phone. The university registrar needs to ensure that each student can be uniquely identified, even if two students share the same name and email. Which column should be designated as the primary key?

   • AEmail
   • BStudentID
   • CFirstName
   • DPhone
   Reveal Solution Discussion Select an answer first
6. 5foundation · easy

   In a relational database, what is a table?

   • AA software program used to manage the database.
   • BA single piece of data, such as a customer's name.
   • CA query that retrieves data from the database.
   • DA collection of related data organized into rows and columns.
   Reveal Solution Discussion Select an answer first