SELECT *
FROM instructor
ORDER BY salary ____, name ___;
To display the salary from greater to smaller and name in ascending order which of the following options should be used?
Ascending, Descending
Asc, Desc
Desc, Asc
Descending, Ascending
Quiz Recommendation System API Link - https://fresherbell-quiz-api.herokuapp.com/fresherbell_quiz_api
# | Quiz |
---|---|
1
Discuss
|
Department (dept name, building, budget) and Employee (employee_id, name, dept name, salary)
Solution |
2
Discuss
|
The term _______ is used to refer to a row.
Solution |
3
Discuss
|
The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
Solution |
4
Discuss
|
A relational database consists of a collection of
Solution |
5
Discuss
|
Which keyword must be used here to rename the field name?
Solution |
6
Discuss
|
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
Solution |
7
Discuss
|
The _______ operator takes the results of two queries and returns only rows that appear in both result sets.
Solution |
8
Discuss
|
_____ operator is used for appending two strings.
Solution |
9
Discuss
|
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
Solution |
10
Discuss
|
Which one of the following has to be added into the blank to select the dept_name which has Computer Science as its ending string?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved