Genpact SQL WA2

Genpact SQL WA2

Professional Development

17 Qs

quiz-placeholder

Similar activities

Project Procurement Management

Project Procurement Management

Professional Development

20 Qs

DOCUMENT-INFORMATION SECURITY

DOCUMENT-INFORMATION SECURITY

Professional Development

20 Qs

Noom | Day 3 - Enrollment

Noom | Day 3 - Enrollment

Professional Development

16 Qs

Anime 99

Anime 99

9th Grade - Professional Development

13 Qs

Redmi Note 10 Series

Redmi Note 10 Series

Professional Development

12 Qs

Design Thinking - Quiz

Design Thinking - Quiz

Professional Development

15 Qs

Technical Quiz Round 1

Technical Quiz Round 1

Professional Development

20 Qs

Week 16 - Primary Survey Recap

Week 16 - Primary Survey Recap

University - Professional Development

12 Qs

Genpact SQL WA2

Genpact SQL WA2

Assessment

Quiz

Professional Development

Professional Development

Practice Problem

Hard

Created by

Ivy Professional School

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

17 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Media Image

From the "Records" table list all the students from Delhi and Mumbai.

Select Student

From Records

Where city= "Delhi" OR city= "Mumbai"

Select Student

From Records

Where city= "Delhi" And city= "Mumbai"

Select Student

From Records

Where city= "Delhi" OR "Mumbai"

Select Student

From Records

Where city= "Delhi" and "Mumbai"

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What does UNIQUE keyword do?

Returns only those values which appeared only once in the column

Returns list of values without repetition

Removes Duplicates

UNIQUE keyword allows duplicate values in a column

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Select all records from the Customers table, sort the result alphabetically, first by the column Country, then, by the column City.

SELECT * FROM Customers ORDER BY City, Country;

SELECT * FROM Customers Sort BY Country, City;

Select * From Customers

Order By Country, City;

SELECT * FROM Customers Order BY Country, City desc;

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Find the names from the "employee" table that has ET in the second and third positions.

SELECT * FROM EMPLOYEE WHERE NAME LIKE '_ET_';

SELECT * FROM EMPLOYEE WHERE NAME LIKE '%ET%;

SELECT * FROM EMPLOYEE WHERE NAME LIKE 'ET';

SELECT * FROM EMPLOYEE WHERE NAME LIKE '_ET%';

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Select all records where the first letter of the City is an "a" or a "c" or an "s".

SELECT * FROM CUSTOMERS WHERE CITY NOT LIKE '[acs]%';

SELECT * FROM CUSTOMERS WHERE CITY LIKE '[acs]%';

SELECT * FROM CUSTOMERS WHERE CITY LIKE '%[acs]%';

SELECT * FROM CUSTOMERS WHERE CITY LIKE '[a,c,s]%';

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is used to apply filters on Result of GROUP BY based on specific conditions.

HAVING

WHERE

FILTER

LIMIT

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

The following SQL statement selects all products with a price between 10 and 20. In addition; do not show products with a CategoryID of 1,2, or 3

SELECT * FROM Products WHERE Price BETWEEN 10 AND 20 AND CategoryID NOT IN (1,2,3)

SELECT * FROM Products WHERE Price BETWEEN 10 AND 20 AND CategoryID IN (1,2,3)

SELECT * FROM Products WHERE Price IN (10,20) AND CategoryID NOT IN (1,2,3)

SELECT * FROM Products WHERE Price BETWEEN 10 AND 20 AND CategoryID NOT BETWEEN (1,2,3)

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?

Discover more resources for Professional Development