Computer Science: CUET Mock Test - 9 - CUET MCQ

Parentheses, Exponential, Multiplication, Division, Addition, Subtraction
Just remember: PEMDAS, that is, Parenthesis, Exponentiation, Multiplication, Division, Addition, Subtraction. Note that the precedence order of Division and Multiplication is the same.

The correct answer is B D C A E

Key Points

1. B. Create database: This command establishes a new database within the MySQL server to store your tables. Replace with the desired name for your database (e.g., my_database).
2. D. Use database: This command tells MySQL to start working within the newly created database. This ensures that all subsequent table creation, insertion, and selection operations occur within that specific database.
3. C. Create table: This command defines the structure of your table, specifying column names and their data types. You'll need to provide the table name and column definitions (e.g., id INT PRIMARY KEY, name VARCHAR(255)).
4. A. Insert data: This command adds a new record (row) to the table. You'll specify the column names and corresponding values for the record you want to insert (e.g., INSERT INTO my_table (id, name) VALUES (1, 'John Doe')).
5. E. Select data: This command retrieves data from the table. You can use SELECT * to get all columns or specify individual column names. The FROM clause indicates the table you want to select data from.

Example:
B. Create database; my_database; -- Create a database named "my_database"
D. Use my_database; -- Use the "my_database"
C. CREATE TABLE customers ( -- Create a table named "customers" id INT PRIMARY KEY, -- Column "id" as integer, primary key name VARCHAR(255) -- Column "name" as string (up to 255 characters) );
A. INSERT INTO customers (id, name) -- Insert a record into "customers" VALUES (1, 'Alice'); -- id: 1, name: 'Alice'
E. SELECT * FROM customers; -- Select all data from "customers"

By following this sequence, Rohan can effectively create a table, insert data, and view the contents of his database in MySQL.

The correct answer is Update

Key Points

• DDL stands for Data Definition Language.
• DDL commands are used to define and modify the structure of a database, such as creating or removing tables and specifying the data types of columns.
• Update is a DML (Data Manipulation Language) command.
• DML commands are used to manipulate the data within a database, such as inserting, updating, and deleting records.
• The other options (Drop, Alter, Create) are all DDL commands.

Breakdown of all the options:

• Drop: This command removes a database object, such as a table.
• Alter: This command modifies the structure of an existing database object.
• Update: This command modifies the data within a table. (Not a DDL command it is DML command)
• Create: This command creates a new database object, such as a table.

The correct answer is Schema

Key Points

• Schema refers to the overall design of a database, including the definition of tables, columns, data types, keys, and constraints [2].
• It essentially blueprints the structure and organization of the data within the database.

The correct answer is Switch

Key PointsOut of the options you provided, the best device for Mr. Sameer to connect 20 systems within a single hall and ensure data reaches the intended receiver is: 3) Switch

Here's why:

• Repeater: Repeaters amplify the wireless signal to extend the range of an existing WiFi network. They're not suitable for Mr. Sameer's scenario as he likely wants a wired connection for stability and data transfer speed within the hall.
• Hub: Hubs are basic devices that simply broadcast any data they receive to all connected devices. This can be inefficient and lead to network congestion, especially with 20 systems. Data wouldn't be sent directly to the intended receiver.
• Switch: A switch is an intelligent device that learns the MAC addresses of the connected devices and creates a table to direct data only to the intended recipient. This avoids unnecessary traffic and improves network performance.

Switches are commonly used for wired connections within a local area network (LAN) like the one Mr. Sameer wants to create. They offer efficient data transfer and ensure data security by delivering information only to the designated system.

The correct answer is a
file modes:

• г (likely a typo for "r"): Opens a file for reading only. The file offset position is set to the beginning of the file.
• w: Opens a file for writing only. Overwrites the existing file if it exists, or creates a new file if it doesn't. The file offset position is set to the beginning of the file.
• w+: Opens a file for both reading and writing. Overwrites the existing file if it exists, or creates a new file if it doesn't. The file offset position is set to the beginning of the file.
• a: Opens a file for appending new data to the end. Creates a new file if it doesn't exist. The file offset position is set to the end of the file.

Key Points

• Use "a" mode when you want to add content to a file without overwriting existing data.
• Use "w" or "w+" when you want to create a new file or overwrite an existing file.
• The file offset position determines where the next write operation will occur.

The correct answer is Accuracy

Key Points

Data Integrity:

• Data Integrity refers to the characteristics that determine the reliability of the information in terms of its physical and logical validity.
• Data Integrity is based on parameters such as accuracy, validity, and consistency of the data across its lifecycle.
• It is the absence of unintended change to the information between two successive updates or modifications to data records.
• Data Integrity can be considered as a polar opposite to data corruption that renders the information as ineffective in fulfilling desired data requirements.
• Data integrity can be compromised in a variety of ways, making data integrity practices an essential component of effective enterprise security protocols. Data integrity may be compromised.
  • Human error, whether malicious or unintentional
  • Transfer errors, including unintended alterations or data, compromise during the transfer from one device to another
  • Bugs, viruses/malware, hacking, and other cyber threats
  • Compromised hardware, such as a device or disk crash
  • Physical compromise to devices

  • Since only some of these compromises may be adequately prevented through data security, the case for data backup and duplication becomes critical for ensuring data integrity. Other data integrity best practices include input validation to preclude the entering of invalid data, error detection/data validation to identify errors in data transmission, and security measures such as data loss prevention, access control, data encryption, and more.

Therefore, Data integrity refers to the validity of data.

The correct answer is ?, *

Key Points

The term "wildcard characters" refers to specific symbols that take the place of any character or group of characters in a string.

• The most common wildcard characters are "*", which represents any number of characters (including none), and "?", which represents exactly one character.
• "[ ]" are used as wild card expression for a set of characters in regex but not universally recognized as wildcard characters.
• "*" is a wild card character, it can represent any number of characters. However, "/" is not.
• both "?" and "*" are wild card characters.
• Not all of these are wild card characters. For example, "{ }" and "/" are not.

So, the correct answer would be option 3) '?', '*' as these both are universally recognized as wildcard characters.

The correct answer is Automatically correcting all programming errors without any additional code.

Key Points

• The exception handling process involves raising an exception when an error occurs, searching for an appropriate exception handler, and executing the handler's code to manage the error. It does not encompass automatically correcting all errors in the program without any intervention or additional code. Exception handling is about managing errors, not automatically fixing underlying causes.

The correct answer is option 1.

Concept:

Exception:

An exception is an occurrence that happens during program execution that disturbs the regular flow of the program's instructions. When a Python script finds a condition that it cannot handle, it throws an exception. A Python object that reflects an error is known as an exception.

• The KeyboardInterrupt error happens when a user tries to manually stop a running application by pressing delete (Del) or escape (Esc), Ctrl + C or Ctrl + Z, or by interrupting the kernel in the case of Jupyter Notebook.
• To avoid the unintentional usage of KeyboardInterrupt, we can leverage Python's exception handling.

Hence the correct answer is KeyboardInterrupt.

Additional Information

• IOError stands for Input/Output Error. It happens when the file, file path, or OS activity we're looking for doesn't exist.
• Indentation errors can arise when spaces or tabs are not properly positioned. If the translator finds no problems with the spaces or tabs, there will be no problem.
• TypeError is a Python programming language error that happens when the data type of objects in an operation is incorrect.

The correct answer is Disk

Network topology is the schematic description of a network arrangement, connecting various nodes (sender and receiver) through lines of connection. Various types of Network Topologies are described below:

Key Points

• Ring: In a ring topology, each node is connected to exactly two other nodes, forming a circular pathway for signals. This topology ensures that each piece of data can reach any node, but a break in the ring can disrupt the entire network.
• 
• Mesh: In a mesh network topology, every device (node) is connected to every other device in the network. This results in robustness (if one link fails, other links can continue functioning) but requires a large number of connections, making it expensive and difficult to manage.
• 
• Star: In a star topology, all nodes are connected to a central node – often a hub, switch, or controller. The central node typically manages the network, and each peripheral node communicates through this central one. This topology simplifies adding or removing nodes but a failure in the central node affects the entire network.
• 
• Bus: In a bus topology, all nodes are connected to a common backbone or bus. The bus transmits the signal from one end to the other. All nodes along the bus can receive the signal, but only the intended recipient (identified by an address in the signal) processes it. A problem in the bus can disrupt the entire network.
• 

Types of SQL Commands:

• DDL (Data Definition Language)
• DML (Data Manipulation Language)
• DQL (Data Query Language)
• DCL (Data Control Language)
• Data administration commands
• Transaction control commands

The loop does not terminate as new elements are being added to the list in each iteration.

A queue is a data structure that follows the First-In-First-Out (FIFO) principle. It means the first item added to the queue is the first item to be removed from the queue.

To access only a particular part of a file, functions such as fseek(), rewind(), and ftell() can be used.

The append mode defines the way in which new data is added to the already existing data. The property can be used with both, import and export operations. During import, new table is created in the target database.

The World Wide Web—commonly referred to as www, W3, or the web—is an interconnected system of public web pages accessible through the internet.

Cryptography is the study and practice of techniques for secure communication in the presence of third parties called adversaries. It deals with developing and analyzing protocols which prevents malicious third parties from retrieving information being shared between two entities thereby following the various aspects of information security.

The reverse() method reverses the order of the elements in an array. The reverse() method overwrites the original array.

A right parenthesis makes pop operation to delete the elements in stack till we get left parenthesis as top most element. 3 elements are there in stack before right parentheses comes. Therefore, maximum number of elements in stack at run time is 3.

lengths = list(map(lambda s: len(s), strings))
The above line will count the number of characters in each string and store the result in list lengths. So, in first statement result will be [5,6,6,4] and the result of second statement will be [6,4,5,6].

• Keywords : They have a special meaning in SQL. They are understood as instructions.
• Commands : They are instructions given by the user to the database also known as statements.
• Clauses : They begin with a keyword and consist of keyword and argument.

DDL commands provide definitions for creating table structure, deleting relations and modifying relation schemas.

Some of the most common threats include:

• Malware
• Viruses
• Spyware
• Adware
• Trojan horses
• Worms
• Phishing
• Spear phishing

• 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 opens a file in only read mode.
• myfile= open ('student.txt') also allows opening a file in reading mode.

Function Name and Parameter List are parts of a function header in Python.

Full-duplex mode is used when communication in both direction is required all the time. The capacity of the channel, however must be divided between the two directions.
Example: Telephone Network in which there is communication between two persons by a telephone line, through which both can talk and listen at the same time.

The hue parameter in the seaborn library is used to specify the variable to use for color encoding. It allows users to create plots with multiple colors based on a categorical variable. For example, if you have a dataset with different species of flowers and you want to create a scatter plot with different colors for each species, you can use the hue parameter to specify the species variable.

• Bar charts are useful for comparing data across categories or groups.
• Line charts are useful for displaying trends over time or continuous data.
• Scatter plots are useful for showing the relationship between two variables.
• Pie charts are useful for showing parts of a whole or percentages.

Remote Area Network or RAN was a network method that enabled wireless transfer of data via landline, RS232 serial port, cell phone or satellite connections. The Symax 8030 CRM 560 was a Remote Network Interface Module that used this method of linking IO from field devices to local area and remote area networks. The RAN methodlogy is the basis for transmitting data via radio modems.