
Genpact SQL WA2
Quiz
•
Professional Development
•
Professional Development
•
Hard
Ivy Professional School
FREE Resource
Enhance your content in a minute
17 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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)
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
12 questions
Gucci x Doraemon
Quiz
•
Professional Development
20 questions
Pneumatics comprehension
Quiz
•
Professional Development
18 questions
Customer Relations Day 6
Quiz
•
Professional Development
15 questions
SQL Statements and Queries
Quiz
•
Professional Development
20 questions
Assertiveness
Quiz
•
Professional Development
20 questions
Business and Professional Excellence
Quiz
•
Professional Development
20 questions
Hampshire UK: Do you know it?
Quiz
•
8th Grade - Professio...
15 questions
Google Ads Fundamentals
Quiz
•
Professional Development
Popular Resources on Wayground
10 questions
Honoring the Significance of Veterans Day
Interactive video
•
6th - 10th Grade
10 questions
Exploring Veterans Day: Facts and Celebrations for Kids
Interactive video
•
6th - 10th Grade
19 questions
Veterans Day
Quiz
•
5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
Circuits, Light Energy, and Forces
Quiz
•
5th Grade
6 questions
FOREST Self-Discipline
Lesson
•
1st - 5th Grade
7 questions
Veteran's Day
Interactive video
•
3rd Grade
20 questions
Weekly Prefix check #2
Quiz
•
4th - 7th Grade
