Download NWCA Database Processing Exam and more Exams Technology in PDF only on Docsity!
Question 1. Which of the following best describes the primary purpose of aligning an information system strategy with business goals? A) To minimize IT staff hiring B) To ensure technology investments support organizational objectives C) To increase the number of software licenses purchased D) To standardize all hardware across departments Answer: B Explanation: Aligning IS strategy with business goals guarantees that technology resources are directed toward achieving the organization’s strategic objectives, rather than being a cost center. Question 2. In the context of a manager’s role in network planning, which activity is most directly related to ensuring system reliability? A) Selecting the cheapest vendor B) Designing redundant pathways and fail‑over mechanisms C) Training employees on social media use D) Outsourcing all IT functions Answer: B Explanation: Redundant pathways and fail‑over mechanisms provide alternative routes for data, enhancing network reliability and availability. Question 3. Which functional area most commonly uses an HR information system (HRIS) to process employee data? A) Procurement B) Human Resources C) Marketing D) Logistics
Answer: B Explanation: An HRIS is designed to manage employee records, payroll, benefits, and performance data for the Human Resources department. Question 4. Which phase of the Systems Development Life Cycle (SDLC) focuses on gathering and documenting user requirements? A) Implementation B) Design C) Analysis D) Maintenance Answer: C Explanation: The analysis phase involves detailed investigation of business needs and creation of requirement specifications. Question 5. Business Process Management (BPM) primarily aims to: A) Increase the number of employees B) Automate and improve business processes for efficiency C) Replace all manual tasks with AI D) Eliminate all documentation Answer: B Explanation: BPM seeks to model, analyze, and optimize processes to improve efficiency, effectiveness, and adaptability. Question 6. Which of the following statements accurately distinguishes a DBMS from a database? A) A DBMS stores data; a database processes queries. B) A DBMS is software that manages databases; a database is the collection of data.
Explanation: A foreign key references a primary key in another table, establishing a relationship between tables. Question 10. Normalization to the Third Normal Form (3NF) primarily eliminates: A) All null values B) Redundant data and transitive dependencies C) Primary keys D) Data types Answer: B Explanation: 3NF removes transitive dependencies, ensuring that non‑key attributes depend only on the primary key, reducing redundancy. Question 11. Which of the following is a characteristic of a flat‑file database? A) Supports complex joins B) Stores data in a single, delimited text file C) Enforces referential integrity automatically D) Uses stored procedures for data manipulation Answer: B Explanation: Flat files are simple text files where records are stored line‑by‑line, often separated by commas or tabs. Question 12. Which SQL statement is used to retrieve data from one or more tables? A) INSERT B) UPDATE C) SELECT D) DELETE
Answer: C Explanation: SELECT queries read data without modifying the underlying tables. Question 13. The SQL command that adds a new row to a table is: A) INSERT INTO B) ALTER TABLE C) CREATE TABLE D) DROP TABLE Answer: A Explanation: INSERT INTO specifies the table and values for a new record. Question 14. Which SQL clause is used to filter rows returned by a SELECT statement? A) GROUP BY B) ORDER BY C) WHERE D) HAVING Answer: C Explanation: WHERE restricts the result set based on specified conditions. Question 15. In SQL, the command to permanently remove a table and its data is: A) DELETE TABLE B) DROP TABLE C) TRUNCATE TABLE D) REMOVE TABLE
Answer: B Explanation: Concurrency control mechanisms (e.g., locking, MVCC) ensure data consistency when many users read/write concurrently. Question 19. Which isolation level in SQL provides the highest level of protection against dirty reads, non‑repeatable reads, and phantom rows? A) READ UNCOMMITTED B) READ COMMITTED C) REPEATABLE READ D) SERIALIZABLE Answer: D Explanation: SERIALIZABLE ensures complete transaction isolation, preventing all three phenomena. Question 20. In a data warehouse, the term “data mart” refers to: A) A collection of raw transaction logs B) A subset of the warehouse focused on a specific business line or department C) An online transaction processing (OLTP) system D) A backup of the entire data warehouse Answer: B Explanation: Data marts are smaller, subject‑area focused repositories derived from the central warehouse. Question 21. Which of the following best describes the ETL process in data warehousing? A) Encrypt, Transfer, Load B) Extract, Transform, Load C) Evaluate, Test, Launch
D) Expand, Transfer, Log Answer: B Explanation: ETL extracts data from source systems, transforms it to fit the warehouse schema, and loads it into the warehouse. Question 22. Data mining techniques are primarily used to: A) Store large volumes of raw data B) Identify hidden patterns, associations, or trends within data sets C) Backup databases nightly D) Enforce referential integrity Answer: B Explanation: Data mining applies statistical and machine learning algorithms to discover useful information. Question 23. Which BI tool is most commonly used for creating interactive dashboards? A) Microsoft Word B) Tableau C) Notepad D) Adobe Photoshop Answer: B Explanation: Tableau specializes in visual analytics and interactive dashboard creation. Question 24. Social Media Information Systems (SMIS) typically integrate data from platforms such as: A) SAP ERP only B) Twitter, Facebook, Instagram, LinkedIn
A) Public cloud B) Private cloud C) Community cloud D) Hybrid cloud Answer: B Explanation: Private clouds are dedicated to one organization, offering greater control and security. Question 28. In a hybrid cloud architecture, which component typically handles the integration between on‑premises and cloud resources? A) VPN or dedicated interconnect B) Local floppy disk drive C) Standalone desktop PC D) Physical tape library Answer: A Explanation: VPNs or dedicated links enable secure, seamless connectivity between internal data centers and cloud services. Question 29. Scalability in database systems refers to the ability to: A) Reduce data size automatically B) Increase capacity and performance as workload grows C) Convert relational data to XML D) Delete old records without backup Answer: B Explanation: Scalable systems can handle higher transaction volumes or data growth without degradation.
Question 30. Which of the following is a primary advantage of using a column‑store database for analytical workloads? A) Faster OLTP transaction processing B) Improved compression and query performance for read‑heavy operations C) Automatic generation of UI forms D) Simplified backup procedures only Answer: B Explanation: Column stores store data by column, enabling high compression and efficient aggregation queries. Question 31. A “deadlock” in a DBMS occurs when: A) Two transactions simultaneously try to lock the same rows in opposite order, causing a circular wait B) The server runs out of disk space C) Users forget their passwords D) The database schema is missing a primary key Answer: A Explanation: Deadlocks arise from circular waiting for resources, requiring the DBMS to abort one transaction. Question 32. Which SQL function is used to calculate the total of a numeric column? A) AVG() B) COUNT() C) SUM() D) MAX() Answer: C Explanation: SUM aggregates values in a column to produce a total.
Explanation: GDPR grants individuals the ability to have their personal data erased under certain conditions. Question 36. Which of the following is a common method for implementing row‑level security in a database? A) Using a stored procedure that checks the user’s role before returning rows B) Deleting all rows after each query C) Disabling the SELECT statement D) Encrypting the entire database with a single key Answer: A Explanation: Row‑level security filters query results based on the user’s permissions, often using predicates in views or stored procedures. Question 37. In the context of database backups, a “point‑in‑time recovery” allows you to: A) Restore the database to the exact moment before a failure or error occurred B) Move the database to a new server automatically C) Compress backup files without loss D) Duplicate the database schema only Answer: A Explanation: Point‑in‑time recovery uses transaction logs to roll the database back to a specific timestamp. Question 38. Which SQL clause is used to group rows that have the same values in specified columns? A) ORDER BY B) GROUP BY
C) HAVING
D) WHERE
Answer: B Explanation: GROUP BY aggregates rows based on column values, enabling functions like SUM, COUNT, AVG per group. Question 39. The “HAVING” clause differs from “WHERE” in that it: A) Filters groups after aggregation, whereas WHERE filters rows before aggregation B) Only works with INSERT statements C) Is used to order results alphabetically D) Requires a subquery in every case Answer: A Explanation: HAVING applies conditions to aggregated groups, while WHERE applies to individual rows. Question 40. A “materialized view” in a database is: A) A virtual table that stores query results physically for faster access B) A view that cannot be updated C) A stored procedure that generates reports D) A synonym for a temporary table Answer: A Explanation: Materialized views precompute and store results, improving performance for complex queries. Question 41. Which of the following is an example of a non‑relational (NoSQL) database? A) Oracle Database
A) Atomicity B) Consistency C) Isolation D) Distribution Answer: D Explanation: ACID stands for Atomicity, Consistency, Isolation, Durability. Distribution is not part of ACID. Question 45. Which SQL command is used to modify existing data in a table? A) ALTER B) UPDATE C) INSERT D) CREATE Answer: B Explanation: UPDATE changes column values for rows that meet specified criteria. Question 46. In a relational database, the term “referential integrity” ensures that: A) Every table has a primary key B) Foreign key values must match existing primary key values or be NULL C) Data types are consistent across columns D) All tables are stored on SSDs Answer: B Explanation: Referential integrity enforces valid relationships between tables. Question 47. Which of the following is a typical characteristic of an OLTP system?
A) Complex, ad‑hoc analytical queries B) High volume of short, atomic transactions C) Large data warehouse schemas D) Batch processing of nightly reports Answer: B Explanation: OLTP (Online Transaction Processing) handles many short, real‑time transactions. Question 48. The term “data provenance” in data processing refers to: A) The physical location of the database server B) The lineage and origin of data, tracking its history and transformations C) The encryption algorithm used for data at rest D) The size of the data file in megabytes Answer: B Explanation: Data provenance records where data came from and how it has been altered, supporting trust and auditability. Question 49. Which of the following best describes a “cold backup”? A) A backup taken while the database is online and active B) A backup taken when the database is shut down, ensuring a consistent state without transaction logs C) A backup that only includes schema definitions D) A backup stored on magnetic tape only Answer: B Explanation: Cold backups are performed offline, guaranteeing a static snapshot without needing log replay.
Question 53. Which of the following best describes “eventual consistency” in distributed databases? A) All nodes are instantly synchronized after each write B) Updates propagate asynchronously, and all replicas will become consistent over time C) No consistency guarantees are provided D) Data is always read from the master node only Answer: B Explanation: Eventual consistency accepts temporary divergence, guaranteeing convergence eventually. Question 54. In a data warehouse, “slowly changing dimensions” (SCD) are used to: A) Store real‑time transaction data B) Track changes to dimension attributes over time C) Compress data for faster queries D) Delete obsolete dimension records automatically Answer: B Explanation: SCD techniques preserve historical attribute values while allowing updates. Question 55. Which of the following is a primary advantage of using stored procedures? A) They eliminate the need for indexes B) They encapsulate business logic on the server, reducing network traffic and improving security C) They automatically generate ER diagrams D) They convert relational data to XML without code Answer: B Explanation: Stored procedures run on the DBMS, centralizing logic, minimizing client‑server round trips, and allowing permission control.
Question 56. In the context of BI, a “KPI” stands for: A) Knowledge Processing Interface B) Key Performance Indicator C) Kernel Process Integration D) Known Primary Index Answer: B Explanation: KPIs are measurable values that demonstrate how effectively a company achieves key objectives. Question 57. Which data mining technique is most appropriate for predicting a categorical outcome, such as churn vs. non‑churn? A) Association rule mining B) Clustering C) Classification D) Regression Answer: C Explanation: Classification models predict discrete class labels. Question 58. Which of the following best describes “data governance”? A) The process of physically moving data between servers B) A framework of policies, procedures, and standards that ensure data quality, security, and compliance C) The automatic generation of reports D) The use of AI to replace database administrators Answer: B
