MCQ Bank

A data structure describes the conceptual organization or arrangement of data and the relationships among its elements. Examples include arrays, linked lists, stacks, queues, and trees.

CS101 Final Term AI Solved

Q146

In the case of ________that are subject to heavy transaction loads, it is highly likely that a random snapshot will find the database in the middle of some transaction.

A) web development
B) small database
C) object oriented programming
D) large databases

AI Explanation

Python supports functional programming features such as higher-order functions, lambda expressions, and functions like map, filter, and reduce. Although Python is multi-paradigm, it can be used with the functional paradigm.

CS101 Final Term AI Solved

Q147

This conceptual view of the database is called a ________ model.

A) Database
B)
C)
D)

AI Explanation

The conceptual view of a database describes the overall structure and organization of the data. This is represented by a database model.

CS101 Final Term AI Solved

Q148

In case of an equipment malfunction, the DBMS uses the log to reconstruct ______.

A) the entire database from scratch
B) only incomplete transactions
C) completed transactions since the last backup
D) non-committed transactions

AI Explanation

Cyberbullying involves using electronic communication and digital technologies to harass, threaten, or intimidate others. It is therefore an example of misuse involving electronic communication.

CS101 Final Term AI Solved

Q149

Shortcut key of paste is:

A) Ctrl+V
B)
C)
D)

AI Explanation

Ctrl+V is the standard keyboard shortcut for pasting content from the clipboard. It is commonly used after copying or cutting text, files, or other objects.

CS101 Final Term AI Solved

Q150

A transaction requiring exclusive access will ___________.

A) Automatically gain access without checks
B) Grant shared access to other transactions
C) Be forced to wait if the item is already exclusively locked
D) Share the access with other transactions

AI Explanation

The question is incomplete because the available choices are missing and only “REVIEW REQUIRED” is shown. A relational operator normally includes operators such as =, <>, <, >, <=, and >=, but the intended non-relational option cannot be identified from the provided choices.

CS101 Final Term AI Solved

Q151

The format in which information is displayed by spreadsheet programs is similar to the format used in the ________.

A) Hierarchical model
B) Network model
C) Object-oriented model
D) Relational model

AI Explanation

In Microsoft Word, the Text Highlight Color feature is available in the Font group. It allows users to highlight selected text with a chosen background color.

CS101 Final Term AI Solved

Q152

The PROJECT operation allows extraction of columns and places the result in a __________.

A) Matrix
B) New row
C) New relation
D) Existing column

AI Explanation

Artificial intelligence enables automated systems to process information and deliver reports electronically. Email allows these reports to be sent directly to a user's home or other location.

CS101 Final Term AI Solved

Q153

Today, database technology, combined with _________ techniques,

A) data mining
B) Sentiment analysis
C) text mining
D) opening mining

AI Explanation

The CAN-SPAM Act is a United States law that regulates commercial email messages. It establishes requirements for senders and gives recipients certain rights regarding unsolicited commercial email.

CS101 Final Term AI Solved

Q154

What could best describe the application of a one-dimensional array with 26 elements?

A) Tracking alphabet letter occurrences
B) Representing monthly sales and profit
C) Managing skill ratings and reviews of employee data
D) Storing student data

AI Explanation

Social issues can arise from the effects of technology on individuals and society, including privacy, security, access, and ethical concerns. Therefore, when all listed choices represent social issues, “All of given” is correct.

CS101 Final Term AI Solved

Q155

The following statement extracts __________ from the EMPLOYEE relation. MAIL <- PROJECT Name, Address from EMPLOYEE

A) Names and Addresses
B) Addresses only
C) Names only
D) Phone numbers

AI Explanation

The equals sign (=) is commonly used as the assignment operator in programming. It assigns the value on the right-hand side to the variable on the left-hand side.

CS101 Final Term AI Solved

Q156

To retrieve information about an employee, we perform ______ operation on the EMPLOYEE relation.

A) SELECT
B) UPDATE
C) INSERT
D) DELETE

AI Explanation

A database is a collection of organized data with relationships among its entries. These relationships allow information to be accessed and viewed from different perspectives.

CS101 Final Term AI Solved

Q157

In the context of data structures, what is the primary use of pointers?

A) To serve as a counter in loops
B) To record the location of data items
C) To delete instructions
D) To store string data type

AI Explanation

The statement z=x+y calculates the sum of x and y and assigns the resulting value to z. The equals sign here acts as an assignment operator.

CS101 Final Term AI Solved

Q158

A typical database application involves two major layers: the application layer and the __________ management layer.

A) user
B) database
C) data
D) schema

AI Explanation

Weizenbaum's DOCTOR, commonly known as ELIZA, produced responses that sometimes convinced users they were interacting with a human. Its Turing test performance was therefore considered ambiguous rather than conclusively successful.

CS101 Final Term AI Solved

Q159

What does a tree structure's hierarchical organization resemble?

A) Array
B) Graph
C) Organization chart
D) Stack

AI Explanation

The software life cycle describes the systematic process used to design, develop, test, deploy, and maintain software. It provides structured stages for producing high-quality software.

CS101 Final Term AI Solved

Q160

In a tree structure, what is the top node called?

A) Parent node
B) Terminal node
C) Leaf node
D) Root node

AI Explanation

Ctrl+A is the standard keyboard shortcut for selecting all content in a document. It selects the entire text or all selectable content in the current document or application.

CS101 Final Term AI Solved

Q161

Changes in the database schema for a single user involve modifying the overall schema and the subschemas of __________ users involved in the change.

A) other
B) all
C) selected
D) new

AI Explanation

In the incremental model, prototypes are progressively refined as requirements and functionality are added. This evolution continues until the prototype becomes the complete final system, a process called evolutionary prototyping.

CS101 Final Term AI Solved

Q162

Why is a stack considered a LIFO structure?

A) Entries are removed in the reverse order of storage
B) Entries are removed from the base
C) Entries are removed from the middle
D) Entries are removed in the order they were stored

AI Explanation

In Microsoft Word, the Design tab includes document formatting features such as Page Borders. Page Borders can be used to add borders around pages.

CS101 Final Term AI Solved

Q163

The problem known as the ____________ can arise if one transaction is in the middle of transferring funds from one account to another when another transaction tries to compute the total deposits in the bank.

A) potential problem
B) incorrect summary problem
C) time sharing
D) lost update problem

AI Explanation

After the design phase, the system is implemented by translating the design into working code or components. This phase is commonly followed by testing and verification.

CS101 Final Term AI Solved

Q164

How does a program counter function as a pointer?

A) It holds the address of the next instruction
B) It updates the value of data items
C) It stores numeric values
D) It decode data in memory cells

AI Explanation

The commit point is reached when all steps of a transaction have been recorded in the log and the transaction is considered successfully completed. After this point, the transaction's effects can be made permanent.