Deloitte National Level Assessment (NLA): Practice Questions & Worked Solutions

Consider the given schema: sql VISITORS(regno, name, telno, city) PATIENT(p_id, pname, city) Which one of the following queries will display the name and regno of visitors who are in 'Kolkata'?

Rearrange the parts to make a meaningful paragraph:

1. Even though P. she ran to meet her team Q. Komal knew R. she had to S. finish the case, so T. she was tired

Find the missing term in the sequence: A25Z, C21X, E17V, (?), I9R

Select the option that correctly substitutes the underlined phrase: Today is a totally different world than have seen in last decade.

Select the correct method which is used to transform each element of a collection.

Overloading without explicit arguments are called:

Which of the following is not an example for Block Storage?

Adding more compute resources is known as __________.

A bus covers the first 40 km of a journey at a speed of 20 km/h and the next 60 km at 30 km/h. What is the average speed (in km/h) of the bus for the entire journey?

A parallelogram has a base of 12 cm and a height of 9 cm. If the side length adjacent to the base is 7 cm, then find the ratio of the area and parameter?

The word 'ASTOUNDINGG' is rewritten by arranging the letters in reverse alphabetical order. What will be the 4th letter from the left end? [Note: counting starts from the left]?

In the below given number series how many numbers are more than 11 and less than 21? 4, 18, 13, 10, 22, 19, 24, 26

A person walks 5 meters north, then 12 meters east. What is the shortest distance between their starting and ending points?

If the average score of 5 students is 72 and four students scored 65, 70, 75, and 80, what is the score of the fifth student?

A man buys a chair for ₹600 and sells it for ₹750. What is his profit percentage?

Choose the word that best completes the sentence: "Her performance was so __________ that everyone in the audience stood up and applauded."

What comes next in the pattern: AA, AB, AC, AD, AE, _____?

Choose the most logical order of the given sentences to construct a coherent paragraph. A. Some, like the Ice Bucket Challenge, promote a cause B. But then, there are those fads that are ill-informed or, worse, dangerous. C. Others, like the bottle-flipping craze, are benign. D. The latest, the 'Tide Pod Challenge', belongs in that category. E. It seems every few weeks another challenge takes social media by storm.

Choose the most logical order of the given sentences to construct a coherent paragraph. A. Communicating with someone who is not physically present is alienating, forcing the mind to separate from the body. B. The cellphone intrudes into the public and private realms, preventing holistic engagement with what is around us. C. It also puts its users constantly on call, constantly available, and as much as that can be liberating or convenient, it can also be overwhelming. D. Even though we have two hands, I'm convinced that you can't hold a cellphone and someone else's hand at the same time.

Out of the four marked parts (A), (B), (C), and (D), choose the part that is incorrect or inappropriate in the context of the sentence: Sending gifts to each other (A) on (B) Christmas has been (C) a (D) lifelong tradition.

What will be the output of the below query? sql SELECT SUBSTRING ('San Antonio, TX', 5, 3);

Which of the following devices operate at both the physical and data link layers? I) Repeaters II) Bridges

Which of the following is not a block-level element? I) <code> II) <script> III) <label> IV) <video>

What is the next letter in the series? z, w, t, q, n, ?

Identify the incorrect part of the sentence from the options provided: Armstrong and Butchart bought the aircraft (A) into a nose-down alignment (B) to increase speed, (C) then launched the Skyrocket.

Out of the words/phrases given below, the position of 1 is fixed. Choose the most logical order of the remaining words/phrases to construct a coherent sentence.

1. The silent and non- P) protests in the lake city took Q) began pelting stones at vehicles R) mobs of angry S) protesters T) an ugly turn around noon when

Fill in the blank with the most appropriate word: Since Harry lived in Finland all his life, he knows neither Hindi (blank) Japanese.

Choose the most appropriate word to complete the sentence: "The manager's explanation was so __________ that everyone understood the complex procedure clearly."

Fill in the blank with the most appropriate word: "The research team is __________ the latest findings from their experiments."

Rearrange the following phrases to form a coherent sentence. The position of 1 is fixed.

1. In the bustling city P) cars honked and Q) creating a symphony R) pedestrians hurried, S) of urban life

Fill in the blank with the most appropriate word: (blank) a doubt she is the team's best performer.

Identify if the underlined part in the below sentence is incorrect. If yes, choose the option which makes the sentence grammatically correct: Steel-helmeted Reichswehr captains, who served at Tannenburg stood at each corner with drawn swords of the bed.

Fill in the blank with the most appropriate word: "There have been twenty similar incidents (blank) March and July."

Identify the TRUE statement about software testing:

Which phase of incident response involves restoring affected systems and data to a known good state?

Identify a valid attribute for the tag in HTML5.

Identify an invalid HTML tag from the following.

What is the smallest unit of information?

Which data structure is based on the Last In First Out (LIFO) principle?

Rearrange the digits of a given string such that all digits at even positions appear first, followed by all digits at odd positions (using 0-based indexing): Input: "1234567890" What will be the resulting output?

Problem Statement: Add "do not " at the beginning of the given string: Input: "enjoy cold weather" What will be the output?

Given two strings, create a new string by picking characters from the first string where the corresponding character in the second string is '1': Input: str1 = "12345" str2 = "10101" What is the output?

Given a target string and a reference string, remove all characters from the target string that are present anywhere in the reference string, and return the modified target string: Input: target = "communication" reference = "com" What is the output?

Calculate and display the sum of even and odd numbers in the given array: Input: [1, 2, 3, 4, 5, 6] What are the sums of the even numbers and odd numbers respectively?