Database Concepts FC0-U71 Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   What is the main advantage of using a database over storing data in individual files?

   • ADatabases store data in a single file for easy sharing
   • BDatabases eliminate the need for any data validation
   • CDatabases automatically create backups of all data every hour
   • DDatabases allow multiple users to access and update data concurrently while maintaining consistency
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   What is the primary role of a Database Management System (DBMS)?

   • ATo create visual dashboards for displaying database statistics
   • BTo design the physical layout of the building where the database servers are located
   • CTo replace the need for any application software in an organization
   • DTo provide an interface for users and applications to interact with the database while managing data storage, retrieval, and security
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   Which of the following is a typical function performed by a DBMS?

   • ASending email notifications to users
   • BCompiling source code into executable programs
   • CRendering graphics for video games
   • DEnforcing data integrity rules and managing user access permissions
   Reveal Solution Discussion Select an answer first
5. 19application · medium

   A database designer is creating a table to store customer feedback. Each record must include a unique feedback ID, the date the feedback was submitted, the customer's rating from 1 to 5, and the comment text. Which set of data types is most appropriate for these columns?

   • AFLOAT for ID, DATE for date, INT for rating, IMAGE for comment.
   • BVARCHAR for ID, TEXT for date, FLOAT for rating, BLOB for comment.
   • CINT for ID, DATETIME for date, BOOLEAN for rating, CHAR for comment.
   • DINT for ID, DATE for submission date, INT for rating, VARCHAR for comment.
   Reveal Solution Discussion Select an answer first
6. 20application · medium

   A database has a Customers table and an Orders table. The administrator wants to ensure that an order cannot be created for a customer who does not exist. Which action should be taken?

   • ACreate an index on Orders.CustomerID.
   • BDefine a foreign key constraint on Orders.CustomerID referencing Customers.CustomerID.
   • CMake Orders.CustomerID a primary key.
   • DSet a default value of 0 for Orders.CustomerID.
   Reveal Solution Discussion Select an answer first