Download ALBERTA DATA SCIENTIST EXAM| and more Exams Advanced Data Analysis in PDF only on Docsity!
ALBERTA DATABASE ADMINISTRATOR EXAM QUESTIONS
AND CORRECT ANSWER (VERIFIED ANSWER) PLUS
RATIONALE 2026 Q&A|INSTANT DOWNLOAD PDF
1 โ 10: Database Fundamentals
1. A database is used to: A. Design websites B. Store and manage data C. Compile programs D. Encrypt networks Answer: B Rationale: Databases store and organize structured data. 2. DBMS stands for: A. Data Backup Management System B. Database Management System C. Digital Binary Model System D. Data Build Machine System Answer: B Rationale: Software that manages databases. 3. Primary key is used to: A. Duplicate records B. Uniquely identify rows C. Encrypt data D. Delete tables Answer: B Rationale: Ensures unique identification. 4. Foreign key is used to: A. Delete tables B. Link two tables
C. Encrypt database D. Speed up CPU Answer: B Rationale: Creates relationships between tables.
5. SQL stands for: A. Structured Query Language B. Simple Query Logic C. System Query List D. Sequential Question Language Answer: A Rationale: Language for database operations. 6. Table in a database represents: A. File system B. Data in rows and columns C. Program code D. Network Answer: B Rationale: Structured data storage. 7. Record in a database is: A. Column B. Row C. Table D. Index Answer: B Rationale: One data entry in a table. 8. Field in database is: A. Row B. Column C. Table D. Query
Answer: B Rationale: Adds new data.
13. UPDATE modifies: A. Database engine B. Existing records C. Server hardware D. Queries Answer: B Rationale: Changes data values. 14. DELETE removes: A. Database B. Rows C. Columns D. Indexes Answer: B Rationale: Deletes records. 15. WHERE clause is used for: A. Sorting B. Filtering data C. Joining tables D. Encrypting Answer: B Rationale: Filters records. 16. ORDER BY is used to: A. Delete data B. Sort results C. Encrypt data D. Join tables Answer: B Rationale: Sorts output.
17. GROUP BY is used to: A. Encrypt data B. Aggregate data C. Delete tables D. Create indexes Answer: B Rationale: Groups similar records. 18. JOIN is used to: A. Encrypt data B. Combine tables C. Delete rows D. Backup database Answer: B Rationale: Merges related tables. 19. COUNT function returns: A. Sum B. Number of rows C. Average D. Max value Answer: B Rationale: Counts records. 20. DISTINCT keyword removes: A. Tables B. Duplicate values C. Indexes D. Columns Answer: B Rationale: Eliminates duplicates. 21 โ 30: Database Design & Normalization
B. Improve performance C. Delete data D. Encrypt data Answer: B Rationale: Adds redundancy for speed.
26. ER diagram represents: A. Hardware B. Database design C. CPU structure D. Network Answer: B Rationale: Entity-relationship model. 27. Entity represents: A. Attribute B. Real-world object C. Query D. Index Answer: B Rationale: Things in database. 28. Attribute is: A. Table B. Property of entity C. Server D. File Answer: B Rationale: Describes entity. 29. Relationship defines: A. CPU connection B. Association between entities C. File storage
D. Encryption Answer: B Rationale: Links entities.
30. Cardinality defines: A. Speed B. Relationship quantity C. Storage size D. Encryption Answer: B Rationale: Number of relationships. **31 โ 40: Indexing & Performance
- Index improves:** A. Storage B. Query speed C. Security D. Backup Answer: B Rationale: Speeds up retrieval. 32. Clustered index determines: A. Column order in storage B. Encryption C. Backup D. API Answer: A Rationale: Physical order of data. 33. Non-clustered index: A. Changes table structure B. Uses separate structure C. Deletes data D. Encrypts data
38. Partitioning divides: A. CPU B. Large tables C. Networks D. Files Answer: B Rationale: Improves performance. 39. Stored procedure is: A. File B. Precompiled SQL code C. Index D. Backup Answer: B Rationale: Reusable SQL logic. 40. Trigger executes when: A. Manual call B. Event occurs C. Server shuts down D. Backup runs Answer: B Rationale: Automatic execution. **41 โ 50: Transactions & Concurrency
- A database transaction ensures:** A. Speed only B. Data consistency C. UI design D. File compression Answer: B Rationale: Transactions maintain data integrity.
42. ACID stands for: A. Access Control Integrity Data B. Atomicity, Consistency, Isolation, Durability C. Active Control Index Data D. Automated Consistent Input Database Answer: B Rationale: Core transaction properties. 43. Atomicity means: A. Partial execution B. All or nothing execution C. Fast execution D. Data duplication Answer: B Rationale: Transaction fully completes or rolls back. 44. Consistency ensures: A. Random data B. Valid database state C. Faster queries D. File storage Answer: B Rationale: Data follows rules before/after transaction. 45. Isolation means: A. Transactions run independently B. Data is deleted C. Data is compressed D. Backup occurs Answer: A Rationale: Transactions donโt interfere. 46. Durability ensures: A. Data is temporary
D. Encryption Answer: B Rationale: Prevents conflicts in simultaneous access. 51 โ 60: Backup & Recovery
51. Backup is used for: A. Speed B. Data recovery C. Encryption D. Sorting Answer: B Rationale: Restores lost data. 52. Full backup means: A. Partial data B. Entire database copy C. Deleted files D. Index only Answer: B Rationale: Complete backup. 53. Incremental backup stores: A. Full database B. Only changes since last backup C. No data D. Index only Answer: B Rationale: Efficient backup method. 54. Differential backup stores: A. All changes since last full backup B. No changes C. Index only D. Metadata only
Answer: A Rationale: Accumulated changes.
55. Recovery means: A. Deleting database B. Restoring lost data C. Encrypting files D. Sorting tables Answer: B Rationale: Restores system state. 56. Disaster recovery focuses on: A. UI design B. System restoration after failure C. Speed increase D. Encryption only Answer: B Rationale: Handles major system failures. 57. Replication is: A. Deleting data B. Copying data across systems C. Sorting tables D. Compressing files Answer: B Rationale: Improves availability. 58. Failover system ensures: A. Data loss B. Continuous operation C. Slow queries D. Encryption Answer: B Rationale: Backup system activation.
63. Authorization defines: A. Hardware B. Access rights C. Speed D. Backup Answer: B Rationale: Controls permissions. 64. Role-based access control (RBAC) means: A. Random access B. Permissions based on roles C. No security D. Encryption only Answer: B Rationale: Security by role. 65. SQL injection is: A. Backup method B. Security attack C. Index type D. Query optimization Answer: B Rationale: Malicious SQL code attack. 66. Encryption converts data into: A. Readable form B. Unreadable form C. Index D. Table Answer: B Rationale: Protects confidentiality. 67. Data masking is used to: A. Speed queries
B. Hide sensitive data C. Delete tables D. Backup data Answer: B Rationale: Protects private information.
68. Audit logs are used for: A. Speed B. Tracking user actions C. Storage D. Indexing Answer: B Rationale: Security monitoring. 69. Privilege means: A. Storage B. User permission level C. Backup type D. Query type Answer: B Rationale: Access rights. 70. Firewall protects: A. Database structure B. Unauthorized access C. Speed D. Storage Answer: B Rationale: Blocks threats. **71 โ 80: Performance & Administration
- Index improves:** A. Storage B. Query speed
Answer: A Rationale: Improves scalability.
76. Sharding means: A. Encrypting data B. Splitting database across servers C. Backup method D. Sorting data Answer: B Rationale: Horizontal scaling technique. 77. High availability ensures: A. Downtime B. System uptime C. Data deletion D. Slow queries Answer: B Rationale: System always accessible. 78. Scalability means: A. Fixed system B. Ability to grow C. Slow performance D. No storage Answer: B Rationale: Handles increased load. 79. Database tuning improves: A. Errors B. Performance C. Security only D. Backup only Answer: B Rationale: Optimizes system efficiency.
80. Final goal of DBA is: A. Slow database B. Secure, reliable, high-performance database system C. Random storage D. UI design only Answer: B Rationale: Ensures stability, security, and performance.
