Basic SQL Quiz By - M Khan
5 Questions
| Total Attempts: 84
Questions and Answers
- 1.Sorts are Alphabetical in SQL, not Logical.
- A.
True
- B.
False
- 2.Which one is wrong Alias syntax ?
- A.
First_name AS Fname
- B.
Last_name Lname
- C.
Class_Code "Class Code"
- D.
Grade_pt AS AVG
- 3.SELECT * FROM Student_table WHERE Grade_pt = 3.0 OR 4.0; What will be the result ?
- A.
Display students from Grade_pt 3.0 or 4.0
- B.
Will show syntax error
- C.
Display only students from Grade_pt 3.0
- D.
Not Sure
- 4.What is the order of Precedence in SQL ?
- A.
( ) NOT OR AND
- B.
AND OR NOT ( )
- C.
NOT OR ( ) AND
- D.
( ) NOT AND OR
- 5.LIKE Keyword uses which two special character ?
- A.
# and @
- B.
$ and %
- C.
% and &
- D.
% and _ (underscore)
A server query language is designed so that users can retrieve specific information from a database. As a software developer, you should have some knowledge of the use of such languages. Do you believe you understand SQL...
Questions: 42 | Attempts: 9825 | Last updated: Mar 19, 2021
-
Sample QuestionWhich SQL function is used to count the number of rows in a SQL query?
Questions: 26 | Attempts: 4046 | Last updated: Jan 24, 2013
-
Sample QuestionWhich SELECT statement should you use if you want to display unique combinations of the POSITION and MANAGER values from the EMPLOYEE table?
This is a quiz on the SQL system. needed for learning at school
Questions: 10 | Attempts: 3601 | Last updated: Mar 2, 2019
-
Sample QuestionWhen did SQL appear
Back to top