Computer Science: CUET Mock Test - 8 - CUET MCQ

The correct matching pairs are

The correct answer is Name Error

Key Points

• The given statement Print("Hello world") will generate a Name Error.
• In Python, the function print() should be written in lowercase, not uppercase.
• So the correct statement would be print("Hello world"). Python is case-sensitive, so using Print instead of print would result in a Name Error.
• Therefore, option 4) Name Error is the correct answer.
• 

The correct answer is Tim Berners Lee

Key Points

• Tim Berners-Lee:
  • Tim Berners-Lee is a British computer scientist who invented the World Wide Web in 1989 while working at CERN (European Organization for Nuclear Research) in Switzerland.
  • He proposed the concept of a global hypertext system to facilitate information-sharing among researchers.
  • His invention led to the development of the first web browser and web server, revolutionizing the way information is accessed and shared worldwide.

Additional Information

• Alan Turing:
  • Alan Turing was a British mathematician, logician, and cryptanalyst who is widely considered the father of theoretical computer science and artificial intelligence. He made significant contributions to the Allied efforts during World War II by breaking the German Enigma code. Although Turing laid foundational work for computing.
• Claude Shannon:
  • Claude Shannon was an American mathematician, electrical engineer, and cryptographer known as the "father of information theory." His groundbreaking work laid the foundation for digital circuit design theory and provided the mathematical framework for digital communication. While Shannon's work was pivotal for modern computing and communication systems.
• Herman Hollerith:
  • Herman Hollerith was an American inventor and entrepreneur who developed the punched card tabulating machine, which was used for the 1890 United States Census. His invention laid the foundation for modern automated data processing systems and played a crucial role in the development of early computing technology.

The correct answer is E→D→A→C→B

Key PointsThe correct order for handling an exception in a program is as follows:

• E. An error is encountered: First, an error occurs in the program.
• D. Create exception object: As a result of the error, an exception object is created.
• A. Exception is raised: The exception is then raised.
• C. Program searches for an exception handler: The program searches for a suitable block of code designed to handle the exception.
• B. Executes exception: Once the appropriate handler is found, the exception is executed or handled.

Therefore, the correct answer is: E→D→A→C→B

The correct answer is %

Key PointsThe commonly used wildcard characters in SQL LIKE:

• %: Matches zero, one, or more characters.
• _: Matches a single character (any letter, number, or symbol).

Examples:

• SELECT * FROM customers WHERE name LIKE '%en%'; - This query will find all customer names that contain the letters "en" anywhere in the name (e.g., "John", "Steven", "Weekend").
• SELECT * FROM products WHERE code LIKE 'PR%'; - This query will find all product codes that start with "PR" followed by any characters (e.g., "PR123", "PR-ABC").
• SELECT * FROM users WHERE username LIKE 'user_'; - This query will find all usernames that start with "user_" followed by a single character (e.g., "user_a", "user_1").

Important Points

• Wildcard characters are powerful for pattern matching in SQL queries.
• Use them strategically to retrieve data that meets specific criteria.
• Be mindful of potential performance implications when using wildcards at the beginning of patterns, as it may require a full table scan.

The correct answer is A - II, B - IV, C - III, D - I

Key Points

• A - II (Data redundancy) - Duplication of data at different places (files)
• B - IV (Data inconsistency) - Mismatch of data, maintained at different places
• C - III (Data Isolation) - Separation of resource or data modification made by different transactions
• D - I (Data dependency) - Updating the structure of a data file requires modification in all the application programs accessing the file

So, the correct answer is: A - II, B - IV, C - III, D - I

The correct answer is John McCarthy

Key PointsJohn McCarthy:

• The title "Father of Artificial Intelligence" is often given to Dr. John McCarthy.
• McCarthy was born in Boston, Massachusetts, USA in 1927 and passed away in 2011.
• He coined the term "Artificial Intelligence" in 1956 while proposing a conference at Dartmouth College.
• His groundbreaking work laid the foundations for AI as a distinct field within computer science.
• McCarthy was one of the co-creators of the Lisp programming language, instrumental in AI development.
• He also initiated the concept of "time-sharing" systems, enhancing computer efficiency.
• His concept of the "Advice Taker" in 1958 can be seen as the forerunner to modern knowledge-based systems.
• McCarthy championed the development of Logic programming, a crucial theory for AI.
• His vision included machines that could carry on meaningful conversations with humans, a key tenet of modern AI.
• He was awarded the Turing Award in 1971, the highest honor in computer science, for his contributions to AI.

The correct option is (3)

All 'n' tuples

Concept:-

A delete statement is used to delete/remove one or more records from a table. If we will not provide a where clause with a delete statement then the whole table data will be deleted.

Syntax:

DELETE FROM table_name;

WHERE condition;

For example, here SQL command DELETE FROM EMPLOYEE; is executed on relation EMPLOYEE having n-tuple in it, all 'n' tuples will be deleted from EMPLOYEE.

Key Points

• The Delete command in SQL is a part of the Data Manipulation Language, a sub-language of SQL that allows modification of data in databases.
• This command is used to delete existing records from a table. Using this, we can either delete specific records based on a condition or all the records from a table.
• DELETE FROM EMPLOYEE; This query will delete all the records from the employee table.

The correct answer is Two

Key PointsFTP (File Transfer Protocol) uses two TCP connections to maintain a clear separation of data commands and file data.

• Control Connection: This is used to send and receive commands between the client and the server. It's initiated by the client and remains open for the duration of the session.
• Data Connection: This connection is used specifically for data transfer. It is opened and closed as needed during the session. When an FTP client requests a file, a new data connection gets set up.

The reason for keeping these two connection types separate is to allow for clean, uninterrupted control commands while simultaneously allowing for the transmission of file data.

The correct answer is option 4.

Concept:

Relational Algebra:

Relational Algebra is a query language that accepts a Relation as input and returns a Relation as output. Relational algebra is primarily concerned with providing a theoretical foundation for relational databases and SQL.

The following are the several types of relational algebra operations:

• Select operation
• Project operation
• Rename operation
• Union operation
• Intersection operation
• Difference operation
• Cartesian product operation
• Join operation
• Division operation

Select, project, rename comes under unary operation (operate on one table).

Select operation:

It displays the records that satisfy a condition and is denoted by sigma (σ).

Projection operation:

It displays the specific column of a table. It is denoted by pie (Π). Hence the correct answer is 1 and 2 only.

The correct answer is IP Address

Key Points

• IP Address:
  • This is the identifier assigned to devices on a network. The IP stands for "Internet Protocol," which is the set of rules governing internet activity.
  • An IP address may be either dynamic (changing each time the device connects to the network) or static (permanent).
  • There are two versions of IP addresses in use: IPv4, a series of four numbers separated by periods (e.g., 192.168.1.1), and IPv6, more complex but allowing for many more devices.

Additional Information

• System Address:
  • ​This term isn't commonly used in the context of networking. It could refer to a variety of different addresses involved in the functioning of a system, such as memory addresses used by a computer's hardware and software.
• Process ID:
  • Also known as PID, this is a unique identifier assigned by a computer's operating system to each process (program) running on the machine.
• SYSID:
  • This abbreviation often stands for "System Identifier." In a network, it isn't a term commonly used to describe a device's address.

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.

With random hashing, the probe sequence is generated by the output of a pseudorandom number generator seeded by the key (possibly together with another seed component that is the same for every key, but is different for different tables)

These are the built-in exceptions in Python:

• 'ValueError' is raised when an invalid argument is passed to a function.
• 'TypeError' is raised when an operation or function is applied to an object of inappropriate type.
• 'IndexError' is raised when an index is out of range.
• 'KeyError' is raised when a dictionary key is not found.

Information includes the processed data by planning, controlling and analysing.

This communication protocol prevents a fast sender from flooding a slow receiver with data, by regulating the flow of data on communication lines.

You can treat a tuple as a kind of record, where the index of an element in a tuple is its name within the equivalent record, so (10, 25) is {0 : 10, 1 : 25}. I believe 'Standard ML' and related languages use records as the basic unit of type conjunction (algebraic data types provide type dis-junction) and treat tuples as a kind of record in this way.

Database Management Systems (DBMS) are software systems used to store, retrieve, and run queries on data. A DBMS serves as an interface between an end-user and a database, allowing users to create, read, update, and delete data in the database.

Data Definition Language(DDL) is a subset of SQL and a part of DBMS(Database Management System). DDL consist of Commands to commands like CREATE, ALTER, TRUNCATE and DROP. These commands are used to create or modify the tables in SQL.

Transmission media is basically divided into two categories:

• Broadcast Networks
• Point-to-Point Networks

Spyware, in context of computer software, is software that aims to gather information about a person without his/her knowledge, and that may send such information to another entity.
Spyware is mostly used for stealing information, storing internet users' movements on the web, and serving up pop-up ads to the internet users. Whenever a spyware is used for malicious purposes, its presence is typically hidden from the user and can be difficult to detect. Some spyware, such as keyloggers, may be installed by the owner of a shared, corporate, or public computer intentionally in order to monitor users.

Protocol is a set of rules and regulations. It defines the rules and regulations for communication over the network.