Java mcq- https://pythonvenue.blogspot.com/2020/05/tcs-pa-java-mcqs.

html

https://thanks4help.blogspot.com/p/tcs-xplore-hackathon-java.html

https://pythonvenue.blogspot.com/2020/05/tcs-opa-mcqs-8-may.html

Q1. In which year TCS was established?

Ans- 1968

Q2. Which of the following sorting algorithms are best suited when almost all elements
are already sorted(max one or two are not sorted)?
Ans - Insertion Sort

Q3. What is the use of CAPTION tag in HTML?

Ans- Add Title to the table

Q4. What is the use of Blockqoute tag in HTML?

Ans- Used to indicate the quotation of a large section of text from another source

Q5. Which of the following is inline tag in HTML?

Ans- <b> <a> <i> <img> <q> <br>

Q6. Syntax to define array in Javascript.

Ans- arrayname = [ ]

Q7. Table Level Constraint in Mysql.

Ans- Check , Primary Key

Q8. Command to compress a file in UNIX.

Ans- gzip , bzip2, zip

Q9. Command to give length of longest line in a file in UINX.

Ans - wc -L filename

Q10. When to use dynamic programming approach?

Ans- Optimization is needed

Q11. How to give negative information through email?

Ans- Negative information should not be given
Q12. You are new to an organization and you are middle of an assessment then only
your senior asked to attend a seminar behalf on him.
Ans - Politely say you will attend after completing your assessment

Q13. Pattern matching command in UNIX.

Ans - grep

Q14. TCS has won mega partner excellence award in

Ans- 2017

Q15. Two A's of effective writing is

Ans- Accurate and Accesssible

Q16. Details provided in signature of email

Ans- Name,Email,Phone,Role

Q17. Some challenges of Artificial Intelligence

Ans- Cost, Common Sense, Technology

Q18. Synatx of background image in css

Ans- background-image

Q19. All html tgs have closing tags

Ans- False

Q20. How mant types of indices are present in sql server

Ans- 2

Q21. Emphasizing the text in HTML

Ans- <em>

Q22. Which of the following is not a formatting tag in HTML?

Ans- <p>

Q23. Invalid filed in HTML

Ans- Day
Q24. Fastest sorting algorithm among Heap,Merge,Quick & Selection Sort
Ans- Merge

Q25. Which of the following in not a dynamic programming approach?

Ans- Primes Algorithm

Q1. What is the command for ordered list with roman number in HTML?
Ans- <ol type='I'>

Q2. What is not a CSS unit?

Ans- ut

Q3. To remove a folder which have files

Ans- rm -rf

Q4. Being objective in writing skills means

Ans- Figuring out facts and something & Figuring out facts not personal view

Q5. p{ color : green} <p>xyz</p>

Ans- Paragraph will be printed in green color

Q6. Judging others based on our culture

Ans- Ethnocentrism

Q7. Sql commands to drop a column from a table

Ans- Alter table tablename drop column columnname

Q8. Correct Sql command to check between the value

Ans- BETWEEN value1 and value2

Q9. What’s the difference between public and private cloud

Ans- Deployment Location

Q10. Computer algorithms that learn from previous result

Ans- Classification
Q11. The production log can be shared with the concerned team after appropriate
Ans- Approval

Q13. Which of the following is invalid escape sequence in javascript?

Ans- /e

Q14. Which method is used by humans while making judgments?

Ans- Intuitive

Q15. The filed that investigate in intelligence is

Ans- Cognitive Science

Q16. One power and one neutral wire is known as

Ans- Single Phase

Q17. Which of the following is valid modes of operation in vi editor?

Ans- Command Mode

Q18. What is minimum number of disks in RAID

Ans- 3

Q19. To copy two files in a new file in UNIX

Ans- cat file1 file2 > file3

1. Which application takes highest maintaince cost ?

Ans - Native Application

2. What will be fair, honest, transparent and ethical in our conduct .

Ans - Integrity

3. Major Concern of data centers is

Ans - Data Loss

4. Navigational concern is one of the key consideration for hybrid application as the UI flow can be
complicated .
Ans - TRUE

5. The science and technology that deals with Automatic Computer driven machine which replaces
Humans is called ad
Ans - Robotics

6. Customers asserts that Cloud computing permite bussinesses to bypass upfront infrastructure charge.
Ans - TRUE

7. Key expectation in mobile application development is

Ans - Option 1 and 2

8. What are two A's of effective writing.

Ans- Accurate and Accessible

KYT

1. Technique include fluid layout design so that site can adjust according to the resolution of the
device

a. Hybrid Design b. Adaptive Design

c. Responsive Design d. Progressive Design

2. Cloud services are massively scalable IT enabled capabilities which are delivered to external
customers using Internet technology

a. TRUE b. FALSE

3. I need a software to install in my laptop to complete a critical delivery. Should I do it ?

a. Since a client will be expecting delivery, downloading the software can be done
 b. Never make unauthorized copies of computer software program to use unlicensed software on
company’s computer/laptop

4. Who founded TATA groups?

a. Dorabaji TATA b. Jamsetji TATA

c. NOEL TATA d. Ratan TATA

5. What are the problem associated with Big Data ?

a. All of the option

b. Not accustomed to dealing with such large quantities of data

c. Inexperience collecting data from nontraditional resources

d. Overlay complex with relatively slow system

Bizz Skill

1. What are the elements of Project Status Report?

a. Current Status, Area of Concern , Suggestions & Plan for Next phase

b. Current Status, Area of Concern

c. Current Status, Area of Concern , Plan for Next phase

d. Current Status, Area of Concern , Suggestions

2. What are the elements of conversation ?

a. Plan, Prepare, Close & Clarify along the way

b. Think, Know, Say, Close and Clarify

c. Think, Learn , Know, Say, Close and Clarify

d. Plan, Prepare, Listen, Close & Clarify along the way

3. Jennifer works as a Project Manager. She is required to provide a solution to beat the exponential
increase in costs. What could be the best possible requirement?

a. Provide justification for the increase in cost

b. Avoid any audit necessary for cost control

c. Persuade the associates to spend addition working hours

d. Automation of the tasks which requires continuous monitoring & analysis

5. What is the aim of Project Development under digital learning program?

a. It is the art of delegating works to others and getting the appreciation

b. Complete the works assigned by managers within specified time frame to help
organization to make more profit

c. Synthesize the technical and business skill set that help associate to become adaptive in
digital business requirement

d. It is simply about writing long lines of code & integrating module at the end

Design & RiO

1. List three aspects that will be at stake, if a major impact on business has occurred due to outage

a. Integrity in Business b. Brand Reputation

c. Employee Utilization d. Sales Revenue

2. Developers should follow design principles to achieve which of the following quantities?

a. Maintainability b. Readability

d. Extensibility d. Simplicity

3. As per good programming practice it is better to __________ in code.

a. Minimize coupling & decrease cohesion

b. Maximize coupling & increase cohesion

c. Minimize coupling & increase cohesion

d. Maximize coupling & decrease cohesion

4. Rio provides TCSers with “RiO Workbench”, a framework that help us to benchmark our maturity in
providing support.

a. TRUE b. FALSE

5. Do you think you know the secret to success ? Select the option that leads to success.

a. Continuous learning as it makes an individual have a steady growth in his career

b. Being Proactive

c. Continuous innovation and differentiation

d. Taking up responsibilities of his/her action

 UNIX

1. What will be the output of the below command?

find . -type f -perm 0777 -print

a. Display all files who has all the three permission for all levels of users

b. Display all directories who has all the three permission for all levels of users

c. Display all files who has minimum level of permission for all levels of users

d. Display all folders who has all the three permission for all levels of users

2. Which awk script will give you the average of second column of the file named file1, which has ‘|’ as the
delimiter

a. awk ‘BEGIN(FS=”|”;s=0)(s=s+$2)END(print s/NR)’ file1

b. awk ‘BEGIN{FS=”|”;s=0}{s=s+$2}END{print s/NR}’ file1

c. awk ‘BEGIN{FS=”|”;s=0}{s=s+$2}END{print s}’ file1

d. awk ‘BEGIN{FS=” ”;s=0}{s=s+$2}END{print s/NR}’ file1

3. What is the use of diff command & what is the correct syntax ?

a. diff file1 options file2 . This command is used to display the difference in the file by
comparing the file line by line

b. diff options file1 . This command is used to compare the lines within the a file a display
the lines which are different

c. diff options file1 file2 . This command is used to display the difference in the file by
comparing the file line by line

d. diff file1 file2 options. This command is used to display the difference in the file by
comparing the file line by line
4. What is the use of shebang line in Unix?

a. It indicates the directory in which the shell is saved.

b. A first line in the shell scripts which shell need to be execute the following command
in the shell scripts

c. The line which contains the total numbers of lines in the shell scripts

d. None of the Above

MYSQL

1. Which is the significance of using a number in an order by clause?

a. Number used in an order by clause signifies the position of a column in a table

b. Number used in an order by clause signifies the position of a column in the select list

c. Number used in an order by clause signifies the position of a column in the where clause

d. Number cannot be used in a order by clause

2. Which of the following set of operation can be used to enable a multi value comparison within a
single column?

a. CHCECK b. IS NULL

b. LIKE d. IN

3. What is the output of below Query:

USE CUSTOMER;

a. SQL command is used to select view named as “CUSTOMER”

 b. SQL command is used to select database named as “CUSTOMER

a. SQL command is used to select table named as “CUSTOMER”

b. Wrong Query

UI

1. Which of the below is the correct way to set a font size?

a. h2 {font-size:200pixels;} b. h2 {font-size:200;}

b. h2 {font-size:200px;} d. h2 {font-size:200%;}

2. To specify table border in CSS _____ proper is used

a. table-border b. border

b. Tb-border D. tbl-border

3. Block element can be aligned by setting the left and right margin to “align”

a. TRUE b. FALSE

4. Output of the below script

<html>

<body>

<p id=”showresult”> <b> Welcome To TCS </b> </p>

<input type=”button” onclick=”display()” value=” Click Me”/>

<script>

function display()
 {

b = document.getElementById(‘showresult’).innerHTML;

alert(b)

</script>

</body>

</html>

a. Internal Error b. None of the option

b. <b> Welcome TO TCS </b> d. Welcome To TCS

5. Output of below script.

<html>

<body>

<input type=”text” name=”Java” value=”JDK” />

<input type=”text” name=”Version” value=”1.8” />

<button onclick=”display()”> Display </button>

<div id = “content”></div>

<script>

function display() {

a = document.getElementByTagName(“input”);

document.getElementById(‘content’).innerText = a[0].value+a[1].value;

</script>
 </body>

</html>

a. None of the Option b. JDK1.8

b. JavaVersion d. Internal Error

Python.

1. What is the output of the below code?

if 0:

print(“hai/”)

else:

print(“0 is falsy!”)

a. 0 b. NOT

b. hai d. 0 is falsy!

2. What is the output of below code?

tcs = {}

print(type(tcs))

a. <type ‘dict’> b. <type ‘list>

b. Array d. <type ‘tuple’>

 KYT

Big Data Applications prefers large datasets over small datasets

a. TRUE b. FALSE

Which are the below listed options that we need to take care with respect to environment
protection?

a. To prevent the wasteful use of natural resources

b. The management of waste and hazardous materials

c. Consumptions of water and electricity

d. All of the option

Reporting to any event(actual or potential) of misconduct that is not reflective in our values and
principles can be done via.

a. Any other reporting channel set out in our company’s “Whistleblower’ policy.

b. Designated ethics officials of our company

c. Reporting is not required as we should not interfere in other personal work

d. Immediate line manager or the Human Resource department of our company

 An associate is interested in Cloud, while his current project requires him to learn an Automation
Testing Tool, in which he has no interest. How can the situation be handled effectively ?

a. Ask for a release from the current account and join a project that caters to his interest.

b. The associate can forget the personal choices for the time being and go ahead with the project
requirement

c. The associate can prioritize the current need of the project. At the same time, he cater to personal
interests by striking a fine ball of time and interest

d. The associate can express his disinterest in learning the new Automation Testing Tool to the project
manager. The project manager instead can appoint another team member to learn the tool

How many hours of videos uploaded to YouTube every minute

a. 50 b. 80

b. 10 d. 100

Bizzskill

Advantages of Diversity include:

a. All of the options b. Fosters Innovation

b. Enhance employee engagement d. Improve business performance

Judging others person’s view solely based on our own values and culture is called :

a. Ethnocentrism b. Criticism

b. Centrality d. Diversity
 Sarah, an associate, is a bit confused about dinning etiquette. For a business lunch, Sarah took the
napkin and placed it on her lap. Which of the following does not come under the etiquette for napkin
use?

a. Do not crumple or twist it; fold it casually

b. When leaving the table at the end of the meal, place the napkin loosely next to your plate

c. Keep the napkin on your lap during the entire meal. Lift it to blot your mouth if needed

d. If your napkin falls on the floor during a formal meal , pick it up.

General best practice for Telephone etiquette include :

A. Assuming proper posture

B. Speaking clearly & slowly

C. Smiling when speaking

D. Giving the call your full attention

E. Avoid confusion language

F. Speaking loudly

a. A , B, C b. All of the options

b. A, B, C, D, E d. B, C, D, F

Design

What is Single Responsibility Principle

a. One person gets one responsibility b. Do One thing at all levels

b. None of the options d. One class should perform a single task

 According to KISS Design Principle, we should use features like frameworks, APIs only when there are
perceptible benefits to the problem we are solving.

a. TRUE b. FALSE

What type of review must be done to determine the change success rate

a. pre-implementation review b. None of the options

b. Review is not required as it will be evaluated by clients d. post-implementation review

During a crisis, do not cascade incorrect updates to the customers and other associates. Always wait
for confirmation from the

a. DR Team b. none of the options

b. BCP Manager d. Crisis Management Team

UNIX

Which one is the true regarding awk command?

a. BEGIN and END blocks are not Mandatory in all awk commands

b. Both BEGIN and END blocks are mandatory in all awk commands

c. A END block is always mandatory whereas BEGIN block is not

d. A BEGIN block is always mandatory whereas END block is not

Which command will print the last line of a file ?

a. head – 1 filename b. last -s filename

b. tail -1 filename d. lp -s filename

Select the command to read the input from the User in shell scripting?

a. scan b. ip

b. read d. input

UI

Which option/opinions correctly represent the code of creating and initializing a string variable?

a. var str1=’Hello’; b. var str1=’’’Hello’’’;

b. var str1=Hello; d. var str1=”Hello”;

<h2 class=”fruit mango”> I love fruits </h2>

What is true about the above statement?

a. It is an invalid statement in HTML

b. It is a heading tag with a class named “fruit mango”

c. It is a heading tag with two classes named as “fruit” and “mango”

d. None of the option

Which of the following CSS syntax will be hiding the element?

a. h1.hidden{ display: hidden;} b. h1.hidden{ visibility: hidden;}

b. h1.hidden{ visibility: none;} d. h1. hidden { display: none;}

 “The <div> element is a block-level element” State true of false.

a. TRUE b. FALSE

Which of the following are the elements that have been added in HTML5?

a. <article> b. <header>

b. <footer> d. <main>

“I cannot create a JS array using the ‘new’ keyword” State true or false.

a. TRUE b. FALSE

State true or false. “ Different tags cannot share same class.”

a. TRUE b. FALSE

When Tata Consultancy Service was established?

a. 1968
b. 1971
c. 1978
d. 1988

Some challenges in Artificial Intelligence are

a. Cost
b. Common Sense
c. Technology
d. All of the above

We will be fair , honest, transparent and ethical in our conduct, everything we do must stand the test of
public scrutiny. The above quote applies to which of our five core values.
a. Responsibility
b. Pioneering
c. Integrity
d. Excellence
Prime difference between Private and Public Cloud is
a. Deployment Location
b. Hardware used
c. All of the options
d. Software used

Mobile application can interact with GPS and Camera of the device
a. True
b. False

Being objective in your writing is the ability to

1. Present accurate facts and figures
2. Present fact and not personal views
3. Present stereotypical information

• 1, 3
• 2, 3
• 1, 2
• 1, 2, 3

What is true about agile principles?

a. Leadership over management
b. Management over leadership
c. Adaptive over perspective
d. Perspective over adaptive
e. Customer collaboration over contract negotiation
f. Contract negotiation over customer collaboration

• a, d, f
• b, c, e
• a, c, e
• b, d, f

What all details should be provided in the signature of an e-mail? Choose the best options.
a. Name & role
b. Phone & e-mail
c. Personal address
d. Organization Website

• a, b & d
• a, b & c
• b, c & d
• a, b, c, d

Paul is working with a client who is casual while communicating him through a chat application. The
client send him memes and other forwards to build a better workplace relationship. Select the best
option.
a. Paul should take up this matter to HR.
b. Since client is informal while communicating Paul can do the same.
c. Paul can be task orient and polite. He can avoid responding by sharing memes and forwards
through chat applications.
d. Paul can tell the client that what is done so far is not right and that is not professional to do so.

Identify the correct statements

a. Accepting help is the sign of weakness
b. We can be little careless as we can apologize whenever we make a mistake. After all mistakes help
us learn
c. We need to accept help when needed. The key is to be assertive. Being honest about your
weakness build trusts.
d. Ask before help before something on your own. It will help you get a head start.

After creating a Knowledge Article (KA)

a. Ensure you have used standard template
b. Ensure exception are clearly visible
c. All the options
d. Check and re-certify the KA at regular interval

We use dynamic programing approach when

a. The solution has optimal substructure
b. The given problem can be reduced into 3-SAT problem
c. We need an optimal solution
d. Its faster than greedy

What is the sequence of the transition management phase

a. None of the option
b. Secondary Support to Primary Support to KT
c. Primary Support to Secondary Support to KT
d. KT to Secondary Support to Primary Support

Which of the following sorting algorithms in typical implementation gives best performance when
applied on an array which is sorted or almost sorted(maximum one or two elements are misplaced).

a. Quick Sort
b. Merge Sort
c. Bubble Sort
d. Insertion Sort

What is the use of $# in shell Scripting?

give the count of number of argument passed into shell script

Which is TRUE statement regarding PIPE(|) symbols?

Pipe symbol is used combine more than 1 UNIX commands.

The COUNT function in SQL returns the number of

Not NULL values
Which of the following is not a constraint in SQL?
ISNULL

Nulls in PL/SQL can be assigned and it can be equated with anything, including iteself.
FALSE

Choose the inc correct variable declaration from below statement

v_text number(10);

Which tag is correct to add CSS style inline using Style attribute?
<tagname style="property: value;">

The <noscript> tag can only used inside <body> element in HTML5.
FALSE

Strings in JAVA are Mutable.

FALSE

JAVA

1.class A
{Final a;
System.out.println(a);
}
error in line 3

2.To find length of the string:

String a;
1.a.length
2.a.length()

3.class Box{.....}
Class solution
{
Box box[]={b1,b2,b3,b4,b5};
for(int i=0;i<box.length();i++)
error ( because we should use box.length)

4.Object includes ?
1. attributes
2.behaviour
3.both
4.None

5.____is also known as static variable.. ?

1) class variable
2) instance variable
3) local variable
4) all of above

6.Predict output of program

char ch=127;
ch++;
System . out . println(ch+" = "+(int)ch);
1) compilation error
2) ? = 128
3) garbage value =-128
4) none of above

7.Predict output of program

String s[] = {hybernate, java, object}
Arrays . sort(s);
for(String k in s)
{
System . out . println(k);
}
1) java hybernateobject
2) hybernatejava object
3) hybernateobject java
4) object java hybernate

8.Predict output of program

String str = "I like JAVA";
System .out .println(str . length());
1) 12
2) 11
3) 10
4) 9

9.Which operator gives result if no condition satisfies.?

1) IN
2) OR
3) NOT
4) AND

10.Which is not the correct declaration ?

1.int a_1
2.int 1_a
3.int A1
4.None

11.Tick the correct one-

1.Java is platform independent
2.Jvm is platform dependent
3. Jvm converts byte code into machine level code

12.Static int a=1;

Inc()
{
a++;
print(a)
}
Inc()
Inc()
1.1,1
2.1,2
3.2,3

13.What is the output of relational operator?

Boolean(true, false)

14.Which among the following falls under key elements of programming?

1. Good analytical skills
2. Declarative knowledge
3. imperative knowledge
4. Abstraction knowledge in programming

15.What is the extension of java code files?

1. .java
2. .class
3. Both 1 and 2
4. txt

16.Which is not OOPS concept?

1.Compilation
2.Polymorphism
3.Encapsulation
4.InheritanceAns:
17.Which component is used to compile, debug and execute java program?
1.JIT
2.JRE
3.JVM
4.JDK

18.What is the extension of compiled java classes?

1..java
2..txt
3..class

19.Which of these can not be used for a variable name in java?

1.Identifier & keyword
2.Keyword
3.Identifier
4. None of these

20.expression1 ? expression2 :expression3|what it will return?

1.Float
2.Integer
3.Boolean

21.Which of these is long data type literal?

1.0x99fffa
2.0x99fffL
3.99671246
22.Which of these is superclass of every class?
1.String class
2.Object class
3.Abstract class
4.ArrayList class

23.Which of these keywords can be used to prevent inheritance of a class?

1.Constant
2.Class
3.Super
4.Final

BIZ SKILL

1.Two A's of effective writing.

accurate and accessible

2.Details provided in the signature of email ?

1.Name email
2.phone number
3.Role
4.address

3.Being objective in writing skills means

1.Figuring out accurate facts and something
2.Figuring out facts but not personal views
3.Assuming stereotypical information
1,2
1,3
1,2,3
2,3
4.While making the help document for the ABC application or something which factors should be in
consideration ?
1.User experience
2.Technical knowledge
3.Gender
4.Experience

5.Judging others based on our culture.?

Ethnocentrism

6.The production logs can be shared with the concerned team after appropriate ?
1.Data masking
2.Review
3.Approval
4.None

7.Agile principle
1.Leadership over management
2.Management over management
3.Adaptive over prescriptive
4.Prescriptive over adoptive
5.Customer collaborative over contort negotiation
6. Contort negotiation over customer collaborative

8.If a client become informal to you then what will you do.?
1.you will tell your hr
2.will be informal with him
3.will tell him to be formal
4.task oriented and will not send any stickers
9.If you are in between you assessment and your manager told you to attend the call what you will do...
?
1.say him politely that you will attend the call after your assessment
2.you will ignore it
3.you will tell him that you are doing your assessment
4.will not attend the call.

10.Declining help .. ?
1.Ignore help
2.say don't need anything
3.Not decline at first
4.Politely tell that you are ok and thank you for asking.

15.Paul is going to his brothers wedding....what should he exclude in his draft leave mail ?
1.Details of wedding and traveling back to office
2.Reason for leave and return date with other details
3.Current project status and whom to handover until you return

16.What is value added service?

Customers start recognizing and comparing you with other brand names

17. Mark the correct ones which can be written in psr(Project status report)
1.Current status
2.Plan for next phase
3.Areas of concern
4.Suggestions

18.MOM contains?
date, time, points discussed, participants, agenda, date for next meeting
19.What is Upward flow and downward flow?
Junior to senior and senior to junior

20.Kav is a client from Germany. Team speaks in their regional language. He feels a bit lost. What
can the team do differently.
The team lead should have stressed the usage of a common language that is English among team
members

23. Mike wants to draft an email to his client after his team came up with the network of an application.
The network was asked to be done by the client due to some issues that the customer faced after the
sample product was tested in the market. how should mike start his email ?
Apologize to the client for not meeting his expectations

24.select the effective sentence

The manager’s laissez faire attitude has led to an efficient work culture in the team.(the policy of
leaving things to take their own course, without interfering)

25.you received the project requirements from the client you are not clear about a certain requirement
what is the right way to respond?
Send an email to the client keeping your manager in the loop.

26.Vivian had around 5 minutes before an important meeting he found a client mail in his in box and
asked for additional requirement he is of the belief that emails need to be responded to promptly Vivian
wanted to be on time for the meeting and also wanted to reply to the client What should he do?
Take time of after the meeting and reply to the client after analyzing the requirement in detail.

27.Which of the following statements are incorrect?

1.to field is meant for primary emailrecipients email is for their information and action
2.CC field is meant for secondary email recipient the email is meant for their information
3.BCC field is typically used for internal broadcast
4.BCC field can be used to hide recipient while sharing an internal document

28.replace the underlined words with a more meaningful one. " Ben reverted/(_____) back to the mail
saying that the team will work collaboratively together".
Replied, together

29.which of the following factors should be considered while wearing ties.

ANS: The tip of tie should always touch the beltline.

38.how do you ask your supervisor for a promotion in an assertive tone?

I would like you to consider my name for the promotion as I believe I have taken on many new
responsibilities lately.

39.JAYA AND AMITABH CONVERSATION

Aishwarya : Passive –Aggressive
Jaya: Aggressive
Amitabh :Assertive

40.Chose The correct option a good email

A) Should never over communicate
B) Should contain Emotions
C) Should be properly specified and arranged
D) Should be polite in tone

41.When communicating with vendors which of the following statements is true?

We need to document every message between the vendor and TCS.

42.The Elevators are always crowded at ABC facility what rules of elevator etiquette shouldbe followed?
Always allow the people inside the elevator to disembark before entering the elevator.

44. Tcs has created a sofwareas required for a certain bank and add some addons?
Value added service

45.Some authorized member of 3rd team deleted some extra data this is because of?
1.lack of communication
2.lack of understanding
3.none of the above

46.one member of a team needs help to solve a problem, but he is afraid to ask for help he thinks that
they will not help him. This occurs due to?
Subject of assumption

47.Group Discussion is an important Culture in which country?

India, Japan, Australia
PLSQL

1.What type of join in below statement..?

Select column name(s) from table1 T1 , table2 T2 Where condition;
1.self join
2.inner join
3.outer join
4.Left outer join

2.Plsql question with global variables and local variables

1.95,95
2.95,195
3.195,195
4.Error

3.How many types of indices are present in sqlserver ?

1.2
2.1
3.3
4.4

4.Sql command-
1.select age where age between 30 and 100
2.select age where age(30,100)
3.select age where age>=30 and age<=100
5.Which is the invalid command in sql?
1.Revoke
2.Join
3.Fetch
4.Like

6.To increase the size of a column in SQL.. ?

ALTER TABLE table_name MODIFY column_name datatype(new_size)

7.One question from plsqlwas” the upward to lower flow in a loop is ....?”
1.inverse
2.reverse
3.backward
4.none

8.SQL Query used to search details based on the 1st character in a column..?
Select * from table_namewhere name like ‘(char)%’;

9.What is purpose of type and rowtype..?

TYPE provides datatype of a variable and ROWTYPE provides record type that represents a entire row
of a table or view or columns selected in the cursor

10.Procedure can be called in how many ways

1.automatically called
2.called using select statement
3.using execute command
4.calling the name of the procedure from other plsqlblock

11.What will happen(pl/sqlcode)Exit when (c1%rowcount>5) or (c1%notfound)

terminate loop when row count is greater than 5 or when no data found

12.Which are the types of conditional statements in plsql?

1. IF THEN END IFIF THEN ELSE END IFIF THEN ELSEIF END IF
2.IF THEN END IFIF THEN ELSE END IFIF THEN ELSIF END IF
3.IF THEN END IFIF THEN ELSE ENDIF THEN ELSEIF END
4.IF THEN END IFIF THEN ELSE ENDIF THEN ELSIF END

14.We cannot use where clause with truncate.

1.True
2.False

15.What is the output of the below query?

select left('Welcome to PLSQL',3)
1.wel
2.Error
3.SQL
4.We

16.Sql command to drop the column in specific table.. ?

alter table tablenamedrop column columnname
 TCS PA Unix MCQs

1.To copy two files in a new files ?

cat file1 file 2 > file 3

2.To sort the records from large to small number and print the largest number ?
Option with Desc limit 1

3.Grep tata.*services$//multiple answer question

which has tata --service –may contain anything like consultancy , conference etc..

4.To remove a folder which have files

1.rm –rf
2.rmdir –l
3.rmdiv
4.rmAns:

5.Grep –v java// multiple answer question

options which doesn’t contain the java word in the line is the answer

6.S=0 {s=s+$2}
Avg of second column
Sum of second column

7.Unix command to remove duplicates in line ?

1.sort –u
2.sort unique
3.uniq
4.unique
8.What is output of below commands.. ?
grep –o cat animal.txtgrep ‘cat’ animal.txt
1.cat cat
2.Cat Cat
3.None cat
4.none of these

9.File and directory permission access will be done by which command ... ?
chmod

10.On update cascade ensures what .. ?

1.Data integrity
2.Normalization
3.Materialized
4.All

11.Delete lines from ‘this’ file .. ?1.Sed/’this’/d file2.Delete –f this file3.Sed/this/file4.Sed/this/d fileAns :
1

12.String ‘llp’ file case insensitive.. ?

1.Grep –i‘llp’ file.txt
2.Grep –wi‘llp’ file.txt
3.Grep –w ‘llp’ file.txt

13.Compress file in unix.. ?

1.Compress
2.Comp
3.Zip
4.gzip

14.Pattern match at beginning of file ?

1.Pat^
2.Pat$
3.$pat
4.^pat

15.Length of longest file .. ?

1.Wc -cl
2.Wc –L <filename>
16.Sort file1| uniq–u
1.Sort the file name file 1 and diplaysdistinct lines
2.Find unique lines and sort
3.Command has syntax error
4.Sort the file and display duplicate lines

17.Query to delete primary key constraints .. ?

Drop

18.To print first line from file1.txt use,

1.echo $1 file1.txt
2.awk 'NR==1' file1.txt
3.head -1 file1.txt
4.sed -n '1p' file1.txt

19.What is output of below command

awk'BEGIN{s=0 while(s<55){print s; ++s}}'
1. prints 0 to 54 number
2. prints 0 to 55 number
3. syntax error.
4. infinite loop

20.To count only words from which command is used ?

1.wc filename
2.wc -w filename
3.wc -word filename

21.S=S+$2.. ?
1.avg of second column
2.sum of second column
3.None

22._____displays all environment variables

1.environ
2.env
3.HOME
4.HOM

23.in order to determinvalue of a variable use the command?

1.echo
2.cat
3.ls
4.set

24.What is unix?
1.an operating system
2.programming language
3.software
4.editor

25.What are three main components of the Unix Architecture

1.kernel,data,PC
2.pcb,utilities,shell
3.shell,kernel,shared memory
4.kernel,shell,utilities

26.When a process finished its execution and exit status not received by the parent, the process state
becomes...
1.new
2.stopped
3.orphan
4.Zombie

1 .Tcs had won the mega partner excellence award in ?

Options:

2007

2017

2018

2008
2.Two A's of effective writing ?

Ans: accurate and accessible

3.Details provided in the signature of email ?

Options

Name email

phone number

Role

address

Ans : 1,2,3

4.Some challenges in Artifical Intelligence ?

Options

cost

common sense

Technology
All

Ans : 4

5.Fastest Sorting alogithm ?

Ans:Merge

6.which is the not dynamic programming ?

Ans: Primes algorithm

7.Which algorithm will gives best performance

when array is half or almost sorted ?

Ans: Insertion sort

8.To copy two files in a new files ?

Ans: cat file1 file 2 > file 3

9.To sort the records from large to small number

and print the largest number ?

Ans: Option with Desc limit 1

10.Syntax of background image in css ?

Ans: background-image
11.All html tags have closing tags ?

Ans: false

13.what is command for order list with roman number ?

Ans: <ol type='I'>

14.Which is not css unit ?

Ans: ut

15.Cloud computing provides virtual and storage

adta. They can access our data or not ?

Ans: True

16. if[-r & 2]

Ans: is which contains right expresion in options

17.<p>top news </p>

<blockquote url: hindu news…. Com</blockquote>

Todays news block quote display or not ?

Ans : True

18. To remove a folder which have a files

Ans: rm –rf

19.String ‘llp’ file case insensitive.. ?

Ans : Grep –i ‘llp’ file.txt

20.What type of join in below statement..?

Select column_name(s) from table1 T1 , table2 T2

Where condition;

Ans: self join

21. Plsql question with global variables and local

variables

Ans :Error

22. Being objective in writing skills means

1.Figuring out accurate facts and something

2.Figuring out facts but not personal views

3.Assuming stereotypical information

Ans: 1,2

23. How many types of indices are present in sql server ?

Ans: 2

24. p{

color:green

<p>xyz</p>

Paragraph is printed in which color

Ans :Green

25. While making the help document for the ABC

application or something which factors should be in
consideration ?

Options

User experience
Technical knowledge

Gender

Ans : 1,2,4

26. Emphasing the text in html … ?

Ans : <em>

27. Tag which is not for formatting text ?

Ans : <p>

28. Judging others based on our culture.. ?

Ans : Ethnocentrism

29. Algorithm category.. ?

Ans : Minimum coupling and increase cohesion

30. Rio weekly celebrate because … ?
Ans : Aimed to improve System support operation

31. Computer algorithm which learns using previous result .. ?

Ans : Classification

32. The production logs can be shared with the

concerned team after appropriate ?

Ans :Approval

33. Sql command to drop the column in specific table.. ?

Ans : alter table tablename drop column columnname

34. Sql command correct syntax to check between the

values .. ?

Ans : BETWEEN val1 and val2

35. Duplication of code is the root cause of problem in
dp ?

Ans : True

36. What is difference between private and public cloud ?

Ans : Deployment location

37. which is the invalid field in HTML5 ?

Ans : Day

38. Which is invalid escape sequence in javascript ?

Ans : /e

39. which is the invalid command in sql ?

Ans :Fetch

40. which of the method is used by humans while

making judgements ?

Ans : Intuitive based

41. The field that investigates in intelligence is

Ans : Cognitive science

42. what is the exit condition … plsql ?

Ans : exit when SQL%NOTFOUND

43. What is minimum number of disks RAID ?

Ans : 3
44. One power and one neutral wire is know as

Ans : Single phase

45. Which is valid mode of operation in vi editor ?

Ans :Command mode

46. you have created a shell script and wants to run

the script . what should you do before trying to run the
script ?

Ans :Update the execute permission of the script…

48. To find length of the string

String a;

Ans : a.lenght();

49. class Box{

…..

}
Class solution {

Box box[]={b1,b2,b3,b4,b5};

For(int i=0;i<box.length();i++)

Ans : error

50.Mobile devices connect with GPS and camera of

our phone… ?

Ans : True

51.Delete lines from ‘this’ file .. ?

Ans : Sed/’this’/d file

52.In python section qn is

Print(‘TCS’+8)
Ans : Error

53.When tcs was established ?

Ans : 1968

54. Object includes ?

Options
1. attributes
2.behaviour
3.both
4.None
Ans : 2(Object includes behaviour and identity)

55.Agile principle

Options
Leadership over management
Management over management
Adaptive over prescriptive
Prescriptive over adoptive
Customer colloborative over contrort negotiation
Contrort negotiation over customer collaborative

Ans : 1,3,5

56.Caption tag is used with …

Options
Image
Table
Both
None
Ans : 3

57.Tcs values are

Ans: Integrity , Leading change , Respect for
individual , Excellence , learning and sharing.

58.We will be fair ,honest, transparent and ethical in our

conduct; everything we do must stand the test of public
scrutiny ? this refers to which value ?

Ans: Integrity

59.To increase the size of a column in SQL.. ?

Ans : ALTER TABLE table_name

MODIFY column_name datatype(new_size)

60.In unix section qn is

S=0 {s=s+$2}

Ans : Sum of second column

61.Is caption rage used to give table a caption … ?

Ans : True

62.Text-align:justify… ?

Options

Left
Right
Center
None of these

Ans : 4
63.If a client become informal to you then what will you
do… ?
//partially same meaning options , not exactly same

Ans : will him to be formal

64.One question from plsql was” the upward to lower flow

in a loop is …. ?”

Ans : reverse

65.If you are in between you assessment and your

manager told you to attend the call what you will do… ?
//partially same meaning options , not exactly same
Ans : say him politely that you will attend the call
after your assessment

66. a:link,a:visited {
background-color : red;
}
a:hover {
background-color : green
}
<a href = "abc.html">Click me </a>

Ans:will create a link having background color

red and on moving the pointer background color
will be green
67.SQL Query used to search details based on the
1st character in a column..?

Ans : Select * from table_name where name like

‘(char)%’;

68.Unix command to remove duplicates in line .. ?

Ans : sort –u

69.What is output of below commands.. ?

grep –o cat animal.txt

grep ‘cat’ animal.txt

Ans :cat cat

70.Question from javascript section ,”var x=100+5**3 ? “

Ans : 225NAN
71.File and directory permission access will be done
by which command … ?
Ans : chmod

72.What is purpose of type and rowtype ..?

(from plsql section)

Ans: TYPE provides datatype of a variable and

ROWTYPE provides record type that represents
a entire row of a table or view or columns selected
in the cursor

73.Which tag is used to emphasize the text.. ?

Ans : <emph> or <em>

74.On update cascade ensures what .. ?

Ans :Data integrity

75.Flow of information in R10.. ?

Ans :Primary -> Secondary -> KT