NEW
Font size
WorksheetsQUIZ- BSACC2-2-FROM INQUIRIES
Total questions: 50
Worksheet time: 50mins
Which DBMS is most similar to MS Access but is free and open-source?
MySQL
PostgreSQL
LibreOffice Base
MongoDB
What does referential integrity prevent?
Large data sizes
Orphan records
Duplicate tables
Slow performance
A relationship error in MS Access usually occurs when:
Tables have too many records
Data types do not match
The PC lacks storage
Queries are missing
A one-to-many relationship is best represented by:
Employee ↔ Company President
Employee ↔ Employee Profile
Customer ↔ Orders
One product ↔ One barcode
SQL is mainly used for:
Image processing
Network routing
Data retrieval and management
Antivirus scanning
Recording refers to:
the process of capturing audio or video for future playback
the act of deleting files from a device
the method of editing written documents
the technique of encrypting data for security
Processing refers to:
Creating tables
Entering raw data
Turning raw data into information
Exporting files
Which system is more suitable for large, multi-table datasets?
Excel
Access
PowerPoint
Word
Excel vs. Access: Access is better because it:
Allows pictures in tables
Handles relational data
Has more chart types
Requires no planning
Primary keys ensure:
Fast internet
Unique identification of records
Data encryption
Backup automation
Which of the following summarizes all financial transactions?
Stores employee information
Summarizes all financial transactions
Holds customer emails
Is used only for budgeting
ERP systems are:
Manual systems
Only for payroll
Broader systems that include accounting
Sales-only systems
Internal controls apply to:
Only manual systems
Only computerized systems
Both manual and computerized systems
Neither system
Application Controls focus on:
Hardware failures
Individual transactions
Cloud subscriptions
Computer speed
General IT Controls focus on:
Validating entries
Invoice matching
Overall system security
Account balance checks
RPA works best for:
Predictive analytics
Creative writing
Rule-based repetitive tasks
Fraud detection
AI is different from RPA because AI:
Works without data
Learns and makes decisions
Never makes mistakes
Only copies data
Internal controls improve AIS by:
Allowing free access
Automating emails
Ensuring data integrity and preventing fraud
Removing audit trails
Audit trails show:
System design layout
Who changed what and when
Marketing strategies
Deleted emails only
Locking formulas in Excel prevents:
Creating new sheets
Accidental modification of computations
Printing errors
Long loading time
Implicit, schema-based, and application-based constraints are influenced by:
Weather conditions
Company policies and regulations
Internet speed
Number of employees
Schema-based constraints include:
Attendance rules
Credit limits
Primary and foreign keys
Employee promotions
Application-based constraints include:
NOT NULL
Foreign keys
Business rules (like approval limits)
UNIQUE
RDBMS advantage over spreadsheets:
Stores photos
Prevents data duplication
Works offline only
Does not need design
Businesses choose DBMS based on:
Logo design
Trendiness
Data size, cost, and performance
Color scheme
Using Excel instead of SQL for large data results in:
Improved security
High risk of errors and duplicates
Faster processing
Strong access control
A database is:
A. A set of financial rules
B. The storage of data
C. A reporting tool
Database management refers to:
Storing the data only
Organizing, updating, and securing data
Designing office layouts
Communicating results
Forms in Access help users by:
Displaying animations
Allowing easier and validated data entry
Encrypting files
Sending emails
Reports are used to:
Play videos
Summarize and present data
Backup the database
Create tables
Which technology currently has the greatest impact on accounting?
Robotics only
Blockchain
Data analytics
Virtual reality
AI bias can be reduced by:
Using smaller datasets
Ignoring errors
Reviewing outputs and using diverse data
Data analytics identifies risks by:
Hiding information
Visualizing and analyzing patterns
Deleting old data
Printing financial reports
Blockchain prevents fraud mainly because of:
Color-coded blocks
Immutability of records
Fast internet
Government regulation
In blockchain, each block contains:
Only images
Transaction data + timestamp + previous hash
Financial statements
Password lists
Blockchain differs from traditional systems because it is:
Fully manual
Centralized
Decentralized and tamper-proof
Offline only
AI assists in preparing financial reports by:
Playing audio files
Automating data cleaning and trend analysis
Blocking user access
Editing PDFs
A. Database system B. Graphic design tool D. File storage system
Database system
Graphic design tool
Data visualization tool
File storage system
QuickBooks is:
A programming language
A general-purpose DBMS
An accounting system
A spreadsheet program
SQL tools like MySQL and SQL Server are:
Weak compared to Excel
Enterprise-level databases
Used only for graphs
Replacements for PowerPoint
The six components of AIS include software, data, internal controls, procedures, IT infrastructure, and:
Charts
People
Vehicles
Invoices
All AIS components must be present because:
Laws require it
AIS will not function reliably without all components
Financial statements need color
Reports will not print
To protect Excel locked cells when uploading to Google Drive, you should:
Convert the file to PDF before uploading
Use password protection in Excel before uploading
Unlock all cells before uploading
Enable sharing without editing permissions
IT controls ensure accuracy by:
Ignoring incorrect inputs
Validating data and maintaining logs
Removing user accounts
Automating presentations
Internal IT issues can be identified by:
Avoiding system checks
Regular audits and log reviews
Changing staff monthly
Deleting reports
An important non-security factor for accounting databases is:
File color
Scalability
Desktop wallpaper
Number of printers
One-to-one relationships are used when:
One record must match many records
Two tables share identical fields
Each record in one table matches exactly one record in another
Tables have unrelated data
In a Customers–Orders relationship, the foreign key is found in:
Customers table
Orders table
Both tables
Neither table
Access Totals (Σ) differ from PivotTables because:
Access Totals rely on relational data integrity
PivotTables require queries
Totals are only for charts
PivotTables work only online
Losing integrity in Excel happens because Excel:
Enforces foreign keys strictly
Has no relational constraints
Requires SQL for formulas
Automatically validates all entries
