Computer Terminology

603 questions available

FILTER BY SUBTOPIC

All Common Computer Terms 2 Abbreviations 2 File Extensions 6 Operating Systems 99 Programming Basics 213 Database Basics 142 Common Technical Terms 138
Showing 581–600 of 603

Q581.Which fixed database role in Microsoft SQL Server has the authority to add or remove user IDs and manage database access?

Easy
A db_sysadmin
B db_accessadmin
C db_securityadmin
D db_setupadmin
Database Basics PPSC

Correct Answer: B

The db_accessadmin fixed database role is responsible for managing user access and security permissions within SQL Server.

Q582.Why is the following SQL statement erroneous? 'SELECT dept_name, ID, avg(salary) FROM instructor GROUP BY dept_name;'

Easy
A The non-aggregated column ID is selected but omitted from the GROUP BY clause
B The GROUP BY clause is not valid with the SELECT statement
C The avg() aggregate function cannot be selected alongside group elements
D None of the above options are correct
Database Basics PPSC

Correct Answer: A

When using aggregate functions (such as avg), all non-aggregated columns listed in the SELECT clause (like ID) must be explicitly specified in the GROUP BY clause.

Q583.Which of the following is NOT classified as a Database Management System (DBMS)?

Easy
A MySQL
B Microsoft Access
C IBM DB2
D Google
Database Basics PPSC

Correct Answer: D

Google is a web search engine and multinational technology firm, whereas MySQL, MS Access, and DB2 are relational database management systems.

Q584.How many types of quantification are formally available in the study of Predicate Logic within Artificial Intelligence?

Easy
A 4
B 2
C 1
D 3
Common Technical Terms PPSC

Correct Answer: B

Predicate logic utilizes exactly two quantifiers: the Universal quantifier (denoting 'for all') and the Existential quantifier (denoting 'there exists').

Q585.What term refers to a specialized subset of a data warehouse focused on a single business department or functional area?

Easy
A Data mart
B Association rules
C Flat files
D Database
Database Basics PPSC

Correct Answer: A

A Data Mart is a focused, departmental-level slice of a larger data warehouse designed to support a specific line of business (like marketing or sales).

Q586.What is the time complexity of the pre-processing phase of the Rabin-Karp pattern-matching algorithm, where 'm' is pattern length?

Easy
A Theta(m^2)
B Theta(m * log n)
C Theta(m)
D Big-Oh(n)
Programming Basics PPSC

Correct Answer: C

The Rabin-Karp pre-processing algorithm computes the initial hash of the pattern, taking Theta(m) time relative to the pattern's length.

Q587.What are the fundamental binary elements that make up a computer's machine language program?

Easy
A Statements
B Directives
C Injunctions
D Instructions
Programming Basics PPSC

Correct Answer: D

Machine language programs are composed of raw binary instructions (consisting of opcodes and operands) that the CPU executes directly.

Q588.Which of the following statements is/are correct regarding cloud computing deployments on AWS?

Easy
A Security can be configured via passwords, Kerberos tickets, or certificates
B Secure access to EC2 AMIs can be controlled via passwords, Kerberos, and X.509 certificates
C Most of the pre-made system image templates offered by Amazon AWS are based on Red Hat Linux
D All of the above statements are correct
Operating Systems PPSC

Correct Answer: D

All listed statements are accurate regarding Amazon Web Services' security models, access controls, and RHEL template environments.

Q589.In MySQL database administration, which command option is used to enable the binary log index file?

Easy
A –log-bin-index
B –bin-log-index
C –index-log-bin
D –index-bin-log
Database Basics PPSC

Correct Answer: A

The MySQL startup parameter '--log-bin-index' is used to specify the file name and path for the binary log index file.

Q590.Google Language Translator is a classic, widely used application of which computer science discipline?

Easy
A Internet Protocols
B Software Debugging
C Computer simulations
D Machine learning
Common Technical Terms PPSC

Correct Answer: D

Google Translate uses advanced deep machine learning and natural language processing (NLP) models to translate text across languages.

Q591.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
Database Basics 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.

Q592.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
Database Basics PPSC

Correct Answer: D

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

Q593.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
Database Basics 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.

Q594.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
Database Basics PPSC

Correct Answer: D

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

Q595.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
Database Basics PPSC

Correct Answer: C

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

Q596.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
Common Technical Terms PPSC

Correct Answer: A

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

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

Easy
A REPEATABLE READ
B SERIALIZABLE
C READ COMMITTED
D READ UNCOMMITTED
Database Basics 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.

Q598.What is a hardware box or chassis that houses multiple hard disk drives combined together called?

Easy
A Hard disk array
B Disk enclosure
C Storage unit
D None of these
Programming Basics PPSC

Correct Answer: A

A collection of multiple hard disk drives grouped together in a single system to provide storage or RAID is called a Hard Disk Array.

Q599.In the Microsoft Windows operating system, what is the function of the 'Windows Key + M' shortcut?

Easy
A Minimize all open windows
B Open system properties
C Lock the active screen
D Switch active user account
Operating Systems PPSC

Correct Answer: A

Pressing the Windows Key and letter M simultaneously minimizes all active application windows to the taskbar.

Q600.A standard computer Byte is fundamentally constructed from which of the following elements?

Easy
A Array of bits
B Collection of bytes
C Sequence of characters
D Group of pixels
Programming Basics PPSC

Correct Answer: A

A Byte is a standardized unit of digital data formed by a contiguous array of exactly 8 bits.