Basic SQL Quiz By - M Khan
5 Questions
| Attempts: 175
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)
Related Topics
Recent Quizzes
Featured Quizzes
Popular Topics
Back to top