SQL QUIZ NA MAHIRAP
Quiz by zernie pugao
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
- Q1
In "Where" clause, which of the following is NOT relational operator?
==
BETWEEN
>
LIKE
15s - Q2
Which clause should come first?
where Location in ('San Juan', 'Mandaluyong', 'Makati');
group by ZipCode;
having StudID = 500;
order by StudentName Desc;
15s - Q3
Which sql function could determine the total number of (a collection of items)?
sum
avg
union
count
15s - Q4
The SQL code for deleting a table
DELETE TABLE Shippers;
REMOVE TABLE Shippers;
TRUNCATE TABLE Shippers;
DROP TABLE BOX;
15s - Q5
What should be present when you use "Join"?
code key
foreign key
primary key
critical key
15s - Q6
If I will use Count or Sum Function, what clause is best partner for that?
Like
Min and Max
Group By
Order By
15s - Q7
What kind of join does this venn implied?
full outer join
inner join
left join
right join
15s - Q8
SELECT Customers.CustomerName, Orders.OrderID
FROM Customers
LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID
ORDER BY Customers.CustomerName;
In this code, what is the foreign key?
CustomerName
CustomerID
OrderID
Customers
15s - Q9
SELECT
Orders.OrderID, Employees.LastName, Employees.FirstName
FROM Orders
RIGHT JOIN Employees
ON Orders.EmployeeID = Employees.EmployeeID
ORDER BY Orders.OrderID;
In this code, which one in the right table?
Orders
Employees
Customers
20s - Q10
"Having" Clause is a condition for _________ clause
From
Order By
Where
Group By
20s - Q11
The code _____ is to establish foreign key.
Null
On
From
Having
20s - Q12
What is the correct Sequence?
Users link answersLinking45s - Q13
What does NULL means?
Contain Space
Zero Value
No Key
No Value
45s - Q14
The following are correct "where" clause which all ABOVE 18 YRS OLD AGE except __________
where AGE >=18
where AGE <= 17
where AGE >17
where AGE >= 17
45s - Q15
Which code serves highest to lowest?
SELECT * FROM QuizScores
ORDER BY Scores DESC;
SELECT * FROM QuizScores
ORDER BY Scores ;
SELECT * FROM QuizScores
ORDER BY Scores ASC;
20s
