Showing 1–20 of 142

Q1.In formal database system rows are called :

Easy
A Record
B Field
C Header
D Range
Database Basics PPSC 2026

Correct Answer: A

In database terminology, rows are called records and columns are called fields.

Q2.Normalization in database through?

Medium
A Minimize data
B Delete data
C Copy data
D Increase data
Database Basics PPSC 2026

Correct Answer: A

Database normalization minimizes data redundancy and improves data integrity.

Q3.Is a fundamental Data structure in computer science that stores a collection of elements, typically of the same data type in contiguous memory location?

Hard
A Data Array
B Data Storage
C Data Recovery
D None of these
Database Basics PPSC 2026

Correct Answer: A

Q4.A collection of related data is called ____?

Easy
A Database
B Software
C Hardware
D None of these
Database Basics PPSC

Correct Answer: A

A database is an organized collection of related data structured for easy access, storage, management, and modification.

Q5.In relational databases, which property of ACID ensures that a transaction is completed entirely or not executed at all?

Easy
A Atomicity
B Consistency
C Isolation
D None of these
Database Basics PPSC

Correct Answer: A

Atomicity follows the 'all-or-nothing' principle, ensuring a database transaction is either fully completed or completely rolled back.

Q6.What is information about data called?

Easy
A Database
B Metadata
C Spreadsheet
D None of these
Database Basics PPSC

Correct Answer: B

Metadata is defined structurally as data about data, providing descriptions or summaries of information such as file size, type, or author.

Q7.SQL stands for _____?

Easy
A Structured Query Language
B Sequence Query Language
C Structured Query Logo
D None of these
Database Basics PPSC

Correct Answer: A

SQL stands for Structured Query Language, a standard programming language used to query and manage relational database systems.

Q8.Which programming language is commonly used for mobile app development?

Easy
A Java
B HTML
C SQL
D None of these
Database Basics PPSC

Correct Answer: A

Java is commonly used for developing mobile applications, particularly the native platform code for Android devices.

Q9.Which one is an example of database designing software?

Easy
A MS Word
B MS Excel
C MS Access
D None of these
Database Basics PPSC

Correct Answer: C

Microsoft Access is a relational database management software included in the Microsoft Office suite, designed to create, query, and edit databases.

Q10.Which of the following is a feature of a relational database?

Easy
A Stores data in tables with rows and columns
B Only allows sequential storage of data
C Does not support queries
D Uses key-value pairs exclusively
Database Basics PPSC

Correct Answer: A

A Relational Database organizes and stores data in a structured tabular format of related horizontal rows and vertical columns.

Q11.The SQL command used to retrieve data from a database table is?

Easy
A SELECT
B FETCH
C RETRIEVE
D None of these
Database Basics PPSC

Correct Answer: A

The SELECT statement is the standard SQL command utilized to extract and query specific data records from a database table.

Q12.LLM (Large Language Model) belongs to which field?

Easy
A Cyber Security
B Database Management
C Artificial Intelligence (AI)
D None of these
Database Basics PPSC

Correct Answer: C

Large Language Models (LLMs) are advanced neural network models that belong to the field of Artificial Intelligence, specifically Natural Language Processing (NLP).

Q13.Which of the following is NOT a deep learning framework?

Easy
A PyTorch
B Keras
C TensorFlow
D MySQL
Database Basics PPSC

Correct Answer: D

PyTorch, TensorFlow, and Keras are popular deep learning coding frameworks, whereas MySQL is an SQL-based relational database.

Q14.Which of the following is primarily a NoSQL/Big Data tool used in data science?

Easy
A Photoshop
B AutoCAD
C Hadoop
D Notepad
Database Basics PPSC

Correct Answer: C

Apache Hadoop is an open-source big data framework designed for distributed storage and processing of massive datasets across computing clusters.

Q15.Foreign key is?

Easy
A A key that uniquely identifies a record in the same table
B A key used to delete records
C A field in one table that refers to the primary key of another table
D A password for database security
Database Basics PPSC

Correct Answer: C

A Foreign Key is a table column that references the Primary Key of another table, establishing logical links and relational integrity between them.

Q16.SQR stands for?

Easy
A Structured Query Report
B Simple Query Reporter
C Structured Query Reporter
D None of these
Database Basics PPSC

Correct Answer: C

SQR stands for Structured Query Reporter, a database programming and reporting language used to compile formatted reports.

Q17.What is a prompt injection attack?

Easy
A A hardware failure
B An attempt to manipulate an AI model through malicious instructions
C A type of image filter
D A database error
Database Basics PPSC

Correct Answer: B

Prompt injection is an exploit targeting LLMs where untrusted inputs are used to override the system instructions and hijack model behavior.

Q18.What is a user prompt?

Easy
A The instruction entered by the user to guide the AI
B A hardware chip
C A hidden database
D A printer setting
Database Basics PPSC

Correct Answer: A

A user prompt is the text instruction or query entered into an AI interface to initiate a response.

Q19.What is a 'neuron' in an artificial neural network?

Easy
A A database
B A type of CPU
C A basic computational unit
D A storage device
Database Basics PPSC

Correct Answer: C

An artificial neuron is the core mathematical block of a neural network that receives inputs, applies weights, and produces an output.

Q20.An algorithm that improves automatically through experience is the core idea of?

Easy
A Networking
B Database management
C Word processing
D Machine Learning
Database Basics PPSC

Correct Answer: D

Machine learning is the scientific study of algorithms that allow computers to learn and improve tasks automatically using data.