MCQ Bank

Image analysis involves examining an image to understand its characteristics, contents, or meaning. It can include identifying objects, patterns, shapes, and other visual features.

CS101 Final Term AI Solved

Q141

How are positions in a one-dimensional array identified?

A) By an index numbers
B) Field names
C) Pairs of indices
D) Rows and columns

AI Explanation

The conceptual view of a database describes the overall logical organization of data and relationships. This view is commonly represented through a database model.

CS101 Final Term AI Solved

Q142

What is an aggregate type in programming?

A) An integer variable
B) 2-dimensional array
C) Block of data items with different data types
D) Rectangular array of numbers

AI Explanation

An index is normally maintained as a separate file associated with the indexed data file. It helps locate records efficiently without searching the entire data file.

CS101 Final Term AI Solved

Q143

If we seek the JobTitle column within a relation named NEW1, the expression would be: SELECT _____ FROM NEW1;

A) Department
B) EmployeeID
C) Salary
D) JobTitle

AI Explanation

Declarative programming paradigms focus on describing what result is required rather than specifying every step to obtain it. They can be designed for several purposes and applications, so “All of these” is the intended answer.

CS101 Final Term AI Solved

Q144

Operations that are only partially completed in commercial systems might lead to ___________ information in the database.

A) Accurate
B) Verified
C) Valid
D) Incomplete

AI Explanation

A design pattern is a reusable, pre-developed solution to a recurring problem in software design. It provides a general approach that can be adapted to particular programming situations.

CS101 Final Term AI Solved

Q145

In a two-dimensional array, what does the second index in a pair identify?

A) Field name
B) Row associated with the position
C) Column associated with the position
D) Numerical index number

AI Explanation

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.