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
|
Which one of the following is procedural language?
Solution |
2
Discuss
|
The_____ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.
Solution |
3
Discuss
|
In SQL the spaces at the end of the string are removed by _______ function.
Solution |
4
Discuss
|
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
Solution |
5
Discuss
|
Which keyword must be used here to rename the field name?
Solution |
6
Discuss
|
This query does which of the following operation?
Solution |
7
Discuss
|
The _________ provides a set of operations that take one or more relations as input and return a relation as an output.
Solution |
8
Discuss
|
A ________ in a table represents a relationship among a set of values.
Solution |
9
Discuss
|
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
Solution |
10
Discuss
|
This query can be replaced by which of the following ?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved