use these mcqs as a reference purpose. all the best kyt

26 January 2021 iON Proctored Assessment MCQs

Use these MCQs as a reference purpose.

All the Best

1 | P a g e

KYT The Science and Technology which deal with Automatic, Computer driven machine which replaces Humans is called as

1. Human Kinematics

2. Robotics

3. Cognitive Intelligence

4. None of the Options

Cloud Services are massively scalable IT enabled capabilities which are delivered to external customers using Internet technologies

1. TRUE

2. FALSE

Best Mobile application to make content of a website available to users

1. Native Application

2. Web Application

3. Composite Application

4. Hybrid Application

New area of Technology which deals with collecting data from all types of devices

1. Big Data

2. Internet of Things

3. Twitter

4. Facebook

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

1. Since client will be expecting the deliver, downloading the software can be done.

2. Never make unauthorised copies of computer software

programs or use unlicensed personal software on company computers/laptop.



All the Best

2 | P a g e

BizSkill

Sarah, an associate, is a bit confused about dining 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 ?

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

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

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

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

What are the essential structural elements of an email?

1.Introduction.

2.Appreciation.

3.Body.

4.Conclusion.

5.Summary.

6.Feedback.

1. 1,2,3,4

2. 1,3,5,4

3. 2,3,5,6

4. 1,3,4

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?

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



All the Best

3 | P a g e

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

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

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

Advantages of Diversity include:

1. Fosters Innovation

2. Enhances employee engagement

3. Improves business performance

4. All of the options

Judging another person's views solely based on our own values and culture is called :

1. Centrality

2. Diversity

3. Ethnocentrism

4. Criticism

UNIX While editing a file in vi, you need to display the permissions for all files in the current directory. Which command accomplishes this from Command mode ?

1. :x “ls -l”

2. :e! ls -l

3. Shift+L+S+-+L

4. :! ls -l

Suppose you have a file called 'file1' on your system. What will happen if you execute the following command in the terminal?



All the Best

4 | P a g e

mv file1 f1

1. Moves the file1 to a folder called “ f1 ”.

2. Rename the “file1” to “f1”.

3. Copy the contents of “file1” to the file called “f1”.

4. Move the contents of “file1” to the file called “f1”.

Which one among the given statements is not correct about the following command?

chmod 755 file1

1. User has read, write and execute permissions for file1.

2. Group has only read and execute permissions for file1.

3. User has only read and execute permissions for file1.

4. Others have only read and execute permissions for file1.

What does the following unix command mean?

sort file1.txt | uniq

1. Sorts the contents of file1 and without removing duplicate rows.

2. Sorts the contents of file1 and removes unique rows.

3. Sorts the contents of file1 and removes duplicate rows.

4. Sorts the contents of file1 in the reverse order.

Which of the following command is used to change the ownership of a file?

1. chmod

2. chowner

3. chgrp

4. chown



All the Best

5 | P a g e

Java UI The event that occurs when an element gets focus.

1. onblur

2. onfocus

3. onfocusin

4. onmouseout

Which HTML tag which is used to define internal style sheet

1. <css>

2. <script>

3. <style>

4. <link>

What does the _parent value in target attribute indicates

1. It opens the document in the parent frame

2. It opens the document in the full body of the window

3. It opens the document in the same window/tab as it was clicked

4. It is the default value of attribue

What is the output of the below code snippet :

<html> <body> <h2>Welcome All</h2> <p>Happy Learning</p>

<a href="https://www.google.com/" title="Go to Google">Click Me</a>

</body> </html>

1. Syntax is wrong

2. Below output will be displayed with 'Click Me' as link

http://www.google.com/



All the Best

6 | P a g e

Welcome All Happy Learning Click Me

3. Below output will be displayed as links

Welcome All Happy Learning Click Me

4. Below output will be displayed with 'Click Me' as link

Welcome All Click Me

Output of the below code snippet is :

<html> <body> <h2></h2> <p title='Learn from "Mistakes"'>You learn more from failure than from success</p> </body>

</html>

1. Below output will be displayed and on hovering it should display Learn from “Mistakes”

You learn more from failure than from success

2. Cannot use single quotes around attribute values

3. Below output will be displayed

You learn more from failure than from success

4. Below output will be displayed and on hovering it should display “You learn more from failure than from success”

Learn from “Mistakes”



All the Best

7 | P a g e

What is the output of below code snippet

<html> <head> <style> a[target=_top] { background-color: lightblue; font-family: Arial;

} </style> </head> <body> <a href="https://www.udemy.com" target="_top">Udemy</a> <a href="http://www.linkedin.com" target="_blank">LinkedIn</a> </body> </html>

1. The below links will be displayed with LinkedIn highlighted in lightblue color and in Arial font

Udemy LinkedIn

2. The below links will be displayed with LinkedIn highlighted in lightblue color

Udemy LinkedIn

3. The below links will be displayed with Udemy highlighted in lightblue color and in Arial font

Udemy LinkedIn

4. The below links will be displayed with Udemy highlighted in lightblue color

Udemy LinkedIn

What is the output of the below code snippet

<html> <head>

http://www.udemy.com/

http://www.linkedin.com/



All the Best

8 | P a g e

<style> div { padding: 25px 50px; background-color: yellow; } </style> </head> <body> <div>The best brains of nation may be found on the last benches of classroom</div> </body> </html>

1. The below output will be displayed in yellow background within black border

The best brains of nation may be found on the last benches of classroom

2. The below output will be displayed with top and bottom padding of 25px, and a right and left padding of 50px in yellow background.


3. The below output will be displayed within black border with top and bottom padding of 25px, and a right and left padding of 50px in yellow background.


4. The below output will be displayed with top and bottom padding of 25px, and a right and left padding of 50px in yellow font



<html>

<head> <style> #1demo { background-color: lightblue; text-align: center; }



All the Best

9 | P a g e

</style> </head> <body> <p id="demo">The best and most beautiful things in the world must be felt with the heart</p> </body> </html>

1. The below output will be displayed in lightblue background

The best and most beautiful things in the world must be felt with the heart

2. The below output will be displayed in lightblue background aligned at the center


3. The below output will be displayed aligned at the center


4. The below output will be displayed


What will be the output of below code snippet?

<html> <body> <p id="demo"></p> <script> var str = "The most beautiful gift of nature is that it gives one pleasure to look around and try to comprehend what we see. Nature is a great physician."; var sc = str.search ("beautiful") ; document.getElementById ("demo") .innerHTML = sc;

</script> </body> </html>

1. 10



All the Best

10 | P a g e

2. 9

3. 9 and 113

4. 113

What will be the output the of the following code snippet? <html> <body> <p id="demo"></p> <script> document.getElementById ("demo") .innerHTML ="The root is " + sqroot (49) ; function sqroot (num) {

return (num*num); } </script> </body> </html>

1. The root is 2401

2. The root is 49

3. Syntax error

4. 2409

JAVA There are two relations Associates and Sessions having one-to-many relationships that is , an entity in Associate is associated with any number of entities in Sessions . An entity in Sessions , however can be associated with at most entity in Associates.

1. one

2. more than one

3. one or more than one

4. None of the options

Data Dictionary is a ….



All the Best

11 | P a g e

1. meta data

2. ERD

3. Entity

4. Table

Consider the table Channel

Channel_id Channel_nam e Channel_role ================================== CH01 Discovery Administration CH02 Sports Program Manger CH03 Kids In Charge CH04 Entertainment Technician

Which query will give the below output

Channel_id Channel_name Channel_role ================================== CH02 Sports Program Manger CH03 Kids In Charge

1. SELECT Channel_id, Channel_name, Channel_role FROM (SELECT Channel_id, Channel_name,Channel_role FROM Channel ORDER BY Channel_name DESC) WHERE ROWNUM <=3;

2. SELECT Channel_id, Channel_name, Channel_role FROM (SELECT Channel_id, Channel_name,Channel_role FROM Channel ORDER BY Channel_name DESC) WHERE ROWNUM <3;

3. SELECT Channel_id, Channel_name,Channel_role FROM Channel ORDER BY Channel_name DESC WHERE ROWNUM <3;

4. SELECT Channel_id, Channel_name,Channel_role FROM Channel ORDER BY Channel_name DESC;

Consider the below FB_Score table from

FlappyBird Game

Id Name Country Score ========================= 1 Mark UK 200 2 John IN 300 3 Kevin IN 400 4 Paul IN 100 5 George UK 200 6 Devika US 300

Which query would answer the number of players having score greater than 200 in India(IN) ?

1. SELECT COUNT(Id) as PlayerCount FROM FB_Score where Score > 200 GROUP BY Country

HAVING Country="IN";

2. SELECT COUNT(ID) as PlayerCount



All the Best

12 | P a g e

FROM FB_Score where Score > 200 and Country="IN"

3. SELECT COUNT(ID) as PlayerCount FROM FB_Score

GROUP BY Country Having Score > 200 and Country="IN";


Consider the below FB_Score table from

FlappyBird Game

Id Name Country Score ========================= 1 Mark UK 200 2 John IN 300 3 Kevin IN 400 4 Paul IN 100 5 George UK 200 6 Devika US 300

Which query would display the player score in descending order ?

1. select name,score from FB_Score ORDER BY Score DESC;

2. select name,score from FB_Score SORT Score DESC;

3. select name,score from FB_Score Where score SORT BY DESC ;


In a PL/SQL Block a variable price is declared as below

Price NUMBER(8,2);

Identify the correct statement w.r.t this.

1. Price is of number data type with total precision 8 and decimal digits 2.

2. Price is of number data type with total precision 10 and decimal digits 2.

3. NUMBER can be used for Integers only.


Identify the PL/SQL block that will produce the below output: No Grade!



All the Best

13 | P a g e

1.

DECLARE

Mark NUMBER :=25;

BEGIN

IF( mark >= 70) THEN

dbms_output.put_line(‘Grade A’);

ELSIF(mark >= 40 AND mark < 70) THEN

dbms_output.put_line(‘Grade B');

ELSIF(mark >=35 AND mark < 40) THEN

dbms_output.put_line(‘Grade C);

ELSE

dbms_output.put_line(‘No Grade’);

END IF;

END;

/

2.

DECLARE

Mark NUMBER :=25;

BEGIN







END IF;


END;

/

3.

DECLARE

Mark NUMBER :=25;

BEGIN



ELS IF(mark >= 40 AND mark < 70) THEN


ELS IF(mark >=35 AND mark < 40) THEN



All the Best

14 | P a g e


ELSE


END IF;

END;

/

4.

DECLARE

mark NUMBER :=25;

BEGIN







ELSEIF


END IF;

END;

/

What will be the output of the below code:

DECLARE greetings varchar2(20) := 'Good Morning!'; BEGIN dbms_output.put_line ( SUBSTR (greetings, -1, 1)); END; /

1. g

2. !


4. syntax error

Identify the PL/SQL block that will produce same output.

1.

BEGIN

FOR n IN 1 .. 5

LOOP



All the Best

15 | P a g e

dbms_output.put_line(n);

END LOOP;

END;

/

2.

DECLARE

n NUMBER:=1;

BEGIN

LOOP


EXIT WHEN n>5;

END LOOP;

END;

/

3.

DECLARE

n NUMBER:=1;

BEGIN

LOOP


n:=n+1;

EXIT WHEN n>5;

END LOOP;

END;

/

4.

BEGIN

FOR n IN 1 .. 5

LOOP


n=n+1

END LOOP;

END;

/

Identify the PL/SQL block that will produce the below output:



All the Best

16 | P a g e

Hi you are there!

1.

DECLARE

char1 CHAR(1) :=’u’;

BEGIN

IF UPPER(char1) in ('A’,'E','I','0','U' ) THEN

dbms_output.put_line(‘Hi you are there!');

END IF;

END;

/

2.

DECLARE

char1 CHAR(1) :=’u’;

BEGIN

IF char1 in ('A’,'E','I','0','U' ) THEN


END IF;

END;

/

3.

DECLARE

char1 CHAR(1) :=’U’; BEGIN

IF char1 in ('A’,'E','I','0','U' ) THEN


END IF;

/

4.

DECLARE

char1 CHAR(1) :=’U’; BEGIN

IF char1 in ('A’,'E','I','0','u' ) THEN


END;

/

Choose the output of the below code.



All the Best

17 | P a g e

public class Sample { int num1=10; static String str1= "Xplore"; public static void main(String args[]) { Sample obj = new Sample(); System.out.println(new Sample().num1); str1="2020"; System.out.println(obj.str1); } }

1. Compiletime Error

2. 10

Xplore

3. 10

2020

4. 0

Null

Identify the output from the below code snippet

public class Sample { public void method() {

final String var1 = "Good Day"; System.out.println(var1); } public static void main(String args[]) { Sample obj = new Sample();

} }

1. Good Day

2. Runtime Error

3. NULL Value



All the Best

18 | P a g e

4. No Output

What is the output of below code snippet?

public static void demo() { final String var1 = "Xplore Learning"; System.out.println(var1);

var1= "2021"; } public static void main(String args[]) { demo();

}

1. Xplore Learning

2. Compilation error 3.

2021

4. Xplore Learning 2021

What is the output of below code snippet.

public class Test { public static void main(String[] args) { int i=1; int j=2; String str="Output: "; do { System.out.println(str+ ++i+j); } while(j<i); } }

1. Output: 22



All the Best

19 | P a g e

2. Output: 12

3. Output: 4

4. Output: 3

Character and number are compatible with each other.

1. TRUE

2. FALSE

Which method removes whitespace from both ends of a string

1. split()

2. isEmpty()

3. trim()

4. delete()


public class Sample { public static void main(String[] args) { String str = "Learning is not attained by chance. Learning is a lifelong process"; String[] ab = str.split(" ");

for (int i = 0; i < ab.length; i++) { for (int j = i + 1; j < ab.length; j++) { if (ab[i].equals(ab[j])) System.out.println(ab[i]);

} } }

}



All the Best

20 | P a g e

1. Learning

2. Learning is

3. Learning is a lifelong process

4. Learning is not attained by chance

What will be the output of below code? public class Demo{

public static void main(String args[]){

String s1="Java";

String s2=new String();

System.out.println(s1+s2);

}}

1. Java Null

2. Java

3. Run Time Error

4. Compile Time Error

If you declare a method as private, what is the access level of the method

1. can be accessed within the class and package

2. can be accessed within the class

3. can be accessed within the method

4. can be accessed within class, package and outside package

What is the output of below code public static void main(String[] args) { String str = "Digital";



All the Best

21 | P a g e

System.out.println(str.replace('a','y')); System.out.println(str.replace('Di','0'));

}

1. 0gityl

2. Digityl 0gital

3. Digityl

Digital

4. Compile time error


public class Sample { public static void main(String[] args) { int age = 9; if (age<=2)

{ System.out.println("Babies"); } else if (age<=8 && age>2) { System.out.println("Kids"); } else if (age<=12 && age>8) { System.out.println("Tweens"); } else if(age>12 && age <18) { System.out.println("Teens"); }



All the Best

22 | P a g e

else { System.out.println("Invalid entry"); }}}

1. Kids

2. Teens

3. Invalid entry

4. Tweens

What is the difference between equals() method and == operator?

1. The == operator matches content of the strings whereas equals() method matches object or reference of the strings

2. equals() method matches content of the strings whereas == operator matches object or reference of the strings

3. There is no difference between equals() method and == operator as both serves same purpose

4. There is no equals() method


public class Sample { public static void main(String[] args) { String str="Learning"; String str1="LEARNINGS";

if(str.equalsIgnoreCase(str1)) { if(str.contains("I")) System.out.println("Present"); else

{ System.out.println("Not present"); } } else System.out.println("Invalid"); }



All the Best

23 | P a g e

}

1. Present

2. Not present

3. Invalid

4. No Output

What is the output of below code snippet

public static void main(String[] args) {

double[] lst = { 11,55,44,33,7}; double

max = lst[0];

int temp = 0,i=0;

for (i = 0; i < lst.length-1; i++) { if

(lst[i] > max) {

max = lst[i];

temp = i;

}

}

System.out.println(lst[i]);

}

1. 5



All the Best

24 | P a g e

2. 7.0


4. 1


public class Sample {

public static void main(String[] args) {

double var1 = 10 + 5;

double var2 = var1 / 4;

int var3 = 10 + 5;

int var4 = var3 / 4;

System.out.print(var2 + "," + var4);

}

}

1. 3,3

2. 3.75,3

3. Compile time Error

4. 3



All the Best

25 | P a g e

Python

Choose the correct statement that returns the students from all states except Andhra.

1. SELECT FirstName, LastName FROM Student WHERE State <= 'Andhra';

2. SELECT FirstName, LastName FROM Student WHERE State NOT 'Andhra;

3. SELECT FirstName, LastName FROM Student WHERE State IS NOT 'Andhra';

4. SELECT FirstName, LastName FROM Student WHERE State != 'Andhra';

Which statement will sort a list of students in ascending order by last name

1. SELECT FirstName, LastName FROM Student ORDER BY LastName ASC;

2. SELECT FirstName, LastName FROM Student WHERE ORDER BY LastName DESC;

3. SELECT FirstName, LastName FROM Student ORDER BY ASC LastName;

4. SELECT FirstName, LastName FROM Student ORDER BY LastName;

Select the statement that will display all the students details whose grade is not available

1. SELECT * FROM students WHERE GRADE='NULL';

2. SELECT * FROM students WHERE GRADE=NULL;

3. SELECT * FROM students WHERE GRADE IS 'NULL';

4. SELECT * FROM students WHERE GRADE IS NULL;

In a LIKE clause, you can ask for any value ending in “tcs” by writing

1. LIKE tCS$

2. LIKE *tcs

3. LIKE %tcs

4. LIKE tcs

There are two relations Associates and Sessions having one-to-many relationships that is , an entity in Associate is associated with any number of



All the Best

26 | P a g e

entities in Sessions . An entity in Sessions , however can be associated with at most entity in Associates.

1. one

2. more than one

3. one or more than one


Data Dictionary is a ….

1. meta data

2. ERD

3. Entity

4. Table

On executing DELETE command, if you get an error "foreign key constraint"- what does it imply?

1. Data is present in the other table

2. Foreign key not defined

3. Table is empty

4. All the options are correct.

A teacher table has 3 columns : teacher_id, teacher_name and department.

dentify the correct SQL query to get the number of unique departments from teacher table.

1. SELECT COUNT(*) DISTINCT department FROM teacher;

2. SELECT COUNT(DISTINCT department) FROM teacher;

3. SELECT COUNT(*) UNIQUE department FROM teacher;

4. SELECT COUNT(UNIQUE department) FROM teacher;

The citizen age should not be greater than 100. This is

1. Integrity Constraint

2. Referential Integrity Constraint

3. Feasible Consraint.



All the Best

27 | P a g e


Consider the following Employee table

Name Null Type -------------------------------- EMPID NOT NULL NUMBER(10) EMPNAME NOT NULL VARCHAR2(50) BRANCHID NOT

NULL NUMBER(10) BRANCHNAME NOT NULL VARCHAR2(50)

Choose the query which is used to change the table name from Employee to EmployeeDetails

1. ALTER TABLE Employee

CHANGE TO EmployeeDetails;


CHANGENAME TO EmployeeDetails;


RENAME TO EmployeeDetails;

4. ALTER TABLE RENAME TO EmployeeDetails;

What is the output of the following code?

x, y = 9, 8

print("x" if x> y else "y")

1. x

2. y

3. 9

4. Error


print('pycharm'[0:-2])



All the Best

28 | P a g e

1. pycharm

2. pycha

3. charm

4. rm

What is the output of the following Python code?

numbers = [1, 2, 3, 4]

numbers.append([5,6,7,8])

print(numbers[4][3])

1. [5,6,7,8]

2. 7

3. 8

4. Error

What is the output of the following Python code?

birds=['pigeon','sparrow','crow']

x = "The birds are: {0}, {1} and {2}.".format( birds[2],birds[1],birds[0] )

print(x)

1. The birds are: crow, sparrow and pigeon.

2. The birds are: pigeon, sparrow and crow.

3. The birds are: sparrow, crow and pigeon.

4. Error



All the Best

29 | P a g e

What is the output of the following code

print('python'*3)

1. Error

2. pythonpythonpython

3. python3

4. python*3


x = 2

y = 4

z = "6"

print(x + y + z)

1. 246

2. 12

3. Error

4. 66

What is output of below expression?

2 * 2 **3

1. 12

2. 64

3. 16

4. 36



All the Best

30 | P a g e

Choose the correct code snippet that insert a object at a specified index in a list?

1. list.append(index,obj)

2. list.insert(index,obj)

3. list.add(index,obj)

4. list[i].index(obj)

Choose all the correct option for import in python?

1. from module import function

2. import module#functionName

3. import module.funcitonName

4. All are correct options.

What is the output of the below code?

result = {x: x*x*x for x in range(5)}

print(result)

1. {0: 0, 1: 1, 2: 8, 3: 27, 4: 64}

2. {1: 1, 2: 8, 3: 27, 4: 64}

3. {0, 1: 1, 2: 8, 3: 27, 4: 64}

4. {0: 0, 1: 1, 2: 8, 3: 27, 4: 64, 5:125}

what is the output of below program?

x=range(6);

print(x[6]);

1. Compile Error



All the Best

31 | P a g e

2. Runtime Error 3.

6

4. (0,6)


dictionary = {}

dictionary[1] = 1

dictionary['1'] = 3

dictionary[1] *= 4

sum = 0

for k in dictionary:

sum += dictionary[k]

print (sum)

1. 5

2. 3

3. 7

4. 8

You have created a file myFunctions.py and defined a function displayMessage() in this file. You have created another file mainProgram.py to define the main section of Python program and want to call the function displayMessage() defined in myFunctions.py. Both the files are created in the same folder/directory. Identify the statement that you have to write in the file mainProgram.py to access the function displayMessage().

1. import test1

2. import module test1



All the Best

32 | P a g e

3. use test1

4. from test1 import displayMessage()

What is the output of the below code? z = {"x":0, "y":1}

1. A dictionary z is created

2. x and y are the keys of dictionary z

3. 0 and 1 are the values of dictionary z


What is the output of the below code snippet?

if (1, 2): print('True') else:

print('False')

1. TRUE

2. FALSE

3. Syntax Error

4. Runtime Error

use these mcqs as a reference purpose. all the best kyt

Documents