Quiz-summary
0 of 5 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
Information
SQL Basic Practice Quiz
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Results
0 of 5 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- Answered
- Review
-
Question 1 of 5
1. Question
Consider the query:
SELECT * FROM employees WHERE dept_id NOT IN (10, 20, NULL);What will this query return?
Correct
Incorrect
-
Question 2 of 5
2. Question
What will happen when this query is executed?
SELECT salary * 12 AS annual_salary FROM employees WHERE annual_salary > 600000;Correct
Incorrect
-
Question 3 of 5
3. Question
What is the result of the following query?
SELECT COUNT(*) FROM employees GROUP BY dept_id ORDER BY COUNT(*) DESC LIMIT 1;Correct
Incorrect
-
Question 4 of 5
4. Question
Consider the following transaction:
START TRANSACTION; TRUNCATE TABLE employees; ROLLBACK;What will be the final state of the employees table in most SQL databases?
Correct
Incorrect
-
Question 5 of 5
5. Question
Consider the query:
SELECT name, salary, dept_id FROM employees ORDER BY 2 DESC;What does ORDER BY 2 refer to?
Correct
Incorrect
