Database Use: Queries, Reports, Scalability, Cloud vs. Local Storage. IT-FUNDAMENTALS-ITF-CERTIFICATION Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   What is the role of SQL in database interaction?

   • AIt is a hardware protocol for connecting database servers
   • BIt is a programming language used to design user interfaces
   • CIt is a file format for storing database backups
   • DIt is a standard language for managing and querying relational databases
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A sales manager needs to see a list of customers who made a purchase in the last 30 days, showing only their names and total purchase amounts. The database administrator provides a tool that accepts a text command to retrieve this data. Which type of command should the manager use to retrieve exactly this information?

   • AA DELETE query that removes all customers with no purchases in the last 30 days
   • BA SELECT query with a WHERE clause filtering by date and a GROUP BY on customer name
   • CA parameter query that prompts for a date and then displays all columns from the customer table
   • DAn UPDATE query that modifies the customer records to include only recent purchases
   Reveal Solution Discussion Select an answer first
4. 18application · easy

   A database administrator needs to increase the price of all products in the 'Electronics' category by 10%. The change must be applied to existing records only. Which type of query should be used?

   • AA SELECT query
   • BAn UPDATE query
   • CA parameter query
   • DA report
   Reveal Solution Discussion Select an answer first
5. 19application · easy

   A database administrator needs to add a new column to an existing table to store customer email addresses. Which language is specifically designed for this type of database structure modification?

   • AHTML (Hypertext Markup Language)
   • BPython
   • CSQL (Structured Query Language)
   • DCSS (Cascading Style Sheets)
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   Which of the following is a limitation of local database storage?

   • AIt cannot be secured with passwords
   • BData is not accessible from the local network
   • CIt is always slower than cloud storage
   • DRequires upfront investment in hardware and ongoing maintenance
   Reveal Solution Discussion Select an answer first