SELECT name
FROM instructor
WHERE dept name = ’Physics’
ORDER BY name;
By default, the order by clause lists items in ______ order.
Descending
Any
Same
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
|
For each attribute of a relation, there is a set of permitted values, called the ________ of that attribute.
Solution |
3
Discuss
|
In SQL the spaces at the end of the string are removed by _______ function.
Solution |
4
Discuss
|
The most commonly used operation in relational algebra for projecting a set of tuple from a relation is
Solution |
5
Discuss
|
The _______operation performs a set union of two “similarly structured” tables
Solution |
6
Discuss
|
Which one of the following is procedural language?
Solution |
7
Discuss
|
The term _______ is used to refer to a row.
Solution |
8
Discuss
|
The tuples of the relations can be of ________ order.
Solution |
9
Discuss
|
Which keyword must be used here to rename the field name?
Solution |
10
Discuss
|
In the SQL given above there is an error . Identify the error.
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved