Download ALBERTA ORACLE DATABASE SPECIALIST EXAM and more Exams Database Programming in PDF only on Docsity!
ALBERTA ORACLE DATABASE SPECIALIST EXAM
QUESTION AND CORRECT ANSWERS (VERIFIED
ANSWERS) PLUS RATIONALE 2026 Q&A|INSTANT
DOWNLOAD PDF
1. What is Oracle Database? A. Operating system B. Relational database management system C. Programming language D. Web browser Answer: B Oracle is an RDBMS used to store and manage structured data. 2. What is SQL in Oracle? A. System Query Logic B. Structured Query Language C. Simple Query Language D. Server Query Loader Answer: B SQL is used to query and manage data. 3. What is PL/SQL? A. Programming Language for SQL B. Procedural extension of SQL C. Database engine D. UI tool Answer: B PL/SQL adds programming logic to SQL.
4. What is Oracle instance? A. Database file B. Memory + background processes C. Table D. Query Answer: B Instance manages memory and processes. 5. What is Oracle database? A. Memory B. Physical storage of data files C. UI system D. API layer Answer: B Stores actual data on disk. 6. What is SGA? A. System Global Area B. Simple Grid Access C. SQL Group Area D. Storage Global API Answer: A Memory structure shared by Oracle processes. 7. What is PGA? A. Program Global Area B. Process Group Access C. Public Global API D. Primary Grid Area Answer: A Memory used by individual processes.
Answer: B Connects related tables.
12. What is an index? A. UI tool B. Performance optimization structure C. Backup file D. Query type Answer: B Speeds up data retrieval. 13. What is a view? A. Physical table B. Virtual table C. Backup system D. Index Answer: B Stored query result. 14. What is a sequence in Oracle? A. UI flow B. Generates unique numbers C. Table structure D. API Answer: B Used for primary keys. 15. What is a trigger? A. Manual script B. Automatic execution program
C. UI tool D. Backup system Answer: B Runs automatically on events.
16. What is a stored procedure? A. UI function B. Precompiled SQL program C. Table D. Index Answer: B Reusable database logic. 17. What is a function in PL/SQL? A. Returns no value B. Returns a value C. UI tool D. Table Answer: B Returns computed result. 18. What is a cursor? A. UI pointer B. Row-by-row data handler C. Table D. Index Answer: B Processes query results. 19. What is COMMIT in Oracle?
23. What is Oracle optimizer? A. UI tool B. Chooses best execution plan C. Backup tool D. Index tool Answer: B Improves query performance. 24. What is execution plan? A. UI layout B. Steps to execute SQL query C. Backup plan D. Table design Answer: B Shows how query runs. 25. What is partitioning? A. UI design B. Splitting large tables C. Coding style D. API system Answer: B Improves performance and management. 26. What is Oracle RAC? A. Single database B. Real Application Clusters C. UI system D. Backup system Answer: B Multiple servers access same database.
27. What is Data Guard? A. UI tool B. Disaster recovery solution C. Coding system D. Index system Answer: B Provides database redundancy. 28. What is backup in Oracle? A. Deleting data B. Copying data for recovery C. UI design D. Query tool Answer: B Protects against data loss. 29. What is RMAN? A. Report Manager B. Recovery Manager tool C. UI tool D. API tool Answer: B Oracle backup and recovery tool. 30. What is hot backup? A. Offline backup B. Backup while database is running C. UI backup D. Code backup
C. Query D. Backup Answer: B Defines user permissions.
35. What is privilege? A. UI feature B. Permission to perform actions C. Table D. Index Answer: B Controls access rights. 36. What is data dictionary? A. UI system B. Metadata repository C. Backup system D. Code system Answer: B Stores database information. 37. What is Oracle SQL tuning? A. UI design B. Improving query performance C. Backup D. Coding only Answer: B Optimizes SQL execution. 38. What is full table scan?
A. Fast search B. Reading entire table C. Index usage D. Backup Answer: B Less efficient query method.
39. What is indexing benefit? A. Slower queries B. Faster data retrieval C. UI design D. Backup system Answer: B Speeds up searches. 40. What is Oracle job scheduler? A. UI tool B. Automates tasks C. Backup tool D. Query tool Answer: B Runs scheduled jobs. 41. What is Oracle export/import? A. UI tool B. Data transfer utility C. Coding tool D. Index tool Answer: B Moves data between systems.
46. What is 3NF? A. Third Normal Form B. Backup system C. UI system D. API system Answer: A Removes transitive dependencies. 47. What is Oracle locking? A. UI lock B. Preventing data conflicts C. Backup D. Indexing Answer: B Controls concurrent access. 48. What is row-level locking? A. Table lock B. Locks single row C. UI lock D. API lock Answer: B Allows concurrent access. 49. What is database tuning goal? A. UI design B. Improve performance C. Backup only D. Coding only
Answer: B Optimizes database efficiency.
50. What is Oracle DBA main role? A. UI design B. Manage database system C. Coding apps D. Network setup Answer: B Ensures database performance and security. 51. What is Oracle AWR? A. Application Web Report B. Automatic Workload Repository C. Active Work Request D. Archive Write Recovery Answer: B Stores performance statistics for analysis. 52. What is Oracle ADDM? A. Automatic Database Diagnostic Monitor B. Advanced Data Definition Model C. Active Data Deployment Manager D. Archive Data Design Model Answer: A Analyzes AWR data to detect performance issues. 53. What is Oracle ASH? A. Active Session History B. Automated System Handler C. Archive Storage Helper D. Active Schema Handler
C. Code container D. API layer Answer: B Stores database objects.
58. What is datafile in Oracle? A. UI file B. Physical storage file C. Code file D. Backup file Answer: B Stores actual data. 59. What is control file? A. UI control B. Stores database structure metadata C. Query file D. Log file Answer: B Critical database file. 60. What is Oracle listener? A. UI tool B. Handles incoming database connections C. Backup tool D. Query tool Answer: B Manages network requests. 61. What is TNS in Oracle?
A. UI system B. Transparent Network Substrate C. Table Naming System D. Transaction Network Service Answer: B Manages network communication.
62. What is Oracle RAC benefit? A. Single server B. High availability C. UI design D. Slow processing Answer: B Multiple servers increase reliability. 63. What is failover in Oracle? A. UI switch B. Automatic system recovery C. Coding error D. Backup deletion Answer: B Switches to standby system. 64. What is Oracle Data Guard role? A. UI tool B. Disaster recovery system C. Query tool D. Index system Answer: B Maintains standby database.
69. What is SQL tuning advisor? A. UI tool B. Suggests performance improvements C. Backup tool D. Index tool Answer: B Optimizes SQL queries. 70. What is explain plan? A. UI design B. Query execution path C. Backup plan D. Database copy Answer: B Shows how SQL runs. 71. What is bind variable? A. UI element B. Reusable SQL parameter C. Index type D. Backup file Answer: B Improves performance and security. 72. What is hard parsing? A. Fast query B. Full SQL analysis C. UI process D. Backup process
Answer: B Expensive SQL processing.
73. What is soft parsing? A. UI process B. Reusing existing execution plan C. Backup process D. Data delete Answer: B Faster query execution. 74. What is Oracle latch? A. UI lock B. Memory access control C. Backup tool D. Query tool Answer: B Protects shared resources. 75. What is Oracle lock? A. UI lock B. Controls data access C. Backup system D. Index system Answer: B Prevents data conflicts. 76. What is row chaining? A. UI chain B. Row stored across blocks
