Computer Science: CUET Mock Test - 6 - CUET MCQ

Normalization is a process that is used to eliminate redundant data and to ensure that data is stored in a way that minimizes data dependency. It involves dividing a larger table into smaller tables and defining relationships between them to reduce data redundancy and improve data integrity.

A single row of a table, which contains a single record for that relation is called a tuple.

A repeater is a device that operates only in the physical layer. Signals that carry information within a network can travel a fixed distance before attenuation endangers the integrity of the data.

The strupr( ) function is used to convert a given string to uppercase.

A network packet is a formatted unit of data carried by a packet-switched network. Computer communications links that do not support packets, such as traditional packet switching, simply transmit data as a bit stream. When data is formatted into packets, the bandwidth of the communication medium can be better shared among users than with circuit switching. A packet consists of control information and user data, which is also known as the payload. Control information provides data for delivering the payload, for example: source and destination network addresses, error detection codes, and sequencing information. Typically, control information is found in packet headers and trailers.

Option 1 is the correct answer. The address range of this class is from 128.0.0.0 to 191.255.255.255.

Statement I is correct. Hashing technique is very fast and efficient for large collections, but requires additional memory to store the hash table. Statement II is a fact for Linear Search not for a Binary Search. Binary Search technique reduces the search space by half at each step, making it faster than linear search for larger collections.

Opening a CSV file is simpler than you may think. In almost any text editor or spreadsheet program, just choose File > Open and select the CSV file.

• Join command combines rows from two or more tables.
• Group By command groups the result set by specified columns.
• Order By command sorts the result set based on a specified column.
• Where clause filters the result set based on specified conditions.

Sorting is the process of arranging data into meaningful order so that you can analyze it more effectively.

The ''/'' operator cannot be used with string data type, while the rest three can be used for strings data type.

Option 1 is the correct answer.
Exception handling in Python allows for graceful recovery from errors and prevents program crashes. When an error occurs during program execution, Python's exception handling mechanism allows the program to gracefully handle the error and take corrective action, rather than crashing the program entirely. This can be achieved by wrapping potentially error-prone code in a try-except block, where the except block catches any exceptions that are raised and takes appropriate action.

Database management systems are intended to eliminate data redundancy, establish relationships among records in different files and manage file access. Since all of the given options are true, option 4 is the correct answer.

Dos attack is the type of attack intended to make resources or service unavailable to its intended users. Such DOS attacks are carried out on websites to stop them from functioning.

The most reliable way to make sure you are safe is to open an email attachment or click on a link is to scan it with anti-virus software.

'tup1[2]=20' will make an error.
Here, the first option 'print(tup1[2])' will display the value at the position.
Therefore, print(tup1[2])=25. The starting position is 0.
print(min(tup1)) will display the minimum value in that tuple.
Here, print(min(tup1))=10
print(len(tup1)) will give output as the tuple length.
print(len(tup1)) = 4
But, tup1[2]=20 means assigning a new value to the position.
In tuples, values are constant.
So, tup1[2]=20 will result in an error.

In a relational database, a primary key is a unique identifier for each record in a table. A primary key cannot be null, and it must have a unique value for each record in the table. The primary key is used to identify each record in the table and to ensure data integrity by preventing duplicate records from being inserted into the table. Therefore, the reason does not correctly explain the assertion.

• There are some codes to handle a file in a programming language.
• myfile=open('student. txt', 'w') is the mode that allows opening a file in write mode.
• myfile=open('student.txt', 'r') is the mode that open file in only read mode.
• myfile= open ('student.txt') is also allowed to open in reading mode.

The pickle module implements binary protocols for serializing and de-serializing a Python object structure.

Here, Check will be treated as a string, not a tuple, as there is no comma after the element.

The conversion using stack is as follows:

The correct option is B
A → III, B → I, C → IV, D → II

Concept:
Match the following:
A: Modem → III: The device used for conversion between electric signals and digital bits.
B: Ethernet card → I: A network adapter is used to set up a wired network.
C: Repeater → IV: Regenerate the signals.
D: Switch → II: Connect multiple computers.

The correct answer is option C.

Concept:
Queues:
The queue is an abstract data structure, somewhat similar to Stacks.
Unlike stacks, a queue is open at both ends. One end is always used to insert data (en queue) and the other is used to remove data (de queue). Queue follows the First-In-First-Out methodology, i.e., the data item stored first will be accessed first.
Queue follows the principle of First In First Out (FIFO) and Last In Last Out (LILO)
maxsize:
The maximum number of items in the queue. 
put(item): 
Add something to the queue. Wait until a free spot becomes available if the queue is filled before adding the item. 
qsize(): 
Return the number of items in the queue.
full():
If there are maxsize items in the queue, return True. 
get():
A queue item can be removed and returned. Wait until an item is available if the queue is empty.
empty():
Return True if the queue is empty, False otherwise. Here queue is not empty because the still elements are there in the queue. Example:
Explanation:
from queue import Queue
q=Queue(maxsize=10)
q.put('A')
q.put('AA')
q.put('AAA')
print(q.qsize())
print(q.full())
print(q.get())
print(q.empty())
Hence the correct answer is empty().

The evaluation of the expression is as follows:

The correct option is C
1 → IV, 2 → II, 3 → I, 4 → V, 5 → III

• Bus topology → Each communicating device connects to a transmission medium.
• Ring topology → Each node is connected to two other devices, one each on either side.
• Mesh topology → Each communicating device is connected with every other device.
• Star topology → Each communicating device is connected to a central node.
• Hybrid topology → Each branch can have one or more basic topologies.

The correct answer is option D.

Concept:
Arithmetic Error:

An arithmetic Error is simply an error that occurs during numeric calculations. ArithmeticError types in Python include:

Over Flow Error.
Zero Division Error.
Floating Point Error.
All of these errors have the potential to cause Python programming to crash. Because we do not want our code to fail as a result of improper input from us or a user, it is crucial to capture errors.

Example:
Zero Division Error.:

try:
  arithmetic = 5/0
  print(arithmetic)
except ArithmeticError:
  print('Has error')

Over Flow Error:
import math
try:
    print("The exponential value is")
    print(math.exp(1000))
except OverflowError as oe:
    print("After overflow", oe)

Floating Point Error:
It happens frequently when a system handles floating-point numbers internally. This issue arises from floating-point numbers' underlying representation, which employs a set number of binary digits to represent a decimal integer. Since it might be challenging to convert a decimal integer to binary, roundoff mistakes frequently occur.

Hence the correct answer is All the above.

Concept:
Conversion of the domain name of each web server to its corresponding IP address is called domain name resolution. It is done through a server called DNS server.

• A DNS server keeps a list of domain names and the IP addresses that go with them. Knowing how and where the DNS servers are housed is necessary to comprehend how domain name resolution functions.
• The DNS servers are organized in a hierarchy. There are 13 servers known as root servers at the highest level. There are then other DNS servers at various levels below the root servers.
• The HTTP protocol contacts a computer server called a DNS server when we type a URL into a web browser to get the IP address associated with that domain name.
• The process of obtaining a physical address from a machine or a virtual address that a network node or computer peripheral has sent is known as address resolution or name resolution.

Mean is the arithmetic average of a data set. This is found by adding the numbers in a data set and dividing by the number of observations in the data set.
The median is the middle number in a data set when the numbers are listed in either ascending or descending order.
MODE is the value of the observation which has the maximum frequency.
The Standard deviation is a measure of dispersion. It is the action or process of distributing thing over a wide area (nothing about central location)
∴ The Standard deviation is not a measure of central tendency.

• Python provides the append() method to add elements to the top of a stack, until an overflow condition is encountered.
• The operation of entering elements into a stack is called a Push operation, but Python does not have any in-built function with the same name.
• The insert() and add() are not valid Python functions.

• In bubble sort, selection sort, and insertion sort, two loops are required to sort the array into an ascending or descending order.
• The outer loop determines the number of passes and runs as many times as there are elements in the array.
• The inner loop for bubble sort compares every element with the adjacent element to determine their order.
• The inner loop for selection sort runs through the array to determine the smallest element and then swaps it to the relevant position.
• The inner loop for insertion sort determines the correct position for an element in the sorted part of the list by running through the sorted list.
• As a result, all three algorithms have two loops, each running approximately n times, where n is the number of elements in the array.
• Therefore, the bubble sort, selection sort, and insertion sort algorithms all have a time complexity of n².