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

In Python, we use the hash symbol # to write a single-line comment.

" .py " is the correct extension of the Python file.
.PY file is a program or script written in Python, which is an interpreted object-oriented programming language. It may be written in a text editor and may be edited, but it must be run using a Python interpreter. .PY files are often used to program web servers and other administrative computer systems.

Linear search has a time complexity of O(n), which means that it takes linear time to search an array. This makes it inefficient for large arrays, as the time taken to search the array grows linearly with the size of the array. Therefore, whether linear search is a simple and easy-to-implement algorithm, it is not efficient for large arrays.

SQL stands for Structured Query Language. It lets you access and manipulate databases and became a standard of the American National Standards Institute (ANSI) in 1986, and of the International Organization for Standardization (ISO) in 1987.

• Primary key is a key that uniquely identifies each record in a table.
• Foreign key is used to establish a relationship between two tables.
• Candidate key can be used as a primary key and is unique for each record.
• Composite key is composed of two or more columns and is used to uniquely identify each record in a table.

A router is a networking device that forwards data packets between computer networks. Routers perform the traffic directing functions on the Internet. Data sent through the internet, such as a web page or email, is in the form of data packets.

The 'readline()' function can be used to read the first line of a text file Myfile. txt. Hence, the correct answer is option 3.

The "a" mode allows you to open a file to append some content to it. If we want to add a new line to it, we can open it using the "a" mode (append) and then, call the write() method, passing the content that we want to append as argument.

ALTER TABLE statement is used to add a new column to an existing table in SQL. INSERT ROW statement is not used to insert the Row to an existing table in SQL. INSERT INTO is used to insert the Row.

No, Python does not support labels and goto. It's a (highly) structured programming language.

Concept of slicing is used in this question. In string slicing, the output is the substring starting from the first given index position i.e. 2 to one less than the second given index position i.e. (8 - 1 = 7) of the given string str1. Hence, the output will be "format".

The process of identifying a slot for the second and further items in the hash table in the event of collision, is called collision resolution.

Yes, All (1), (2) and (3) are the advantages of a database management system.

The binary heap data structure takes O(n) time to build, and the repeated extraction and placement operations take O(log n) time. Hence, the total worst-case time complexity of Heap Sort is O(n log n).

• Selection Sort: O(n²) - This occurs when the array is in reverse sorted order or any other order, as the algorithm has to traverse the entire array to find the minimum element repeatedly.
• Radix Sort: O(nk), where n is the size of the array and k is the number of digits in the largest number.
• Count Sort: O(n+k), where n is the number of elements to be sorted, and k is the range of input values.

In Python, any non-zero value is considered True. So, it will evaluate to true.

A DNS secondary server gets its data from another DNS server. A primary/secondary DNS server setup is a master/slave setup where the primary DNS server is the master and the secondary DNS server is the slave.

Binary search takes a sorted/ordered list and divides it in the middle.

Variable names should not start with a number.

Tuple is the data type of L.

• A list contains python objects and objects inside are separated by comma (,) and enclosed within square brackets.
• A tuple is almost like a List and contains python objects and objects inside are separated by comma (,) and enclosed within parentheses.
• Dictionary in Python is used to store data values in an unordered collection. For storing data in a dictionary, keys are used. It's like a key: value pair in which data is held by unique keys.

In the print(), indexing is used. L1[0] denotes [1, [2, 3], 4]. L1[0][1] denotes [2, 3].
L1[0][1][1] = 3 and L1[2] = 8
Thus, the two integers are added: 3 + 8 = 11 and the output comes out to be 11.

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.