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

Python is an interpreted, object-oriented, high-level programming language with dynamic semantics.

Python uses indentations to define blocks of code. Indentations are simply spaces or tabs used as an indicator that is part of the indent code child, as used in curly braces C, C++, and Java.

Network security is essential to protect computer networks from unauthorised access, use, disclosure, disruption, modification, or destruction. It includes measures such as firewalls, encryption, and access control to prevent or detect unauthorised access to network resources, ensuring the confidentiality, integrity, and availability of data and network resources. Hence, option 1 is the correct answer.

A foreign key is a field (or collection of fields) in one table, that refers to the primary key in another table. The table with the foreign key is called the child table, and the table with the primary key is called the referenced or parent table.

CREATE command is a data definition language command but not a data manipulation command. Data manipulation command is used to manipulate the data of those tables that are created by Data definition languages.

This networking component is called a three-layer switch. It can operate at the physical, data link and network layers. A layer 3 switch combines the functionality of a switch and a router. It acts as a switch to connect devices that are on the same subnet or virtual LAN at lightning speeds and has IP routing intelligence built into it to double up as a router.

Operator ''/'' can not be used with string data type.

The readlines() method returns a list containing each line in the file as a list item. The hint parameter is used to limit the number of lines returned. If the total number of bytes returned exceeds the specified number, no more lines are returned.

Cloud computing, artificial intelligence, and machine learning are all essential technologies for IoT. Cloud computing provides the necessary infrastructure to store and process the vast amounts of data generated by IoT devices. Artificial intelligence and machine learning enable IoT devices to learn from the data they collect and make more intelligent decisions. The purpose of IoT is to make everyday objects smarter and more connected, enabling them to communicate with each other and with humans to perform tasks more efficiently and effectively.

• 'append()' adds an element to the end of the list.
• 'clear()' removes all elements from the list.
• 'extend()' extends the list by appending elements from an iterable.
• 'reverse()' reverses the order of the elements in the list.

Pickle in Python is primarily used in serializing and deserializing of a Python object structure. In other words, it's the process of converting a Python object into a byte stream to store it in a file/database, maintain program state across sessions, or transport data over the network.

In linear queue, an insertion takes place from one end while the deletion occurs from another end. The end at which the insertion takes place is known as the rear end, and the end at which the deletion takes place is known as the front end.

Infix notation is the most commonly used notation in mathematics, but it is not necessarily because it is easy to read and understand. Infix notation is commonly used because it is the most intuitive notation for humans to use. On the other hand, while it is true that most programming languages use infix notation as their default notation, this is not the reason why infix notation is the most commonly used notation in mathematics.

Processing is any computer program that is not a control program, such as an application program, or a non-controlling part of the operating system, such as a sort-merge program or language translator.

Data base security and integrity are two advantages of the data base management system. Central control also ensures that adapted checks are incorporated.

A firewall is an essential piece of security software that monitors all incoming and outgoing traffic going through your network, checking for hackers, malware, unauthorized outgoing information, or anything that might put you or your PC at risk. Firewalls are often the first line of defense when protecting your data.

In-circuit switching when the source does not have enough data to transmit, the resources are unnecessarily kept idle. To avoid such situation, Message switching is used.
Circuit Switching is a switching technique method that establishes a dedicated path between the sender and the receiver to send the data. The example of a Circuit-switch network is a telephone network.

A tuple is almost like a List and contains python objects and objects inside are separated by comma (,) and enclosed within parentheses.
Example:
list1 = (6.25, 'brinjal', 'onion', 'beans')
list1 is a tuple.

File mode r+, w+, or a+ may be to perform both read and write operations using a single file object.

Although SQL does support procedural programming constructs such as loops and conditional statements, yet it is not considered a programming language in traditional sense. SQL is a declarative language, meaning that the user specifies what he wants the database to do, and the database management system takes care of the how. Therefore, SQL has some programming-like features, but it is not generally considered a programming language.
Hence, option 2 is the correct answer.

An exception is an error that occurs during the execution of a Python program. When an exception occurs, the program stops executing, and an error message is printed to the console. Exceptions can be handled in Python using the try-except statement.

A relation is in third normal form, if there is no transitive dependency for non-prime attributes as well as it is in Second Normal Form.
A relation is in 3NF if at least one of the following conditions holds in every non-trivial function dependency X –> Y:

• X is a super key.
• Y is a prime attribute (each element of Y is a part of some candidate key).

In other words, a relation that is in First and Second Normal Form and in which no non-primary-key attribute is transitively dependent on the primary key, then it is in Third Normal Form (3NF).

Table constraints allow you to specify more than one column in a PRIMARY KEY, UNIQUE, CHECK, or FOREIGN KEY constraint definition. Column-level constraints (except for check constraints) refer to only one column.

• queue.append(item) adds an item to the rear of the queue.
• queue.pop(0) removes and returns the item from the front of the queue.
• queue[0] returns the item at the front of the queue without removing it.
• len(queue) returns the number of items currently in the queue.

The eight-pin RJ45 connector is a standardised interface which often connects a computer to a local area network (LAN). This type of connector was originally developed for telephone communications but is now used in a range of applications. The abbreviation, RJ45, stands for Registered Jack-45.

A queue data structure supports the Enqueue, Dequeue, and Peek operations. The Enqueue operation adds an element to the rear of the queue, the Dequeue operation removes an element from the front of the queue, and the Peek operation retrieves the element at the front of the queue without removing it.

Below are the Python Data Structure:
List is an ordered collection of elements, mutable.
Tuple is an unordered collection of unique elements, immutable.
Set is an unordered collection of elements, mutable.
Dictionary is a collection of key-value pairs, mutable.

Syntax error, there should not be a space between + and =.

Every line ends with a new line character is incorrect in the context of Binary files.