Which of the following provides an example of direct/manual access that allows a user to interact with a database without relying on application code or scheduled automation?
Scheduling an automated import job via a batch script
Restoring data from an encrypted database backup file
Writing application code that uses an API to call the database
Typing SQL commands in a database command-line interface (e.g., the MySQL shell)
Typing commands in an interactive database shell (such as the MySQL or PostgreSQL command-line client) is considered direct/manual access because the user issues SQL statements directly to the DBMS in real time. The remaining options involve programmatic access, backup or restore utilities, or automated jobs, none of which fall under direct/manual access.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is SQL, and why is it important for databases?
Open an interactive chat with Bash
What is a database command-line interface, and how does it differ from other access methods?
Open an interactive chat with Bash
What is the difference between direct/manual access and programmatic access in databases?
Open an interactive chat with Bash
CompTIA ITF+ FC0-U61 (V5)
Database Fundamentals
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .