Commercient Aptitude Test - 2023

If all cats are mammals, and some mammals are brown, which of the following must be true?

• All cats are brown
• Some cats are brown
• All brown things are cats
• Some brown things are cats

If NOIDA is written as OPJEB, then what will be the code for DELHI?

• EFMAJ
• EFAMK
• EFMIJ
• EFMIK

Which number is correct in place for ? in this series 6, 11, 21, 36, 56, ?

• 75

• 68

• 91

• 81

Which letter is four letters before the letter that comes two letters after 'E'?

• A

• B

• C

• D

In a group of 90 students, 60 like chocolates, 50 like candies, and 30 like both. How many like neither?

• 10

• 15

• 20

• 25

A snail crawls up 12 feet during the daytime, but it slips down 8 feet during the night. How long to reach 48 feet high pole? (in days)

• 10

• 11

• 12

• 9

What will be the output of the following SQL query? SELECT CONCAT('John', ' ', 'Doe') AS Name;

• John Doe

• John+Doe

• John''Doe

• Name

What is the result of the following SQL query? SELECT * FROM students ORDER BY marks DESC LIMIT 3;

• All students in descending order of marks
• Top 3 students with the highest marks
• All students with marks less than 3
• Top 3 students with the lowest marks

What is the purpose of the SQL CASE statement?

• To add a new column to the table
• To filter rows based on a condition
• To sort the result set
• To perform conditional logic in the query

What is the purpose of the SQL DISTINCT keyword?

• To sort the result set in ascending order
• To remove duplicates from the result set
• To filter rows based on a condition
• To combine multiple tables