Font size
S
M
L
XL
WorksheetsIT222 - Quiz
Total questions: 42
Worksheet time: 32mins
Name
Class
Date
1.
FULL NAME (LN, FN, M.I)
4 lines
2.
SECTION
a)
IT-2203
b)
IT-2204
c)
IT-2205
d)
IT-2206
3.
Which of the following best explains why DDBMS can improve communication in organizations?
a)
It allows data compression across all networks
b)
It stores backup data for all departments
c)
It places data closer to the sites of highest usage, reducing data access latency
d)
It eliminates the need for data encryption
4.
In a distributed environment, what would be a likely consequence of lacking failure transparency?
a)
Users experience increased query speed
b)
A local node failure could affect the entire system’s operation
c)
System backups become unnecessary
d)
Data becomes more fragmented
5.
Why is distributed concurrency control more complex than in centralized systems?
a)
Because data is always replicated in distributed systems
b)
Because transactions may involve multiple sites, increasing the risk of deadlocks and inconsistencies
c)
Because distributed systems do not support rollback
d)
Because logs are not available at each site
6.
What is the main function of the distributed data catalog (DDC)?
a)
Maintains metadata about the fragments and locations of the distributed database
b)
Acts as a temporary buffer for distributed transactions
c)
Stores encryption keys for all data nodes
d)
Handles user authentication and access control
7.
Why is the DO-UNDO-REDO protocol crucial in distributed databases?
a)
It improves database normalization
b)
It supports read-only transactions only
c)
It compresses logs before storage
d)
It ensures that transactions can be rolled back or forward to maintain consistency
8.
Which feature allows a single SQL statement to access data from multiple remote sites?
a)
Distributed transaction
b)
Remote transaction
c)
Distributed request
d)
Global query coordinator
9.
Why is the CAP theorem significant in designing distributed databases?
a)
It defines encryption protocols for distributed systems
b)
It guides trade-offs between consistency, availability, and partition tolerance
c)
It prescribes the database normalization levels for distributed systems
d)
It recommends replication frequencies
10.
What is the main reason for employing the two-phase commit protocol in distributed transactions?
a)
To speed up query execution
b)
To validate data types in SQL statements
c)
To synchronize clocks across distributed nodes
d)
To ensure that all involved sites either commit or roll back the transaction collectively
11.
Why is data consistency more difficult to maintain in a fully replicated distributed database?
a)
Updates must be synchronized across all replicas to prevent divergence
b)
Each node stores different schema versions
c)
Only one replica is allowed to perform write operations
d)
Reads are always slower on replicated databases
12.
Which of the following best defines a remote transaction?
a)
A transaction that accesses only one fragment stored on the same node
b)
A transaction that accesses multiple sites simultaneously
c)
A set of requests processed at a single remote site
d)
A distributed request executed by multiple transaction processors
13.
What is the primary role of the ETL process in a Business Intelligence architecture?
a)
To automate user interface development
b)
To perform data mining on transactional data
c)
To manage customer relationships
d)
To extract, transform, and load data into a data store
14.
How does a star schema support data analysis more effectively than a traditional relational schema?
a)
It eliminates the need for foreign keys
b)
It simplifies complex queries through dimensional modeling
c)
It stores only unstructured data
d)
It allows operational and analytical data to mix freely
15.
Why are data warehouses generally read-only environments?
a)
They are designed for analysis, not frequent updates
b)
They are connected directly to customer-facing apps
c)
They are optimized for transaction processing
d)
Their data is updated constantly through user inputs
16.
What is the key advantage of using a data mart over a full data warehouse?
a)
It supports real-time data analytics
b)
It processes only unstructured data
c)
It offers faster and simpler implementation for specific departments
d)
It integrates data from every system in the organization
17.
What is the primary difference between data mining and predictive analytics?
a)
Data mining predicts future outcomes, predictive analytics does not
b)
Predictive analytics is used for storage, while data mining is not
c)
Data mining explores past data; predictive analytics forecasts future behavior
d)
Predictive analytics is only used in financial industries
18.
In the context of Business Intelligence, what is a KPI (Key Performance Indicator) used for?
a)
Managing database indexing
b)
Assessing how well strategic and operational goals are being met
c)
Organizing tables in a snowflake schema
d)
Designing user interfaces for BI dashboards
19.
What characteristic makes a data lake different from a traditional data warehouse?
a)
It stores all types of data in raw form without prior structuring
b)
It uses only normalized schemas
c)
It processes only structured data
d)
It is used only for financial transactions
20.
Why is integrating architecture important in BI systems?
a)
It enables decentralized database structures
b)
It helps in bypassing security protocols
c)
It allows independent, siloed analysis tools
d)
It provides a unified interface and consistent data for analysis
21.
Why is a common user interface beneficial in Business Intelligence architecture?
a)
It allows multiple users to edit the same report simultaneously
b)
It hides key performance indicators from executives
c)
It simplifies access to analytical tools and reports across departments
d)
It reduces the need for storing historical data
22.
Which of the following best describes a data mart?
a)
A real-time reporting tool used in dashboards
b)
A large-scale, unstructured data repository
c)
A small, focused subset of a data warehouse used by specific departments
d)
A tool used to design snowflake schemas
23.
Which of the following best explains why traditional relational databases are not suitable for managing Big Data?
a)
They do not support cloud storage
b)
They cannot efficiently handle high volume, velocity, and variety of data
c)
They are incompatible with open-source software
d)
They are primarily designed for graphical data processing
24.
What does the term “scaling out” refer to in the context of Big Data storage?
a)
Replacing outdated software with more scalable software
b)
Expanding storage capacity within a single system
c)
Increasing CPU speed for faster processing
d)
Distributing the workload across multiple systems
25.
Which of the following statements best describes polyglot persistence?
a)
Employing different types of databases to handle various data types and workloads
b)
Using only relational databases for all organizational needs
c)
Integrating machine learning algorithms directly into SQL queries
d)
Converting all data into one common format for storage
26.
What is a key distinguishing feature of document databases compared to key-value databases?
a)
Document databases cannot store binary data
b)
Document databases store structured data only
c)
Document databases always store values as tagged documents
d)
Document databases do not support CRUD operations
27.
Which NoSQL model is most appropriate for applications with complex relationships between entities?
a)
Document databases
b)
Graph databases
c)
Column-oriented databases
d)
Key-value databases
28.
What challenge do NewSQL databases aim to solve?
a)
Lack of scalability in relational databases
b)
Inability to process unstructured data
c)
Absence of a graphical user interface
d)
Shortage of SQL-skilled developers
29.
What best describes the difference between stream processing and feedback loop processing in Big Data velocity?
a)
Stream processing analyzes historical data, while feedback loop is real-time
b)
Stream processing handles input as it arrives; feedback loop uses it to take action
c)
Stream processing is slower and used for batch jobs
d)
Feedback loop processing is used only in relational databases
30.
What is the significance of the “veracity” characteristic of Big Data?
a)
It ensures the speed at which data is processed
b)
It measures the size of the dataset
c)
It addresses the trustworthiness and quality of the data
d)
It describes how well data fits into a predefined model
31.
In MapReduce, what is the role of the reducer program?
a)
It encrypts key-value pairs for secure storage
b)
It groups data into predefined categories
c)
It summarizes mapped data to generate final output
d)
It converts raw data into visual dashboards
32.
Which advantage is offered by using NoSQL databases for Big Data applications?
a)
Flexibility in data models suitable for unstructured and semi-structured data
b)
Automatic normalization of data
c)
In-built support for only structured data
d)
Strong adherence to traditional schema requirements
33.
Which statement best explains why ODBC is widely supported across many platforms?
a)
It uses a vendor-specific protocol.
b)
It allows applications to access any data source using a standard API.
c)
It only supports Microsoft SQL Server.
d)
It requires no installation on client systems.
34.
In the context of cloud computing, what is a significant advantage of using Infrastructure as a Service (IaaS)?
a)
Users must manage their own hardware.
b)
It provides prebuilt applications ready for immediate use.
c)
It limits configuration to predefined options.
d)
It offers scalable resources on demand with minimal setup.
35.
Why is XML beneficial in web database development?
a)
It encrypts data for transmission.
b)
It tightly couples data structure with its presentation.
c)
It replaces the need for any database backend.
d)
It separates data from presentation and supports structured data exchange.
36.
Which scenario best illustrates the use of Platform as a Service (PaaS) in cloud computing?
a)
Renting server hardware for hosting static websites.
b)
Using an online CRM like Salesforce.
c)
Developing and deploying an app using a provider’s development tools and infrastructure.
d)
Purchasing an off-the-shelf antivirus package.
37.
Why is the web considered a stateless system, and how does this affect web application development?
a)
Web pages do not use stylesheets; hence, state is lost
b)
Web servers do not retain information about client sessions by default.
c)
Browsers store all session data locally.
d)
JavaScript handles session persistence automatically.
38.
What is a main drawback of using native SQL connectivity from a developer’s perspective?
a)
It increases programming complexity due to vendor-specific interfaces
b)
It has no support for structured query language
c)
It cannot access enterprise-level databases
d)
It requires using only Java-based code
39.
What distinguishes XML from HTML in terms of data representation?
a)
XML allows users to define custom tags and structure data
b)
XML is used only for presenting data, HTML is for structure
c)
HTML supports data validation, XML does not
d)
HTML is case-sensitive, XML is not
40.
Why is cloud computing described as a potential “game changer” for businesses?
a)
It encourages organizations to build more in-house infrastructure
b)
It requires advanced hardware knowledge to set up
c)
It removes technological and financial entry barriers
d)
It forces vendors to switch to desktop solutions
41.
What differentiates private cloud from public cloud implementations?
a)
Private cloud services are always cheaper than public ones
b)
Private clouds are built and maintained for exclusive use by one organization
c)
Public clouds require users to manage their own infrastructure
d)
Public clouds cannot be accessed through APIs
42.
Which best explains why JDBC is a valuable tool for companies using Java?
a)
It eliminates the need for SQL knowledge.
b)
It allows Java programs to interact with databases using a standard interface.
c)
It is limited to Oracle databases only.
d)
It replaces the need for server-side extensions.
Reset
