Computer Science: CUET Mock Test - 1 - CUET Humanities MCQ

Assertion is correct because Database Management System (DBMS) provides a variety of software tools for organising, processing and querying data in a flexible manner. MS Access, Oracle, SQL Server, and IBM-DB2 are examples of DBMS software.
Reason is correct because normalisation is the process for removing data redundancy. It breaks up the information into separate but related tables.
Therefore, assertion and reason both are correct, but reason is not the correct explanation of assertion.

When we are allocating the memory using new operator and allocation fail, then bad_alloc exception is thrown by the program.

A file management system can typically access records from only one file at a time.

Both the Assertion and Reason are true, and the Reason is the correct explanation of the Assertion. Data is any form of information that can be processed by a computer, including text, numbers, images, audio, and video.

Top 10 most popular RDBMSs are:

• Oracle
• MySQL
• SQL Server
• PostgreSQL
• IBM DB2
• Microsoft Access
• SQLite
• MariaDB
• Informix
• Azure SQL

So, all the above is correct.

The PRIMARY KEY constraint uniquely identifies each record in a table. Primary keys must contain UNIQUE values, and cannot contain NULL values.

'Try' is used to define the code block where an exception might occur. 'Raise' is used to trigger a specific exception intentionally. 'Finally' defines the code block that will execute regardless of whether an exception occurs. 'Except' is used to handle the raised exception.

We can do all the above using computer networks.

The 'x' file access mode is used to open a file for exclusive creation. This mode allows you to create a new file but will raise an error if the file already exists. This mode is useful when you want to create a new file and ensure that it does not already exist. The 'a' file access mode is used to open a file for appending data to the end of the file. This mode allows you to write to the file but not overwrite any existing content. If the file does not exist, it will be created.

When stack is completely full (i.e. TOP= MaxSize -1) and we try to insert more elements onto stack then this condition is called overflow condition and no further element could be inserted now until any element is deleted.

Both the stack and queue are the linear data structure, which means that the elements are stored sequentially and accessed in a single run.

The major limitation of binary search is that there is a need for the sorted array to perform the binary search operation. If the array is not sorted the output is either not correct or maybe after a long number of steps and according to the data structure, the output should come in a minimum number of steps.
Not a limitation of Binary search :Binary search algorithm is not efficient when the data elements are more than 1000.

Both the Assertion and Reason are true, and the Reason is the correct explanation of the Assertion. Data visualization is the process of creating visual representations of data to communicate information effectively. It helps to uncover patterns, trends, and insights in data that might not be apparent in raw data, making it easier for decision-makers to understand and act on the data.

Data processing refers to the process of performing specific operations on a set of data or a database.
Process data is called information.

• (A+B)*(C+D) = (AB+)*(CD+) = AB+CD+*
• (A*B)+(C*D) = (AB*)+(CD*) = AB*CD*+
• (A+B)+(C*D) = (AB+)+(CD*) = AB+CD*+
• (A*B)+(C+D) = (AB*) + (CD+) = AB*CD+*

The Assertion is not correct and Reason are correct. A LAN (Local Area Network) is a computer network that connects devices within a small geographic area such as a building or a campus not city. LANs typically use wired or wireless connections to enable devices to communicate with each other and share resources such as printers and files.

All A, B and C are correct. Option 4 is the correct answer.

The software used to store, manage, query, and retrieve data stored in a relational database is called a relational database management system (RDBMS).

Data communication is a process of exchanging data or information. In case of computer networks, this exchange is done between two devices over a transmission medium. It cannot exchange person.

Adware is unwanted software designed to throw advertisements up on the user's screen.
Adware generates revenue for its developer by automatically displaying online advertisements in the user interface of the software or on a screen that pops up in the user's face during the installation process.
It is not self-replicating.

The correct matching pairs are

Statement I is correct because it follows the LIFO(Last in First Out). It means you can delete that element which comes first. Statement II is incorrect because elements can be deleted only from the top in Stack data structure.

ADD is not a keyword in SQL.

The union operator requires that both relations are union-compatible. This means that they are required to have the same set of attributes.

Metadata is the data about the data. Anything that describes the database—as opposed to being the contents of the database—is metadata. Metadata stored in the MySQL in the MySQL database mysql.

A DDL performs the following functions :

1. It identifies the type of data division such as data item, segment, record and database file.
2. It gives a unique name to each data item type, record type, file type and data base.
3. It specifies the proper data type.
4. It defines the size of the data item.
5. It may define the range of values that a data item may use.
6. It may specify privacy locks for preventing unauthorized data entry.

Correct Prefix notation for the (a+b)*(c-d) is *+ab-cd(a+b)*(c+d) = (+ab)*(-cd) = *+ab-cd (Statement I is Incorrect). Postfix notation for the (a+b)*(c-d) is *+ab-cd(a+b)*(c-d) = (ab+)*(cd-) = ab+cd -* (Statement II is Correct).

The 'is empty ( )' function can be also be written by using '? :'.

A stack pointer is a small register that stores the address of the last program request in a stack. A stack is a specialized buffer which stores data from the top down. Both stack and stack pointers reside in the memory.

A cookie stores information about the user's web activity.
They are small files often including unique identifiers that web servers send to browsers. They can be sent back to the server each time your browser requests a new page. It helps browsers remember your preferences and habits online.