Bank Exams Exam  >  Bank Exams Tests  >  SEBI Grade A (IT) Mock Test - 5 - Bank Exams MCQ

SEBI Grade A (IT) Mock Test - 5 - Bank Exams MCQ


Test Description

30 Questions MCQ Test - SEBI Grade A (IT) Mock Test - 5

SEBI Grade A (IT) Mock Test - 5 for Bank Exams 2024 is part of Bank Exams preparation. The SEBI Grade A (IT) Mock Test - 5 questions and answers have been prepared according to the Bank Exams exam syllabus.The SEBI Grade A (IT) Mock Test - 5 MCQs are made for Bank Exams 2024 Exam. Find important definitions, questions, notes, meanings, examples, exercises, MCQs and online tests for SEBI Grade A (IT) Mock Test - 5 below.
Solutions of SEBI Grade A (IT) Mock Test - 5 questions in English are available as part of our course for Bank Exams & SEBI Grade A (IT) Mock Test - 5 solutions in Hindi for Bank Exams course. Download more important topics, notes, lectures and mock test series for Bank Exams Exam by signing up for free. Attempt SEBI Grade A (IT) Mock Test - 5 | 130 questions in 100 minutes | Mock test for Bank Exams preparation | Free important questions MCQ to study for Bank Exams Exam | Download free PDF with solutions
SEBI Grade A (IT) Mock Test - 5 - Question 1

What does KIRTI stand for, as inaugurated by the Union Minister for Youth Affairs and Sports, Anurag Singh Thakur, for identifying sports talents among school-goers?

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 1

The correct answer is Khelo India Rising Talent Identification

In News

  • The KIRTI program was inaugurated in Chandigarh with the aim of identifying and nurturing sporting talent from every corner of the country.

Key Points

  • The program has two main objectives: scouting talent and using sports as a tool to deter addiction to drugs and other distractions.
  • KIRTI made its debut across 50 centers in India, with 50,000 applicants being assessed in the first phase across 10 sports, including athletics, boxing, wrestling, hockey, football, and wrestling.
  • The program aims to conduct 20 lakh assessments throughout the year to identify talent through notified Talent Assessment Centers.
  • Shri Thakur emphasized the importance of starting sports training early and mentioned the government's goal to make India a top 10 sports nation by 2036 and among the top five by 2047.
  • KIRTI's selection methodology is transparent and based on Information Technology, utilizing data analytics and Artificial Intelligence to predict sporting potential.
  • The program requires collaboration with National Sports Federations and state governments. The government has already invested Rs 3000 Crore in infrastructure and established over 1000 Khelo India Centers across the country.
SEBI Grade A (IT) Mock Test - 5 - Question 2

What will fit in the blank taken from the passage: ‘But this surge, and the deficit tally, was ______ expectations, with economists describing it as ‘a rude shock’ thanks to ‘idiosyncratic’ effects.

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 2

The correct answer is ‘beyond’.

Key Points

  • The context indicates the surge and deficit tally surpassed what was expected, thus surprising economists.
  • The term 'rude shock' suggests something surprising or unexpected, hence 'beyond' fits perfectly, capturing the idea that the surge and deficit tally exceeded expectations.
  • Options such as 'below', 'meeting', 'in line with', or 'undermining' do not correctly represent the unexpected and high nature of the surge and deficit tally mentioned in the passage.
  • Complete Sentence: But this surge, and the deficit tally, was beyond expectations, with economists describing it as ‘a rude shock’ thanks to ‘idiosyncratic’ effects.

Therefore, the correct answer is ‘Option 3’.

Additional Information

  • Option 1, "below", implies that the surge and deficit tally were less than expectations, which contradicts the passage.
  • Option 2, "meeting", and option 4, "in line with", suggest that the surge and tally matched expectations rather than exceeding them.
  • Option 5, "undermining", doesn't fit well in the context as it's typically used to suggest diminishing or devaluing something. It does not convey the surprising high level of the surge and deficit tally.
1 Crore+ students have signed up on EduRev. Have you? Download the App
SEBI Grade A (IT) Mock Test - 5 - Question 3

Find the number of females visiting only B

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 3

Calculation:

Let the number of females visiting both cities be 2x

So, Number of males visiting both cities = 2x × 150% = 3x

Females visiting B only = 2x × 4 = 8x

Males visiting A only = 4 × 3x = 12x

Females visiting A only = 36

Males visiting B only = 16


Now, According to the question

12x + 16 + 3x = 36 + 8x + 2x

⇒ 15x + 16 = 36 + 10x

⇒ 5x = 20

⇒ x = 4

Now, Putting the values in table


∴ Number of females visiting only B is 32

SEBI Grade A (IT) Mock Test - 5 - Question 4

If the ratio between number of qualified women in 2018 and number of qualified women in 2020 is 3 : 7 and the number of qualified men in 2018 is same as number of qualified man in 2020. Then find the total number of qualified women candidate in 2018 and 2020 together?

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 4

Let no. of qualified man in 2018 and 2020 = a
Let no. of qualified woman in 2018 and 2020 3b and 7b respectively.
Then, a + 3b = 288 ----(1)
And a + 7b = 576 ----(2)
From (1) and (2) b = 72
No. of qualified woman candidate in 2018 and 2020 together
= 72(3 + 7) = 720

SEBI Grade A (IT) Mock Test - 5 - Question 5

If the ratio between number of qualified men in 2017 and the number of qualified men in 2019 is 4 : 3 and total number of men qualified in 2017 and 2019 together is 392 then number of candidate appeared in 2017 that what percent of the number of candidate appeared in 2019?

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 5

Calculation:

No. of qualified man in 2017

No. of qualified man in 2019

No. of appeared candidates in 2017 =

No. of appeared candidates in 2019

Required %
∴ The required percentage is

SEBI Grade A (IT) Mock Test - 5 - Question 6

In 2017, number of men who qualified were 50% of the number of men who qualified in 2020. Find the number of appeared candidate in 2017 if respective ratio of number of qualified men and woman candidates in 2020 is 13 : 11.

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 6

No. of men candidates who qualified in 2020

No. of man who qualified in 2017

Total no. of appeared candidates who qualified in 2017

Total no. of appeared candidates in 2017

SEBI Grade A (IT) Mock Test - 5 - Question 7

How many boxes are there between P and R?

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 7

Seven boxes : P, Q, R, S, T, U, and V.

Number of chocolates: 2, 6, 9, 12, 16, 17, and 19.

1). There are two boxes between S and the box in which there is 12 chocolates.

2). S is above the box which has 12 chocolates.

3). S is placed below P.

4). P doesn't have 16 chocolates.

5). There are two boxes between the box having 6 and 16 chocolates.

6). Two boxes are placed between P and the box in which there are 9 chocolates.

7). U is immediately below the box which has 16 chocolates.

8). There are only three boxes between T and the box which has 9 chocolates.

After combining all, we have

Case 1:

Case 2:

Case 3:

Case 4:

9). The difference between the number of chocolates in box S and the box just above S is 13. ( Here we see only numbers 6 and 19, where the difference is 13 possible. so, either S is 6/19 or the box just above S is 19/6 has the number of chocolates).

From here Case 1, Case 2, and Case 4 get eliminated. ( as the number of 6 chocolates is in it but it is not just above S.)

From Case 3, we can say that S has 19 chocolates, as 6 is just above it.

Case 3

10). Only one box is between Q and V.

11). Q doesn't have 6 chocolates.

12). The number of chocolates in the box which is just above V is less than the number of chocolates in V.

13). As Only R and 17 chocolates are left, it occupies the left position i.e. R has 16 chocolates and T has 17 chocolates.

The final arrangements:

Hence, There are three boxes between P and R.

SEBI Grade A (IT) Mock Test - 5 - Question 8

Which of the following is true about the box which contains 6 chocolates?

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 8

Seven boxes : P, Q, R, S, T, U, and V.

Number of chocolates: 2, 6, 9, 12, 16, 17, and 19.

1). There are two boxes between S and the box in which there is 12 chocolates.

2). S is above the box which has 12 chocolates.

3). S is placed below P.

4). P doesn't have 16 chocolates.

5). There are two boxes between the box having 6 and 16 chocolates.

6). Two boxes are placed between P and the box in which there are 9 chocolates.

7). U is immediately below the box which has 16 chocolates.

8). There are only three boxes between T and the box which has 9 chocolates.

After combining all, we have

Case 1:

Case 2:

Case 3:

Case 4:

9). The difference between the number of chocolates in box S and the box just above S is 13. ( Here we see only numbers 6 and 19, where the difference is 13 possible. so, either S is 6/19 or the box just above S is 19/6 has the number of chocolates).

From here Case 1, Case 2, and Case 4 get eliminated. ( as the number of 6 chocolates is in it but it is not just above S.)

From Case 3, we can say that S has 19 chocolates, as 6 is just above it.

Case 3

10). Only one box is between Q and V.

11). Q doesn't have 6 chocolates.

12). The number of chocolates in the box which is just above V is less than the number of chocolates in V.

13). As Only R and 17 chocolates are left, it occupies the left position i.e. R has 16 chocolates and T has 17 chocolates.

The final arrangements:

Hence, Box contains 6 chocolates is immediately above Box S.

SEBI Grade A (IT) Mock Test - 5 - Question 9

Who among the following joined the company in the month of July?

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 9

Given: Eight persons join a company on two particular dates of four different months in the same year.

Combining the given conditions, we get the following possibilities as follows-

1. Only two persons joined the company before Jos. Jonny joined the company on the 21st of the month which has 31 days. This gives rise to the following cases-

2. Charles didn’t join the company in the month of April or July. No one joined the company after Marcus. Adding these two conditions to the above two cases we get-

3. Jonny didn’t join the company in the months of July and November. Only two persons join the company in between Jos and Carlos. Charles and Marcus, who are twin brothers, joined the company in the same month. Combining these conditions, we see that Case 2 and Case 3 from the above are eliminated. Hence, we get-

4. Xander and Carlos joined the company in the same month. Patrick joined the company immediately before Xander. Combining these two conditions, we get the final table as follows-

From the above final table, we see that Xander and Carlos join the company in the month of July.

Hence, Carlos joined the company in July.

SEBI Grade A (IT) Mock Test - 5 - Question 10

Who joined the company on the 21st of July?

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 10

Given: Eight persons join a company on two particular dates of four different months in the same year.

Combining the given conditions, we get the following possibilities as follows-

1. Only two persons joined the company before Jos. Jonny joined the company on the 21st of the month which has 31 days. This gives rise to the following cases-

2. Charles didn’t join the company in the month of April or July. No one joined the company after Marcus. Adding these two conditions to the above two cases we get-

3. Jonny didn’t join the company in the months of July and November. Only two persons join the company in between Jos and Carlos. Charles and Marcus, who are twin brothers, joined the company in the same month. Combining these conditions, we see that Case 2 and Case 3 from the above are eliminated. Hence, we get-

4. Xander and Carlos joined the company in the same month. Patrick joined the company immediately before Xander. Combining these two conditions, we get the final table as follows-

From the above final table, we see that Patrick joined on the 21st of April and Xander joined on the 12th of Juy.

Hence, CARLOS is the correct answer.

SEBI Grade A (IT) Mock Test - 5 - Question 11

Which item was the first to be purchased?

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 11

Given:-

Nine items - Perfume, Watch, Raincoat, Coffee, Charger, Purse, Notebook, Racquet, and Knife

Let the first item purchased be numbered 1 and the last item purchased be numbered 9.

Now,

1) The number of items purchased before the Purse is less than the number of items purchased after the Purse. It means at least 5 items were purchased after Purse. So Purse can be numbered 1, 2, 3, or 4.

2) More than three items were purchased after Raincoat. It means Raincoat cannot be numbered 6, 7, 8, and 9.

3) Only two items were purchased between Raincoat and Purse.

So the possibilities are -

4) The Perfume was purchased before Raincoat. So, Raincoat was not the first item to be purchased. We cannot place Perfume yet.

The possible cases are -

5) More than one item was purchased between the Purse and Charger. It means Charger was purchased after Raincoat in both cases.

6) The Perfume was purchased before Charger but not immediately before. So, Perfume was purchased before Raincoat and Charger.

We can place Perfume as follows:

7) Charger was purchased before Racquet.

8) The Knife was purchased before Notebook but after Racquet.

So, the sequence will be Raincoat > Charger > Racquet > Knife > Notebook.

8) Coffee was purchased immediately before Watch. This is possible only in Case II (a).

So, the final arrangement is:

The Perfume was the first item to be purchased.

Hence, the correct answer is Perfume.

SEBI Grade A (IT) Mock Test - 5 - Question 12

Directions: Read the sentence given below to find out if it contains an error. The error, if any, will be in one part of the sentence. If the sentence is error-free, select No error or option 5. Ignore errors of punctuation if any.

If I have (A)/ enough money, (B)/ I will buy (C)/ some chocolates. (D)/ No error (E)

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 12

The correct answer is 'E' i.e. No error.

Key Points

  • In the given sentence, there is no error in any part of the sentence.
  • The given sentence is the first conditional sentence talking about a thing that might happen in the future.
  • We can't know what will happen in the future, but this describes possible things, which could easily come true.
  • The first conditional sentence format: if + present simple, ... will + infinitive.
  • When using the first conditional, we use the present simple (here, have) in the if-clause and the future simple (here, will buy) in the main clause.

Hence, the correct answer is option 5.

Correct sentence: If I have enough money, I will buy some chocolates.

SEBI Grade A (IT) Mock Test - 5 - Question 13

Directions: Read the sentence given below to find out if it contains an error. The error, if any, will be in one part of the sentence. If the sentence is error-free, select No error or option 5. Ignore errors of punctuation if any.

Her books (A)/ have been (B)/ translate into (C)/ 24 languages. (D)/ No error (E)

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 13

The correct answer is 'C' i.e. this part of the sentence has an error.

Key Points

  • In the third part of the given sentence, the use of the base form of the verb 'translate' is incorrect.
  • The given sentence is a passive voice in the present perfect tense as it links the past to the present in some way.
  • The present perfect tense refers to an action or state that either occurred at an indefinite time in the past or began in the past and continued to the present time.
  • The present perfect tense in a passive voice is formed by have/has + been + the past participle (here, it should be translated).
  • The subject 'books' of the sentence is plural and it will take the plural verb 'have'.
  • Therefore, the past participle form of the verb 'translated' should be used in place of the base form of the verb 'translate'.

Hence, the correct answer is option 3.

Correct sentence: Her books have been translated into 24 languages.

SEBI Grade A (IT) Mock Test - 5 - Question 14

In the following question, two columns are given containing three phrases each. In the first column, phrases are A, B, and C, and in the second column, the phrases are D, E and F. A phrase from the first column may or may not connect with a phrase from the second column to make a grammatically and contextually correct sentence. There are five options, four of which display the sequence(s) in which the phrases can be joined to form a grammatically and contextually correct sentence. If, none of the options given forms a correct sentence after combination, select ‘None of these’ as your answer.

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 14

We need to join the sentence segments in column 1 with those in column 2 to create sentences that are conceptually and grammatically correct. Let us see how the sentence parts can join.

  • Part A talks about a lesson. So contextually, it should be joined with the part that talks about learning, i.e. part F. But 'learning' is a present participle here, while we need a verb in the present tense to follow the infinitive marker 'to'. That is, it would have been grammatically correct if it was 'learn' and not 'learning'. Hence, A and F cannot be joined grammatically.
  • Part B talks about how power foods can be enjoyed. So, contextually, it should be joined with part E which states more ways through which they can be enjoyed. So, B-E.
  • Part C talks about advice given by cartoonists and so should be joined with part D that completes the advice being given. So, C-D.

In the given options, the correct answers B-E and C-D are reflected in option 3, making it the correct answer.

SEBI Grade A (IT) Mock Test - 5 - Question 15

Directions: Given below is a word, followed by three sentences which consist of that word. Identify the sentence(s) that don't/doesn't express the meaning of the word.

PARODY
A. It also includes some brilliant parodies.
B. He had become a grotesque parody of himself and the gallery, at last, began to avert its eyes.
C. There is a twist to his parody tale.

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 15

The correct answer is 'Only C'.

Key Points

  • Parody means- a piece of writing, speech, or music that copies the style of somebody/something in a funny way.
  • In Sentence A, the meaning of parody is understandable. "It includes some brilliant parodies."
  • In Sentence B, the meaning of parody is understandable here too. "He had become a grotesque parody of himself and the gallery, at last, began to avert its eyes"
  • In Sentence C, the meaning of parody is not being portrayed properly. Here, it is giving another meaning to the sentence.
  • Hence, the correct answer is option 3.
SEBI Grade A (IT) Mock Test - 5 - Question 16

In the following question two equations are given. You have to solve the equations and mark the answer accordingly.

l. x2 – 29x + 204 = 0

ll. 2y2 – 43y + 176 = 0

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 16

Calculation:

x2 – 29x + 204 = 0

⇒ x2 – 17x – 12x + 204 = 0

⇒ x (x - 17) – 12(x - 17) = 0

⇒ (x - 17) (x - 12) = 0

⇒ x = 17, 12

2y2 – 43y + 176 = 0

⇒ 2y2 – 32y – 11y + 176 = 0

⇒ 2y ( y - 16) – 11 ( y - 16) = 0

⇒ (2y - 11) (y - 16) = 0

⇒ y = 11/2, 16

Comparison between x and y (via Tabulation):

∴ The relation between x and y cannot determined.

SEBI Grade A (IT) Mock Test - 5 - Question 17

In the given question, two equations numbered l and II are given. Solve both the equations and mark the appropriate answer.
I. 4x2
– 17x + 15 = 0
II. 3y2
+ 13y - 38 = 0

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 17

Given:

I. 4x2 – 17x + 15 = 0

II. 3y2 + 13y - 38 = 0

Calculation:

From I,

4x2 – 17x + 15 = 0

⇒ 4x2 – 12x - 5x + 15 = 0

⇒ 4x(x - 3) - 5(x - 3) = 0

⇒ (x - 3)(4x - 5) = 0

Taking,

⇒ (x - 3) = 0 or (4x - 5) = 0

⇒ x = 3 or (5/4)

From II,

3y2 + 13y - 38 = 0

⇒ 3y2 + 19y - 6y - 38 = 0

⇒ y(3y + 19) - 2(3y + 19) = 0

⇒ (y - 2)(3y + 19) = 0

Taking,

⇒ (y - 2) = 0 or (3y + 19) = 0

⇒ y = 2 or (-19/3)

Comparison between x and y (via Tabulation):

∴ x = y or relation between x and y can not be established.

SEBI Grade A (IT) Mock Test - 5 - Question 18

Consider the tree T given below. If post order traversal of T gives BCEAD, the lables of nodes 1, 2, 3, 4, 5, respectively are:

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 18

Key Points

Pre-order of above tree = 12453

In order of above tree = 42513

Postorder of above tree = 45231

And the given Post order is BCEAD

Hence B=4, C=5, E=2, A=3, D=1

The labels of nodes 1, 2, 3, 4, 5 = {D, E, A, B, C}

Hence the correct answer is DEABC.

SEBI Grade A (IT) Mock Test - 5 - Question 19
Bus, star and ring are the example of topology. In which of the following these topologies are used in most?
Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 19
Topologies Bus, Start and Ring are used in local area network (LAN). A local-area network (LAN) is a computer network that spans a relatively small area. Most often, a LAN is confined to a single room, building or group of buildings; however, one LAN can be connected to other LANs over any distance via telephone lines and radio waves.
SEBI Grade A (IT) Mock Test - 5 - Question 20
The digital footprints also known as ___________.
Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 20

The correct answer is digital shadow.

The digital shadows reflect the activity of any person on the internet and their behaviors towards the information on the internet.

Important Points

  • The digital footprint is generated and used with or without user knowledge. It includes websites we visited, emails sent by users, any information submitted by users on the online platform, and the computer’s address, location, and other device-specific details.
  • There are two types of digital footprint: Active Digital Footprint and Passive Digital Footprint.
  • Active Digital Footprint: There are two kinds of digital footprints users leave behind. Active digital footprints include data that users intentionally submit online. This would include emails the users write or responses or posts users make on different websites or mobile Apps, etc.
  • Passive Digital Footprint: The digital data trail users leave online unintentionally is called passive digital footprints. This includes the data generated when users visit a website, use a mobile app, browse the Internet, etc.
  • Everyone who is connected to the Internet may have a digital footprint. With more usage, the trail grows. By examining the browser settings, Users can find out how it stores our browsing history, cookies, passwords, auto fills, and many other types of data.
SEBI Grade A (IT) Mock Test - 5 - Question 21

Consider a relation student has Student_id, Student_name, Student_age, Student_Income, Student_address.

Query:

SELECT DISTINCT Student_Income FROM student;

How many student_incomes prints the given sql query?

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 21

The correct answer is option 2.

Concept:

DISTINCT Clause:

By default, SQL shows all the data retrieved through query as output. However, there can be duplicate values. The SELECT statement when combined with DISTINCT clause, returns records without repetition (distinct records).

Explanation:

Query:

SELECT DISTINCT Student_Income FROM student;

The above query prints the distinct student incomes from given relation student. So it five different income prints like below as output.

Student_Income

80k

50k

100k

60k

90k

Hence the correct answer is 5.

SEBI Grade A (IT) Mock Test - 5 - Question 22

SHA-1 generates a hash code of size _________ bits.

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 22

SHA-1 was designed by the United States National Security Agency and is a U.S. Federal Information Processing Standard.

In cryptography, SHA-1 is a cryptographic hash function which takes an input and produces a 160-bit (20-byte) hash value known as a message digest.

It is represented in hexadecimal number which will be 40 digits, that is, 40 × 4 = 160 bits because each hexadecimal value takes 4 bits.

Notes:

SHA-1 stands for Secure Hash Algorithm 1

SEBI Grade A (IT) Mock Test - 5 - Question 23
What is the full form of RTCP?
Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 23

Real-timeTransport Control Protocol (RTCP):

  • RTCP is a sister protocol of the Real-time Transport Protocol (RTP)
  • The primary function of RTCP is to provide feedback on the quality of service (QoS) in media distribution by periodically sending statistics information such as transmitted octet and packet counts, packet loss, packet delay variation, and round-trip delay time to participants in a streaming multimedia session
SEBI Grade A (IT) Mock Test - 5 - Question 24
What is the best case complexity of QuickSort?
Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 24

Concept

Quick Sort is a Divide and Conquer algorithm. It picks an element as a pivot and partitions the given array.

If pivot element divides the array into two equal half in such a scenario, quick sort takes the least time sort, that is, best case time complexity.

The best case complexity of QuickSort is O(nlogn)

Additional Information

SEBI Grade A (IT) Mock Test - 5 - Question 25
All Oracle transactions obey the basic properties of a database transaction. What is the name of the following property?
‘All tasks of a transaction are performed or none of them are. There are no partial transactions.’
Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 25

Answer: Option 1

Concept:

ACID Properties:

A transaction in a database system must maintain Atomicity, Consistency, Isolation, and Durability − commonly known as ACID properties − in order to ensure accuracy, completeness, and data integrity.

Atomicity − This property states that a transaction must be treated as an atomic unit, that is, either all its operations are executed or none.There are no partial transactions

Consistency − The database must remain in a consistent state after any transaction. No transaction should have any adverse effect on the data residing in the database.

Isolation − In a database system where more than one transaction is being executed simultaneously and in parallel, the property of isolation states that all the transactions will be carried out and executed as if it is the only transaction in the system.

Durability − The database should be durable enough to hold all its latest updates even if the system fails or restarts.

SEBI Grade A (IT) Mock Test - 5 - Question 26

The LANs are located in small geographical boundaries ranging from

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 26

The correct answer is option 3.

Concept:

A local area network (LAN) is a computer network that connects computers within a specific geographic area, such as a home, school, research lab, college campus, or office complex.

Local Area Network form network of the computers which are in the range of 100 m to the 2-kilometer radius.

Hence the correct answer is 100 m to 2 km.

SEBI Grade A (IT) Mock Test - 5 - Question 27

What is output of the code in Python Language:

>>> str1 = ‘All the Best’

>>> str1[-3]

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 27

Key Points

str1 = ‘All the Best’

Here str1 is an array of continuous elements,

str1[0]=A=str1[-0]

str1[1]=l=str1[-11]

str1[2]=l=str1[-10]

str1[3]=' '=str1[-9]

str1[4]=t=str1[-8]

str1[5]=h=str1[-7]

str1[6]=e=str1[-6]

str1[7]=' '=str1[-5]

str1[8]=B=str1[-4]

str1[9]=e=str1[-3]

str1[10]=s=str1[-2]

str1[11]=t=str1[-1]

Hence the correct answer is 'e'.

SEBI Grade A (IT) Mock Test - 5 - Question 28

A recursive function f is defined as follows:

f(n)=2, if n=0

=m, if n=1

=2*f(n-1)+4*f(n-2), if n>=2

If the value of f(4) is 88, then the value of m is:

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 28

Given f(0) = 2 ; f(1) = m ;f(4) = 88

f(2) = 2*f(1) + 4*f(0) ≡ 2*m+8

f(2) = 2m + 8

f(3) = 2*f(2) + 4*f(1) ≡ 2(2m+8) + 4m

f(3) = 8m + 16

f(4) = 2*f(3) + 4*f(2) ≡ 2(8m + 16) + 4*(2m+8)

88 = 16m+32+8m+32

88 = 24m+64

88-64 = 24m

1 = m

m = 1

SEBI Grade A (IT) Mock Test - 5 - Question 29

What is the value of the following 'C' language expression?

(2 ? 3 : 4) + 8/4/2

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 29

The correct answer is option 3.

Concept:

Conditional Operator in C:

The ternary operator is another name for the conditional operator. Conditional statements are decision-making statements that are based on the expression's outcome. The symbols '?' and ':' are used to represent it. As a conditional operator works on three operands, it is also known as the ternary operator. The behavior of the conditional operator is similar to the 'if-else' statement as the 'if-else' statement is also a decision-making statement.

Syntax:

Expression1? expression2: expression3;

The given expression is,

(2 ? 3 : 4) + 8/4/2;

Here 2 is true So it will give the expression1.

(True? 3: 4) +8/4/2;

3+8/4/2; (/ is left to right associativity so (8/4) / 2 =1)

3+1;

So it gives the 4 as the result.

Hence the correct answer is 4.

SEBI Grade A (IT) Mock Test - 5 - Question 30

Consider the following student relation.

Student relation has Name, Subject1_Marks, and Subject2_Marks attributes.

Query1:

Select count (*)

From student;

Query2:

Select count (10)

From student;

Query1 prints the Q1 and Query2 prints Q2. Which of the following condition is true?

Detailed Solution for SEBI Grade A (IT) Mock Test - 5 - Question 30

The correct answer is option 5.

Concept:

Count():

It takes one set of values and gives one output. The COUNT() function returns the number of records returned by a select query.

Note: NULL values are not counted.

Syntax:

COUNT(expression)

Explanation:

The given table is,

Consider the following student relation.

Student relation has Name, Subject1, and Subject2 attributes.

Query1:

Select count (*)

From student;

Explanation:

The query1 has count(*) prints the number of rows that are not null. Here no complete row is null. So it prints the 6 as output.

Query2:

Select count (10)

From student;

Explanation:

Note:

Count(constant) prints the number of rows in a relation.

The query2 has count(10) prints the number of rows that are not null. Here no complete row is null. So it prints the 6 as output.

Hence the correct answer is Q1=Q2.

View more questions
Information about SEBI Grade A (IT) Mock Test - 5 Page
In this test you can find the Exam questions for SEBI Grade A (IT) Mock Test - 5 solved & explained in the simplest way possible. Besides giving Questions and answers for SEBI Grade A (IT) Mock Test - 5, EduRev gives you an ample number of Online tests for practice

Top Courses for Bank Exams

Download as PDF

Top Courses for Bank Exams