Basic SQL Quiz By - M Khan | Attempts: 192

Reviewed by Editorial Team

The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.

Learn about Our Editorial Process

| By Teradatakhan

Teradatakhan

Community Contributor

Quizzes Created: 1 | Total Attempts: 192

| Attempts: 192

Feedback

During the Quiz End of Quiz

Difficulty

Sequential Easy First Hard First

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

1/5 Questions

Sorts are Alphabetical in SQL, not Logical.
- True
- False

About This Quiz

Basic SQL Quiz By - M Khan assesses understanding of SQL syntax and operations. It covers topics like sorting, aliasing, query syntax, precedence rules, and wildcard usage, essential for database management skills.

2.

Which one is wrong Alias syntax ?
- First_name AS Fname
- Last_name Lname
- Class_Code "Class Code"
- Grade_pt AS AVG
Correct Answer

A. Grade_pt AS AVG

Explanation

The given syntax "Grade_pt AS AVG" is incorrect because it does not follow the correct alias syntax. In alias syntax, the keyword "AS" is used to assign an alias to a column or expression. The correct syntax would be "Grade_pt AS AVG" where "Grade_pt" is the column or expression being aliased and "AVG" is the alias assigned to it.

Rate this question:
3.

SELECT * FROM Student_table WHERE Grade_pt = 3.0 OR 4.0; What will be the result ?
- Display students from Grade_pt 3.0 or 4.0
- Will show syntax error
- Display only students from Grade_pt 3.0
- Not Sure
Correct Answer

A. Will show syntax error

Explanation

The given SQL query is correct and will not show a syntax error. It will display all the rows from the Student_table where the Grade_pt is either 3.0 or 4.0.

Rate this question:
4.

What is the order of Precedence in SQL ?
- ( ) NOT OR AND
- AND OR NOT ( )
- NOT OR ( ) AND
- ( ) NOT AND OR
Correct Answer

A. ( ) NOT AND OR

Explanation

The order of precedence in SQL is determined by the use of parentheses, followed by the NOT operator, and then the AND and OR operators. In this case, the correct answer is "( ) NOT AND OR" which means that expressions inside parentheses are evaluated first, followed by the NOT operator, and then the AND and OR operators. This order ensures that the logical operations are performed in the correct sequence, allowing for accurate query results.

Rate this question:
5.

LIKE Keyword uses which two special character ?
- # and @
- $ and %
- % and &
- % and _ (underscore)
Correct Answer

A. % and _ (underscore)

Explanation

The LIKE keyword in SQL is used to search for a specified pattern in a column. It supports the use of two special characters: '%' and '_' (underscore). The '%' character is used to represent any sequence of characters, while the '_' character is used to represent a single character. Therefore, the correct answer is % and _ (underscore).

Rate this question:

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 21, 2023

Quiz Edited by
ProProfs Editorial Team
May 06, 2014

Quiz Created by
Teradatakhan

Basic SQL Quiz By - M Khan

Sorts are Alphabetical in SQL, not Logical.

Quiz Preview

Which one is wrong Alias syntax ?

**SELECT * FROM Student_table WHERE Grade_pt = 3.0 OR 4.0; What will be the result ?**

What is the order of Precedence in SQL ?

LIKE Keyword uses which two special character ?