Computer — All MCQs

4795 questions available

Showing 4721–4740 of 4795

Q4721.Which of the following actions is a Business Intelligence (BI) reporting system unable to perform?

Easy
A Filter data based on criteria
B Group and aggregate data
C Modify or update the underlying source data
D Both filter and group data
General MCQs PPSC

Correct Answer: C

BI reporting systems are designed to retrieve, aggregate, and present data for analysis, but they do not write back or modify the raw source databases.

Q4722.What is the primary role of a data pipeline in the context of data modeling and warehousing?

Easy
A To visualize relationships between database keys
B To calculate summary statistics of the output
C To define database schema attributes and properties
D To prepare, clean, and transform data from various sources for analysis
Computer Terminology PPSC

Correct Answer: D

A data pipeline extracts data from various source databases, transforms and cleanses it, and loads it into a warehouse for analytics.

Q4723.Under which database administration context does the execution privilege 'CREATE TABLESPACE' apply?

Easy
A Views management
B Tables structure
C Stored routines execution
D Server administration
Computer Terminology PPSC

Correct Answer: D

Creating tablespaces alters physical database storage files on the disk, making it a high-level server administration privilege.

Q4724.How does the SQL 'HAVING' clause function in database queries?

Easy
A Acts like a WHERE clause but is applied to grouped rows rather than individual rows
B Acts like a WHERE clause but is applied to columns rather than grouped rows
C Acts EXACTLY like a WHERE clause in all contexts
D Acts like a clause but is applied to rows rather than columns
Computer Terminology PPSC

Correct Answer: A

The HAVING clause filters grouped data sets created by the GROUP BY clause, whereas the WHERE clause filters individual rows before grouping.

Q4725.With which type of OSPF network connection will route adjacencies be established without performing a DR/BDR election?

Easy
A Point-to-point
B Backbone area 0
C Broadcast multi-access
D Non-broadcast multi-access
Computer Networks PPSC

Correct Answer: A

On point-to-point links (which only connect two routers), there is no need to elect a Designated Router (DR) or Backup Designated Router (BDR).

Q4726.What type of hardware virtualization is utilized by hypervisors like Microsoft's Hyper-V?

Easy
A Full virtualization
B Emulation
C Para-virtualization
D None of these
Computer Basics PPSC

Correct Answer: C

Hyper-V uses para-virtualization where guest operating systems are aware of the hypervisor and communicate with it for optimized hardware performance.

Q4727.What term defines the application of machine learning methods to discover patterns in very large databases?

Easy
A Internet of things
B Artificial intelligence
C Big data computing
D Data mining
Computer Terminology PPSC

Correct Answer: D

Data mining combines statistics and machine learning algorithms to uncover hidden patterns and relationships in massive data warehouses.

Q4728.Which of the following WAN encapsulation protocols can be successfully configured on an asynchronous serial link?

Easy
A PPP and ATM
B ATM and SDLC
C HDLC only
D SDLC and Frame Relay
Computer Networks PPSC

Correct Answer: A

Asynchronous serial connections commonly use Point-to-Point Protocol (PPP) and Asynchronous Transfer Mode (ATM) encapsulations.

Q4729.What is the standard administrative distance of the OSPF routing protocol?

Easy
A 90
B 100
C 110
D 120
General MCQs PPSC

Correct Answer: C

OSPF has a default Administrative Distance (AD) of 110. (In comparison, EIGRP is 90, RIP is 120, and static routes have an AD of 1).

Q4730.Which evaluation metric represents the ratio of correctly predicted positive instances to all actual positive instances in a dataset?

Easy
A Accuracy
B Precision
C Recall
D F1 Score
General MCQs PPSC

Correct Answer: C

Recall (also called sensitivity) measures a model's completeness by calculating True Positives divided by the sum of True Positives and False Negatives.

Q4731.What is the primary purpose of the Spanning Tree Protocol (STP) in a switched Local Area Network (LAN)?

Easy
A To monitor network performance across switched environments
B To prevent routing loops in networks with redundant paths
C To prevent switching loops in networks with redundant switched paths
D To manage and distribute the VLAN database across multiple switches
Computer Terminology PPSC

Correct Answer: C

STP prevents switching (layer 2) loops in redundant switched networks by dynamically blocking redundant paths to prevent broadcast storms.

Q4732.Telnet, which is used for remote command-line access to network devices, is what type of protocol?

Easy
A Sound-based protocol
B Image-based protocol
C Text-based protocol
D Animation-based protocol
MS PowerPoint PPSC

Correct Answer: C

Telnet is a simple, unencrypted text-based network protocol that transmits command-line keystrokes over TCP port 23.

Q4733.Which Cisco IOS command displays the configurable parameters and operational statistics for all interfaces on a router?

Easy
A show running-config
B show startup-config
C show versions
D show interfaces
Computer Networks PPSC

Correct Answer: D

The 'show interfaces' command provides detailed status, bandwidth, encapsulation, and packet error statistics for all router interfaces.

Q4734.Which of the following is NOT a valid Country Code Top-Level Domain (ccTLD)?

Easy
A .In
B .can
C .de
D .cat
General MCQs PPSC

Correct Answer: D

While '.In' (India) and '.de' (Germany) are ccTLDs, '.cat' is a sponsored top-level domain (sTLD) designed for Catalan language and culture.

Q4735.In problem-solving and Artificial Intelligence, what term describes experience-based rules of thumb used to simplify complex decisions?

Easy
A Heuristic
B Critical
C Value based
D Analytical
Computer Terminology PPSC

Correct Answer: A

Heuristics are intuitive, practical problem-solving methods or shortcuts that arrive at satisfactory solutions quickly.

Q4736.In which year was the Google Chrome web browser initially released to the public by Google?

Easy
A 2008
B 2007
C 2010
D 2009
Internet & Web PPSC

Correct Answer: A

Google Chrome was first released as a beta version for Windows on September 2, 2008.

Q4737.What is the strictest transaction isolation level supported by Microsoft SQL Server?

Easy
A REPEATABLE READ
B SERIALIZABLE
C READ COMMITTED
D READ UNCOMMITTED
Computer Terminology PPSC

Correct Answer: B

The SERIALIZABLE isolation level is the most restrictive; it locks the entire range of keys to prevent phantom reads and concurrency conflicts.

Q4738.What is the full form of the internet organization abbreviated as 'ICANN'?

Easy
A The Internet Corporation Active Names and Numbers
B The Internet Corporation for Assigned Names and Numbers
C The Internet Corporation for Archive Names and Numbers
D The Internet Corporation for Assigned Tames and Numbers
Internet & Web PPSC

Correct Answer: B

ICANN stands for the Internet Corporation for Assigned Names and Numbers, which coordinates DNS, IP allocation, and root server management.

Q4739.Which situation describes concurrent processes being in a state of deadlock?

Easy
A A process locks a resource while another process terminates normally
B All processes in the system complete execution and terminate
C All involved processes are blocked indefinitely waiting for resources held by each other
D All processes actively attempt to terminate other system operations
General MCQs PPSC

Correct Answer: C

A deadlock occurs when two or more processes cannot proceed because each is waiting for a resource held by another blocked process.

Q4740.In computer hardware, what is meant by a 'bottleneck'?

Easy
A A component that improves the performance of other hardware
B A component that limits the potential or performance of other hardware
C An unnecessary motherboard expansion component
D A hardware component that is always the fastest in the system
Computer Basics PPSC

Correct Answer: B

A bottleneck refers to a hardware component (like a slow CPU or storage drive) that limits the performance and potential of faster components (like a high-end GPU).