BPSC COMPUTER 25 YEARS PAST PAPERS
BPSC 5
years Past Papers Click
here
چار آپشن میں سے کسی ایک پر کلک کرنے سے جواب سرخ ہو جائے گا۔
مندرجہ ذیل میں سے کون بڑی میزوں کو چھوٹی چھوٹیوں میں تقسیم کرکے استفسار کی کارکردگی کو بڑھاتا ہے؟
- Replication
- Partitioning
- Normalization
- None of these
اس سوال کو وضاحت کے ساتھ پڑھیں
Explanation
Partitioning divides a large table into smaller, manageable parts based on ranges, lists, or hashes.
It improves query performance and maintenance efficiency, especially for large datasets.
- Max()
- Sum()
- Avg()
- All of them
اس سوال کو وضاحت کے ساتھ پڑھیں
Explanation
MAX(), SUM(), and AVG() all ignore NULL values during calculation.
Only non-NULL values are considered when computing SQL aggregate results.
ڈیڈ لاکس کی موجودگی کو کم سے کم کرنے میں کون سی لاکنگ حکمت عملی سب سے زیادہ موثر ہے؟
- Exclusive
- Pessimistic
- Optimistic
- None of these
اس سوال کو وضاحت کے ساتھ پڑھیں
Explanation
Optimistic locking assumes conflicts are rare and avoids holding locks during transactions.
By reducing lock holding time, it minimizes the chances of deadlocks.
- Neo4j
- MongoDB
- Cassandra
- None of these
اس سوال کو وضاحت کے ساتھ پڑھیں
Explanation
Cassandra is a column-oriented (wide-column) NoSQL database, where data is stored in column families.
It is designed for high scalability, high availability, and fast writes across distributed systems.
ایک کلسٹرڈ انڈیکس بنیادی طور پر _____ کو متاثر کرتا ہے؟
- Data backups
- Query speed only
- Physical data order
- None of these
اس سوال کو وضاحت کے ساتھ پڑھیں
Explanation
A clustered index determines the physical order of data rows in a table.
Because data is stored in this order, it can significantly improve range query performance.
کون سی نارملائزیشن فارم عبوری انحصار کو حل کرتا ہے؟
- 1NF
- 2NF
- 3NF
- None of these
اس سوال کو وضاحت کے ساتھ پڑھیں
Explanation
Third Normal Form (3NF) eliminates transitive dependencies, where a non-key attribute depends on another non-key attribute.
It ensures that all non-key attributes depend only on the primary key, improving data integrity.
ویکٹر کے اعداد و شمار کا نقصان کون سا ہے؟
- Not suitable for network analysis
- Poor thematic detail
- Large file size for complex geometry
- None of these
اس سوال کو وضاحت کے ساتھ پڑھیں
Explanation
Vector data can result in large file sizes when representing highly detailed or complex geometries.
This can make storage and processing slower compared to simpler datasets.
Despite this, vector data is excellent for precise location and network analysis.
جی آئی ایس لیئرنگ _____ کی اجازت دیتا ہے؟
- Run macros
- Add music
- Overlay multiple datasets
- None of these
اس سوال کو وضاحت کے ساتھ پڑھیں
Explanation
GIS layering allows users to overlay multiple datasets (like roads, rivers, and land use) for spatial analysis.
Each layer represents a different type of geographic information.
Layering enables complex map creation and decision-making by combining various spatial data.
کمپیوٹر نیٹ ورکس میں فائر وال کا بنیادی کام کیا ہے؟
- To prevent/block unauthorized access
- To block viruses
- To speed up network traffic
- None of these
اس سوال کو وضاحت کے ساتھ پڑھیں
Explanation
A firewall is a security system that monitors and controls incoming and outgoing network traffic.
Its primary function is to prevent unauthorized access to or from a private network by filtering data based on security rules.
ایکسل میں چارٹ کی کون سی قسم حصوں کا مجموعی تناسب دکھانے کے لیے بہترین ہے؟
- Pie Chart
- Bar Chart
- Lines Chart
- None of these
اس سوال کو وضاحت کے ساتھ پڑھیں
Explanation
A pie chart is best suited for showing the proportion of parts to a whole.
As it visually represents data as slices of a circle.
It highlighting the relative sizes of components.
