SD_Python SQL JS

Gayatrry | 30 Aug 2024

zeomega | Gayatrry Page 1 / 31

 Test Name::

SD_Python SQL JS

Overall Status: Completed Detailed Status: Time Over Test Finish Time: August 30, 2024 07:13:45 PM IST

Gayatrry
G
gayathrrysre@[Link]

Test-Taker ID: - 136772342

Last Name: Sre

Gender Identity: Not Filled

Country of Residence: Not Filled

Profile Picture Snapshot Identity Card Snapshot

zeomega | Gayatrry Page 2 / 31

 Overall Summary

80 Marks Scored
out of 100 80 % 87.7 percentile
out of 244 Test Takers 1h 30m Time taken
of 1hr 30mins

Marks Scored

Marks percentage percentile

72

Section #1 90
96

Section #2 0
54

Section #3 80
93

Section #4 0
59

80

Total 80
88

Attempt Summary
Distribution of questions attempted in a total of 18 question(s).

Correct 13 Ques 80/80 Marks

18
Incorrect 5 Ques 0/20 Marks

Partially Correct 0 Ques 0/0 Marks

Total Questions

This shows the correctness of questions attempted Not Attempted 0 Ques 0/0 Marks
by the test taker

zeomega | Gayatrry Page 3 / 31

 Section-Wise Details

Section 1 question(s) Time taken Marks Scored

Section #1 10 Q. 25m (Untimed) 72 / 80

Marks Scored

Marks percentage

72
Python 2.7
90

72
Total
90

Attempt Summary
Distribution of questions attempted in a total of 10 question(s).

Correct 9 Ques 72/72 Marks

Incorrect 1 Ques 0/8 Marks

10
Total Questions

This shows the correctness of questions

attempted by the test taker

zeomega | Gayatrry Page 4 / 31

 Section-Wise Details

Section 2 question(s) Time taken Marks Scored

Section #2 1 Q. 32m 3s (Untimed) 0/8

Marks Scored

Marks percentage

0
Coding Skills - Basic
0

0
Total
0

Attempt Summary
Distribution of questions attempted in a total of 1 question(s).

Incorrect 1 Ques 0/8 Marks

1
Total Questions

This shows the correctness of questions

attempted by the test taker

zeomega | Gayatrry Page 5 / 31

 Section-Wise Details

Section 3 question(s) Time taken Marks Scored

Section #3 5 Q. 10m 42s (Untimed) 8 / 10

Marks Scored

Marks percentage

8
Javascript
80

8
Total
80

Attempt Summary
Distribution of questions attempted in a total of 5 question(s).

Correct 4 Ques 8/8 Marks

Incorrect 1 Ques 0/2 Marks

5
Total Questions

This shows the correctness of questions

attempted by the test taker

zeomega | Gayatrry Page 6 / 31

 Section-Wise Details

Section 4 question(s) Time taken Marks Scored

Section #4 2 Q. 22m 13s (Untimed) 0/2

Marks Scored

Marks percentage

0
Database Query Qu…
0

0
Total
0

Attempt Summary
Distribution of questions attempted in a total of 2 question(s).

Incorrect 2 Ques 0/2 Marks

2
Total Questions

This shows the correctness of questions

attempted by the test taker

zeomega | Gayatrry Page 7 / 31

 Question-Wise Details

Section 1 10 25m 72/80

Section #1 question(s) Time taken Marks Scored

Q.
Question 1 Time taken: 6m 42s Marks Scored: 8/8
1

Question

Which of the following strings is/are not matched by the given Python Regex?

1 import re
2 r = [Link]('^[A-Z]{5}[0-9]{4}[A-Z]{1}$')

EASY Python - Regex - Analysis

Response

OPTIONS RESPONSE ANSWER

'AAAAA0000B'

'ABCDE0000XX'

'ABCDEF1234X'

'ABCDE0000XX' and 'ABCDEF1234X'

zeomega | Gayatrry Page 8 / 31

Q.
Question 2 Time taken: 1m 35s Marks Scored: 8/8
2

Question

Which of the following objects is/are immutable in Python?

EASY Python - Miscellaneous - Essential

Response

OPTIONS RESPONSE ANSWER

String

List

Tuple

String and tuple

Q.
Question 3 Time taken: 3m 7s Marks Scored: 8/8
3

Question

What will be the result of evaluating the given expression in Python?​​

1 a,b=[1, [2], 3]

EASY Python - Miscellaneous - Analysis

Response

OPTIONS RESPONSE ANSWER

a=1, b=[[2],3]

a=[1,[2]], b=3

[1,2,3,[4,5]]

Syntax error

zeomega | Gayatrry Page 9 / 31

Q.
Question 4 Time taken: 4m 55s Marks Scored: 0/8
4

Question

What will be the output of the given code in Python version 2.7?

1 print (7 > 10)

2 print (4 < 16)
3 print (4 == 4)
4 print (4 <= 4)
5 print (4 != 4)

EASY Python - Classes and Operators - Application

Response

OPTIONS RESPONSE ANSWER

1 False
2 True
3 True
4 True
5 False

1 False
2 True
3 False
4 True
5 False

1 false
2 true
3 true
4 true
5 false

1 0
2 1
3 1
4 1
5 0

zeomega | Gayatrry Page 10 / 31

Q.
Question 5 Time taken: 1m 38s Marks Scored: 8/8
5

Question

What will the given statement print in Python version 2.7?

1 print (0xA + 0xB + 0xC)

EASY Python - Miscellaneous - Concept

Response

OPTIONS RESPONSE ANSWER

0x21

ABC

0xA0xB0xC

33

zeomega | Gayatrry Page 11 / 31

Q.
Question 6 Time taken: 1m 23s Marks Scored: 8/8
6

Question

In Python version 2.7, what does the given expression evaluate to?

1 print 'a b c d'.split()

EASY Python - Strings - Application

Response

OPTIONS RESPONSE ANSWER

1 ['a', ' ', 'b', ' ', 'c', ' ', 'd']

1 ('a', ' ', 'b', ' ', 'c', ' ', 'd')

1 ['a', 'b', 'c', 'd']

1 ('a', 'b', 'c', 'd')

zeomega | Gayatrry Page 12 / 31

Q.
Question 7 Time taken: 1m 5s Marks Scored: 8/8
7

Question

In Python version 2.7, what does the given expression evaluate to?

1 '' and 'b'

EASY Python - Classes and Operators - Application

Response

OPTIONS RESPONSE ANSWER

''

Syntax error

True

False

Q.
Question 8 Time taken: 1m 25s Marks Scored: 8/8
8

Question

Which of the following members can Python classes have in Python version 2.7?

EASY Python - Classes and Operators - Essential

Response

OPTIONS RESPONSE ANSWER

Public

Private

Protected

Public and private

zeomega | Gayatrry Page 13 / 31

Q.
Question 9 Time taken: 36s Marks Scored: 8/8
9

Question

In Python version 2.7, what does the expression 2**10 evaluate to?

EASY Python - Classes and Operators - Essential

Response

OPTIONS RESPONSE ANSWER

20

2*e10

1024

Syntax error

Q.
Question 10 Time taken: 2m 30s Marks Scored: 8/8
10

Question

What will be the output of this in Python 2.7?

print [1,2,3] + [3,2,1]

EASY Python - Lists - Application

Response

OPTIONS RESPONSE ANSWER

[4, 4, 4]

Syntax error

[1, 2, 3, 3, 2, 1]

[[1, 2, 3], [3, 2, 1]]

zeomega | Gayatrry Page 14 / 31

 Question-Wise Details

Section 2 1 32m 3s 0/8

Section #2 question(s) Time taken Marks Scored

Q.
Question 1 Compilation: Successful Time taken: 32m 3s Marks Scored: 0/8
1

Question

Arrangement

Given an array of size n, write a function to rearrange the numbers of the array in such a way that even and odd numbers are arranged
alternatively in increasing order.

Input Specification:

input1: Array size i.e. n

input2: Array elements (separated by comma)

Output Specification:

Return the updated array

Example 1:

input1: 5
input2: {9,12,23,8,5}

Output: {5,8,9,12,23}

Explanation:
As the numbers are to be arranged in increasing order hence we start with 5 in the given array, also the starting number is odd therefore the
next number has to be even and has to be smallest in even number i.e. 8 ....and so on.
Hence the output is {5,8,9,12,23}

Example 2:

input1: 5
input2: {47,49,36,98,90}

Output: {36,47,90,49,98}

Explanation:
In the given array, 36 is the smallest number hence we start with it and arrange the series as even-odd alternatively.

EASY Coding Skills - Basic - Array

zeomega | Gayatrry Page 15 / 31

 Response

Compilation Time Taken Marks Scored Language

Successful 32m 3s 0 Out of 8 PYTHON3

1 # Read only region start PYTHON3

2 class UserMainCode(object):
3 @classmethod
4 def arrange(cls, input1, input2):
5 '''
6 input1 : int
7 input2 : int[]
8
9 Expected return type : int[]
10 '''
11 # Read only region end
12
13 def rearrange_alternatively(arr):
14 #Separate even and odd numbers
15 evens = [num for num in arr if num % 2 == 0]
16 odds = [num for num in arr if num % 2!= 0]
17
18 #Sort even and odd numbers
19 [Link]()
20 [Link]()
21
22 #Initialize result array
23 result = []
24
25 #Merge sorted even and odd numbers alternatively
26 i,j = 0,0
27 while i < len(evens) and j < len(odds):
28 [Link](evens[i])
29 [Link](odds[j])
30 i += 1
31 j += 1
32
33 #Append remaining even or odd numbers if any
34 while i < len(evens):
35 [Link](evens[i])
36 i += 1
37 while j < len(odds):
38 [Link](odds[j])
39 j += 1
40 return result
41
42 #Example usage
43 arr = [9, 12, 23, 8, 5]
44 print(rearrane_alternatively(arr))

zeomega | Gayatrry Page 16 / 31

 0

Sample Test Case Timestamp Graded Test Case Timestamp

Graded Test Case Code Compilation : 3 Successful 3 Attempt Code Score : 90

Sample Test Case Code Compilation : 10 Successful 10 Attempt

Total no. of Testcase : 10 Total Passed : 0

TEST CASE MARKS CPU (MS) PROCESSING MEMORY (KB) INPUTS EXPECTED OUTPUT ACTUAL ERROR
(MS) OUTPUT MESSAGE

Basic TestCase 1 0 0 154 60236 9, {2,11,6,23,16,29,18,4 NA

{11,6,29,2,1 7,50}
6,18,23,47,5
0}

Basic TestCase 2 0 0 154 60360 4, {3,0,4,5} {0,3,4,5} NA

Basic TestCase 3 0 0 150 60360 3, {9,6,20} {6,9,20} NA

Basic TestCase 4 0 0 225 60360 6, {1,6,5,16,9,32} NA

{5,9,1,6,16,3
2}

Necessary TestCase 1 0 0 236 60360 11, {1,2,3,4,5,6,7,8,9,10,1 NA

{11,10,9,8,7, 1}
6,5,4,3,2,1}

Necessary TestCase 2 0 0 203 60492 8, {2,9,8,11,10,13,14,15} NA

{13,15,9,8,1
4,10,11,2}

Corner TestCase 1 0 0 167 60360 1, {1} {1} NA

Corner TestCase 2 0 0 150 60492 3, {1,3,5} {1,3,5} NA

Time Complexity 0 0 193 60360 9, {2,11,6,23,16,29,18,4 NA

TestCase 1 {11,6,29,2,1 7,50}
6,18,23,47,5
0}

Time Complexity 0 0 301 60360 7, {11,22,33,66,77,88,99 NA

TestCase 2 {88,77,11,22 }

zeomega | Gayatrry Page 17 / 31

 ,66,99,33}

zeomega | Gayatrry Page 18 / 31

 Question-Wise Details

Section 3 5 10m 42s 8/10

Section #3 question(s) Time taken Marks Scored

Q.
Question 1 Time taken: 1m 15s Marks Scored: 2/2
1

Question

Which of the following statements will complete the given code to perform the operation of opening the window1 and loading the page
[Link] into it? ​

EASY Archive JavaScript - Forms - Concept

Response

OPTIONS RESPONSE ANSWER

window("[Link]","window1")

[Link]("[Link]","window1")

[Link]("window1","[Link]")

[Link](window1,[Link])

zeomega | Gayatrry Page 19 / 31

Q.
Question 2 Time taken: 4m 55s Marks Scored: 2/2
2

Question

What will be the output of the given code when the user clicks My Button?

1 <body>
2 <p id="myNode">This is Node</p>
3 <button onclick="myFunction();">My Button</button>
4 <script>
5 function myFunction(){
6 var oldP = [Link]("myNode");
7 [Link]="New text";
8 }
9 </script>
10 </body>

EASY JavaScript - HTML and Links - Application

Response

OPTIONS RESPONSE ANSWER

The text 'This is Node' will be replaced with 'New text'

The text 'New text' will be replaced with 'This is Node'

Runtime Error will occur

Nothing will happen

zeomega | Gayatrry Page 20 / 31

Q.
Question 3 Time taken: 1m 7s Marks Scored: 0/2
3

Question

What will be the output of the following JavaScript when a user clicks on the Submit button?

1 <script type="text/javascript">
2 var fruits = ["Mango", "Banana", "Apple", "Orange"];
3 function showListOfFruits(){
4 for(var i=0; i< [Link]; i++ ){
5 [Link]("showFruits").innerHTML = fruits[i]
6 }
7 }
8 </script>
9
10 <button onclick="showListOfFruits()"> Submit</button>
11 <ul>
12 <li id="showFruits"></li>
13 </ul>

EASY Archive JavaScript - Functions - Application

Response

OPTIONS RESPONSE ANSWER

Mango
Banana
Apple
Orange

Orange

Apple
Banana

Mango

zeomega | Gayatrry Page 21 / 31

Q.
Question 4 Time taken: 1m 26s Marks Scored: 2/2
4

Question

What will be the output of the given code when the user clicks My Button?

1 <button onclick="[Link]();">My Button</button>

EASY Archive JavaScript - HTML and Links - Application

Response

OPTIONS RESPONSE ANSWER

Exits the page

Reloads the page

Error

Nothing will happen

zeomega | Gayatrry Page 22 / 31

Q.
Question 5 Time taken: 1m 56s Marks Scored: 2/2
5

Question

What will be the output of the given code when the user clicks the button?

1 <body>
2 <button onclick="myFunction(this);">Test attribute!</button>
3 <script type="text/JavaScript">
4 function myFunction (button) {
5 var newAttr = [Link] ("myAttribute");
6 [Link] = "My Value";
7 [Link] (newAttr);
8 [Link] ([Link] ("myAttribute"));
9 }
10 </script>
11 </body>

EASY JavaScript - HTML and Links - Application

Response

OPTIONS RESPONSE ANSWER

False

Test attribute!

My Value

Nothing will happen

zeomega | Gayatrry Page 23 / 31

 Question-Wise Details

Section 4 2 22m 13s 0/2

Section #4 question(s) Time taken Marks Scored

Q.
Question 1 Time taken: 17m 26s Marks Scored: 0/1
1

Question

Write a MySQL query to display:

The employee name, employee category and bonus pay (use alias BONUS) for all employees based on the following criteria:

If there is no category assigned to an employee then take the bonus as 1000.

Your output should contain 3 columns in the below-mentioned order.

You can view the database schema by clicking the View Schema tab at the bottom of the query window on the right-hand side of the
screen.

EASY Database Query Questions - MySQL

Response

Answer 1 select empname, employee_category, case employee_category when 'A' then 6000
when 'B' then 4000
MYSQL 8.0
2 when 'C' then 3000
3 when 'D' then 2000 else 1000 END "BONUS" from employee_info;

Test taker's response 1 SELECT

2 EMPNAME,
MYSQL 8.0
3 EMPLOYEE_CATEGORY,
4 CASE
5 WHEN EMPLOYEE_CATEGORY = 'A' THEN 6000
6 WHEN EMPLOYEE_CATEGORY = 'B' THEN 4000
7 WHEN EMPLOYEE_CATEGORY = 'C' THEN 3000
8 WHEN EMPLOYEE_CATEGORY = 'D' THEN 2000
9 ELSE 1000
10 END AS BONUS
11 FROM
12 employees;

zeomega | Gayatrry Page 24 / 31

 Test Cases

TEST CASE EXPECTED OUTPUT ACTUAL OUTPUT SCORED SYSTEM MESSAGE

Testcase 1 31 Row(s), 3 Columns(s) 0 Row(s), 0 Columns(s) 0.0/100.0 Solution Query Failed to

Execute Reason: Table
'employees' doesn't exist

zeomega | Gayatrry Page 25 / 31

Q.
Question 2 Time taken: 4m 46s Marks Scored: 0/1
2

Question

Write a MySQL query to find:

The count (use alias count) of express trains that start from New Delhi (NDLS) and go to Mumbai (BCT) or Bhopal (BHP).

Your output should have 1 column as given below.

You can view the database schema by clicking the View Schema tab at the bottom of the query window on the right-hand side of the
screen.

EASY Database Query Questions - MySQL

Response

Answer 1 SELECT COUNT(*) AS count FROM train_details_tbl

2 WHERE train_type = 'EXP'
MYSQL 8.0
3 AND train_to IN (SELECT station_id FROM train_stations_tbl
4 WHERE station_name = 'Mumbai Central' OR station_name = 'Bhopal')
5 and train_from in (SELECT station_id FROM train_stations_tbl WHERE station_name
='New Delhi')

Test taker's response 1 SELECT

2 COUNT(*) AS COUNT
MYSQL 8.0
3 FROM
4 trains
5 WHERE
6 start_station = 'NDLS'
7 AND (end_station = 'BCT' OR end_station = 'BHP')
8 AND train_type = 'EXPRESS';

Test Cases

TEST CASE EXPECTED OUTPUT ACTUAL OUTPUT SCORED SYSTEM MESSAGE

Count operator and sub 2 Row(s), 1 Columns(s) 0 Row(s), 0 Columns(s) 0.0/10.0 Solution Query Failed to
query Execute Reason: Table
'trains' doesn't exist

zeomega | Gayatrry Page 26 / 31

zeomega | Gayatrry Page 27 / 31
 Test Log

30th Aug 2024

05:43 PM Started the test with Section #1

05:43 PM Candidate gave us right to the following feeds

- camera : Integrated Webcam (0c45:6a05)
- microphone : Default - Microphone (Realtek Audio)

06:01 PM Went to Section #2 of the test

06:17 PM Went to Section #3 of the test

06:27 PM Went to Section #4 of the test

06:28 PM Candidate Face Partially Visible

06:33 PM Candidate Face Partially Visible

06:34 PM Candidate Face Partially Visible

06:49 PM Went to Section #2 of the test

07:05 PM Went to Section #1 of the test

07:12 PM Went to Section #3 of the test

07:13 PM Test ended due to time over

Profile Picture Snapshot Identity Card Snapshot

Images of Test-Taker

05:43 PM 05:50 PM

zeomega | Gayatrry Page 28 / 31

 05:58 PM 06:05 PM

06:12 PM 06:20 PM

06:27 PM 06:28 PM : Candidate Face Partially Visible

06:33 PM : Candidate Face Partially Visible 06:33 PM : Candidate Face Partially Visible

zeomega | Gayatrry Page 29 / 31

 06:34 PM : Candidate Face Partially Visible 06:34 PM : Candidate Face Partially Visible

zeomega | Gayatrry Page 30 / 31

 About the Report

This Report is generated electronically on the basis of the inputs received from the assessment takers. This Report including the AI flags that are generated in
case of availing of proctoring services, should not be solely used/relied on for making any business, selection, entrance, or employment-related decisions.
Mettl accepts no liability from the use of or any action taken or refrained from or for any and all business decisions taken as a result of or reliance upon
anything, including, without limitation, information, advice, or AI flags contained in this Report or sources of information used or referred to in this Report.

zeomega | Gayatrry Page 31 / 31