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

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


Test Description

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

SEBI Grade A (IT) Mock Test - 3 for Bank Exams 2024 is part of Bank Exams preparation. The SEBI Grade A (IT) Mock Test - 3 questions and answers have been prepared according to the Bank Exams exam syllabus.The SEBI Grade A (IT) Mock Test - 3 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 - 3 below.
Solutions of SEBI Grade A (IT) Mock Test - 3 questions in English are available as part of our course for Bank Exams & SEBI Grade A (IT) Mock Test - 3 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 - 3 | 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 - 3 - Question 1

Sunil Chhetri announces retirement from international football. When he was named as captain of Indian Football Team?

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

The correct answer is 2010

In News

  • Sunil Chhetri, the captain of the Indian men's football team, announced his retirement from international football after the FIFA World Cup qualifier against Kuwait.

Key Points

  • Chhetri's retirement was conveyed through a video posted on X (formerly Twitter), emphasizing the significance of the upcoming match against Kuwait on June 6.
  • This decision marks the end of an illustrious career spanning 19 years, during which Chhetri has been a key figure for Indian football.
  • Chhetri expressed a mix of emotions in the video, highlighting the sense of duty, pressure, and joy he experienced throughout his career.
  • The 39-year-old striker made his senior debut for India in 2005 and served as captain since 2010, leading the team to several victories, including the 2012 Nehru Cup and four SAFF Championships.
  • The striker is fourth on the list of most goals scored in international football, having hit theback of the net on 94 occasions in 150 appearances, with only Lionel Messi (106 goals), Ali Daei (108 goals) and Cristiano Ronaldo (128 goals), ahead of him.
  • Chhetri's retirement marks the end of an era for Indian football, leaving behind a legacy of leadership, skill, and dedication to the sport.
SEBI Grade A (IT) Mock Test - 3 - Question 2

In May 2024, PhonePe announced that it has enabled UPI payment acceptance in collaboration with __________. Earlier in February, India’s instant payment technology service, the Unified Payment Interface (UPI), was launched in Sri Lanka and Mauritius in a virtual event that Prime Minister Narendra Modi attended.

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

The correct answer is LankaPay

In News

  • PhonePe announced the enablement of UPI payment acceptance in collaboration with LankaPay.

Key Points

  • PhonePe enabled UPI payment acceptance in collaboration with LankaPay on May 15.
  • India’s Unified Payment Interface (UPI) was launched in Sri Lanka and Mauritius in February.
  • Prime Minister Narendra Modi attended the virtual launch event.
  • This collaboration marks a significant expansion of UPI's international reach.
1 Crore+ students have signed up on EduRev. Have you? Download the App
SEBI Grade A (IT) Mock Test - 3 - Question 3

Who has been unanimously elected as the President of the Federation of Indian Micro and Small & Medium Enterprises (FISME) for 2024-25?

Detailed Solution for SEBI Grade A (IT) Mock Test - 3 - Question 3
The correct answer is Sandeep Jain. In News
  • Sandeep Jain, has been unanimously elected as the President of FISME for the term 2024-25.

Key Points

  • Jain's election was approved during the meeting of the Central Executive Committee (CEC) of FISME held in New Delhi.
  • He is an alumnus of IIT-Kanpur and an auto-component manufacturer.
  • Prior to assuming the role of President, Jain served as the Vice President of FISME, showcasing his dedication and involvement in the organization's activities.
  • He took over the position from Prashant Patel, a manufacturer of dyes and chemicals with plants in Ahmedabad and Surat.
  • Jain's background in mechanical engineering, along with his extensive experience in the industry, positions him well to address both legacy challenges and emerging trends in the MSME ecosystem, including advancements in technology and climate solutions.
  • Furthermore, Jain's involvement in the Indo-German Manager Training program and his role as the Northern Region head for IGBDA highlight his commitment to professional development and networking within the industry.
SEBI Grade A (IT) Mock Test - 3 - Question 4
In the finals of the men's javelin throw event at the Federation Cup 2024, Neeraj Chopra defeated ______________ to claim the gold medal?
Detailed Solution for SEBI Grade A (IT) Mock Test - 3 - Question 4

The correct answer is DP Manu

In News

  • Neeraj Chopra, the acclaimed Olympic and world champion, emerged victorious in the men's javelin throw event at the Federation Cup 2024, clinching the gold medal.

Key Points

  • Neeraj Chopra's achievement at the Federation Cup 2024 adds to his illustrious career as both an Olympic and world champion in javelin throw.
  • His winning throw of 82.27 meters came on his fourth attempt, surpassing DP Manu, who led the competition until the third round with a throw of 82.06 meters.
  • This victory not only highlights Neeraj Chopra's consistent excellence in javelin throw but also his ability to outperform amidst strong competition.
  • Neeraj Chopra's winning throw of 82.27 meters underscores his skill and dedication to maintaining a top position in the sport on both national and international platforms.
  • The Federation Cup 2024 served as a competitive stage for India's top javelin throwers, showcasing the depth of talent in the country.
SEBI Grade A (IT) Mock Test - 3 - Question 5
Which author has been awarded the Sahitya Akademi Fellowship, the highest literary honour given by the literary organisation?
Detailed Solution for SEBI Grade A (IT) Mock Test - 3 - Question 5
The correct answer is Ruskin Bond. In News
  • Ruskin Bond, the eminent author, has been awarded the Sahitya Akademi Fellowship, the highest literary honour given by the literary organisation.
Key Points
  • Due to his ill health, the honour was presented to him at his Mussoorie home by Sahitya Akademi president Madhav Kaushik and Sahitya Akademi secretary K. Sreenivasarao.
  • Born on May 19, 1934, in Kasauli, Himachal Pradesh, Ruskin Bond has been an active writer for over 50 years, contributing to various genres of literature.
  • His notable works include Vagrants in the Valley, Angry River, Tales of Fosterganj, and The Blue Umbrella, among others.
  • Ruskin Bond has received numerous accolades, including the Padma Shri in 1999, Padma Bhushan in 2019, and Sahitya Akademi Bal Sahitya Puraskar in 2012.

SEBI Grade A (IT) Mock Test - 3 - Question 6
Which company has been recognized and honored by the Bureau of Indian Standards (BIS) for its outstanding commitment to quality and branding excellence?
Detailed Solution for SEBI Grade A (IT) Mock Test - 3 - Question 6

The correct answer is Genius Box

In News

  • Genius Box, a leader in DIY educational kits for children, has been acknowledged by the Bureau of Indian Standards (BIS) for its exceptional dedication to quality and branding.

Key Points

  • The company has pioneered the "Play-full-learning" methodology, aiming to make learning enjoyable and engaging for children by incorporating play-based activities alongside educational content.
  • Genius Box's products are designed to instill curiosity, creativity, and critical thinking, thereby imparting essential 21st-century skills including problem-solving and effective communication.
  • By offering a diverse range of kits that cover various subjects from STEM to arts and crafts, Genius Box supports not just classroom learning but also homeschooling, making it a versatile tool in a child's learning journey.
  • The upcoming range from Genius Box promises even more enriching experiences, emphasizing skill development and multidisciplinary learning to further enhance socio-emotional development, logical reasoning, and problem-solving skills among children.

Additional Information

  • The Bureau of Indian Standards (BIS) is the National Standards Body of India, operating under the Department of Consumer Affairs, Ministry of Consumer Affairs, Food & Public Distribution, Government of India.
  • It was formed on December 23, 1986, with its headquarters located at Manak Bhawan in Old Delhi.
  • The motto of BIS is "मानकः पथप्रदर्शकः" (Mānakaḥ Pathapradarśakaḥ), which translates to "Standards are the guiding path" in English.
  • BIS is a statutory body under the Bureau of Indian Standards Act, 1986, with Pramod Kumar Tiwari, IAS, serving as the Director General.
SEBI Grade A (IT) Mock Test - 3 - Question 7

What fake thing made the state of Kerala panic?

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

The correct answer is fake plastic eggs.

Key Points

  • The paragraph clearly states the following –

‘Two weeks ago, Kerala was aflutter over reports that “fake” plastic eggs from China were being sold in supermarkets.'

  • Hence from the passage, we can infer that option 2 is the correct answer.
SEBI Grade A (IT) Mock Test - 3 - Question 8

Choose the correct antonym of the word ‘boycott‘ as highlighted in the paragraph in context to the whole from the given options.

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

The correct answer is 'sanctioned'.

Key Points

  • If a country, group, or person boycotts a country, organization, or activity, they refuse to be involved with it in any way because they disapprove of it.
  • Sanctioned means to give official permission or approval for (an action).
  • This makes option 3 the correct answer.

Additional Information

The meaning of the other options are as follows -

  • avoid - keep away from or stop oneself from doing (something).
  • exclude - deny (someone) access to a place, group, or privilege.
  • outlaw - ban or make illegal.
SEBI Grade A (IT) Mock Test - 3 - Question 9

Which of the following should be the FIRST sentence after the arrangement?

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

The correct answer is E.

Key Points

  • The first sentence is E as it is introducing the topic by mentioning about a meeting.
  • The second sentence is D as it mentions that the deputy government also attended the meeting.
  • The third sentence is B as it mentions what was said at the meeting.
  • The fourth sentence is C. It informs that some other issues were also discussed at the meeting.
  • The last sentence is A as it is concluding the passage by mentioning the purpose behind the discussion of these issues.
  • Thus the correct sequence is EDBCA.
  • The first sentence is E.

Additional Information

  • Concern: to relate to or to worry
  • Regulator: a person or body that supervises a certain industry
  • Assessment: evaluation or judgement
SEBI Grade A (IT) Mock Test - 3 - Question 10

Which of the following should be the FIFTH sentence after the arrangement?

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

The correct answer is A.

Key-Points

  • The first sentence is E as it is introducing the topic by mentioning about a meeting.
  • The second sentence is D as it mentions that the deputy government also attended the meeting.
  • The third sentence is B as it mentions what was said at the meeting.
  • The fourth sentence is C. It informs that some other issues were also discussed at the meeting.
  • The last sentence is A as it is concluding the passage by mentioning the purpose behind the discussion of these issues.
  • Thus the correct sequence is EDBCA.
  • The fifth sentence is A.

Additional Information

  • Concern: to relate to or to worry
  • Regulator: a person or body that supervises a certain industry
  • Assessment: evaluation or judgement
SEBI Grade A (IT) Mock Test - 3 - Question 11

Which of the following should be the SECOND sentence after the arrangement?

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

The correct answer is D.

Key-Points

  • The first sentence is E as it is introducing the topic by mentioning about a meeting.
  • The second sentence is D as it mentions that the deputy government also attended the meeting.
  • The third sentence is B as it mentions what was said at the meeting.
  • The fourth sentence is C. It informs that some other issues were also discussed at the meeting.
  • The last sentence is A as it is concluding the passage by mentioning the purpose behind the discussion of these issues.
  • Thus the correct sequence is EDBCA.
  • The second sentence is D.

Additional Information

  • Concern: to relate to or to worry
  • Regulator: a person or body that supervises a certain industry
  • Assessment: evaluation or judgement
SEBI Grade A (IT) Mock Test - 3 - Question 12

If the fail percentage of school P is 60% then, find number of students who failed from school P is what percentage of the number of students passed from school T

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

Given that:
Fail percentage of school P is 60%. Then, pass percentage of school P is 40%.

Formula Used:
Percentage = (Actual/Total) × 100

Calculation:
From the given graph,
Students who passed in school P = 80
⇒ 40% = 80
⇒ 1% = 2
⇒ 60% = 60 × 2 = 120 {Failed students of school P)
Now, the number of students passed from school T = 90
Then, the required percentage = (120/90) × 100 = (4/3) × 100
⇒ 133.33%
∴ The required percentage is 133.33%

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

Who sits 4th to the left of the one who sits 5th to the right of the person sitting 2nd from the left end of the row?

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

Given:
People sitting in a row facing North.
1. Only 2 people sit to the left of U, who sits 10 places away from M.
2. 3 people sit between M and N, who sits 3rd to the left of T.
3. N sits 5th from the right end.
4. T does not sit beside M.

4. P, who sits to the immediate right of U, has 4 people sitting between him and L.
5. U sits 7th to the left of G, who sits 3rd to the right of A.
6. O sits to the right of T.

7. D sits to the immediate right of I, who sits 3rd to the left of O.
8. J sits at an end of the row beside E, who sits 10th to the left of R.
9. B, who sits beside R, has 2 people between him and Q who sits to the left of B.
10. M does not sit beside Q.

E sits 2nd from the left end of the row.
A sits 5th to the right of E.

Hence, U sits 4th to the left of A.

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

How many people sit between Q and the one who sits 9th from the right end of the row?

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

Given:
People sitting in a row facing North.
1. Only 2 people sit to the left of U, who sits 10 places away from M.
2. 3 people sit between M and N, who sits 3rd to the left of T.
3. N sits 5th from the right end.
4. T does not sit beside M.

4. P, who sits to the immediate right of U, has 4 people sitting between him and L.
5. U sits 7th to the left of G, who sits 3rd to the right of A.
6. O sits to the right of T.

7. D sits to the immediate right of I, who sits 3rd to the left of O.
8. J sits at an end of the row beside E, who sits 10th to the left of R.
9. B, who sits beside R, has 2 people between him and Q who sits to the left of B.
10. M does not sit beside Q.

M sits 9th from the right end of the row.

Hence, 4 people sit between Q and M

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

Who sits 7th to the right of P?

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

Given:
People sitting in a row facing North.
1. Only 2 people sit to the left of U, who sits 10 places away from M.
2. 3 people sit between M and N, who sits 3rd to the left of T.
3. N sits 5th from the right end.
4. T does not sit beside M.

4. P, who sits to the immediate right of U, has 4 people sitting between him and L.
5. U sits 7th to the left of G, who sits 3rd to the right of A.
6. O sits to the right of T.

7. D sits to the immediate right of I, who sits 3rd to the left of O.
8. J sits at an end of the row beside E, who sits 10th to the left of R.
9. B, who sits beside R, has 2 people between him and Q who sits to the left of B.
10. M does not sit beside Q.

Hence, B sits 7th to the right of P.

SEBI Grade A (IT) Mock Test - 3 - Question 16

If the Villas of Balu and Daya interchanged then who among the following stays with Daya?

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

Given Details

Twelve friends—Jishnu, Jay, Hari, Balu, Abhi, Keshav, Ambani, Sanju, Daya, Sreerag, Rohan, and Raghu.
Four different villas; Villa A, Villa B, Villa C, Villa D
Each villa has at least two people and at most four people staying.
Villa C has the least number of people staying in it.
Villa B and Villa D have three people staying in each villa.
Here we get Villa C has two people Staying (Two is the least) and Villa B and Villa D have three people staying in each Villa. So the remaining four people will stay in Villa A.

Keshav and Ambani stay together.
Keshav stays in the villa with the least number of people.
Here we get Keshav and Ambani staying together in Villa C

Balu is staying in Villa A. Sanju stays with three other people. Jay stays in a Villa having even number of people. Here Sanju stays with three other people so he stays in Villa A and Jay stays in Villa A, which has an even number of people staying in it.

Sreerag and Abhi stay in the same Villa but not in Villa D. Jishnu stays with 2 other people. Here we get Sreerag and Abhi staying in Villa B. For Jishnu there are 2 cases

Case 1: Jishnu stays in Villa B.

Case 2: Jishnu stays in Villa D.

Rohan and Raghu stay together but not in the Villa B.
Neither Daya nor Hari does not stays in Villa B.
Daya stays with 2 other people only.
Here we get the final case as Hari stays in Villa A and Daya in Villa D

Hence if we interchange Balu and Daya then Daya stays with Sanju.

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

In the given question, a sentence is given with a part of it missing and represented by a blank. Choose the phrase that can be placed in the given blank to make a meaningful and grammatically correct sentence.

Tamil Nadu _____________ population of vultures south of the Vindhya Mountain Range.

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

The correct answer is "boasts the largest."

Key Points

  • Let us understand the meaning of the given words:
    • "Boats" is the plural form of boat which means a small vehicle used to travel across water.
      • Example: The lure of a better life abroad was tempting thousands of people into rickety boats.
    • "Behests" means a person's orders or command.
      • Example: The budget proposal was adopted at the mayor's behest.
    • "Boasts" is (used about a place) to have something that it can be proud of.
      • Example: The city boasts over a dozen restaurants.
    • "Bequeaths" means to arrange for something to be given to somebody after you have died.
      • Example: He bequeaths one lakh rupees to charity.
  • In the given sentence, "Tamil Nadu" is said to be self praising the population of vultures in the state.
  • Thus, from the above explanation, it is clear that the word "boasts" will be appropriate for the blank, according to its meaning.

Hence, the correct answer is option 3.

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

In the following question, two columns are given containing three phrases each. In the first column phrases are A, B, C and in the second column, the phrases are D, E, 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 - 3 - Question 18

The correct answer is C-F.

Key Points

  • Part C states 'The tablets brought temporary' and part F states 'respite from the excruciating pain'.
  • In part F, the word respite means an interval of rest or relief​ and excruciating means causing great pain or anguish.
  • Here, it's said that the tablets gave them temporary relief from the intense pain.
  • There is only one correct combination in the given options i.e. C-F is the correct combination.

The correct sentence is, C-F: The tablets brought temporary respite from the excruciating pain.

Additional Information

Let us see the meaning of the words:

SEBI Grade A (IT) Mock Test - 3 - Question 19
A and B together can do 50% of a work in 6 days. The efficiency of C is 25% more than that of A and the efficiency of B is 50% more than A. In how many days B and C together can complete 75% of the work?
Detailed Solution for SEBI Grade A (IT) Mock Test - 3 - Question 19

Given :

50% of the total work by A + B in = 6 days

Efficiency of B = 50% more than A

Efficiency of C = 25% more than A

Calculation :

Time taken by (A + B) to complete the 100% of the work = 6/0.50 = 12 days

Efficiency ratio of A : B : C = 100 : 150 : 125 = 4 : 6 : 5

Total work = (4 + 6) × 12 = 120 units

Time taken by (B + C) to complete the 75% of the work = (120 × 0.75)/(6 + 5) = 90/11 days

Hence, the correct answer is 90/11 days.

SEBI Grade A (IT) Mock Test - 3 - Question 20

The ratio of the sum of half of A's present age and B's present age to B's present age is 5 : 4. If the average age of A, B and C is 40 years and the age of C after 15 years is 25% more than his present age. Find the present age of B ?

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

⇒ (A/2 + B) / B = 5 / 4

⇒A + 2B / 2B = 5 / 4

⇒4A + 8B = 10B

⇒4A = 2B

⇒A : B = 1 : 2

Average age of A,B and C is 40 years

Then sum of age of A, B and C is 120 years

After 15 years C age is 25% more than his present age

⇒25 % = 1 / 4

Present age : after 15 years is = 4 : 5

Then the present age of C is 4 × 15 = 60 years

⇒( A + B + 60 ) = 120

⇒( A + B ) = 60 years

Ratio ages of A and B is 1 : 2

⇒3 unit = 60

⇒1 unit = 20

Then, age of B is 2 × 20 = 40 years

Hence 40 is the correct answer.

SEBI Grade A (IT) Mock Test - 3 - Question 21

Directions: There are three statements in the following question after which there are five conclusions given in options. You have to assume that the statements are true regardless of whether they are commonly known statements or not and then choose the conclusion that logically follows these statements.

Statements:
I. All Innovations are Startups.
II. No Startup is Entrepreneur.
III. Some Entrepreneurs are Investors.

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

The least possible Venn diagram for the given statements is as follows -

Conclusions:

1). Some Investors are not Entrepreneurs. → False (There is no negative relation given between Investors and Entrepreneurs. It is possible that All Investors are Entrepreneurs. So it is not definite that Some Investors are not Entrepreneurs. Hence, it doesn't follow.)

2). Some Startups are not Innovations. → False (There is no negative relation given between Startups and Innovations. It is possible that All Startups are Innovations. So it is not definite that Some Startups are not Innovations. Hence, it doesn't follow.)

3). Some Investors are not Startups.True (It is given that No Startup is Entrepreneur and Some Entrepreneurs are Investors. So the part of Investors which is Entrepreneurs can never be Startups. Hence, it follows.)

4). Some Entrepreneurs are Innovations. → False (It is given that All Innovations are Startups and No Startup is Entrepreneur. So it is definite that No Entrepreneur is Innovation. Hence, it doesn't follow.)

5). Some Startups are Investors. → False (There is no direct relation given between Startups and Investors. So it is not definite that Some Startups are Investors. Hence, it doesn't follow.)

Hence, the correct answer is Some Investors are not Startups.

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

DBMS is comprised of tables that made up of rows called ______ and columns called ______.

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

The correct answer is Records, fields.

Key Points

  • In the Relational database model, a table is a collection of data elements organized in terms of rows and columns. A table is also considered a convenient representation of relations. But a table can have a duplicate row of data while a true relation cannot have duplicate data.
  • Fields and records are two basic components of a database, which is an organized collection of information, or data. The term "fields" refers to columns or vertical categories of data; the term "records" refers to rows or horizontal groupings of unique field data. Examples of both database components are seen in older, printed databases and also in modern, computer-based databases.
  • A single entry in a table is called a Tuple or Record or Row. A tuple in a table represents a set of related data.
  • A table consists of several records(row), each record can be broken down into several smaller parts of data known as Attributes.
SEBI Grade A (IT) Mock Test - 3 - Question 23

Let post order traversal of a binary search tree (BST) is given by VSQTURP. If S < V < Q < P < T < R < U, then the pre-order traversal of the BST is:

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

Binary search Tree Inorder always be in Ascending order

Since S < V < Q < P < T < R < U

Therefore In order traversal is SVQPTRU

Given post order is VSQTURP

Binary Search Tree:

Therefore Pre-order traversal of the binary search tree is PQSVRTU.

The correct answer is option 2

SEBI Grade A (IT) Mock Test - 3 - Question 24
Which of the following is a keyword is used for a storage class?
Detailed Solution for SEBI Grade A (IT) Mock Test - 3 - Question 24

Storage Classes are used to describe the features of a variable/function. These features basically include the scope, visibility and lifetime which help us to trace the existence of a particular variable during the runtime of a program.

C language uses 4 storage classes: auto, extern, static and register

auto:

This is the default storage class for all the variables declared inside a function or a block. Hence, the keyword auto is rarely used while writing programs in C language. Auto variables can be only accessed within the block/function they have been declared and not outside them. They are assigned garbage value by default whenever they are declared.

Important Points:

extern is storage class not external
SEBI Grade A (IT) Mock Test - 3 - Question 25
Which of following is incorrect SQL?
Detailed Solution for SEBI Grade A (IT) Mock Test - 3 - Question 25

Aggregate functions are functions that take a collection (a set or multiset) of values as input and return a single value.

The input to sum and avg must be a collection of numbers, but the other operators can operate on collections of non-numeric data types, such as strings.

Sum function cannot work on two columns.
SEBI Grade A (IT) Mock Test - 3 - Question 26
What is the keyword used to creating triggers in DBMS?
Detailed Solution for SEBI Grade A (IT) Mock Test - 3 - Question 26

A trigger is a stored procedure in database which automatically invokes whenever a special event in the database occurs.

Example: A trigger can be invoked when a row is inserted into a specified table.

Syntax:

create trigger [trigger_name] [before | after] {insert | update | delete}

on [table_name] [for each row] [trigger_body]

SEBI Grade A (IT) Mock Test - 3 - Question 27
If the maximum number of elements in the array declaration float ary[x][9] is 117 then what is the value of x?
Detailed Solution for SEBI Grade A (IT) Mock Test - 3 - Question 27

Definition of two-dimensional array

float ary[x][9];

Number of rows: x

Number of columns: 9

9x = 117

∴ x = 13
SEBI Grade A (IT) Mock Test - 3 - Question 28
In which of the following linked list, the last node of that list points to the first node of that list?
Detailed Solution for SEBI Grade A (IT) Mock Test - 3 - Question 28

Circular linked list:
In singly linked lists and doubly linked lists, the end of lists is indicated with a NULL value. But circular linked lists do not have ends. In circular linked lists, each node has a successor, and the last node points to the first node instead of NULL.

Example

Let x be a variable pointer and head.

Head is the pointer of the circular linked list.

Now to insert a new record (node) y, we have to loop through the linked list from the head to the last node like this pseudocode below.

x=head

while(x->next!=head)

{

x=x->next;

}

After finishing the loop x is now the last node and we will append the list. y is the next node of x Then the next of y will have to point to the head since the linked list is circular.

SEBI Grade A (IT) Mock Test - 3 - Question 29
Suppose there is a relation R (A, B, C, D) with functional dependency set (A → BC). The relational R is decomposed into R1(ABC) and R2(AD). The decomposition is ____.
Detailed Solution for SEBI Grade A (IT) Mock Test - 3 - Question 29

In the dependency preservation, at least one decomposed table must satisfy every dependency.

If a relation R is decomposed into relation R1 and R2, then the dependencies of R either must be a part of R1 or R2 or must be derivable from the combination of functional dependencies of R1 and R2.

If the relation R (A, B, C, D) with functional dependency set (A->BC) is decomposed into R1(ABC) and R2(AD), it is dependency preserving because FD A->BC is a part of relation R1(ABC).

SEBI Grade A (IT) Mock Test - 3 - Question 30
Relation algebra query that finds customer's who have a balance more than 1000, from deposit table is:
Detailed Solution for SEBI Grade A (IT) Mock Test - 3 - Question 30

π customer_name (σ balance > 1000 (Deposit)) will be the correct answer

Important Points

Project Operation (π)

It projects column(s) that satisfy a given predicate.

Notation − πA1, A2, An (r)

Where A1, A2 , An are attribute names of relation r.

Duplicate rows are automatically eliminated, as the relation is a set.

Select Operation (σ)

It selects tuples that satisfy the given predicate from a relation

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

Top Courses for Bank Exams

Download as PDF

Top Courses for Bank Exams