Computer Science: CUET Mock Test - 6 - CUET MCQ

Computer Science: CUET Mock Test - 6 - CUET MCQ

Test Description

30 Questions MCQ Test CUET Mock Test Series - Computer Science: CUET Mock Test - 6

Computer Science: CUET Mock Test - 6 for CUET 2024 is part of CUET Mock Test Series preparation. The Computer Science: CUET Mock Test - 6 questions and answers have been prepared according to the CUET exam syllabus.The Computer Science: CUET Mock Test - 6 MCQs are made for CUET 2024 Exam. Find important definitions, questions, notes, meanings, examples, exercises, MCQs and online tests for Computer Science: CUET Mock Test - 6 below.
Solutions of Computer Science: CUET Mock Test - 6 questions in English are available as part of our CUET Mock Test Series for CUET & Computer Science: CUET Mock Test - 6 solutions in Hindi for CUET Mock Test Series course. Download more important topics, notes, lectures and mock test series for CUET Exam by signing up for free. Attempt Computer Science: CUET Mock Test - 6 | 40 questions in 45 minutes | Mock test for CUET preparation | Free important questions MCQ to study CUET Mock Test Series for CUET Exam | Download free PDF with solutions
Computer Science: CUET Mock Test - 6 - Question 1

Two statements are given below: Statement I: Normalization is the process of organizing data in a database into tables to reduce redundancy. Statement II: Normalization is the process of organizing data in a database into tables to reduce dependancy.

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 1

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.

Computer Science: CUET Mock Test - 6 - Question 2

A tuple is a:

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 2

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

 1 Crore+ students have signed up on EduRev. Have you?
Computer Science: CUET Mock Test - 6 - Question 3

A repeater is a device which operates only in the:

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 3

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.

Computer Science: CUET Mock Test - 6 - Question 4

Which of the following string functions in 'C' converts lowercase input string into uppercase?

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 4

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

Computer Science: CUET Mock Test - 6 - Question 5

What is the fundamental unit of data transport on computer networks?

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 5

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.

Computer Science: CUET Mock Test - 6 - Question 6

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 6

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

Computer Science: CUET Mock Test - 6 - Question 7

Two statements are given below:

Statement I: Hashing technique is very fast and efficient for large collections, but requires additional memory to store the hash table.
Statement II: Binary search technique is suitable for small collections but can be slow for larger collections.

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 7

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.

Computer Science: CUET Mock Test - 6 - Question 8

The CSV files can be accessed:

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 8

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.

Computer Science: CUET Mock Test - 6 - Question 9

Directions: Match the contents under List I with those under List II.

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 9
• 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.
Computer Science: CUET Mock Test - 6 - Question 10

What is sorting?

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 10

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

Computer Science: CUET Mock Test - 6 - Question 11

Which of the following operators cannot be used with string data type?

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 11

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

Computer Science: CUET Mock Test - 6 - Question 12

Two statements are given below, one is Assertion (A) and the other is Reason (R). Read the statements carefully and choose the correct answer.

Assertion (A): Exception handling in Python allows for graceful recovery from errors and prevents program crashes.
Reason (R): When an error occurs during program execution, Python's exception handling mechanism allows the program to gracefully handle the error and take corrective action.

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 12

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.

Computer Science: CUET Mock Test - 6 - Question 13

Database management systems are intended to:

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 13

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.

Computer Science: CUET Mock Test - 6 - Question 14

Which statement is true about denial of service (DOS attack)?

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 14

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.

Computer Science: CUET Mock Test - 6 - Question 15

To prevent infection by a computer virus:

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 15

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.

Computer Science: CUET Mock Test - 6 - Question 16

Consider a tuple tup1 = (10, 15, 25 and 30). Identify the statement that will result in an error.

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 16

'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.

Computer Science: CUET Mock Test - 6 - Question 17

Two statements are given below, one is Assertion (A) and the other is Reason (R). Read the statements carefully and choose the correct answer.

Assertion (A): In a relational database, a primary key is a unique identifier for each record in a table.
Reason (R): A primary key can be a combination of two columns.

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 17

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.

Computer Science: CUET Mock Test - 6 - Question 18

A text file student.txt is stored in the storage device. Identify the correct option out of the following options to open the file in read mode.
(i) myfile = open('student.txt','rb')
(ii) myfile = open('student.txt','w')
(iii) myfile = open('student.txt','r')
(iv) myfile = open('student.txt')

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 18
• 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.
Computer Science: CUET Mock Test - 6 - Question 19

Which module is to be imported for working in binary file?

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 19

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

Computer Science: CUET Mock Test - 6 - Question 20

What will be the output of the following program?
tuple=("Check")*3
print (tuple)

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 20

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

Computer Science: CUET Mock Test - 6 - Question 21

Convert the following infix expression to postfix expression using stack:

(A+B*(C-D)^E+(F/G)^H-I)

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 21

The conversion using stack is as follows:

Computer Science: CUET Mock Test - 6 - Question 22

Match the following:

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 22

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.

Computer Science: CUET Mock Test - 6 - Question 23

In python, Which of the following method  is used find weather the queue is empty or not?

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 23

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().

Computer Science: CUET Mock Test - 6 - Question 24

7 9 3 + 4 / *

The evaluation of the above postfix expression is:

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 24

The evaluation of the expression is as follows:

Computer Science: CUET Mock Test - 6 - Question 25

Match the following:

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 25

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.
Computer Science: CUET Mock Test - 6 - Question 26

Which of the following is an Arithmetic Exception?

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 26

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.

Computer Science: CUET Mock Test - 6 - Question 27

Conversion of the domain name of each web server to its corresponding IP address is called _________________.

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 27

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.
Computer Science: CUET Mock Test - 6 - Question 28

Which of the following is not a measure of central tendency

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 28

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.

Computer Science: CUET Mock Test - 6 - Question 29

The method provided by Python to insert elements into a stack is:

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 29
• 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.
Computer Science: CUET Mock Test - 6 - Question 30

Which of the following sorting algorithms have a time complexity of n2?

Detailed Solution for Computer Science: CUET Mock Test - 6 - Question 30
• 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 n2.

CUET Mock Test Series

8 docs|148 tests
Information about Computer Science: CUET Mock Test - 6 Page
In this test you can find the Exam questions for Computer Science: CUET Mock Test - 6 solved & explained in the simplest way possible. Besides giving Questions and answers for Computer Science: CUET Mock Test - 6, EduRev gives you an ample number of Online tests for practice

8 docs|148 tests