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
|
In the SQL given above there is an error . Identify the error.
Solution |
2
Discuss
|
The tuples of the relations can be of ________ order.
Solution |
3
Discuss
|
A relational database consists of a collection of
Solution |
4
Discuss
|
A domain is atomic if elements of the domain are considered to be ____________ units.
Solution |
5
Discuss
|
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
Solution |
6
Discuss
|
The result which the operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.
Solution |
7
Discuss
|
_____ operator is used for appending two strings.
Solution |
8
Discuss
|
A ________ is a pictorial depiction of the schema of a database that shows the relations in the database, their attributes, and primary keys and foreign keys.
Solution |
9
Discuss
|
Student(ID, name, dept name, tot_cred)
Solution |
10
Discuss
|
To display the salary from greater to smaller and name in ascending order which of the following options should be used?
Solution |
# | Quiz |
Copyright © 2020 Inovatik - All rights reserved